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