public ActionResult Edit(int id, Models.AppExpenseBudgetView collection) { try { int outputId = _dataobject.Update(collection); return(RedirectToAction(this.ActionReturn())); } catch (Exception ex) { Services.GlobalErrors.Parse(ModelState, _dataobject.Errors, ex); return(PartialView(this._updateview, collection)); } }
public int Insert(Models.AppExpenseBudgetView data) { try { this.Validate(data); data.CreatedBy = GlobalVariant.GetAppUser().UserID; data.CreatedDateTime = DateTime.Now; SqlParameter[] parameters = ExConvert.Data2SqlParam(data, this._metaobject, this._paramnameoutput).ToArray(); this._db.Database.ExecuteSqlCommand(this._storeNameI, parameters); return((int)parameters.GetValueSqlParam(this._paramnameoutput)); } catch (Exception) { throw; } }
public int Update(Models.AppExpenseBudgetView data) { try { this.Validate(data); data.ModifiedBy = GlobalVariant.GetAppUser().UserID; data.ModifiedDateTime = DateTime.Now; SqlParameter pOriginal = ExConvert.ParseSqlParam(data, this._metaobject.GetMetaByColumnName(this._paramnameoutput), this._paramnameupdate); var parameters = ExConvert.Data2SqlParam(data, this._metaobject, pOriginal).ToArray(); this._db.Database.ExecuteSqlCommand(this._storeNameU, parameters); return(data.ExpenseBudgetID); } catch (Exception) { throw; } }