public void Delete(BESIMREG_NEWFORM entity)
{
try
{
int entityId = entity.ID;
sqlHelper = new SQLHelper(true);
daSIMREG_NEWFORM.Delete(sqlHelper, entityId);
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_NEWFORM entity)
{
string sql = string.Empty;
try
{
if (entity.IsNew)
{
// update tblTableCode
DATableCode daTableCode = new DATableCode();
//entity.ID = daTableCode.GetTableId(sqlHelper, "ID", "SIMREG_NEWFORM");
sql = sqlHelper.MakeSQL(@"INSERT INTO SIMREG_NEWFORM(ID, MSISDNTITLE, REQUESTEDDATE, REQUESTEDBYID, REQUESTEDTYPEID, DELIVEREDBYDATE, DELIVEREDBYID, IDATE, IUSER, EDATE, EUSER)"
+ " VALUES(SQ_SIMREG_NEWFORMID.Nextval, $s, $d, $n, $n, $d, $n, SYSDATE, $n, SYSDATE, $n)",
//entity.ID,
//entity.MSISDNID,
entity.MSISDNTITLE,
entity.REQUESTEDDATE,
entity.REQUESTEDBYID,
entity.REQUESTEDTYPEID,
entity.DELIVEREDBYDATE,
entity.DELIVEREDBYID,
//entity.IDATE,
entity.IUSER,
//entity.EDATE,
entity.EUSER);
}
else
{
sql = sqlHelper.MakeSQL(@"UPDATE SIMREG_NEWFORM SET MSISDNTITLE=$s, REQUESTEDDATE=$d, REQUESTEDBYID=$n, REQUESTEDTYPEID=$n, DELIVEREDBYDATE=$d, DELIVEREDBYID=$n, EDATE=SYSDATE, EUSER=$n WHERE ID=$n",
//entity.MSISDNID,
entity.MSISDNTITLE,
entity.REQUESTEDDATE,
entity.REQUESTEDBYID,
entity.REQUESTEDTYPEID,
entity.DELIVEREDBYDATE,
entity.DELIVEREDBYID,
//entity.EDATE,
entity.EUSER,
entity.ID);
}
sqlHelper.ExecuteNonQuery(sql);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private BESIMREG_NEWFORM PreaperSIMREG_NEWFORMObject(NULLHandler nullHandler)
{
BESIMREG_NEWFORM SIMREG_NEWFORM = new BESIMREG_NEWFORM();
SIMREG_NEWFORM.IsNew = false;
SIMREG_NEWFORM.ID = nullHandler.GetInt("ID");
SIMREG_NEWFORM.MSISDNID = nullHandler.GetInt("MSISDNID");
SIMREG_NEWFORM.MSISDNTITLE = nullHandler.GetString("MSISDNTITLE");
SIMREG_NEWFORM.REQUESTEDDATE = nullHandler.GetDateTime("REQUESTEDDATE");
SIMREG_NEWFORM.REQUESTEDBYID = nullHandler.GetInt("REQUESTEDBYID");
SIMREG_NEWFORM.REQUESTEDTYPEID = nullHandler.GetInt("REQUESTEDTYPEID");
SIMREG_NEWFORM.DELIVEREDBYDATE = nullHandler.GetDateTime("DELIVEREDBYDATE");
SIMREG_NEWFORM.DELIVEREDBYID = nullHandler.GetInt("DELIVEREDBYID");
SIMREG_NEWFORM.IDATE = nullHandler.GetDateTime("IDATE");
SIMREG_NEWFORM.IUSER = nullHandler.GetInt("IUSER");
SIMREG_NEWFORM.EDATE = nullHandler.GetDateTime("EDATE");
SIMREG_NEWFORM.EUSER = nullHandler.GetInt("EUSER");
return SIMREG_NEWFORM;
}
public ActionResult Add(SIMREG_NEWFORMViewModel model)
{
try
{
if (ModelState.IsValid)
{
_boSIMREG_NEWFORM = new BOSIMREG_NEWFORM();
var beSIMREG_NEWFORM = new BESIMREG_NEWFORM
{
MSISDNID = model.MSISDNID,
MSISDNTITLE = model.MSISDNTITLE,
REQUESTEDDATE = Convert.ToDateTime(model.REQUESTEDDATE),
REQUESTEDBYID = model.REQUESTEDBYID,
REQUESTEDTYPEID = model.REQUESTEDTYPEID,
DELIVEREDBYDATE = Convert.ToDateTime(model.DELIVEREDBYDATE),
DELIVEREDBYID = model.DELIVEREDBYID,
IDATE = DateTime.Now,
IUSER = model.IUSER,
EDATE = DateTime.Now,
EUSER = model.EUSER,
IsNew = true
};
_boSIMREG_NEWFORM.Save(beSIMREG_NEWFORM);
return Content(Boolean.TrueString);
}
return Content(ExceptionHelper.ModelStateErrorFormat(ModelState));
}
catch (Exception ex)
{
return Content(ExceptionHelper.ExceptionMessageFormat(ex));
}
}
