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);
}
}
