public ActionResult Add(SIMREG_DELIVEREDBYViewModel model)
{
try
{
if (ModelState.IsValid)
{
_boSIMREG_DELIVEREDBY = new BOSIMREG_DELIVEREDBY();
var beSIMREG_DELIVEREDBY = new BESIMREG_DELIVEREDBY
{
DELIVEREDBYID = model.DELIVEREDBYID,
TITLE = model.TITLE,
USERNAME = model.USERNAME,
IDATE = DateTime.Now,
IUSER = model.IUSER,
EDATE = DateTime.Now,
EUSER = model.EUSER,
IsNew = true
};
_boSIMREG_DELIVEREDBY.Save(beSIMREG_DELIVEREDBY);
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 Delete(BESIMREG_DELIVEREDBY entity)
{
try
{
int entityId = entity.DELIVEREDBYID;
sqlHelper = new SQLHelper(true);
daSIMREG_DELIVEREDBY.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_DELIVEREDBY entity)
{
string sql = string.Empty;
try
{
if (entity.IsNew)
{
// update tblTableCode
DATableCode daTableCode = new DATableCode();
//entity.DELIVEREDBYID = daTableCode.GetTableId(sqlHelper, "DELIVEREDBYID", "SIMREG_DELIVEREDBY");
sql = sqlHelper.MakeSQL(@"INSERT INTO SIMREG_DELIVEREDBY(DELIVEREDBYID, TITLE, USERNAME, IDATE, IUSER, EDATE, EUSER)"
+ " VALUES(SQ_SIMREG_DELIVEREDID.Nextval, $s, $s, SYSDATE, $n, SYSDATE, $n)",
//entity.DELIVEREDBYID,
entity.TITLE, entity.USERNAME,
//entity.IDATE,
entity.IUSER,
//entity.EDATE,
entity.EUSER);
}
else
{
sql = sqlHelper.MakeSQL(@"UPDATE SIMREG_DELIVEREDBY SET TITLE=$s, USERNAME=$s, EDATE=SYSDATE, EUSER=$n WHERE DELIVEREDBYID=$n",
entity.TITLE, entity.USERNAME,
//entity.EDATE,
entity.EUSER,
entity.DELIVEREDBYID);
}
sqlHelper.ExecuteNonQuery(sql);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private BESIMREG_DELIVEREDBY PreaperSIMREG_DELIVEREDBYObject(NULLHandler nullHandler)
{
BESIMREG_DELIVEREDBY SIMREG_DELIVEREDBY = new BESIMREG_DELIVEREDBY();
SIMREG_DELIVEREDBY.IsNew = false;
SIMREG_DELIVEREDBY.DELIVEREDBYID = nullHandler.GetInt("DELIVEREDBYID");
SIMREG_DELIVEREDBY.TITLE = nullHandler.GetString("TITLE");
SIMREG_DELIVEREDBY.USERNAME = nullHandler.GetString("USERNAME");
SIMREG_DELIVEREDBY.CANEDIT = nullHandler.GetBoolean("CANEDIT");
SIMREG_DELIVEREDBY.IDATE = nullHandler.GetDateTime("IDATE");
SIMREG_DELIVEREDBY.IUSER = nullHandler.GetInt("IUSER");
SIMREG_DELIVEREDBY.EDATE = nullHandler.GetDateTime("EDATE");
SIMREG_DELIVEREDBY.EUSER = nullHandler.GetInt("EUSER");
return SIMREG_DELIVEREDBY;
}
