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();
}
}
private void GetDataCmb()
{
liTransporter = MasterDataEntity.GetMasterDataTransporter_CMB(0);
liVehicleType = MasterDataEntity.GetMasterDataVehicleType_CMB(0, 0);
liVehicleNumber = MasterDataEntity.GetMasterDataVehicleNumber_CMB(0, 0);
liDriver = MasterDataEntity.GetMasterDataDriver_CMB();
}
protected void gvFee_BeforePerformDataSelect(object sender, EventArgs e)
{
BootstrapGridView gvFee = (BootstrapGridView)sender;
int transporter_ID = Convert.ToInt32(gvFee.GetMasterRowKeyValue());
gvFee.DataSource = MasterDataEntity.GetMasterDataTransporterFee(transporter_ID, CommonDataModel.ActiveType.Active);
}
protected void Page_Load(object sender, EventArgs e)
{
Page.Header.DataBind();
if (!IsPostBack)
{
//set autorization page
UserProfile.SetAuthorization(new string[] { UserProfile.USER_EKSTERNAL, UserProfile.USER_INTERNAL });
//set sp3m id and sp3m number
NoSP3M = string.Empty;
SP3M_ID = string.IsNullOrEmpty((string)Request.QueryString["SP3M_ID"]) ? 0 : Convert.ToInt16(Request.QueryString["SP3M_ID"]);
StatusSP3M = string.IsNullOrEmpty((string)Request.QueryString["Status"]) ? string.Empty : Request.QueryString["Status"].ToString().ToUpper();
hfSP3MId.Set("Id", SP3M_ID.ToString());
//binding force combobox
cmbForce.DataSource = MasterDataEntity.GetMasterDataForce();
cmbForce.DataBind();
//binding unity combobox
cmbUnity.DataSource = MasterDataEntity.GetMasterDataUnity();
cmbUnity.DataBind();
//binding sp3m control
BindingSP3M(SP3M_ID);
//set grid product sp3m
gvProductSP3M.DataSource = ListProductSP3M(SP3M_ID);
gvProductSP3M.DataBind();
//set sp3m is editable
if (StatusSP3M.Contains("SAVED"))
{
SetEnabled(true);
SetEnabledButton(UserProfile.Roles, StatusSP3M);
btnClose.ClientVisible = true;
btnCancel.ClientVisible = false;
}
else
{
//new entry
if (SP3M_ID == 0)
{
SetEnabled(true);
SetEnabledButton(UserProfile.Roles, StatusSP3M);
}
else
{
SetEnabled(false);
SetEnabledButton(UserProfile.Roles, StatusSP3M);
}
}
}
}
protected void cmbRegion_Init(object sender, EventArgs e)
{
BootstrapComboBox cmb = sender as BootstrapComboBox;
cmb.DataSource = MasterDataEntity.GetMasterDataRegion();
cmb.DataBind();
if (!gv.IsNewRowEditing)
{
cmb.Value = Convert.ToString(gv.GetRowValues(gv.EditingRowVisibleIndex, "Region_ID"));
}
}
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 List <MasterDataModel.MasterDataTBBM> ListTBBM()
{
List <MasterDataModel.MasterDataTBBM> _ListTBBM = new List <MasterDataModel.MasterDataTBBM>();
_ListTBBM = MasterDataEntity.GetMasterDataTBBM_CMB();
//add null items
_ListTBBM.Add(new MasterDataModel.MasterDataTBBM
{
TBBM_ID_PK = 0,
Name = ""
});
return(_ListTBBM);
}
protected List <MasterDataModel.MasterDataTransporter> ListTransporter()
{
List <MasterDataModel.MasterDataTransporter> _ListTransporter = new List <MasterDataModel.MasterDataTransporter>();
_ListTransporter = MasterDataEntity.GetMasterDataTransporter_CMB();
//add null items
_ListTransporter.Add(new MasterDataModel.MasterDataTransporter
{
Transporter_ID = 0,
TransporterName = ""
});
return(_ListTransporter);
}
protected List <MasterDataModel.MasterDataSPSH> ListSPSH()
{
List <MasterDataModel.MasterDataSPSH> _ListSPSH = new List <MasterDataModel.MasterDataSPSH>();
_ListSPSH = MasterDataEntity.GetMasterDataSPSH_CMB();
//add null items
_ListSPSH.Add(new MasterDataModel.MasterDataSPSH
{
SPSH_ID = string.Empty,
Name = ""
});
return(_ListSPSH);
}
protected void gv_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
{
BootstrapGridView gv = (BootstrapGridView)sender;
MasterDataModel.MasterDataTBBM item = new MasterDataModel.MasterDataTBBM();
item.TBBM_ID_PK = Convert.ToInt32(e.Keys[0].ToString());
item.UpdateBy = UserProfile.Username;
string res = MasterDataEntity.DeleteMasterDataTBBM(item);
gv.JSProperties["cpRes"] = res;
e.Cancel = true;
gv.DataBind();
}
protected void cmbUnitCapacity_Init(object sender, EventArgs e)
{
BootstrapComboBox cmb = sender as BootstrapComboBox;
List <MasterDataModel.MasterDataKendaraan> liVehicle = MasterDataEntity.GetMasterDataUnitCapacity_CMB();
cmb.DataSource = liVehicle;
cmb.DataBind();
if (liVehicle.Count == 1)
{
cmb.SelectedIndex = 0;
}
if (!gv.IsNewRowEditing)
{
cmb.Value = Convert.ToString(gv.GetRowValues(gv.EditingRowVisibleIndex, "UnitCapacity_ID"));
}
}
public HrmResultEntity <MasterDataEntity> SaveMasterData(MasterDataEntity data)
{
var par = new DynamicParameters();
par.Add("@Id", data.Id);
par.Add("@GroupId", data.GroupId);
par.Add("@Name", data.Name);
par.Add("@Value", data.Value);
par.Add("@Description", data.Description);
par.Add("@OrderNo", data.OrderNo);
par.Add("@LanguageId", data.LanguageId);
par.Add("@IsActive", data.IsActive);
par.Add("@IsDeleted", data.IsDeleted);
par.Add("@DbName", CurrentUser.DbName);
par.Add("@Color", data.Color);
return(ListProcedure <MasterDataEntity>("System_Update_SaveMasterData", par));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//binding force tbbm
cmbTBBM.DataSource = MasterDataEntity.GetMasterDataTBBM(CommonDataModel.ActiveType.Active);
cmbTBBM.DataBind();
//binding force combobox
cmbForce.DataSource = MasterDataEntity.GetMasterDataForce();
cmbForce.DataBind();
//binding unity combobox
cmbUnity.DataSource = MasterDataEntity.GetMasterDataUnity();
cmbUnity.DataBind();
}
}
protected void gv_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
BootstrapGridView gv = (BootstrapGridView)sender;
MasterDataModel.MasterDataSPSH item = GetGvValue(gv, e.Keys[0].ToString());
string res = MasterDataEntity.EditMasterDataSPSH(item);
gv.JSProperties["cpRes"] = res;
e.Cancel = true;
if (res.Contains("Success"))
{
gv.CancelEdit();
gv.DataBind();
}
}
protected void gv_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
BootstrapGridView gv = (BootstrapGridView)sender;
MasterDataModel.MasterDataKendaraan item = GetGvValue(gv);
string res = MasterDataEntity.AddMasterDataVehicle(item);
gv.JSProperties["cpRes"] = res;
e.Cancel = true;
if (res.Contains("Success"))
{
gv.CancelEdit();
gv.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//binding force tbbm
cmbTBBM.DataSource = MasterDataEntity.GetMasterDataTBBM(CommonDataModel.ActiveType.Active);
cmbTBBM.DataBind();
//binding force combobox
cmbForce.DataSource = MasterDataEntity.GetMasterDataForce();
cmbForce.DataBind();
//binding unity combobox
cmbUnity.DataSource = MasterDataEntity.GetMasterDataUnity();
cmbUnity.DataBind();
//Report.xReportOAT report = new FrancoHandling_App.Report.xReportOAT();
//docViewer.OpenReport(report);
}
}
public HrmResultEntity <bool> SaveListMasterData(MasterDataEntity data, List <LocalizedDataEntity> listData)
{
var par = new DynamicParameters();
par.Add("@Id", data.Id);
par.Add("@GroupId", data.GroupId);
par.Add("@Name", data.Name);
par.Add("@Value", data.Value);
par.Add("@Description", data.Description);
par.Add("@OrderNo", data.OrderNo);
par.Add("@LanguageId", data.LanguageId);
par.Add("@IsActive", data.IsActive);
par.Add("@IsDeleted", data.IsDeleted);
par.Add("@DbName", CurrentUser.DbName);
par.Add("@Color", data.Color);
par.Add("@DataType", data.DataType);
par.Add("@CreatedBy", data.CreatedBy);
par.Add("@Code", data.Code);
par.Add("@LocalizedMasterData", listData.ConvertToUserDefinedDataTable(), DbType.Object);
return(Procedure("System_Update_SaveListMasterData", par));
}
protected void gv_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
BootstrapGridView gv = (BootstrapGridView)sender;
MasterDataModel.MasterDataDistance item = new MasterDataModel.MasterDataDistance();
item.TBBM_ID = Convert.ToInt32(e.Keys[0]);
item.SPSH_ID = Convert.ToString(e.Keys[1]);
item.Distance = Convert.ToDecimal(e.NewValues["Distance"]);
item.NormalRate = Convert.ToDecimal(e.NewValues["NormalRate"]);
item.SpecialRate = Convert.ToDecimal(e.NewValues["SpecialRate"]);
item.UpdateBy = UserProfile.Username;
string res = MasterDataEntity.EditMasterDataDistance(item);
gv.JSProperties["cpRes"] = res;
e.Cancel = true;
if (res.Contains("Success"))
{
gv.CancelEdit();
gv.DataBind();
}
}
public string SaveListMasterData(MasterDataEntity data, List <LocalizedDataEntity> listData)
{
var response = this._masterDataRepository.SaveListMasterData(data, listData);
return(JsonConvert.SerializeObject(response));
}
public IActionResult MasterDataGetListByGroupCode([FromBody] MasterDataEntity _object)
{
DataTable result = _masterDataService.GetListByGroupCode(_object.GroupCode);
return(Ok(result));
}
protected void gv_DataBinding(object sender, EventArgs e)
{
gv.DataSource = MasterDataEntity.GetMasterDataSPSH(CommonDataModel.ActiveType.Active);
}
public IActionResult MasterDataInsert([FromBody] MasterDataEntity _object)
{
int result = _masterDataService.Insert(_object.GroupCode, _object.Code, _object.Name, _object.Order);
return(Ok(result));
}
protected void gvMasterDataTransportir_DataBinding(object sender, EventArgs e)
{
gvMasterDataTransportir.DataSource = MasterDataEntity.GetMasterDataTransporter(CommonDataModel.ActiveType.Active);
}
