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