private void btnSubmit_Click(object sender, EventArgs e)
{
Button oBtn = (Button)sender;
if (!_Export)
{
var Depts = (TLADM_Departments)cmboDepartments.SelectedItem;
if (Depts == null)
{
using (DialogCenteringService svces = new DialogCenteringService(this))
{
MessageBox.Show("Please select a CMT to report on");
return;
}
}
CMTReportOptions repOps = new CMTReportOptions();
repOps.SLFCmt = Depts.Dep_Id;
DateTime dt = Convert.ToDateTime(dtpToDate.Value.ToShortDateString());
repOps.toDate = dt.AddHours(23);
// repOps.toDate = (DateTimedtpToDate.Value;
frmCMTViewRep vRep = new frmCMTViewRep(18, repOps);
int h = Screen.PrimaryScreen.WorkingArea.Height;
int w = Screen.PrimaryScreen.WorkingArea.Width;
vRep.ClientSize = new Size(w, h);
vRep.ShowDialog(this);
}
}
private void ShowMessagebox(string Message)
{
using (DialogCenteringService centeringService = new DialogCenteringService(this)) // center message box
{
MessageBox.Show(this, Message);
}
}
private void dataGridView1_CellValidating(object sender, DataGridViewCellValidatingEventArgs e)
{
DataGridView oDgv = (DataGridView)sender;
if (oDgv != null && formloaded)
{
if (e.ColumnIndex == 3)
{
decimal wt = 0.0M;
decimal.TryParse(e.FormattedValue.ToString(), out wt);
if (wt > 0)
{
var KnitOrder = (TLKNI_Order)cmboKnitOrders.SelectedItem;
if (KnitOrder != null)
{
using (var context = new TTI2Entities())
{
var Qual = context.TLADM_Griege.Find(KnitOrder.KnitO_Product_FK);
if (Qual != null)
{
var MinWeightAllowed = Qual.TLGreige_KgPerPiece / Convert.ToDecimal(1.25);
var MaxWeightAllowed = Qual.TLGreige_KgPerPiece * Convert.ToDecimal(1.25);
if (wt > MaxWeightAllowed)
{
String s = String.Format("The maximum weight permitted is {0} ", Math.Round(MaxWeightAllowed, 2));
using (DialogCenteringService centeringService = new DialogCenteringService(this)) // center message box
{
MessageBox.Show("The value entered exceeds the maximum weight allowed", s);
}
e.Cancel = true;
}
else if (wt < MinWeightAllowed)
{
String s = String.Format("The minimum weight permitted is {0} ", Math.Round(MinWeightAllowed, 2));
using (DialogCenteringService centeringService = new DialogCenteringService(this)) // center message box
{
DialogResult res = MessageBox.Show("The value entered is less than the minimum weight expected. Proceed ?", s, MessageBoxButtons.YesNo, MessageBoxIcon.Error);
if (res == DialogResult.No)
{
e.Cancel = true;
}
}
}
}
}
}
}
else
{
using (DialogCenteringService centeringService = new DialogCenteringService(this)) // center message box
{
MessageBox.Show("Please enter a value");
}
e.Cancel = true;
}
}
}
}
private void rbNonCompliance_CheckedChanged(object sender, EventArgs e)
{
RadioButton oRad = (RadioButton)sender;
if (oRad != null && oRad.Checked && FormLoaded)
{
using (DialogCenteringService centeringService = new DialogCenteringService(this)) // center message box
{
MessageBox.Show("Work in Progress");
}
}
}
private void frmOnOffHold_FormClosing(object sender, FormClosingEventArgs e)
{
Form oFrm = (Form)sender;
if (oFrm != null && this.RememberSave)
{
using (DialogCenteringService centeringService = new DialogCenteringService(this)) // center message box
{
MessageBox.Show("There is a transaction that must be saved prior to existing this transaction");
e.Cancel = true;
}
}
}
private void UpdateNotifcationClick()
{
//Prompt once for the user to update the tool.
DialogResult result;
using (DialogCenteringService centeringService = new DialogCenteringService(this)) // center message box
{
result = MessageBox.Show($"A new update is available {UpdateProgram.LatestRelease.TagName}!" +
$" Would you like to install it?", "Updater", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1);
}
if (result == DialogResult.Yes)
{
UpdateApplication();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
Button oBtn = sender as Button;
if (oBtn != null && FormLoaded)
{
using (var context = new TTI2Entities())
{
foreach (DataRow Row in ExistingDyeBatches.Rows)
{
if (!Row.Field <bool>(1))
{
continue;
}
var Pk = Row.Field <int>(0);
var DB = context.TLDYE_DyeBatch.Find(Pk);
if (DB != null)
{
DB.DYEB_Closed = true;
}
}
try
{
context.SaveChanges();
using (DialogCenteringService centeringService = new DialogCenteringService(this)) // center message box
{
MessageBox.Show("Data successfully stored to the database");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
this.frmCloseDyeBatches_Load(this, null);
}
}
}
}
private void dataGridViewx_CellValidating(object sender, DataGridViewCellValidatingEventArgs e)
{
DataGridView oDgv = (DataGridView)sender;
//==============================================
if (oDgv != null && FormLoaded)
{
if (e.ColumnIndex == -1 + oDgv.Columns.Count)
{
String CellValue = oDgv.CurrentRow.Cells[e.ColumnIndex].EditedFormattedValue.ToString();
if (String.IsNullOrEmpty(CellValue) || Convert.ToInt32(CellValue) == 0)
{
using (DialogCenteringService centeringService = new DialogCenteringService(this)) // center message box
{
MessageBox.Show("Please enter a value greater than 0", "Error", MessageBoxButtons.OK, MessageBoxIcon.Question);
}
e.Cancel = true;
}
}
}
}
private void Application_Idle(object sender, EventArgs e)
{
if (UpdateProgram.CanUpdate && !Runtime.DisableUpdatePrompt)
{
if (!UpdatePromptShown)
{
//Prompt once for the user to update the tool.
UpdatePromptShown = true;
DialogResult result;
using (DialogCenteringService centeringService = new DialogCenteringService(this)) // center message box
{
result = MessageBox.Show($"A new update is available {UpdateProgram.LatestRelease.TagName}!" +
$" Would you like to install it?", "Updater", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1);
}
if (result == DialogResult.Yes)
{
UpdateApplication();
}
}
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
Button oBtn = (Button)sender;
if (oBtn != null && FormLoaded)
{
if (QueryParms.Styles.Count == 0)
{
using (DialogCenteringService svcs = new DialogCenteringService(this))
{
MessageBox.Show("Please select a style from the dropdown box");
return;
}
}
if (QueryParms.Colours.Count == 0)
{
using (DialogCenteringService svcs = new DialogCenteringService(this))
{
MessageBox.Show("Please select a colour from the dropdown box");
return;
}
}
CSVServices csvService = new CSVServices();
frmCSViewRep vRep = new frmCSViewRep(26, QueryParms, csvService);
int h = Screen.PrimaryScreen.WorkingArea.Height;
int w = Screen.PrimaryScreen.WorkingArea.Width;
vRep.ClientSize = new Size(w, h);
vRep.ShowDialog(this);
cmboColours.Items.Clear();
cmboStyles.Items.Clear();
frmDaysSales_Load(this, null);
}
}
private void PrincipalForm_FormClosing(object sender, FormClosingEventArgs e)
{
DialogResult dg;
using (DialogCenteringService centeringService = new DialogCenteringService(this)) // center message box
{
dg = MessageBox.Show(this,
"Tem certeza que deseja sair?",
"Encerrar programa",
MessageBoxButtons.YesNo, MessageBoxIcon.Question);
}
if (dg == DialogResult.No)
{
e.Cancel = true;
}
else
{
SegurancaForm f = Application.OpenForms["SegurancaForm"] as SegurancaForm;
f.Close();
}
}
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 btnRecalculate_Click(object sender, EventArgs e)
{
Button oBtn = (Button)sender;
var oDgv = (DataGridView)dataGridView1;
if (oBtn != null && FormLoaded)
{
var RowCount = (from Rows in dataGridView1.Rows.Cast <DataGridViewRow>()
where (bool)Rows.Cells[1].Value == true
select Rows).Count();
if (RowCount == 0)
{
using (DialogCenteringService centeringService = new DialogCenteringService(this)) // center message box
{
MessageBox.Show("Please select at least one row to process");
}
return;
}
using (var context = new TTI2Entities())
{
foreach (DataRow dr in dt.Rows)
{
if (!dr.Field <bool>(1))
{
continue;
}
var CurrentRow = oDgv.CurrentRow;
var CurrentCell = oDgv.CurrentCell;
if (CurrentRow != null)
{
var CutSheetIndex = (int)CurrentRow.Cells[0].Value;
var CutSheet = context.TLCUT_CutSheet.Find(CutSheetIndex);
if (CutSheet != null)
{
context.TLCUT_ExpectedUnits.Where(x => x.TLCUTE_CutSheet_FK == CutSheet.TLCutSH_Pk)
.Update(x => new TLCUT_ExpectedUnits()
{
TLCUTE_EstNettWeight = 0, TLCUTE_NoOfBinding = 0, TLCUTE_NoofGarments = 0, TLCUTE_NoOfTrims = 0, TLCUTE_MarkerRatio = 0
});
var DBDetails = (from DBatch in context.TLDYE_DyeBatch
join DBatchDetails in context.TLDYE_DyeBatchDetails on DBatch.DYEB_Pk equals DBatchDetails.DYEBD_DyeBatch_FK
where DBatch.DYEB_Pk == CutSheet.TLCutSH_DyeBatch_FK
select DBatchDetails).ToList();
foreach (var dbd in DBDetails)
{
if (dbd != null)
{
//Is a body or is it a Trim Record
//===================================================
if (dbd.DYEBD_BodyTrim)
{
//--------------------------------------------------------------
// The aim of this event is to calculate the number of expected units
// based on the nett weight of the piece of fabric selected
// less the weight of the calculated binding needed (if applicable)
//------------------------------------------------------------------
var Yield = core.FabricYield(dbd.DYEBO_DiskWeight, dbd.DYEBO_Width);
var NettWeight = dbd.DYEBO_Nett;
var BindWeight = 0.00M;
var TrimWeight = 0.00M;
//---------------------------------------------------------
// We now have to establish whether the style relating to the dye batch
// has a Binding and if so what is the rating
//----------------------------------------------------------------
var StyleFK = (from DO in context.TLDYE_DyeOrder
join DB in context.TLDYE_DyeBatch on DO.TLDYO_Pk equals DB.DYEB_DyeOrder_FK
join DBD in context.TLDYE_DyeBatchDetails on DB.DYEB_Pk equals DBD.DYEBD_DyeBatch_FK
where DBD.DYEBD_Pk == dbd.DYEBD_Pk
select DO).FirstOrDefault().TLDYO_Style_FK;
var ISBinding = (from stytrim in context.TLADM_StyleTrim
join trim in context.TLADM_Trims on stytrim.StyTrim_Trim_Fk equals trim.TR_Id
join prodrating in context.TLADM_ProductRating on stytrim.StyTrim_ProdRating_FK equals prodrating.Pr_Id
where stytrim.StyTrim_Styles_Fk == StyleFK && trim.TR_IsBinding
select prodrating).FirstOrDefault();
if (ISBinding != null)
{
BindWeight = NettWeight * ISBinding.Pr_numeric_Rating;
NettWeight -= BindWeight;
}
var ISTrim = (from stytrim in context.TLADM_StyleTrim
join trim in context.TLADM_Trims on stytrim.StyTrim_Trim_Fk equals trim.TR_Id
join prodrating in context.TLADM_ProductRating on stytrim.StyTrim_ProdRating_FK equals prodrating.Pr_Id
where stytrim.StyTrim_Styles_Fk == StyleFK && !trim.TR_IsBinding
select prodrating).FirstOrDefault();
if (ISTrim != null)
{
TrimWeight = dbd.DYEBO_Nett * ISTrim.Pr_numeric_Rating;
}
// select trims.TR_Description , pr.Pr_numeric_Rating
// from TLADM_StyleTrim strim
// inner join. TLADM_Trims trims
// on trims.TR_Id = strim.StyTrim_Trim_Fk
// inner join TLADM_ProductRating pr
// on pr.Pr_Id = strim.StyTrim_ProdRating_FK
// where trims.TR_IsBinding = 1 and strim.StyTrim_Styles_Fk = 34
//-------------------------------------------------
var ProdFK = dbd.DYEBO_ProductRating_FK;
var Rating = context.TLADM_ProductRating.Find(ProdFK).Pr_numeric_Rating;
var NoOfGarments = Math.Round(Yield / Rating * NettWeight);
var Factor = Math.Round(Yield / Rating * NettWeight, 0);
var tst = core.CalculateRatios(ProdFK, (int)Factor);
foreach (var row in tst)
{
decimal EstKg = Math.Round(NettWeight * (row.Value / Factor), 2);
decimal BindKg = Math.Round(BindWeight * (row.Value / Factor), 2);
decimal TrimKg = Math.Round(TrimWeight * (row.Value / Factor), 2);
var ExpectUnits = context.TLCUT_ExpectedUnits.FirstOrDefault(x => x.TLCUTE_CutSheet_FK == CutSheet.TLCutSH_Pk && x.TLCUTE_Size_FK == row.Key);
if (ExpectUnits != null)
{
ExpectUnits.TLCUTE_EstNettWeight += EstKg;
ExpectUnits.TLCUTE_NoOfBinding += (int)(Yield / Rating) * BindKg;
ExpectUnits.TLCUTE_NoOfTrims += (int)(Yield / Rating) * TrimKg;
ExpectUnits.TLCUTE_NoofGarments += (int)((Yield / Rating) * EstKg);
if (ExpectUnits.TLCUTE_MarkerRatio == 0.00M)
{
ExpectUnits.TLCUTE_MarkerRatio = row.Value;
}
}
}
}
}
}
}
dr[1] = false;
}
}
try
{
context.SaveChanges();
MessageBox.Show("Data successfully saved to database");
}
catch (Exception ex)
{
MessageBox.Show(ex.InnerException.Message);
}
}
}
}
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);
}
}
}
}
private void btnAccess_Click(object sender, EventArgs e)
{
Button oBtn = sender as Button;
if (oBtn != null & formloaded)
{
using (var context = new TTI2Entities())
{
if (ConfirmPassword)
{
String Password = txtUserPassword.Text.Replace('*', ' ');
if (Password.Length == 0)
{
using (DialogCenteringService centeringService = new DialogCenteringService(this)) // center message box
{
MessageBox.Show("Please enter a valid password");
}
return;
}
String Confirm = txtConfirmPassword.Text.Replace('*', ' ');
if (Confirm.Length == 0)
{
using (DialogCenteringService centeringService = new DialogCenteringService(this)) // center message box
{
MessageBox.Show("Please enter a validation password");
}
return;
}
IsAuthorised = String.Equals(Password.Trim(), Confirm.Trim(), StringComparison.CurrentCulture);
if (IsAuthorised)
{
var SelectedUser = (TLSEC_UserAccess)cmboUserDetails.SelectedItem;
if (SelectedUser != null)
{
var User = context.TLSEC_UserAccess.Where(x => x.TLSECUA_UserName == SelectedUser.TLSECUA_UserName).FirstOrDefault();
if (User != null)
{
User.TLSECUA_ConfirmedPassword = true;
User.TLSECUA_UserPassword = Password;
UserName = User.TLSECUA_UserName;
IsSuperUser = User.TLSECUA_SuperUser;
UserPk = User.TLSECUA_Pk;
IsExternal = User.TLSECUA_External;
QAFunction = User.TLSECUA_QAFunction;
try
{
context.SaveChanges();
}
catch (Exception ex)
{
using (DialogCenteringService centeringService = new DialogCenteringService(this)) // center message box
{
MessageBox.Show(ex.Message);
}
}
}
}
this.Close();
}
else
{
using (DialogCenteringService centeringService = new DialogCenteringService(this)) // center message box
{
MessageBox.Show("Password not confirmed. Please reconfirm");
}
return;
}
}
else
{
var SelectedUser = (TLSEC_UserAccess)cmboUserDetails.SelectedItem;
if (SelectedUser != null)
{
var User = context.TLSEC_UserAccess.Where(x => x.TLSECUA_UserName == SelectedUser.TLSECUA_UserName).FirstOrDefault();
if (User != null)
{
String Password = txtUserPassword.Text.Replace('*', ' ');
String Confirm = User.TLSECUA_UserPassword;
IsAuthorised = String.Equals(Password.Trim(), Confirm.Trim(), StringComparison.CurrentCulture);
if (IsAuthorised)
{
UserName = User.TLSECUA_UserName;
IsSuperUser = User.TLSECUA_SuperUser;
UserPk = User.TLSECUA_Pk;
IsExternal = User.TLSECUA_External;
this.Close();
}
else
{
using (DialogCenteringService centeringService = new DialogCenteringService(this)) // center message box
{
MessageBox.Show("Please re-enter password", "Invalid Password for " + User.TLSECUA_UserName);
}
return;
}
}
}
}
}
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
Button oBtn = sender as Button;
Repository repo = new Repository();
TLCSV_BoxSelected boxSelected;
if (oBtn != null && Submit)
{
var Depts = (TLADM_Departments)cmboFrom.SelectedItem;
if (Depts == null)
{
MessageBox.Show("Please select a CMT from from the drop down box");
return;
}
QueryParms.Depts.Add(repo.LoadDepart(Depts.Dep_Id));
var BoxesAvailable = repo.Query(QueryParms);
if (BoxesAvailable.Count() == 0)
{
MessageBox.Show("There are no Boxes available");
return;
}
DGVResults.Rows.Clear();
using (var context = new TTI2Entities())
{
foreach (var Box in BoxesAvailable)
{
var index = DGVResults.Rows.Add();
DGVResults.Rows[index].Cells[0].Value = Box.TLCMTWC_Pk;
DGVResults.Rows[index].Cells[1].Value = false;
DGVResults.Rows[index].Cells[2].Value = Box.TLCMTWC_BoxNumber;
DGVResults.Rows[index].Cells[3].Value = Box.TLCMTWC_Qty;
DGVResults.Rows[index].Cells[4].Value = Box.TLCMTWC_Weight;
var Styles = context.TLADM_Styles.Find(Box.TLCMTWC_Style_FK);
if (Styles != null)
{
DGVResults.Rows[index].Cells[5].Value = context.TLADM_CustomerFile.Find(Styles.Sty_Label_FK).Cust_Description;
DGVResults.Rows[index].Cells[6].Value = Styles.Sty_Description;
}
DGVResults.Rows[index].Cells[7].Value = context.TLADM_Colours.Find(Box.TLCMTWC_Colour_FK).Col_Display;
DGVResults.Rows[index].Cells[8].Value = context.TLADM_Sizes.Find(Box.TLCMTWC_Size_FK).SI_Description;
}
}
DGVResults.Visible = true;
label4.Visible = false;
label5.Visible = false;
label6.Visible = false;
Submit = !Submit;
btnSubmit.Text = "Process";
groupBox1.Text = "Results";
}
else
{
//-------------------------------------------------------------------
// 1st Has a to destination been selected
// If No return
//------------------------------------------------------------------------
var Dept = (TLADM_Departments)cmboFrom.SelectedItem;
if (Dept == null)
{
MessageBox.Show("Error encountered" + Environment.NewLine + "Process aborted");
return;
}
var Whse = (TLADM_WhseStore)cmboTo.SelectedItem;
if (Whse == null)
{
MessageBox.Show("Please select a TO Destination from the drop down box provided");
return;
}
var RecCount = DGVResults.Rows.Cast <DataGridViewRow>().Where(x => (bool)x.Cells[1].Value == true).Count();
if (RecCount == 0)
{
MessageBox.Show("Please select a least one record to process");
return;
}
using (var context = new TTI2Entities())
{
//------------------------------------------------
// 1st Things first create a header record
//-------------------------------------------------------------------------
var LNU = context.TLADM_LastNumberUsed.Where(x => x.LUN_Department_FK == Dept.Dep_Id).FirstOrDefault();
boxSelected = new TLCSV_BoxSelected();
boxSelected.TLCSV_TransDate = dateTimePicker1.Value;
boxSelected.TLCSV_From_FK = Dept.Dep_Id;
boxSelected.TLCSV_To_FK = Whse.WhStore_Id;
if (LNU != null)
{
boxSelected.TLCSV_TransNumber = LNU.col6;
LNU.col6 += 1;
}
boxSelected.TLCSV_PLDetails = "CP" + boxSelected.TLCSV_TransNumber.ToString().PadLeft(5, '0');
try
{
context.TLCSV_BoxSelected.Add(boxSelected);
context.SaveChanges();
}
catch (Exception ex)
{
var exceptionMessages = new StringBuilder();
do
{
exceptionMessages.Append(ex.Message);
ex = ex.InnerException;
}while (ex != null);
MessageBox.Show(exceptionMessages.ToString());
return;
}
foreach (DataGridViewRow row in DGVResults.Rows)
{
if ((bool)row.Cells[1].Value == false)
{
continue;
}
TLCMT_CompletedWork comWork = new TLCMT_CompletedWork();
var index = (int)row.Cells[0].Value;
comWork = context.TLCMT_CompletedWork.Find(index);
if (comWork != null)
{
comWork.TLCMTWC_PickList_FK = boxSelected.TLCSV_Pk;
comWork.TLCMTWC_Picked = true;
comWork.TLCMTWC_ToWhse_FK = Whse.WhStore_Id;
}
}
try
{
context.SaveChanges();
using (DialogCenteringService centeringService = new DialogCenteringService(this)) // center message box
{
MessageBox.Show("Data successfully saved to the database");
}
}
catch (Exception ex)
{
var exceptionMessages = new StringBuilder();
do
{
exceptionMessages.Append(ex.Message);
ex = ex.InnerException;
}while (ex != null);
MessageBox.Show(exceptionMessages.ToString());
return;
}
//----------------------------------------------------------------------
frmCSViewRep vRep = new frmCSViewRep(1, boxSelected.TLCSV_Pk);
int h = Screen.PrimaryScreen.WorkingArea.Height;
int w = Screen.PrimaryScreen.WorkingArea.Width;
vRep.ClientSize = new Size(w, h);
vRep.ShowDialog(this);
//-----------------------------------------------------------------------
try
{
DialogResult res = MessageBox.Show(" Do you wish to send a confirmation email ", "Confirmation email", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (res == DialogResult.Yes)
{
//-------------------------------------------------------------------
// We need to build up a data table of
// boxes( stock ) transfered
//-------------------------------------------------------------------
DataTable dt = new DataTable();
dt.Columns.Add("BoxNumber", typeof(String));
dt.Columns["BoxNumber"].DefaultValue = string.Empty;
dt.Columns.Add("Style", typeof(String));
dt.Columns["Style"].DefaultValue = string.Empty;
dt.Columns.Add("Colour", typeof(String));
dt.Columns["Colour"].DefaultValue = string.Empty;
dt.Columns.Add("Size", typeof(String));
dt.Columns["Size"].DefaultValue = string.Empty;
dt.Columns.Add("Grade", typeof(String));
dt.Columns["Grade"].DefaultValue = string.Empty;
dt.Columns.Add("Qty", typeof(int));
dt.Columns["Qty"].DefaultValue = 0;
dt.Columns.Add("Weight", typeof(decimal));
dt.Columns["Weight"].DefaultValue = 0.0M;
var BoxesTransfered = context.TLCMT_CompletedWork.Where(x => x.TLCMTWC_PickList_FK == boxSelected.TLCSV_Pk).ToList();
foreach (var Box in BoxesTransfered)
{
DataRow dr = dt.NewRow();
dr[0] = Box.TLCMTWC_BoxNumber;
dr[1] = context.TLADM_Styles.Find(Box.TLCMTWC_Style_FK).Sty_Description;
dr[2] = context.TLADM_Colours.Find(Box.TLCMTWC_Colour_FK).Col_Description;
dr[3] = context.TLADM_Sizes.Find(Box.TLCMTWC_Size_FK).SI_Description;
dr[4] = Box.TLCMTWC_Grade;
dr[5] = Box.TLCMTWC_Qty;
dr[6] = Box.TLCMTWC_Weight;
dt.Rows.Add(dr);
}
StringBuilder EMailAdd = new StringBuilder();
frmSeleEMailAddress EMailAddress = new frmSeleEMailAddress();
EMailAddress.ShowDialog(this);
var Email = EMailAddress.EMailSelected;
if (Email.ToString().Length > 0)
{
try
{
string ToWhse = context.TLADM_WhseStore.Find(boxSelected.TLCSV_To_FK).WhStore_Description;
core.SendEmailtoContacts(Email.ToString(), dt, 2, dateTimePicker1.Value, ToWhse, boxSelected.TLCSV_PLDetails);
MessageBox.Show("Email successfully despatched");
}
catch (Exception ex)
{
var exceptionMessages = new StringBuilder();
do
{
exceptionMessages.Append(ex.Message);
ex = ex.InnerException;
}while (ex != null);
MessageBox.Show(exceptionMessages.ToString());
}
}
else
{
MessageBox.Show("No Email address's selected or Email address's do not exist");
}
}
}
catch (Exception ex)
{
var exceptionMessages = new StringBuilder();
do
{
exceptionMessages.Append(ex.Message);
ex = ex.InnerException;
}while (ex != null);
MessageBox.Show(exceptionMessages.ToString());
}
}
DGVResults.Visible = false;
groupBox1.Text = "Selection";
label4.Visible = true;
label5.Visible = true;
label6.Visible = true;
Submit = !Submit;
btnSubmit.Text = "Submit";
cmboStyles.Items.Clear();
cmboColours.Items.Clear();
cmboSizes.Items.Clear();
frmWareHouseTransfers_Load(this, null);
}
}
private void datagridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
Util core = new Util();
var oDgv = sender as DataGridView;
int pn = 0;
List <int> xx = null;
if (oDgv.Focused && oDgv.CurrentCell is DataGridViewButtonCell)
{
if (e.ColumnIndex == 1)
{
if (rbBody.Checked)
{
var Id = 1005;
var RowPos = oDgv.CurrentRow.Index;
pn = int.Parse(oDgv.CurrentRow.Cells[9].Value.ToString());
frmTLADMGardProp aprop = new frmTLADMGardProp(Id, pn, Listsizes);
aprop.ShowDialog();
var sizes = aprop.TotalPN;
if (sizes != 0)
{
StringBuilder desciption = new StringBuilder();
int a = Convert.ToInt32(sizes);
using (var context = new TTI2Entities())
{
xx = core.ExtrapNumber(a, context.TLADM_Sizes.Count());
}
xx.Sort();
oDgv.CurrentRow.Cells[8].Value = false;
if (xx.Count > 1)
{
oDgv.CurrentRow.Cells[8].Value = true;
}
foreach (var rw in xx)
{
bool First = true;
foreach (var dd in Listsizes)
{
if (dd.SI_PowerN == rw)
{
if (First)
{
First = !First;
oDgv.CurrentRow.Cells[11].Value = dd.SI_id;
}
if (desciption.Length == 0)
{
desciption.Append(dd.SI_Description);
}
else
{
desciption.Append(", " + dd.SI_Description);
}
}
}
}
oDgv.CurrentRow.Cells[10].Value = false;
if ((int)oDgv.CurrentRow.Cells[0].Value == 0)
{
oDgv.CurrentRow.Cells[10].Value = true;
}
oDgv.CurrentRow.Cells[1].Value = desciption;
oDgv.CurrentRow.Cells[7].Value = "Ratio";
oDgv.CurrentRow.Cells[9].Value = sizes;
}
}
else if (rbTrims.Checked)
{
var StyleSelected = (TLADM_Styles)cmbStyles.SelectedItem;
if (StyleSelected != null)
{
var Id = 1007;
int[] TrimKeys = new int[2];
// First Element is the style
//======================================
TrimKeys[0] = StyleSelected.Sty_Id;
// Second element is the Primary Key of the Trim
//===============================================
TrimKeys[1] = (int)oDgv.Rows[e.RowIndex].Cells[11].Value;
var RowPos = oDgv.CurrentRow.Index;
pn = int.Parse(oDgv.CurrentRow.Cells[9].Value.ToString());
frmTLADMGardProp aprop = new frmTLADMGardProp(Id, TrimKeys, true);
aprop.ShowDialog();
var sizes = aprop._TrimKeys;
oDgv.CurrentRow.Cells[8].Value = false;
oDgv.CurrentRow.Cells[10].Value = false;
if ((int)oDgv.CurrentRow.Cells[0].Value == 0)
{
oDgv.CurrentRow.Cells[10].Value = true;
}
oDgv.CurrentRow.Cells[11].Value = sizes[1];
using (var context = new TTI2Entities())
{
oDgv.CurrentRow.Cells[1].Value = context.TLADM_Trims.Find(sizes[1]).TR_Description;
}
oDgv.CurrentRow.Cells[7].Value = "Ratio";
oDgv.CurrentRow.Cells[9].Value = 0;
}
}
}
else
{
// Only available to body details
//-----------------------------------------------
if (!rbBody.Checked)
{
using (DialogCenteringService centeringService = new DialogCenteringService(this)) // center message box
{
MessageBox.Show("Please select the body check box prior to selecting this option");
}
return;
}
//Only available to multi sized markers
//-----------------------------------------------
var CurrentRow = oDgv.CurrentRow;
if (!(bool)CurrentRow.Cells[8].Value)
{
using (DialogCenteringService centeringService = new DialogCenteringService(this)) // center message box
{
MessageBox.Show("This option is only available to multi sized Markers");
return;
}
}
else
{
var PNumber = (int)CurrentRow.Cells[9].Value;
int PrimaryKey = (int)CurrentRow.Cells[0].Value;
if (PrimaryKey == 0)
{
using (var context = new TTI2Entities())
{
TLADM_ProductRating ProductRating = new TLADM_ProductRating();
context.TLADM_ProductRating.Add(ProductRating);
try
{
context.SaveChanges();
PrimaryKey = ProductRating.Pr_Id;
CurrentRow.Cells[0].Value = PrimaryKey;
CurrentRow.Cells[10].Value = false;
}
catch (Exception ex)
{
MessageBox.Show(ex.InnerException.Message.ToString());
return;
}
}
}
frmTLADMProductRatingDetail prodDetail = new frmTLADMProductRatingDetail(PNumber, PrimaryKey);
prodDetail.ShowDialog(this);
if (prodDetail.ProductRatio != 0)
{
oDgv.Rows[e.RowIndex].Cells[4].Value = (decimal)prodDetail.ProductRatio;
if (oDgv.Rows[e.RowIndex].Cells[5].Value != null)
{
var ML = (decimal)oDgv.Rows[e.RowIndex].Cells[5].Value;
try
{
oDgv.Rows[e.RowIndex].Cells[6].Value = Math.Round(ML / prodDetail.ProductRatio, 4);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
}
}
}
}
}
}
private void rbRejectStore_CheckedChanged(object sender, EventArgs e)
{
RadioButton oRad = sender as RadioButton;
if (oRad != null && formloaded && oRad.Checked)
{
var GreigeSelected = (TLADM_Griege)cmboGreige.SelectedItem;
if (GreigeSelected != null)
{
using (var context = new TTI2Entities())
{
dataGridView1.Rows.Clear();
var dbDetails = (from GP in context.TLKNI_GreigeProduction
join DBD in context.TLDYE_DyeBatchDetails
on GP.GreigeP_Pk equals DBD.DYEBD_GreigeProduction_FK
join ADMGriege in context.TLADM_Griege
on GP.GreigeP_Greige_Fk equals ADMGriege.TLGreige_Id
where !GP.GreigeP_BoughtIn &&
!DBD.DYEBO_QAApproved &&
DBD.DYEBO_Rejected &&
!DBD.DYEBO_WriteOff &&
!DBD.DYEBO_Sold &&
!DBD.DYEBO_CutSheet &&
DBD.DYEBD_QualityKey == GreigeSelected.TLGreige_Id
orderby GP.GreigeP_PieceNo
select new { DBD, GP, ADMGriege }).ToList();
if (dbDetails.Count == 0)
{
using (DialogCenteringService centeringService = new DialogCenteringService(this)) // center message box
{
MessageBox.Show("There are no records found pertaining to selection made", "No Records Found", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
}
foreach (var row in dbDetails)
{
var index = dataGridView1.Rows.Add();
dataGridView1.Rows[index].Cells[0].Value = row.DBD.DYEBD_Pk;
dataGridView1.Rows[index].Cells[1].Value = row.GP.GreigeP_PieceNo;
dataGridView1.Rows[index].Cells[2].Value = row.ADMGriege.TLGreige_Description;
var BD = context.TLDYE_DyeBatch.Find(row.DBD.DYEBD_DyeBatch_FK);
if (BD != null)
{
dataGridView1.Rows[index].Cells[3].Value = context.TLADM_Colours.Find(BD.DYEB_Colour_FK).Col_Display;
}
dataGridView1.Rows[index].Cells[4].Value = row.DBD.DYEBD_GreigeProduction_Weight;
dataGridView1.Rows[index].Cells[5].Value = row.DBD.DYEBO_Nett;
dataGridView1.Rows[index].Cells[6].Value = row.DBD.DYEBO_DiskWeight;
dataGridView1.Rows[index].Cells[7].Value = 0;
dataGridView1.Rows[index].Cells[8].Value = 0;
dataGridView1.Rows[index].Cells[9].Value = 0;
dataGridView1.Rows[index].Cells[10].Value = false;
dataGridView1.Rows[index].Cells[11].Value = row.DBD.DYEBD_DyeBatch_FK;
}
}
}
else
{
using (DialogCenteringService centeringService = new DialogCenteringService(this)) // center message box
{
MessageBox.Show("Please select a quality from the drop down box");
}
}
}
}
