public void Save(BESIMREG_DOMAINUSER entity) { try { sqlHelper = new SQLHelper(true); daSIMREG_DOMAINUSER.Save(sqlHelper, entity); sqlHelper.CommitTran(); } catch (Exception ex) { //SimReg.Common.Utility.SaveErrorLog(this.GetType().ToString(), "", ex); if (sqlHelper != null) sqlHelper.Rollback(); throw ex; } }
private BESIMREG_DOMAINUSER PreaperObject(NULLHandler nullHandler) { BESIMREG_DOMAINUSER SIMREG_DOMAINUSER = new BESIMREG_DOMAINUSER(); try { SIMREG_DOMAINUSER.IsNew = false; SIMREG_DOMAINUSER.userid = nullHandler.GetInt("userid"); SIMREG_DOMAINUSER.loginname = nullHandler.GetString("loginname"); SIMREG_DOMAINUSER.username = nullHandler.GetString("username"); SIMREG_DOMAINUSER.IsDeleted = nullHandler.GetBoolean("IsDeleted"); SIMREG_DOMAINUSER.IsActive = nullHandler.GetBoolean("IsActive"); SIMREG_DOMAINUSER.IDATE = nullHandler.GetDateTime("IDATE"); SIMREG_DOMAINUSER.IUSER = nullHandler.GetInt("IUSER"); SIMREG_DOMAINUSER.EDATE = nullHandler.GetDateTime("EDATE"); SIMREG_DOMAINUSER.EUSER = nullHandler.GetInt("EUSER"); SIMREG_DOMAINUSER.DeletedBy = nullHandler.GetInt("DeletedBy"); SIMREG_DOMAINUSER.DeletedDate = nullHandler.GetDateTime("DeletedDate"); SIMREG_DOMAINUSER.Serial = nullHandler.GetInt("Serial"); } catch (Exception ex) { throw new Exception(ex.Message); } return SIMREG_DOMAINUSER; }
public static void SetLoginInfo(BESIMREG_DOMAINUSER userInfo) { HttpContext.Current.Session["userinfo"] = userInfo; }
public void Save(SQLHelper sqlHelper, BESIMREG_DOMAINUSER entity) { try { string sql = string.Empty; if (entity.IsNew) { sql = sqlHelper.MakeSQL("INSERT INTO tbldomainuser1(userid, loginname, username, IsDeleted, IsActive, CreatedBy," + " CreatedDate, Serial) VALUES ($n, $s, $s, $b, $b, $n, $D, $n)", entity.userid, entity.loginname, entity.username); } else { sql = sqlHelper.MakeSQL("UPDATE tbldomainuser1 SET userid = $n, loginname = $s, username = $s, UpdatedDate = $D," + " UpdatedBy = $n" + " WHERE userid=$n", entity.userid, entity.loginname, entity.username, entity.EDATE, entity.EUSER, entity.userid); } sqlHelper.ExecuteNonQuery(sql); } catch (Exception ex) { throw new Exception(ex.Message); } }