private void GetLabelOptionList(string arrNo, int lineNo) { try { using (ArrivalBLL arrivalBLL = new ArrivalBLL()) { List <T_ARRIVAL_DTL_SUB> lstLabel = arrivalBLL.GetLabelList(arrNo, lineNo); //this.grdUNIT.DataSource = lstUnit; if (lstLabel == null) { lstLabel = new List <T_ARRIVAL_DTL_SUB>(); } //DataTable table = ConvertToDataTable(lstUnit); //this.grdUNIT.DataSource = table; this.dtbLabelOptionList = UiUtility.ConvertToDataTable(lstLabel); if (this.dtbLabelOptionList != null) { this.grdLabelOption.DataSource = this.dtbLabelOptionList; } } } catch (Exception ex) { XtraMessageBox.Show(ex.Message); } }
private void InsertLabelOption() { try { string result = string.Empty; GridView view = (GridView)this.grdLabelOption.Views[0]; var lstLabel = UiUtility.ConvertToList <T_ARRIVAL_DTL_SUB>(this.dtbLabelOptionList); using (ArrivalBLL arrBll = new ArrivalBLL()) { result = arrBll.InsertLabel(this.ARRIVAL_NO, this.LINE_NO, lstLabel, this._USER_ID); } if (result == "OK") { this.DialogResult = DialogResult.OK; } } catch (Exception ex) { XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } }
private void Get_ProductCard_List() { List <MaterialCard> lstPrdCard = null; try { base.BeginProcessing("Begin Load data...", "Please Waiting for Loading Data"); using (ArrivalBLL jobOrdBll = new ArrivalBLL()) { lstPrdCard = jobOrdBll.GetSelectMtlCard(this.SEQ_NO); } this.grdProductCard.DataSource = lstPrdCard; this.dntProductCard.DataSource = lstPrdCard; //default check all this.cardSelect.SelectAll(); } catch (Exception ex) { base.FinishedProcessing(); XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } finally { base.FinishedProcessing(); } }
private void GetMaterialList_Search(string search) { List <Material> lstPrd = null; try { base.BeginProcessing("Begin Load data...", "Please Waiting for Loading Data"); using (ArrivalBLL prdBll = new ArrivalBLL()) { lstPrd = prdBll.GetMaterialList(this.txtSearch.Text, string.Empty, this.PARTY_ID, this.WH_ID); } this.grdMaterial.DataSource = lstPrd; } catch (Exception ex) { base.FinishedProcessing(); XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } finally { base.FinishedProcessing(); } }
private void UploadPurchaseOrderSage50() { try { string resultMsg = string.Empty; using (ArrivalBLL arrivalBll = new ArrivalBLL()) { resultMsg = arrivalBll.UploadPurchaseOrder_SAGE50(this.dtCSVdata, this.USER_ID); } if (resultMsg == "OK") { NotifierResult.Show("Upload CSV Complete", "Result", 50, 1000, 50, NotifyType.Safe); } else { XtraMessageBox.Show(this, resultMsg, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } } catch (Exception ex) { XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } }
public async Task <IActionResult> DeleteConfirmed(int?id) { if (id == null) { return(NotFound()); } ResultObject resultObj = null; try { using (var arrBll = new ArrivalBLL()) { var lstArr = await arrBll.GetArrival(id); var arr = lstArr.First(); if (arr == null) { return(NotFound()); } arr.Updated_By = await base.CurrentUserId(); //resultObj = await arrBll.DeleteProduct(arr); } return(Json(new { success = true, data = (T_Arrival_Header)resultObj.ObjectValue, message = "Arrival Deleted." })); } catch (Exception ex) { return(Json(new { success = false, message = ex.Message })); } }
public async Task <IActionResult> UpdateArrivalDetailSub(List <T_Arrival_Detail_Sub> lstArrDtlSub) { var arrId = lstArrDtlSub.FirstOrDefault().ArrivalId; var lineno = lstArrDtlSub.FirstOrDefault().DtlLineNo; var userId = await base.CurrentUserId(); lstArrDtlSub.ForEach(u => { u.Created_By = userId; }); ResultObject resultObj; try { using (var arrBll = new ArrivalBLL()) { resultObj = await arrBll.UpdateArrivalDetailSub(arrId, lineno, lstArrDtlSub); } return(Json(new { success = true, data = lstArrDtlSub, message = "Update Success" })); } catch (Exception ex) { return(Json(new { success = false, data = lstArrDtlSub, message = ex.Message })); } }
public async Task <IActionResult> Edit([Bind("Id,ArrivalNo,ArrivalDate,RawMatTypeId,VendorId,ArrivalTypeId,PurchaseOrderNo,DocRefNo,DocRefDate,ArrivalRemark,CompanyCode,ArrivalDetails,Is_Active,Created_Date,Created_By,Updated_Date,Updated_By")] T_Arrival_Header t_Arrival_Header) { if (ModelState.IsValid) { t_Arrival_Header.Updated_By = await base.CurrentUserId(); ResultObject resultObj; try { using (var arrBll = new ArrivalBLL()) { resultObj = await arrBll.UpdateArrival(t_Arrival_Header); } return(Json(new { success = true, data = (T_Arrival_Header)resultObj.ObjectValue, message = "Arrival Update." })); } catch (Exception ex) { return(Json(new { success = false, data = t_Arrival_Header, message = ex.Message })); } } var err = ModelState.Values.SelectMany(x => x.Errors).Select(x => x.ErrorMessage).ToList(); return(Json(new { success = false, errors = err, data = t_Arrival_Header, message = "Update Failed" })); }
public async Task <IActionResult> Edit(int?id) { if (id == null) { return(NotFound()); } ViewBag.CompCode = await base.CurrentUserComp(); try { using (var arrBll = new ArrivalBLL()) { var lstArr = await arrBll.GetArrival(id); var arr = lstArr.First(); if (arr == null) { return(NotFound()); } return(PartialView(arr)); } } catch (Exception ex) { return(BadRequest(new { success = false, message = ex.Message })); } }
private void Arrival_GetPurchaseOrderList_Search(string search) { List <Document> lstDocument = null; try { base.BeginProcessing("Begin Load data...", "Please Waiting for Loading Data"); using (ArrivalBLL arrivalBll = new ArrivalBLL()) { lstDocument = arrivalBll.LovDocumentPurchaseList(this._PARTY_ID, search); } this.grdDocument.DataSource = lstDocument; } catch (Exception ex) { base.FinishedProcessing(); XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } finally { base.FinishedProcessing(); } }
public void GetMaterialList() { List <Material> lstPrd = null; try { base.BeginProcessing("Begin Load data...", "Please Waiting for Loading Data"); using (ArrivalBLL prdBll = new ArrivalBLL()) { lstPrd = prdBll.GetMaterialList(string.Empty, string.Empty, this.PARTY_ID, this.WH_ID); } this.grdMaterial.DataSource = lstPrd; } catch (Exception ex) { base.FinishedProcessing(); XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } finally { //GridView view = (GridView)this.grdProduct.Views[0]; //view.Columns["FREE_STOCK"].Visible = false; base.FinishedProcessing(); } }
private void InitializaLOVData() { try { //for warehouse //using (QueryBLL queryBll = new QueryBLL()) //{ // List<Warehouse> lstWH = queryBll.GetWarehouse(); // if (lstWH != null) // { // lstWH.Insert(0, new Warehouse { SEQ_NO = string.Empty, NAME = "(All)" }); // this.lueWarehouse.Properties.DataSource = lstWH; // this.rps_lueWH.DataSource = lstWH; // } //} using (MaterialBLL mtlBll = new MaterialBLL()) { List <Location> lstLoc = mtlBll.GetLocationList(); if (lstLoc != null) { // this.grvQrySummary_rps_lueLocation.DataSource = lstLoc; lstLoc.Insert(0, new Location { SEQ_NO = string.Empty, NAME = "(All)" }); this.lueWarehouse.Properties.DataSource = lstLoc; this.rps_lueWH.DataSource = lstLoc; } } //for ARR TYPE using (ArrivalBLL arrBll = new ArrivalBLL()) { List <M_ARRIVAL_TYPE> lstARR_TYPE = arrBll.GetArrivalTypeList(); if (lstARR_TYPE != null) { // lstWH.Insert(0, new Warehouse { SEQ_NO = string.Empty, NAME = "(All)" }); // this.lueWarehouse.Properties.DataSource = lstWH; this.rps_lueARR_TYPE.DataSource = lstARR_TYPE; } } //for party using (PartyBLL partyBll = new PartyBLL()) { List <Party> lstParty = partyBll.LovPratyList("V", string.Empty); lstParty.Insert(0, new Party { PARTY_ID = string.Empty, PARTY_NAME = "(All)" }); this.lueCUSTOMER.Properties.DataSource = lstParty; } } catch (Exception ex) { XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } }
public async Task <IActionResult> GetArrivalDetail(int?arrId) { try { using (var arrBll = new ArrivalBLL()) { var lstArrDtl = await arrBll.GetArrivalDetails(arrId); return(Json(new { data = lstArrDtl })); } } catch (Exception ex) { return(BadRequest(new { success = false, message = ex.Message })); } }
public async Task <IActionResult> GetLabelOption(int?arrId, int?lineNo) { try { using (var arrBll = new ArrivalBLL()) { var lstLabelOption = await arrBll.GetArrivalDetailSub(arrId, lineNo); return(Json(new { data = lstLabelOption })); } } catch (Exception ex) { return(BadRequest(new { success = false, message = ex.Message })); } }
public async Task <IActionResult> GetSearchArrival([Bind("ArrivalNo,DocRefNo,ArrivalTypeId,RawMatTypeId,ArrivalDateF,ArrivalDateT,DocRefDateF,DocRefDateT")] AdvSearchArrivalModel advArrModel) { try { using (var arrBll = new ArrivalBLL(await base.CurrentUserComp())) { var lstArr = await arrBll.GetArrival(advArrModel.ArrivalNo, advArrModel.DocRefNo, advArrModel.ArrivalTypeId, advArrModel.RawMatTypeId, advArrModel.ArrivalDateF, advArrModel.ArrivalDateT, advArrModel.DocRefDateF, advArrModel.DocRefDateT); return(Json(new { data = lstArr })); } } catch (Exception ex) { return(BadRequest(new { success = false, message = ex.Message })); } }
public async Task <IActionResult> GenerateLabel(List <T_Arrival_Detail> lstArrDtl) { var userId = await base.CurrentUserId(); ResultObject resultObj; try { using (var arrBll = new ArrivalBLL()) { resultObj = await arrBll.GenerateLabel(lstArrDtl, userId); } return(Json(new { success = true, data = lstArrDtl, message = "Generate Success" })); } catch (Exception ex) { return(Json(new { success = false, data = lstArrDtl, message = ex.Message })); } }
private void PrintProductCard_LABEL(List <T_ARRIVAL_DTL> jobOrdNo, string prodSEQNo, List <MaterialCard> lstPrdCard) { int printSeq = 0; try { base.BeginProcessing("Begin Load Report...", "Please Waiting for Loading Report"); ReportViewer viewer = new ReportViewer(); viewer.AutoCloseAfterPrint = true; XtraReport rpt = null; DataSet ds; using (ArrivalBLL jobOrdBll = new ArrivalBLL()) { ds = jobOrdBll.PrintProductCardReport(jobOrdNo, prodSEQNo, lstPrdCard, this.USER_ID, out printSeq); } MaterialCard objMTL = null; objMTL = lstPrdCard.Find(x => (x.WH_ID == "LC00002"));//PRESS if (objMTL != null) { rpt = new RPT_MATERIAL_CARD_LABEL_PRESS(); //change ds val } else { rpt = new RPT_MATERIAL_CARD_LABEL_2(); //rpt = new RPT_MATERIAL_CARD_LABEL(); } // } // else // { // rpt = UiUtility.GetReportByName(fixRpt); // } if (rpt != null) { rpt.DataSource = ds; rpt.Parameters["paramUserPrint"].Value = this.USER_ID; rpt.CreateDocument(); viewer.SetReport(rpt); viewer.LogPrintTime(printSeq); base.FinishedProcessing(); viewer.ShowDialog(); } else { XtraMessageBox.Show("Report is null"); } } catch (Exception ex) { base.FinishedProcessing(); XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } finally { base.FinishedProcessing(); } }
private void PrintProductCard_A4(List <T_ARRIVAL_DTL> jobOrdNo, string prodSEQNo, List <MaterialCard> lstPrdCard) { int printSeq = 0; try { base.BeginProcessing("Begin Load Report...", "Please Waiting for Loading Report"); DataSet ds; using (ArrivalBLL jobOrdBll = new ArrivalBLL()) { ds = jobOrdBll.PrintProductCardReport(jobOrdNo, prodSEQNo, lstPrdCard, this.USER_ID, out printSeq); } ReportViewer viewer = new ReportViewer(); viewer.AutoCloseAfterPrint = true; //RPT_PRODUCT_CARD rpt = new RPT_PRODUCT_CARD(); XtraReport rpt = null; string fixRpt = HTN.BITS.UIL.PLASESS.Properties.Settings.Default.FixProductCardReport;//UiUtility.FixProductCardReport; if (string.IsNullOrEmpty(fixRpt)) { //rpt = new RPT_MATERIAL_CARD(); } else { rpt = UiUtility.GetReportByName(fixRpt); } if (rpt != null) { rpt.DataSource = ds; rpt.Parameters["paramUserPrint"].Value = this.USER_ID; rpt.Parameters["paramPRODUCTION_TYPE"].Value = this.MTL_TYPE; rpt.CreateDocument(); viewer.SetReport(rpt); viewer.LogPrintTime(printSeq); base.FinishedProcessing(); viewer.ShowDialog(); } else { XtraMessageBox.Show("Report is null"); } } catch (Exception ex) { base.FinishedProcessing(); XtraMessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1); } finally { base.FinishedProcessing(); } }