public void Insert(string UserName, int?RoleId, string UserCode) { LUser item = new LUser(); item.UserName = UserName; item.RoleId = RoleId; item.UserCode = UserCode; item.Save(UserName); }
public static void UpdateDoctor(LUser pitems) { try { if (LUser.FetchByID(pitems.UserId) != null) { pitems.IsNew = false; pitems.Save(); } } catch (Exception ex) { throw ex; } }
public void Update(decimal UserId, string UserName, int?RoleId, string UserCode) { LUser item = new LUser(); item.MarkOld(); item.IsLoaded = true; item.UserId = UserId; item.UserName = UserName; item.RoleId = RoleId; item.UserCode = UserCode; item.Save(UserName); }
private void btnSave_Click(object sender, EventArgs e) { try { txtID.Text = txtID.Text.ToUpper(); if (ValidData()) { switch (vAction) { case action.Insert: var obj = new LUser(); obj.UserName = Utility.sDbnull(txtName.Text); obj.UserCode = Utility.sDbnull(cboUserName.Text); obj.IsNew = true; obj.Save(); drList = dtList.NewRow(); drList[LUser.Columns.UserId] = LUser.CreateQuery().GetMax(LUser.Columns.UserId); ApplyData2Datarow(); dtList.Rows.InsertAt(drList, 0); dtList.AcceptChanges(); txtID.Text = Utility.sDbnull(drList[LUser.Columns.UserId]); vAction = action.Update; break; case action.Update: new Update(LUser.Schema.Name).Set(LUser.Columns.UserName).EqualTo(txtName.Text). Set(LUser.Columns.UserCode).EqualTo(Utility.sDbnull(cboUserName.Text)). Where(LUser.Columns.UserId).IsEqualTo(Utility.Int32Dbnull(txtID.Text)). Execute(); ApplyData2Datarow(); drList.AcceptChanges(); break; } } } catch (Exception ex) { Utility.ShowMsg(ex.Message); } }
private void btnSave_Click(object sender, EventArgs e) { try { txtID.Text = txtID.Text.ToUpper(); if (ValidData()) switch (vAction) { case action.Insert: var obj = new LUser(); obj.UserName = Utility.sDbnull(txtName.Text); obj.UserCode = Utility.sDbnull(cboUserName.Text); obj.IsNew = true; obj.Save(); drList = dtList.NewRow(); drList[LUser.Columns.UserId] = LUser.CreateQuery().GetMax(LUser.Columns.UserId); ApplyData2Datarow(); dtList.Rows.InsertAt(drList, 0); dtList.AcceptChanges(); txtID.Text = Utility.sDbnull(drList[LUser.Columns.UserId]); vAction = action.Update; break; case action.Update: new Update(LUser.Schema.Name).Set(LUser.Columns.UserName).EqualTo(txtName.Text). Set(LUser.Columns.UserCode).EqualTo(Utility.sDbnull(cboUserName.Text)). Where(LUser.Columns.UserId).IsEqualTo(Utility.Int32Dbnull(txtID.Text)). Execute(); ApplyData2Datarow(); drList.AcceptChanges(); break; } } catch (Exception ex) { Utility.ShowMsg(ex.Message); } }
public static string InsertDoctor(LUser pitems) { int i = 0; Query _QueryRS = LUser.CreateQuery(); try { if (!LUser.FetchByParameter(LUser.Columns.UserId, Comparison.Equals, pitems.UserId).Read()) { pitems.IsNew = true; pitems.Save(i); return(_QueryRS.GetMax(LUser.Columns.UserId).ToString()); } else { return("-1"); //throw new Exception(string.Format("Name:{0} Đã tồn tại", pitems.IPAddress)); } } catch (Exception ex) { throw ex; } }
public void Insert(string UserName,int? RoleId,string UserCode) { LUser item = new LUser(); item.UserName = UserName; item.RoleId = RoleId; item.UserCode = UserCode; item.Save(UserName); }
public void Update(decimal UserId,string UserName,int? RoleId,string UserCode) { LUser item = new LUser(); item.MarkOld(); item.IsLoaded = true; item.UserId = UserId; item.UserName = UserName; item.RoleId = RoleId; item.UserCode = UserCode; item.Save(UserName); }