public void Save(BESIMREG_MSISDN entity)
{
try
{
sqlHelper = new SQLHelper(true);
daSIMREG_MSISDN.Save(sqlHelper, entity);
sqlHelper.CommitTran();
}
catch (Exception ex)
{
//SimReg.Common.Utility.SaveErrorLog(this.GetType().ToString(), "", ex);
if (sqlHelper != null) sqlHelper.Rollback();
throw ex;
}
}
public void Save(SQLHelper sqlHelper, BESIMREG_MSISDN entity)
{
string sql = string.Empty;
try
{
if (entity.IsNew)
{
// update tblTableCode
DATableCode daTableCode = new DATableCode();
//entity.MSISDNID = daTableCode.GetTableId(sqlHelper, "MSISDNID", "SIMREG_MSISDN");
sql = sqlHelper.MakeSQL(@"INSERT INTO SIMREG_MSISDN(MSISDNID, TITLE, IDATE, IUSER, EDATE, EUSER)"
+ " VALUES(SQ_SIMREG_MSISDNID.Nextval, $s, SYSDATE, $n, SYSDATE, $n)",
//entity.MSISDNID,
entity.TITLE,
//entity.IDATE,
entity.IUSER,
//entity.EDATE,
entity.EUSER);
}
else
{
sql = sqlHelper.MakeSQL(@"UPDATE SIMREG_MSISDN SET TITLE=$s, EDATE=SYSDATE, EUSER=$n WHERE MSISDNID=$n",
entity.TITLE,
//entity.EDATE,
entity.EUSER,
entity.MSISDNID);
}
sqlHelper.ExecuteNonQuery(sql);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private BESIMREG_MSISDN PreaperSIMREG_MSISDNObject(NULLHandler nullHandler)
{
BESIMREG_MSISDN SIMREG_MSISDN = new BESIMREG_MSISDN();
SIMREG_MSISDN.IsNew = false;
SIMREG_MSISDN.MSISDNID = nullHandler.GetInt("MSISDNID");
SIMREG_MSISDN.TITLE = nullHandler.GetString("TITLE");
SIMREG_MSISDN.IDATE = nullHandler.GetDateTime("IDATE");
SIMREG_MSISDN.IUSER = nullHandler.GetInt("IUSER");
SIMREG_MSISDN.EDATE = nullHandler.GetDateTime("EDATE");
SIMREG_MSISDN.EUSER = nullHandler.GetInt("EUSER");
return SIMREG_MSISDN;
}
