protected void gvFee_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { BootstrapGridView gv = (BootstrapGridView)sender; MasterDataModel.MasterDataTransporterFee item = new MasterDataModel.MasterDataTransporterFee(); item.Transporter_ID = Convert.ToInt32(e.Keys[0]); item.Region_ID = Convert.ToByte(e.Keys[1]); item.HandlingFee = Convert.ToDecimal(e.NewValues["HandlingFee"]); item.OATDistanceLimit = Convert.ToInt32(e.NewValues["OATDistanceLimit"]); item.OATPriceUnderEqualLimit = Convert.ToDecimal(e.NewValues["OATPriceUnderEqualLimit"]); item.OATPriceAboveLimit = Convert.ToDecimal(e.NewValues["OATPriceAboveLimit"]); item.UpdateBy = UserProfile.Username; string res = MasterDataEntity.EditMasterDataTransporterFee(item); gv.JSProperties["cpRes"] = res; e.Cancel = true; if (res.Contains("Success")) { gv.CancelEdit(); gv.DataBind(); } }
public static string EditMasterDataTransporterFee(MasterDataModel.MasterDataTransporterFee item) { string res = DbTransaction.DbToString("sp_EditMasterDataTransporterFee", new { Transporter_ID = item.Transporter_ID, Region_ID = item.Region_ID, HandlingFee = item.HandlingFee, OATDistanceLimit = item.OATDistanceLimit, OATPriceUnderEqualLimit = item.OATPriceUnderEqualLimit, OATPriceAboveLimit = item.OATPriceAboveLimit, UpdateBy = item.UpdateBy }, true); return(res); }