asp.net mvc 3 - Save a value to Database - MVC -
i trying save value in "usercontroller" cannot seem tog et save database.
i can database value stored in usercontroller change when value submitted , view refreshed looks though stored. (ie. changing test tested) however, refresh page again returns previous value , database shows no change throughout this.
usercontroller:
var g = httppost.vanityurl; db.ppuser_edituser(g); ppuser_edituser in ppuser:
public ppuser ppuser_edituser(string personvanity) { ppuser user = sessionuser.loggedinuser.person; user.vanityurl = personvanity; basedb.submitchanges(); return user; } editprofile view:
<div> @html.labelfor(m => m.vanityurl, "edit custom url:") @html.textboxfor(m => m.vanityurl, new { maxlength = 15 }) </div> basedb:
public partial class studiokit_mvc3repository : idisposable { private studiokit_mvc3modelsdatacontext _basedb; public studiokit_mvc3modelsdatacontext basedb { { if (_basedb == null) { if (studiokit_mvc3config.environmentdetail.name == "production") { _basedb = new studiokit_mvc3modelsdatacontext(studiokit_mvc3config.environmentdetail.connectionstring); } else { var sqlconnection = new sqlconnection(studiokit_mvc3config.environmentdetail.connectionstring); var conn = new profileddbconnection(sqlconnection, miniprofiler.current); _basedb = new studiokit_mvc3modelsdatacontext(conn); } } return _basedb; } } } edit: figured out problem. saving value session user instance , not actual database. got rid of method , in controller put:
ppuser check = db.ppuser_getuserbypersonid(model.cskpersonid); check.vanityurl = httppost.vanityurl; db.save();
Comments
Post a Comment