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