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