public object creatReqUser(userinfo rn, List<VahedUser> rgr) { Results<string> result = new Results<string>(); try { HelperData h = new HelperData(); db.Connection.Open(); using (db.Transaction = db.Connection.BeginTransaction()) rn.pass = new CustomMembershipProvider().EncryptPassword(rn.pass); rn.deleted = false; Int16 t = h.AddUserInfo(rn); if (t!=0) { bool s = h.AddVahedUser(rgr, t); if (s) { // db.Transaction.Commit(); result.IsSuccessfull = true; } } } catch (Exception error) { db.Transaction.Rollback(); result.IsSuccessfull = false; result.Message = error.Message; } return result; }
//Edit UserInfo Table public int EditUserInfo(userinfo ui) { try { var v = from i in db.userinfos where i.userCode == ui.userCode select i; userinfo newuser = v.FirstOrDefault(); if(newuser!= null) { newuser.userCode = ui.userCode; newuser.fName = ui.fName; newuser.lName = ui.lName; newuser.userName = ui.userName; newuser.pass = ui.pass; newuser.email = ui.email; newuser.mobile = ui.mobile; newuser.zoneCode = ui.zoneCode; newuser.deleted = false; db.SubmitChanges(); return 1; } return 0;//not found } catch (Exception error) { return -1; } }
//Add To UserInfo Table public Int16 AddUserInfo(userinfo ui) { try{ db.userinfos.InsertOnSubmit(ui); db.SubmitChanges(); return ui.userCode; } catch (Exception error) { return 0; } }
partial void Deleteuserinfo(userinfo instance);
partial void Updateuserinfo(userinfo instance);
partial void Insertuserinfo(userinfo instance);
private void detach_userinfos(userinfo entity) { this.SendPropertyChanging(); entity.zoneInfo = null; }
private void attach_userinfos(userinfo entity) { this.SendPropertyChanging(); entity.zoneInfo = this; }
public static string UpdateReqUser(userinfo rn) { UserReqBLL fb = new UserReqBLL(); return JsonConvert.SerializeObject(fb.UpdateReqUser(rn)); }
public static string creatReqUser(userinfo rn, List<VahedUser> rgr) { UserReqBLL fb = new UserReqBLL(); return JsonConvert.SerializeObject(fb.creatReqUser(rn,rgr)); }
public object UpdateReqUser(userinfo rn) { Results<string> result = new Results<string>(); try { HelperData h = new HelperData(); rn.pass = new CustomMembershipProvider().EncryptPassword(rn.pass); int t = h.EditUserInfo(rn); if (t == 1) { result.IsSuccessfull = true; } } catch (Exception error) { result.IsSuccessfull = false; result.Message = error.Message; } return result; }