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