public ActionResult Add(SIMREG_REQUESTEDBYViewModel model)
{
try
{
if (ModelState.IsValid)
{
_boSIMREG_REQUESTEDBY = new BOSIMREG_REQUESTEDBY();
var beSIMREG_REQUESTEDBY = new BESIMREG_REQUESTEDBY
{
REQUESTEDBYID = model.REQUESTEDBYID,
TITLE = model.TITLE,
IDATE = DateTime.Now,
IUSER = model.IUSER,
EDATE = DateTime.Now,
EUSER = model.EUSER,
IsNew = true
};
_boSIMREG_REQUESTEDBY.Save(beSIMREG_REQUESTEDBY);
return Content(Boolean.TrueString);
}
return Content(ExceptionHelper.ModelStateErrorFormat(ModelState));
}
catch (Exception ex)
{
ExceptionHelper.ExceptionMessageFormat(ex);
return Content("Sorry! Unable to add this data.");
}
}
public void Save(BESIMREG_REQUESTEDBY entity)
{
try
{
sqlHelper = new SQLHelper(true);
daSIMREG_REQUESTEDBY.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_REQUESTEDBY entity)
{
string sql = string.Empty;
try
{
if (entity.IsNew)
{
// update tblTableCode
DATableCode daTableCode = new DATableCode();
//entity.REQUESTEDBYID = daTableCode.GetTableId(sqlHelper, "REQUESTEDBYID", "SIMREG_REQUESTEDBY");
sql = sqlHelper.MakeSQL(@"INSERT INTO SIMREG_REQUESTEDBY(REQUESTEDBYID, TITLE, IDATE, IUSER, EDATE, EUSER)"
+ " VALUES(SQ_SIMREG_REQUESTEDBYID.Nextval, $s, SYSDATE, $n, SYSDATE, $n)",
//entity.REQUESTEDBYID,
entity.TITLE,
//entity.IDATE,
entity.IUSER,
//entity.EDATE,
entity.EUSER);
}
else
{
sql = sqlHelper.MakeSQL(@"UPDATE SIMREG_REQUESTEDBY SET TITLE=$s, EDATE=SYSDATE, EUSER=$n WHERE REQUESTEDBYID=$n",
entity.TITLE,
//entity.EDATE,
entity.EUSER,
entity.REQUESTEDBYID);
}
sqlHelper.ExecuteNonQuery(sql);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private BESIMREG_REQUESTEDBY PreaperSIMREG_REQUESTEDBYObject(NULLHandler nullHandler)
{
BESIMREG_REQUESTEDBY SIMREG_REQUESTEDBY = new BESIMREG_REQUESTEDBY();
SIMREG_REQUESTEDBY.IsNew = false;
SIMREG_REQUESTEDBY.REQUESTEDBYID = nullHandler.GetInt("REQUESTEDBYID");
SIMREG_REQUESTEDBY.TITLE = nullHandler.GetString("TITLE");
SIMREG_REQUESTEDBY.IDATE = nullHandler.GetDateTime("IDATE");
SIMREG_REQUESTEDBY.IUSER = nullHandler.GetInt("IUSER");
SIMREG_REQUESTEDBY.EDATE = nullHandler.GetDateTime("EDATE");
SIMREG_REQUESTEDBY.EUSER = nullHandler.GetInt("EUSER");
return SIMREG_REQUESTEDBY;
}
