private void frmProductionSplit_Load(object sender, EventArgs e)
{
formloaded = false;
using (var context = new TTI2Entities())
{
GreigeProd = context.TLKNI_GreigeProduction.Find(_RecordKey);
if (GreigeProd != null)
{
if (GreigeProd.GreigeP_KnitO_Fk != null)
{
var KO = context.TLKNI_Order.Find(GreigeProd.GreigeP_KnitO_Fk);
if (KO != null)
{
lblKnitOrder.Text = "KO" + KO.KnitO_OrderNumber.ToString();
}
txtWeightAvailable.Text = GreigeProd.GreigeP_weightAvail.ToString();
label4.Text = context.TLADM_Griege.Find(GreigeProd.GreigeP_Greige_Fk).TLGreige_Description;
}
}
}
formloaded = true;
}
private void btnSave_Click(object sender, EventArgs e)
{
Button oBtn = (Button)sender;
var TransNo = 0;
if (oBtn != null && FormLoaded)
{
var Origin = (TLADM_CottonOrigin)cmboCountry.SelectedItem;
if (Origin == null)
{
MessageBox.Show("Please select a Country of Origin");
return;
}
var Greige = (TLADM_Griege)cmboGreige.SelectedItem;
if (Greige == null)
{
MessageBox.Show("Please select a quality");
return;
}
var CurrentStore = (TLADM_WhseStore)cmboStore.SelectedItem;
if (CurrentStore == null)
{
MessageBox.Show("Please select a store");
return;
}
var Machine = (TLADM_MachineDefinitions)cmboMachine.SelectedItem;
if (Machine == null)
{
MessageBox.Show("Please select a machine");
return;
}
var Colour = (TLADM_Colours)cmboColour.SelectedItem;
if (Colour == null)
{
MessageBox.Show("Please select a colour");
return;
}
TransNo = core.CenturyDayNumber(DateTime.Now) + DateTime.Now.Hour + DateTime.Now.Minute;
using (var context = new TTI2Entities())
{
foreach (DataGridViewRow Row in dataGridView1.Rows)
{
if (Row.Cells[0].Value == null)
{
continue;
}
TLKNI_BoughtInFabric BoughtIn = new TLKNI_BoughtInFabric();
BoughtIn.TLBIN_COfOrigin_FK = Origin.CottonOrigin_Pk;
BoughtIn.TLBIN_CurrentStore_FK = CurrentStore.WhStore_Id;
BoughtIn.TLBIN_TransDate = TransDate.Value;
BoughtIn.TLBIN_Greige_FK = Greige.TLGreige_Id;
BoughtIn.TLBIN_Machine_FK = Machine.MD_Pk;
BoughtIn.TLBIN_TTS_PN = (string)Row.Cells[0].Value;
BoughtIn.TLBIN_Their_PN = (string)Row.Cells[1].Value;
BoughtIn.TLBIN_Colour_FK = (int)cmboColour.SelectedValue;
BoughtIn.TLBIN_Dsk_Weight = (decimal)Row.Cells[2].Value;
BoughtIn.TLBIN_Dsk_Width = (decimal)Row.Cells[3].Value;
BoughtIn.TLBIN_Nett_Weight = (decimal)Row.Cells[4].Value;
BoughtIn.TLBIN_Meters_Roll = (decimal)Row.Cells[5].Value;
BoughtIn.TLBIN_TransNumber = TransNo;
context.TLKNI_BoughtInFabric.Add(BoughtIn);
try
{
context.SaveChanges();
}
catch (Exception ex)
{
}
//we need to store further information in a separate file for the processing in the Dye Module
//-----------------------------------------------------------------------------------------------------------
TLKNI_GreigeProduction gp = new TLKNI_GreigeProduction();
gp.GreigeP_Captured = true;
gp.GreigeP_BoughtIn = true;
gp.GreigeP_KnitO_Fk = BoughtIn.TLBIN_Pk; // Provides a link to the original transaction
gp.GreigeP_Grade = "A";
gp.GreigeP_InspDate = TransDate.Value;
gp.GreigeP_Inspected = true;
gp.GreigeP_Meas1 = 0;
gp.GreigeP_Meas2 = 0;
gp.GreigeP_Meas3 = 0;
gp.GreigeP_Meas4 = 0;
gp.GreigeP_Meas5 = 0;
gp.GreigeP_Meas6 = 0;
gp.GreigeP_Meas7 = 0;
gp.GreigeP_Meas8 = 0;
gp.GreigeP_PDate = DateTime.Now;
gp.GreigeP_PieceNo = (string)Row.Cells[0].Value;
gp.GreigeP_BoughtIn_FabWeight = (decimal)Row.Cells[2].Value;
gp.GreigeP_BoughtIn_FabWidth = (decimal)Row.Cells[3].Value;
gp.GreigeP_weight = (decimal)Row.Cells[4].Value;
gp.GreigeP_weightAvail = (decimal)Row.Cells[5].Value;
gp.GreigeP_Store_FK = CurrentStore.WhStore_Id;
gp.GreigeP_Greige_Fk = Greige.TLGreige_Id;
gp.GreigeP_BIFColour_FK = BoughtIn.TLBIN_Colour_FK;
gp.GreigeP_BoughtIn_Fk = BoughtIn.TLBIN_Pk;
gp.GreigeP_Meters = BoughtIn.TLBIN_Meters_Roll;
context.TLKNI_GreigeProduction.Add(gp);
}
try
{
context.SaveChanges();
MessageBox.Show("Data saved successfully to database");
Cutting.CuttingQueryParameters QParms = new CuttingQueryParameters();
QParms.BIFTransNumber = TransNo;
frmCutViewRep vRep = new frmCutViewRep(19, QParms);
int h = Screen.PrimaryScreen.WorkingArea.Height;
int w = Screen.PrimaryScreen.WorkingArea.Width;
vRep.ClientSize = new Size(w, h);
vRep.ShowDialog(this);
vRep = new frmCutViewRep(20, QParms);
h = Screen.PrimaryScreen.WorkingArea.Height;
w = Screen.PrimaryScreen.WorkingArea.Width;
vRep.ClientSize = new Size(w, h);
vRep.ShowDialog(this);
frmBoughtInFabric_Load(this, null);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
Button oBtn = sender as Button;
DataGridView oDgv = dataGridView1;
String PalletNo = string.Empty;
String YarnSupplier = String.Empty;
Decimal YarnTex = 0.00M;
TLADM_Yarn YarnType = null;
string MergeDetails = string.Empty;
IList <TLKNI_YarnAllocTransctions> PalletTrans = null;
if (oBtn != null && formloaded)
{
using (var context = new TTI2Entities())
{
var KO = (TLKNI_Order)cmboKnitOrders.SelectedItem;
if (KO != null)
{
var _Begin = dtpProduction.Value.ToShortDateString();
DateTime psd = Convert.ToDateTime(_Begin);
DateTime time = dtpTime.Value;
var YarnAllocTrans = context.TLKNI_YarnAllocTransctions.Where(x => x.TLKYT_KnitOrder_FK == KO.KnitO_Pk && x.TLKYT_TranType == 1).FirstOrDefault();
if (YarnAllocTrans != null)
{
var YarnOrderPallet = context.TLKNI_YarnOrderPallets.Find(YarnAllocTrans.TLKYT_YOP_FK);
if (YarnOrderPallet != null)
{
var YarnOrder = context.TLSPN_YarnOrder.Find(YarnOrderPallet.TLKNIOP_YarnOrder_FK);
if (YarnOrder != null)
{
PalletNo = YarnOrder.YarnO_OrderNumber.ToString() + " - " + YarnOrderPallet.TLKNIOP_PalletNo;
YarnType = context.TLADM_Yarn.Find(YarnOrder.Yarno_YarnType_FK);
if (YarnType != null)
{
YarnTex = YarnType.YA_TexCount;
YarnSupplier = context.TLADM_Suppliers.Find(YarnType.YA_Supplier_FK).Sup_Description;
}
}
}
}
KO = context.TLKNI_Order.Find(KO.KnitO_Pk);
if (KO != null)
{
var YarnO = context.TLSPN_YarnOrder.Find(KO.KnitO_YarnO_FK);
if (YarnO != null)
{
if (YarnO.YarnO_MergeContract_FK != null)
{
var CottonM = context.TLSPN_CottonMerge.Find(YarnO.YarnO_MergeContract_FK);
if (CottonM != null)
{
MergeDetails = CottonM.TLCTM_Description;
}
}
}
if (KO.KnitO_ProductionStartDate == null)
{
KO.KnitO_ProductionStartDate = psd.AddHours(time.Hour);
KO.KnitO_ProductionStartDate = psd.AddMinutes(time.Minute);
}
}
PalletTrans = context.TLKNI_YarnAllocTransctions.Where(x => x.TLKYT_KnitOrder_FK == KO.KnitO_Pk && x.TLKYT_TranType == 1).ToList();
foreach (DataGridViewRow row in oDgv.Rows)
{
if ((decimal)row.Cells[3].Value > 0)
{
if (row.Cells[4].Value == null || row.Cells[5].Value == null)
{
MessageBox.Show("Row Number " + (row.Index + 1).ToString() + " incomplete");
return;
}
TLKNI_GreigeProduction griegP = new TLKNI_GreigeProduction();
var _Key = (int)row.Cells[0].Value;
if (_Key != 0)
{
griegP = context.TLKNI_GreigeProduction.Find(_Key);
}
else
{
griegP.GreigeP_KnitO_Fk = KO.KnitO_Pk;
griegP.GreigeP_Greige_Fk = KO.KnitO_Product_FK;
griegP.GreigeP_Machine_FK = (int)row.Cells[1].Value;
griegP.GreigeP_PieceNo = row.Cells[2].Value.ToString();
if (KO.KnitO_Size_Fk != null)
{
griegP.GreigeP_Size_Fk = (int)KO.KnitO_Size_Fk;
}
if (KO.KnitO_Colour_Fk != null)
{
griegP.GreigeP_BIFColour_FK = (int)KO.KnitO_Colour_Fk;
}
}
griegP.GreigeP_MergeDetail = MergeDetails;
griegP.GreigeP_weight = (decimal)row.Cells[3].Value;
griegP.GreigeP_weightAvail = (decimal)row.Cells[3].Value;
if (row.Cells[4].Value != null)
{
griegP.GreigeP_Shift_FK = (int)row.Cells[4].Value;
}
if (row.Cells[5].Value != null)
{
griegP.GreigeP_Operator_FK = (int)row.Cells[5].Value;
}
if (griegP.GreigeP_PDate == null)
{
griegP.GreigeP_PDate = dtpProduction.Value;
}
BatchBalanceCaptured += (decimal)row.Cells[3].Value;
griegP.GreigeP_Captured = true;
griegP.GreigeP_PalletNo = PalletNo;
griegP.GreigeP_YarnSupplier = YarnSupplier;
griegP.GreigeP_YarnTex = YarnTex;
var TLADMGreige = context.TLADM_Griege.Find(griegP.GreigeP_Greige_Fk);
if (TLADMGreige != null)
{
// We need to start storing the meters knitted for statistical purposes
//===========================================================================
var FabWeight = context.TLADM_FabricWeight.Find(TLADMGreige.TLGreige_FabricWeight_FK);
var FabWidth = context.TLADM_FabWidth.Find(TLADMGreige.TLGreige_FabricWidth_FK);
var FabricYield = core.FabricYield(FabWeight.FWW_Calculation_Value, FabWidth.FW_Calculation_Value);
griegP.GreigeP_Meters = FabricYield * griegP.GreigeP_weightAvail;
}
var Dept = context.TLADM_Departments.Where(x => x.Dep_ShortCode.Contains("KNIT")).FirstOrDefault();
if (Dept != null)
{
if (KO.KnitO_YarnO_FK != null)
{
var TranType = context.TLADM_TranactionType.Where(x => x.TrxT_Department_FK == Dept.Dep_Id && x.TrxT_Number == 1400).FirstOrDefault();
if (TranType != null)
{
griegP.GreigeP_Store_FK = TranType.TrxT_Pk;
}
}
else
{
if (KO.KnitO_CommisionCust)
{
var TranType = context.TLADM_TranactionType.Where(x => x.TrxT_Department_FK == Dept.Dep_Id && x.TrxT_Number == 1300).FirstOrDefault();
if (TranType != null)
{
griegP.GreigeP_Store_FK = TranType.TrxT_Pk;
}
}
else
{
var TranType = context.TLADM_TranactionType.Where(x => x.TrxT_Department_FK == Dept.Dep_Id && x.TrxT_Number == 1200).FirstOrDefault();
if (TranType != null)
{
griegP.GreigeP_Store_FK = TranType.TrxT_Pk;
}
}
}
}
//==============================================================================
if (_Key == 0)
{
context.TLKNI_GreigeProduction.Add(griegP);
}
}
}
if (BatchBalanceCaptured >= KO.KnitO_Weight)
{
KO.KnitO_ProductionCaptured = true;
}
var MachDet = context.TLADM_MachineDefinitions.Find(KO.KnitO_Pk);
if (MachDet != null)
{
var MC = context.TLKNI_MachineLastNumber.Where(x => x.TLMDD_MachineCode == MachDet.MD_MachineCode).FirstOrDefault();
if (MC != null)
{
MC.TLMDD_LastNumber = _LastNumber;
txtPieceNo.Text = _LastNumber.ToString();
}
}
try
{
context.SaveChanges();
oDgv.Rows.Clear();
txtNoOfPieces.Text = "0";
_LastNumber = 0;
MessageBox.Show("Data saved to database");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
Button oBtn = sender as Button;
int _LastNumber = 0;
TLKNI_GreigeProduction GreigeP = null;
if (oBtn != null && formloaded)
{
var ErrorM = core.returnMessage(MandatorySelected, false, MandatoryFields);
if (!String.IsNullOrEmpty(ErrorM))
{
MessageBox.Show(ErrorM);
return;
}
var GrnNumber = (TLKNI_GreigeCommissionTransctions)cmbTrans.SelectedItem;
using (var context = new TTI2Entities())
{
TLADM_LastNumberUsed LNU = context.TLADM_LastNumberUsed.Find(2);
if (LNU != null)
{
_LastNumber = LNU.col10;
LNU.col10 += 1;
}
foreach (DataGridViewRow row in dataGridView1.Rows)
{
var Pk = (int)row.Cells[0].Value;
if (Pk != 0)
{
var Existing = context.TLKNI_GreigeCommissionTransctions.Find(Pk);
if (Existing != null)
{
var NewValue = (decimal)row.Cells[4].Value;
if (NewValue != Existing.GreigeCom_NettWeight)
{
Existing.GreigeCom_NettWeight += NewValue;
//Notes -- we must also now adjust the value in the GreigeProduction File
//====================================================================
GreigeP = context.TLKNI_GreigeProduction.Where(x => x.GreigeP_KnitO_Fk == Pk).FirstOrDefault();
if (GreigeP != null)
{
GreigeP.GreigeP_weight += NewValue;
GreigeP.GreigeP_weightAvail += NewValue;
TLKNI_GreigeCommisionAdjustment adj = new TLKNI_GreigeCommisionAdjustment();
adj.GreigeComAJ_AjustmentNo = _LastNumber;
adj.GreigeComAJ_AmtAdjusted = NewValue;
adj.GreigeComAJ_AprovedBy = txtApprovedBy.Text;
adj.GreigeComAJ_PieceNo_FK = (int)row.Cells[0].Value;
adj.GreigeComAJ_Reasons = txtReason.Text;
adj.GreigeComAJ_Strore_FK = (int)cmbStore.SelectedValue;
adj.GreigeComAJ_TransDate = (DateTime)dtpTransactionDate.Value;
adj.GreigeComAJ_GreigeProduction_FK = GreigeP.GreigeP_Pk;
if (GrnNumber != null)
{
adj.GreigeComAJ_GrnNumber = GrnNumber.GreigeCom_GrnNo;
}
context.TLKNI_GreigeCommisionAdjustment.Add(adj);
}
}
}
}
}
try
{
context.SaveChanges();
MessageBox.Show("Data successfully saved to database");
dataGridView1.Rows.Clear();
SetUp(false);
frmKnitViewRep vRep = new frmKnitViewRep(19, _LastNumber);
int h = Screen.PrimaryScreen.WorkingArea.Height;
int w = Screen.PrimaryScreen.WorkingArea.Width;
vRep.ClientSize = new Size(w, h);
vRep.ShowDialog(this);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
Button oBtn = sender as Button;
Random rnd = new Random();
if (oBtn != null)
{
var Greige = (TLADM_Griege)comboGreige.SelectedItem;
if (Greige == null)
{
MessageBox.Show("Please select a Greige quality from the drop down box");
return;
}
var Machine = (TLADM_MachineDefinitions)comboMachines.SelectedItem;
if (Machine == null)
{
MessageBox.Show("Please select a machine record from the drop down list");
return;
}
using (var context = new TTI2Entities())
{
var Dept = context.TLADM_Departments.Where(x => x.Dep_ShortCode.Contains("KNIT")).FirstOrDefault();
var Operators = context.TLADM_MachineOperators.Where(y => y.MachOp_Department_FK == Dept.Dep_Id).ToList();
var Inspectors = context.TLADM_MachineOperators.Where(y => y.MachOp_Department_FK == Dept.Dep_Id && y.MachOp_Inspector).ToList();
foreach (DataGridViewRow row in dataGridView1.Rows)
{
if (row.Cells[1].Value == null)
{
continue;
}
TLKNI_GreigeProduction greigP = new TLKNI_GreigeProduction();
greigP.GreigeP_Greige_Fk = Greige.TLGreige_Id;
greigP.GreigeP_PieceNo = row.Cells[1].Value.ToString();
var PieceNo = greigP.GreigeP_PieceNo;
var GP = context.TLKNI_GreigeProduction.Where(x => x.GreigeP_PieceNo == PieceNo).FirstOrDefault();
if (GP != null)
{
continue;
}
greigP.GreigeP_weight = (decimal)row.Cells[3].Value;
greigP.GreigeP_PDate = dtpTransactionDate.Value;
greigP.GreigeP_weightAvail = greigP.GreigeP_weight;
greigP.GreigeP_Captured = true;
greigP.GreigeP_Shift_FK = 1;
greigP.GreigeP_InspDate = dtpTransactionDate.Value;
greigP.GreigeP_Inspected = true;
int OperNo = rnd.Next(1, Inspectors.Count);
var nthItem = Inspectors.Skip(OperNo - 1).FirstOrDefault();
greigP.GreigeP_Inspector_FK = nthItem.MachOp_Pk;
OperNo = rnd.Next(1, Operators.Count);
nthItem = Operators.Skip(OperNo - 1).FirstOrDefault();
greigP.GreigeP_Operator_FK = nthItem.MachOp_Pk;
greigP.GreigeP_Grade = row.Cells[2].Value.ToString().ToUpper();
greigP.GreigeP_Dye = false;
greigP.GreigeP_Store_FK = (int)row.Cells[0].Value;
context.TLKNI_GreigeProduction.Add(greigP);
}
try
{
context.SaveChanges();
MessageBox.Show("Data saved successfully to the database");
comboGreige.SelectedIndex = -1;
comboMachines.SelectedIndex = -1;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
Button oBtn = sender as Button;
int CLNU = 0;
if (oBtn != null && formloaded)
{
var ErrorM = core.returnMessage(MandatorySelected, false, MandatoryFields);
if (!String.IsNullOrEmpty(ErrorM))
{
MessageBox.Show(ErrorM);
return;
}
using (var context = new TTI2Entities())
{
var LNU = context.TLADM_LastNumberUsed.Find(2);
if (LNU != null)
{
LNU.col8 += 1;
}
var custSelected = (TLADM_CustomerFile)cmbCommissionC.SelectedItem;
var store = (TLADM_WhseStore)cmbStore.SelectedItem;
if (custSelected != null)
{
CLNU = custSelected.Cust_LastNumberUsed;
custSelected = context.TLADM_CustomerFile.Find(custSelected.Cust_Pk);
custSelected.Cust_LastNumberUsed = CLNU + 1;
}
foreach (DataGridViewRow row in dataGridView1.Rows)
{
if (row.Cells[0].Value == null)
{
continue;
}
TLKNI_GreigeCommissionTransctions comTrans = new TLKNI_GreigeCommissionTransctions();
comTrans.GreigeCom_Custdoc = txtCustDeliveryDoc.Text;
comTrans.GreigeCom_Customer_FK = custSelected.Cust_Pk;
comTrans.GreigeCom_Comments = txtComments.Text;
comTrans.GreigeCom_CustOrderNo = (string)row.Cells[4].Value;
comTrans.GreigeCom_Grade = (string)row.Cells[3].Value;
comTrans.GreigeCom_GrnNo = CLNU;
comTrans.GreigeCom_NettWeight = (decimal)row.Cells[5].Value;
comTrans.GreigeCom_PieceNo = row.Cells[0].Value.ToString();
comTrans.GreigeCom_ProductType_FK = (int)row.Cells[2].Value;
comTrans.GreigeCom_Transdate = dateTimePicker1.Value;
comTrans.GreigeCom_TTSNo = (string)row.Cells[1].Value;
comTrans.GreigeCom_Store_FK = store.WhStore_Id;
comTrans.GreigeCom_Display = CLNU.ToString() + " " + txtCustDeliveryDoc.Text;
context.TLKNI_GreigeCommissionTransctions.Add(comTrans);
try
{
context.SaveChanges();
}
catch (Exception ex)
{
}
//we need to store further information in a separate file for the processing in the Dye Module
TLKNI_GreigeProduction gp = new TLKNI_GreigeProduction();
gp.GreigeP_Captured = true;
//-----------------------------------------------------------
// gp.GreigeP_KnitO_Fk = CLNU;
//------------------------------------------------------
gp.GreigeP_KnitO_Fk = comTrans.GreigeCom_PK;
gp.GreigeP_CommisionCust = true;
gp.GreigeP_CommissionCust_FK = custSelected.Cust_Pk;
gp.GreigeP_Grade = (string)row.Cells[3].Value;
gp.GreigeP_InspDate = DateTime.Now;
gp.GreigeP_Inspected = true;
gp.GreigeP_Meas1 = 0;
gp.GreigeP_Meas2 = 0;
gp.GreigeP_Meas3 = 0;
gp.GreigeP_Meas4 = 0;
gp.GreigeP_Meas5 = 0;
gp.GreigeP_Meas6 = 0;
gp.GreigeP_Meas7 = 0;
gp.GreigeP_Meas8 = 0;
gp.GreigeP_PDate = DateTime.Now;
gp.GreigeP_PieceNo = (string)row.Cells[0].Value;
gp.GreigeP_weight = (decimal)row.Cells[5].Value;
gp.GreigeP_weightAvail = (decimal)row.Cells[5].Value;
gp.GreigeP_Store_FK = store.WhStore_Id;
gp.GreigeP_Greige_Fk = (int)row.Cells[2].Value;
gp.GreigeP_CommissionGrn = CLNU;
context.TLKNI_GreigeProduction.Add(gp);
}
try
{
context.SaveChanges();
MessageBox.Show("Data successfully saved to the database");
frmKnitViewRep vRep = new frmKnitViewRep(13, CLNU);
int h = Screen.PrimaryScreen.WorkingArea.Height;
int w = Screen.PrimaryScreen.WorkingArea.Width;
vRep.ClientSize = new Size(w, h);
vRep.ShowDialog(this);
dataGridView1.Rows.Clear();
SetUp(false);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
Button oBtn = sender as Button;
bool success = true;
TLADM_TranactionType TranType = null;
TLADM_MachineOperators Operators = null;
if (oBtn != null && formloaded)
{
var ErrorM = core.returnMessage(MandatorySelected, false, MandatoryFields);
if (!String.IsNullOrEmpty(ErrorM))
{
MessageBox.Show(ErrorM);
return;
}
var Inspector = (TLADM_MachineOperators)cmbInspector.SelectedItem;
var KO = (TLKNI_Order)cmbKnitOrder.SelectedItem;
using (var context = new TTI2Entities())
{
Operators = (TLADM_MachineOperators)cmbInspector.SelectedItem;
var Dept = context.TLADM_Departments.Where(x => x.Dep_ShortCode.Contains("KNIT")).FirstOrDefault();
foreach (DataGridViewRow row in dataGridView1.Rows)
{
TLKNI_GreigeProduction record = new TLKNI_GreigeProduction();
record = context.TLKNI_GreigeProduction.Find(row.Cells[0].Value);
if (row.Cells[2].Value != null)
{
record.GreigeP_Grade = row.Cells[2].Value.ToString();
}
else
{
record.GreigeP_Grade = "A";
}
if (row.Cells[3].Value != null)
{
record.GreigeP_Remarks = row.Cells[3].Value.ToString();
}
else
{
record.GreigeP_Remarks = string.Empty;
}
record.GreigeP_Meas1 = (int)row.Cells[4].Value;
record.GreigeP_Meas2 = (int)row.Cells[5].Value;
record.GreigeP_Meas3 = (int)row.Cells[6].Value;
record.GreigeP_Meas4 = (int)row.Cells[7].Value;
record.GreigeP_Meas5 = (int)row.Cells[8].Value;
record.GreigeP_Meas6 = (int)row.Cells[9].Value;
record.GreigeP_Meas7 = (int)row.Cells[10].Value;
record.GreigeP_Meas8 = (int)row.Cells[11].Value;
record.GreigeP_Inspected = (bool)row.Cells[12].Value;
record.GreigeP_InspDate = dateTimePicker1.Value;
record.GreigeP_Inspector_FK = Inspector.MachOp_Pk;
record.GreigeP_WarningMessage = (bool)row.Cells[14].Value;
if (row.Cells[2].Value != null)
{
if (row.Cells[2].Value.ToString().Contains("C"))
{
// We need to record a transaction
//-----------------------------------------------
TLKNI_GreigeTransactions GreigeT = new TLKNI_GreigeTransactions();
GreigeT.GreigeT_AdjustedWeight = record.GreigeP_weight;
GreigeT.GreigeT_TransactionDate = dateTimePicker1.Value;
GreigeT.GreigeT_TransactionNumber = 9999;
GreigeT.GreigeT_Grade = row.Cells[2].Value.ToString();
GreigeT.GreigeT_KOrder_FK = KO.KnitO_Pk;
GreigeT.GreigeT_Piece_FK = record.GreigeP_Pk;
if (KO.KnitO_YarnO_FK != null)
{
TranType = context.TLADM_TranactionType.Where(x => x.TrxT_Department_FK == Dept.Dep_Id && x.TrxT_Number == 1500).FirstOrDefault();
if (TranType != null)
{
record.GreigeP_Store_FK = TranType.TrxT_ToWhse_FK;
}
}
else
{
if (KO.KnitO_CommisionCust)
{
TranType = context.TLADM_TranactionType.Where(x => x.TrxT_Department_FK == Dept.Dep_Id && x.TrxT_Number == 1700).FirstOrDefault();
if (TranType != null)
{
record.GreigeP_Store_FK = TranType.TrxT_ToWhse_FK;
}
}
else
{
TranType = context.TLADM_TranactionType.Where(x => x.TrxT_Department_FK == Dept.Dep_Id && x.TrxT_Number == 1600).FirstOrDefault();
if (TranType != null)
{
record.GreigeP_Store_FK = TranType.TrxT_ToWhse_FK;
}
}
}
GreigeT.GreigeT_TransactionType_FK = TranType.TrxT_Pk;
context.TLKNI_GreigeTransactions.Add(GreigeT);
}
else
{
if (KO.KnitO_YarnO_FK != null)
{
TranType = context.TLADM_TranactionType.Where(x => x.TrxT_Department_FK == Dept.Dep_Id && x.TrxT_Number == 1400).FirstOrDefault();
if (TranType != null)
{
record.GreigeP_Store_FK = TranType.TrxT_ToWhse_FK;
}
}
else
{
if (KO.KnitO_CommisionCust)
{
TranType = context.TLADM_TranactionType.Where(x => x.TrxT_Department_FK == Dept.Dep_Id && x.TrxT_Number == 1300).FirstOrDefault();
if (TranType != null)
{
record.GreigeP_Store_FK = TranType.TrxT_ToWhse_FK;
}
}
else
{
TranType = context.TLADM_TranactionType.Where(x => x.TrxT_Department_FK == Dept.Dep_Id && x.TrxT_Number == 1200).FirstOrDefault();
if (TranType != null)
{
record.GreigeP_Store_FK = TranType.TrxT_ToWhse_FK;
}
}
}
}
}
}
try
{
context.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.InnerException.ToString());
success = false;
}
}
if (success)
{
MessageBox.Show("Records stored successfully to the database");
dataGridView1.Rows.Clear();
}
}
}
private void dataGridView1_KeyDown(object sender, KeyEventArgs e)
{
DataGridView oDgv = sender as DataGridView;
TLADM_TranactionType TranType = null;
TLKNI_GreigeProduction GreigeP = null;
if (oDgv != null && e.KeyCode == Keys.Enter)
{
dataGridView1.CurrentCell = core.GetNextCell(oDgv, oDgv.CurrentCell);
e.Handled = true;
}
else if (oDgv != null && e.KeyCode == Keys.Insert)
{
DialogResult res = MessageBox.Show("You are about to insert a new record into this Knit order ", "Please confirm ", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (res == DialogResult.Yes)
{
var KO = (TLKNI_Order)cmbKnitOrder.SelectedItem;
if (KO == null)
{
MessageBox.Show("Please select a Knit order");
return;
}
using (var context = new TTI2Entities())
{
var Machine = context.TLADM_MachineDefinitions.Find(KO.KnitO_Machine_FK);
if (Machine != null)
{
MCode = Machine.MD_MachineCode.Remove(0, 1).Trim();
MLNU = Machine.MD_LastNumberUsed;
var MachDet = Machine.MD_MachineCode.Remove(0);
var Dept = context.TLADM_Departments.Where(x => x.Dep_ShortCode.Contains("KNIT")).FirstOrDefault();
if (Dept != null)
{
if (KO.KnitO_YarnO_FK == null)
{
if (KO.KnitO_CommisionCust)
{
TranType = context.TLADM_TranactionType.Where(x => x.TrxT_Department_FK == Dept.Dep_Id && x.TrxT_Number == 2002).FirstOrDefault();
}
else
{
TranType = context.TLADM_TranactionType.Where(x => x.TrxT_Department_FK == Dept.Dep_Id && x.TrxT_Number == 2003).FirstOrDefault();
}
}
else
{
TranType = context.TLADM_TranactionType.Where(x => x.TrxT_Department_FK == Dept.Dep_Id && x.TrxT_Number == 2001).FirstOrDefault();
}
GreigeP = new TLKNI_GreigeProduction();
GreigeP.GreigeP_Store_FK = TranType.TrxT_ToWhse_FK;
GreigeP.GreigeP_KnitO_Fk = KO.KnitO_Pk;
GreigeP.GreigeP_Greige_Fk = KO.KnitO_Product_FK;
GreigeP.GreigeP_PieceNo = MCode + MLNU.ToString().PadLeft(4,'0');
GreigeP.GreigeP_weight = 0.00M;
GreigeP.GreigeP_weightAvail = 0.00M;
GreigeP.GreigeP_Meas1 = 0;
GreigeP.GreigeP_Meas2 = 0;
GreigeP.GreigeP_Meas3 = 0;
GreigeP.GreigeP_Meas4 = 0;
GreigeP.GreigeP_Meas5 = 0;
GreigeP.GreigeP_Meas6 = 0;
GreigeP.GreigeP_Meas7 = 0;
GreigeP.GreigeP_Meas8 = 0;
GreigeP.GreigeP_Grade = "A";
GreigeP.GreigeP_Captured = true;
GreigeP.GreigeP_Shift_FK = 1;
GreigeP.GreigeP_Captured = true;
Machine.MD_LastNumberUsed += 1;
context.TLKNI_GreigeProduction.Add(GreigeP);
}
try
{
context.SaveChanges();
var Index = dataGridView1.Rows.Add();
dataGridView1.Rows[Index].Cells[0].Value = GreigeP.GreigeP_Pk;
dataGridView1.Rows[Index].Cells[1].Value = GreigeP.GreigeP_PieceNo;
dataGridView1.Rows[Index].Cells[2].Value = "A";
dataGridView1.Rows[Index].Cells[3].Value = 0.00M;
this.dataGridView1.CurrentCell = this.dataGridView1.Rows[Index].Cells[3];
this.dataGridView1.BeginEdit(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
}
}
