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