private void frmPickListView_Load(object sender, EventArgs e)
{
FormLoaded = false;
txtCustomer.Text = string.Empty;
txtNo.Text = string.Empty;
txtTransDate.Text = string.Empty;
FormLoaded = true;
PO = null;
RePackTran = false;
}
private void btnSubmit_Click(object sender, EventArgs e)
{
Button oBtn = (Button)sender;
if (oBtn != null && Formloaded)
{
using (var context = new TTI2Entities())
{
string BoxNumber = txtBoxNumber.Text.ToString();
TLCSV_StockOnHand SOH = context.TLCSV_StockOnHand.Where(x => x.TLSOH_BoxNumber == BoxNumber).FirstOrDefault();
if (SOH != null)
{
frmBoxView_Load(this, null);
txtWareHouse.Text = context.TLADM_WhseStore.Find(SOH.TLSOH_WareHouse_FK).WhStore_Description;
txtColour.Text = context.TLADM_Colours.Find(SOH.TLSOH_Colour_FK).Col_Display;
txtGrade.Text = SOH.TLSOH_Grade;
txtSize.Text = context.TLADM_Sizes.Find(SOH.TLSOH_Size_FK).SI_Description;
txtStyle.Text = context.TLADM_Styles.Find(SOH.TLSOH_Style_FK).Sty_Description;
txtPickingList.Text = SOH.TLSOH_WareHousePickList + " / " + SOH.TLSOH_PickListNo;
txtDeliveryNote.Text = SOH.TLSOH_WareHouseDeliveryNo + " / " + SOH.TLSOH_DNListNo;
txtGrade.Text = SOH.TLSOH_Grade;
txtBoxedQty.Text = SOH.TLSOH_BoxedQty.ToString();
TLCSV_PurchaseOrder POOrder = context.TLCSV_PurchaseOrder.Find(SOH.TLSOH_POOrder_FK);
if (POOrder != null)
{
txtPoOrder.Text = POOrder.TLCSVPO_PurchaseOrder;
txtCustomer.Text = context.TLADM_CustomerFile.Find(POOrder.TLCSVPO_Customer_FK).Cust_Description;
}
if (!SOH.TLSOH_Write_Off)
{
chkInStock.Checked = true;
if (SOH.TLSOH_Picked && SOH.TLSOH_DNListNo == 0)
{
chkPicked.Checked = SOH.TLSOH_Picked;
}
if (SOH.TLSOH_Picked && SOH.TLSOH_DNListNo != 0)
{
chkInStock.Checked = false;
chkDelivered.Checked = true;
}
if (SOH.TLSOH_Returned)
{
chkInStock.Checked = true;
chkPicked.Checked = SOH.TLSOH_Picked;
chkReturned.Checked = SOH.TLSOH_Returned;
}
}
else
{
chkWriteOff.Checked = true;
}
}
else
{
MessageBox.Show("No data matching the text as entered found");
frmBoxView_Load(this, null);
}
}
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
Button oBtn = (Button)sender;
IList <TLCSV_StockOnHand> soh = null;
if (oBtn != null && FormLoaded)
{
DataT.Rows.Clear();
using (var context = new TTI2Entities())
{
int Txt = Convert.ToInt32(txtNo.Text);
if (_PickList)
{
soh = context.TLCSV_StockOnHand.Where(x => x.TLSOH_PickListNo == Txt).OrderBy(x => x.TLSOH_BoxNumber).ToList();
}
else
{
soh = context.TLCSV_StockOnHand.Where(x => x.TLSOH_DNListNo == Txt).OrderBy(x => x.TLSOH_BoxNumber).ToList();
}
if (soh.Count > 0)
{
//----------------------------------------------
// WareHouse
// Box Number
// Purchase Order
// Purchase Order Date
// Style
// Colour
// Size
// Boxed Qty
//----------------------------------------------------------
var PO_Key = soh.FirstOrDefault().TLSOH_POOrder_FK;
PO = context.TLCSV_PurchaseOrder.Find(PO_Key);
if (PO != null)
{
RePackTran = PO.TLCSVPO_RepackTransaction;
txtCustomer.Text = context.TLADM_CustomerFile.Find(PO.TLCSVPO_Customer_FK).Cust_Description;
txtTransDate.Text = PO.TLCSVPO_TransDate.ToShortDateString();
}
foreach (var Item in soh)
{
DataRow dr = DataT.NewRow();
dr[0] = context.TLADM_WhseStore.Find(Item.TLSOH_WareHouse_FK).WhStore_Description;
dr[1] = Item.TLSOH_BoxNumber;
var PODetail = context.TLCSV_PuchaseOrderDetail.Find(Item.TLSOH_POOrderDetail_FK);
if (PODetail != null)
{
dr[2] = context.TLCSV_PurchaseOrder.Find(PODetail.TLCUSTO_PurchaseOrder_FK).TLCSVPO_PurchaseOrder;
dr[3] = context.TLCSV_PurchaseOrder.Find(PODetail.TLCUSTO_PurchaseOrder_FK).TLCSVPO_TransDate.ToShortDateString();
}
dr[4] = context.TLADM_Styles.Find(Item.TLSOH_Style_FK).Sty_Description;
dr[5] = context.TLADM_Colours.Find(Item.TLSOH_Colour_FK).Col_Display;
dr[6] = context.TLADM_Sizes.Find(Item.TLSOH_Size_FK).SI_Description;
dr[7] = Item.TLSOH_BoxedQty;
DataT.Rows.Add(dr);
}
}
else
{
using (DialogCenteringService centeringService = new DialogCenteringService(this)) // center message box
{
MessageBox.Show("No records found for selection made");
}
txtCustomer.Text = string.Empty;
txtTransDate.Text = string.Empty;
}
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
Button oBtn = (Button)sender;
if (oBtn != null && FormLoaded)
{
Number = txtPONumber.Text.Substring(-4 + txtPONumber.Text.TrimEnd().Length, 4);
//===========================================================================
// We have to put in some form of logic to sum the various columns
// and conmpare to PODetails and if there is a difference warn the user and abort
//===============================================================================================
using (var context = new TTI2Entities())
{
foreach (DataColumn dc in dt.Columns)
{
if (dc.Ordinal > 0 && dc.Ordinal < -1 + dt.Columns.Count)
{
var ColTotal = 0;
try
{
foreach (DataRow dr in dt.Rows)
{
ColTotal += dr.Field <int>(dc.Ordinal) * dr.Field <int>(-1 + dt.Columns.Count);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
return;
}
var SizePk = Convert.ToInt32(dc.ColumnName);
var SizeDetail = PODetails.Where(x => x.TLCUSTO_Size_FK == SizePk).FirstOrDefault();
if (SizeDetail != null)
{
if (ColTotal != SizeDetail.TLCUSTO_Qty)
{
var TLSizes = context.TLADM_Sizes.Find(SizePk);
if (TLSizes != null)
{
var Message = "There is a difference between what was ordered and what was captured for Size " + TLSizes.SI_Description;
var TopMessage = "Ordered " + SizeDetail.TLCUSTO_Qty.ToString() + " vs a Repack value " + ColTotal.ToString();
using (DialogCenteringService centeringService = new DialogCenteringService(this)) // center message box
{
MessageBox.Show(Message, TopMessage, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
return;
}
}
}
}
}
PO = context.TLCSV_PurchaseOrder.Find(_PurchaseKey);
if (PO != null)
{
PO.TLCSVPO_RepackTransaction = true;
}
foreach (DataRow Row in dt.Rows)
{
int CellTotals = 0;
foreach (DataColumn dc in dt.Columns)
{
if (dc.DataType == typeof(String))
{
continue;
}
CellTotals += Row.Field <int>(dc.Ordinal);
}
if (CellTotals == 0)
{
continue;
}
foreach (DataColumn dc in dt.Columns)
{
try
{
var SizeSelected = Convert.ToInt32(dc.ColumnName);
var SizeObject = context.TLADM_Sizes.Find(SizeSelected);
if (SizeObject != null)
{
TLCSV_RePackConfig RePac = new TLCSV_RePackConfig();
RePac.PORConfig_PONumber_Fk = _PurchaseKey;
RePac.PORConfig_Colour_FK = ColourPk;
RePac.PORConfig_Style_FK = StylePk;
RePac.PORConfig_Size_FK = SizeObject.SI_id;
RePac.PORConfig_SizeBoxQty = Row.Field <int>(dc.Ordinal);
RePac.PORConfig_TotalBoxes = Row.Field <int>(dt.Columns.Count - 1);
RePac.PORConfig_BoxNumber = Row.Field <string>(0);
RePac.PORConfig_Display = Row.Field <String>(0) + " : " + SizeObject.SI_Description;
RePac.PORConfig_BoxNumber_Key = Convert.ToInt32(Number);
context.TLCSV_RePackConfig.Add(RePac);
}
}
catch (Exception ex)
{
continue;
}
}
}
try
{
context.SaveChanges();
MessageBox.Show("Data successfully saved to the database");
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
