public ActionResult Add(SIMREG_REQUESTEDTYPEViewModel model)
{
try
{
if (ModelState.IsValid)
{
_boSIMREG_REQUESTEDTYPE = new BOSIMREG_REQUESTEDTYPE();
var beSIMREG_REQUESTEDTYPE = new BESIMREG_REQUESTEDTYPE
{
REQUESTEDTYPEID = model.REQUESTEDTYPEID,
TITLE = model.TITLE,
IDATE = DateTime.Now,
IUSER = model.IUSER,
EDATE = DateTime.Now,
EUSER = model.EUSER,
IsNew = true
};
_boSIMREG_REQUESTEDTYPE.Save(beSIMREG_REQUESTEDTYPE);
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_REQUESTEDTYPE entity)
{
try
{
sqlHelper = new SQLHelper(true);
daSIMREG_REQUESTEDTYPE.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_REQUESTEDTYPE entity)
{
string sql = string.Empty;
try
{
if (entity.IsNew)
{
// update tblTableCode
DATableCode daTableCode = new DATableCode();
//entity.REQUESTEDTYPEID = daTableCode.GetTableId(sqlHelper, "REQUESTEDTYPEID", "SIMREG_REQUESTEDTYPE");
sql = sqlHelper.MakeSQL(@"INSERT INTO SIMREG_REQUESTEDTYPE(REQUESTEDTYPEID, TITLE, IDATE, IUSER, EDATE, EUSER)"
+ " VALUES(SQ_SIMREG_REQUESTEDTYPEID.Nextval, $s, SYSDATE, $n, SYSDATE, $n)",
//entity.REQUESTEDTYPEID,
entity.TITLE,
//entity.IDATE,
entity.IUSER,
//entity.EDATE,
entity.EUSER);
}
else
{
sql = sqlHelper.MakeSQL(@"UPDATE SIMREG_REQUESTEDTYPE SET TITLE=$s, EDATE=SYSDATE, EUSER=$n WHERE REQUESTEDTYPEID=$n",
entity.TITLE,
//entity.EDATE,
entity.EUSER,
entity.REQUESTEDTYPEID);
}
sqlHelper.ExecuteNonQuery(sql);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private BESIMREG_REQUESTEDTYPE PreaperSIMREG_REQUESTEDTYPEObject(NULLHandler nullHandler)
{
BESIMREG_REQUESTEDTYPE SIMREG_REQUESTEDTYPE = new BESIMREG_REQUESTEDTYPE();
SIMREG_REQUESTEDTYPE.IsNew = false;
SIMREG_REQUESTEDTYPE.REQUESTEDTYPEID = nullHandler.GetInt("REQUESTEDTYPEID");
SIMREG_REQUESTEDTYPE.TITLE = nullHandler.GetString("TITLE");
SIMREG_REQUESTEDTYPE.IDATE = nullHandler.GetDateTime("IDATE");
SIMREG_REQUESTEDTYPE.IUSER = nullHandler.GetInt("IUSER");
SIMREG_REQUESTEDTYPE.EDATE = nullHandler.GetDateTime("EDATE");
SIMREG_REQUESTEDTYPE.EUSER = nullHandler.GetInt("EUSER");
return SIMREG_REQUESTEDTYPE;
}
