protected MasterDataModel.MasterDataKendaraan GetGvValue(BootstrapGridView gv, int key = 0) { BootstrapComboBox cmbTransportir = gv.FindEditFormTemplateControl("cmbTransportir") as BootstrapComboBox; BootstrapTextBox txtNumber = gv.FindEditFormTemplateControl("txtNumber") as BootstrapTextBox; BootstrapTextBox txtCode = gv.FindEditFormTemplateControl("txtCode") as BootstrapTextBox; BootstrapTextBox txtMerk = gv.FindEditFormTemplateControl("txtMerk") as BootstrapTextBox; BootstrapSpinEdit spinYearManufacture = gv.FindEditFormTemplateControl("spinYearManufacture") as BootstrapSpinEdit; BootstrapComboBox cmbVehicleType = gv.FindEditFormTemplateControl("cmbVehicleType") as BootstrapComboBox; BootstrapComboBox cmbVehicleCategory = gv.FindEditFormTemplateControl("cmbVehicleCategory") as BootstrapComboBox; BootstrapSpinEdit spinCapacity = gv.FindEditFormTemplateControl("spinCapacity") as BootstrapSpinEdit; BootstrapComboBox cmbUnitCapacity = gv.FindEditFormTemplateControl("cmbUnitCapacity") as BootstrapComboBox; MasterDataModel.MasterDataKendaraan item = new MasterDataModel.MasterDataKendaraan(); item.Vehicle_ID = key; item.Transporter_ID = Convert.ToInt32(cmbTransportir.Value); item.Number = txtNumber.Text; item.Code = txtCode.Text; item.Merk = txtMerk.Text; item.YearManufacture = Convert.ToInt32(spinYearManufacture.Value); item.Type_ID = Convert.ToInt16(cmbVehicleType.Value); item.VehicleCategory_ID = Convert.ToInt16(cmbVehicleCategory.Value); item.Capacity = Convert.ToInt32(spinCapacity.Value); item.UnitCapacity_ID = Convert.ToInt32(cmbUnitCapacity.Value); item.CreationBy = UserProfile.Username; item.UpdateBy = UserProfile.Username; return(item); }
public static string DeleteMasterDataVehicle(MasterDataModel.MasterDataKendaraan item) { string res = DbTransaction.DbToString("sp_DeleteMasterDataVehicle", new { Vehicle_ID = item.Vehicle_ID, UpdateBy = item.UpdateBy }, true); return(res); }
protected void gv_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { BootstrapGridView gv = (BootstrapGridView)sender; MasterDataModel.MasterDataKendaraan item = new MasterDataModel.MasterDataKendaraan(); item.Vehicle_ID = (int)e.Keys[0]; item.UpdateBy = UserProfile.Username; string res = MasterDataEntity.DeleteMasterDataVehicle(item); gv.JSProperties["cpRes"] = res; e.Cancel = true; gv.DataBind(); }
protected void gv_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { BootstrapGridView gv = (BootstrapGridView)sender; MasterDataModel.MasterDataKendaraan item = GetGvValue(gv, (int)e.Keys[0]); string res = MasterDataEntity.EditMasterDataVehicle(item); gv.JSProperties["cpRes"] = res; e.Cancel = true; if (res.Contains("Success")) { gv.CancelEdit(); gv.DataBind(); } }
public static string AddMasterDataVehicle(MasterDataModel.MasterDataKendaraan item) { string res = DbTransaction.DbToString("sp_AddMasterDataVehicle", new { Transporter_ID = item.Transporter_ID, Number = item.Number, Code = item.Code, Merk = item.Merk, YearManufacture = item.YearManufacture, Type_ID = item.Type_ID, VehicleCategory_ID = item.VehicleCategory_ID, Capacity = item.Capacity, UnitCapacity_ID = item.UnitCapacity_ID, CreationBy = item.CreationBy }, true); return(res); }