private void btnSave_Click(object sender, EventArgs e)
{
Button oBtn = sender as Button;
TLADM_CustomerFile CommissionCust;
TLKNI_YarnTransaction yarnT;
TLKNI_YarnTransactionDetails yarnTD;
//TLKNI_YarnStatus yarnStat;
TLADM_TranactionType TranType = null;
TLKNI_YarnOrderPallets PalletStore;
int LastNumberUsed = 0;
if (oBtn != null && formloaded)
{
var ErrorM = core.returnMessage(MandSelected, false, MandatoryFields);
if (!String.IsNullOrEmpty(ErrorM))
{
MessageBox.Show(ErrorM);
return;
}
if (dataGridView1.RowCount == 0)
{
MessageBox.Show("Please enter a least one row in the datagrid");
return;
}
CommissionCust = (TLADM_CustomerFile)cmbCommissionCustomers.SelectedItem;
using (var context = new TTI2Entities())
{
//-------------------------
// Yarn Header Record
//----------------------------------------
yarnT = new TLKNI_YarnTransaction();
yarnT.KnitY_TransactionDate = dtpDateReceived.Value;
yarnT.KnitY_Customer_FK = CommissionCust.Cust_Pk;
yarnT.KnitY_Notes = rtbComments.Text;
yarnT.KnitY_TransactionDoc = txtCustomerDoc.Text;
yarnT.KnitY_ThirdParty = false;
yarnT.KnitY_RTS = false;
var LastNumber = context.TLADM_LastNumberUsed.Find(2);
if (LastNumber != null)
{
LastNumberUsed = LastNumber.col1;
yarnT.KnitY_GRNNumber = LastNumberUsed;
LastNumber.col1 += 1;
}
var Dept = context.TLADM_Departments.Where(x => x.Dep_ShortCode.Contains("KNIT")).FirstOrDefault();
if (Dept != null)
{
TranType = context.TLADM_TranactionType.Where(x => x.TrxT_Department_FK == Dept.Dep_Id && x.TrxT_Number == 100).FirstOrDefault();
}
try
{
context.TLKNI_YarnTransaction.Add(yarnT);
context.SaveChanges();
foreach (DataGridViewRow dr in dataGridView1.Rows)
{
if (dr.Cells[1].Value == null)
{
continue;
}
var PalletNo = (int)dr.Cells[0].Value;
PalletStore = new TLKNI_YarnOrderPallets();
PalletStore.TLKNIOP_CommisionCust = true;
PalletStore.TLKNIOP_Cones = (int)dr.Cells[7].Value;
PalletStore.TLKNIOP_DatePacked = dtpDateReceived.Value;
PalletStore.TLKNIOP_Grade = string.Empty;
PalletStore.TLKNIOP_GrossWeight = (decimal)dr.Cells[5].Value;
PalletStore.TLKNIOP_TareWeight = 0.00M;
PalletStore.TLKNIOP_NettWeight = (decimal)dr.Cells[6].Value;
PalletStore.TLKNIOP_YarnType_FK = (int)dr.Cells[1].Value;
PalletStore.TLKNIOP_PalletNo = PalletNo;
PalletStore.TLKNIOP_Store_FK = (int)TranType.TrxT_ToWhse_FK;
PalletStore.TLKNIOP_NettWeightReserved = 0.00M;
PalletStore.TLKNIOP_HeaderRecord_FK = yarnT.KnitY_Pk;
PalletStore.TLKNIOP_ConesReserved = 0;
context.TLKNI_YarnOrderPallets.Add(PalletStore);
context.SaveChanges();
yarnTD = new TLKNI_YarnTransactionDetails();
yarnTD.KnitYD_KnitY_FK = yarnT.KnitY_Pk;
yarnTD.KnitYD_YarnType_FK = (int)dr.Cells[1].Value;
yarnTD.KnitYD_PalletNo_FK = PalletStore.TLKNIOP_Pk;
yarnTD.KnitYD_GrossWeight = (decimal)dr.Cells[5].Value;
yarnTD.KnitYD_NettWeight = (decimal)dr.Cells[6].Value;
yarnTD.KnitYD_NoOfCones = (int)dr.Cells[7].Value;
yarnTD.KnitYD_TransactionDate = dtpDateReceived.Value;
yarnTD.KnitYD_RTS = false;
yarnTD.KnitYD_TransactionNumber = LastNumberUsed;
if (TranType != null)
{
yarnTD.KnitYD_TransactionType = TranType.TrxT_Pk;
}
yarnTD.KnitYD_RTS = false;
context.TLKNI_YarnTransactionDetails.Add(yarnTD);
}
context.SaveChanges();
dataGridView1.Rows.Clear();
MessageBox.Show("Records stored successfully to database");
frmKnitViewRep vRep = new frmKnitViewRep(1, yarnT.KnitY_Pk);
vRep.ShowDialog(this);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
TLSPN_YarnOrder YO = null;
TLKNI_YarnTransaction YO3rdP = null;
Button oBtn = sender as Button;
if (oBtn != null && FormLoaded)
{
var KO = (TLKNI_Order)cmboKnitOrders.SelectedItem;
using (var context = new TTI2Entities())
{
if (rbOwnYarn.Checked)
{
YO = (TLSPN_YarnOrder)cmboYarnOrders.SelectedItem;
}
else
{
YO3rdP = (TLKNI_YarnTransaction)cmboYarnOrders.SelectedItem;
}
foreach (DataGridViewRow Row in dataGridView1.Rows)
{
if ((bool)Row.Cells[1].Value == false)
{
continue;
}
bool lSplit = false;
TLKNI_YarnOrderPallets yarnStat = new TLKNI_YarnOrderPallets();
var _Key = (int)Row.Cells[0].Value;
yarnStat = context.TLKNI_YarnOrderPallets.Find(_Key);
if ((decimal)Row.Cells[4].Value > (decimal)Row.Cells[6].Value)
{
// We now need to start recording as and when a pallet is across orders
//---------------------------------------------------------------------
DialogResult res = MessageBox.Show("Please confirm split transaction", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (res == DialogResult.Yes)
{
TLKNI_YarnOrderPallets YarnSplit = new TLKNI_YarnOrderPallets();
YarnSplit.TLKNIOP_CommisionCust = yarnStat.TLKNIOP_CommisionCust;
YarnSplit.TLKNIOP_Cones = yarnStat.TLKNIOP_Cones;
YarnSplit.TLKNIOP_DatePacked = yarnStat.TLKNIOP_DatePacked;
YarnSplit.TLKNIOP_Grade = yarnStat.TLKNIOP_Grade;
YarnSplit.TLKNIOP_GrossWeight = yarnStat.TLKNIOP_GrossWeight;
YarnSplit.TLKNIOP_HeaderRecord_FK = yarnStat.TLKNIOP_HeaderRecord_FK;
YarnSplit.TLKNIOP_NettWeight = yarnStat.TLKNIOP_NettWeight;
YarnSplit.TLKNIOP_SplitPallet = true;
YarnSplit.TLKNIOP_ReservedBy = KO.KnitO_Pk;
YarnSplit.TLKNIOP_ReservedDate = dtpTransactionDate.Value;
YarnSplit.TLKNIOP_OrderConfirmed = yarnStat.TLKNIOP_OrderConfirmed;
YarnSplit.TLKNIOP_OwnYarn = yarnStat.TLKNIOP_OwnYarn;
YarnSplit.TLKNIOP_PalletNo = yarnStat.TLKNIOP_PalletNo;
YarnSplit.TLKNIOP_Store_FK = yarnStat.TLKNIOP_Store_FK;
YarnSplit.TLKNIOP_TareWeight = yarnStat.TLKNIOP_TareWeight;
YarnSplit.TLKNIOP_YarnOrder_FK = yarnStat.TLKNIOP_YarnOrder_FK;
YarnSplit.TLKNIOP_YarnType_FK = yarnStat.TLKNIOP_YarnType_FK;
YarnSplit.TLKNIOP_NettWeight = (decimal)Row.Cells[6].Value;
YarnSplit.TLKNIOP_ConesReserved = (int)Row.Cells[5].Value;
YarnSplit.TLKNIOP_NettWeightReserved = (decimal)Row.Cells[6].Value;
YarnSplit.TLKNIOP_Cones = (int)Row.Cells[5].Value;
context.TLKNI_YarnOrderPallets.Add(YarnSplit);
lSplit = true;
}
else
{
return;
}
}
yarnStat.TLKNIOP_ConesReserved += (int)Row.Cells[5].Value;
yarnStat.TLKNIOP_NettWeightReserved += (decimal)Row.Cells[6].Value;
if (!lSplit)
{
yarnStat.TLKNIOP_ReservedBy = KO.KnitO_Pk;
yarnStat.TLKNIOP_ReservedDate = dtpTransactionDate.Value;
}
}
// Note for the file
//-----------------------------------
// The Yarn Order Number is either TTL own Yarn or that received
// from a Third Party
//----------------------------------------------------------------
var KnitOrder = context.TLKNI_Order.Find(KO.KnitO_Pk);
if (KnitOrder != null)
{
KnitOrder.KnitO_YarnAssigned = true;
if (rbOwnYarn.Checked)
{
KnitOrder.KnitO_YarnO_FK = YO.YarnO_Pk;
}
else
{
KnitOrder.KnitO_YarnO_FK = YO3rdP.KnitY_Pk;
}
}
try
{
context.SaveChanges();
MessageBox.Show("Data saved to the database successfully");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
dataGridView1.Rows.Clear();
FormLoaded = false;
cmboKnitOrders.SelectedItem = -1;
cmboYarnOrders.SelectedItem = -1;
FormLoaded = true;
btnSave.Enabled = false;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
Button oBtn = sender as Button;
int RecCount = 0;
int LastNumberUsed = 0;
TLADM_Suppliers CommissionCust;
TLKNI_YarnTransaction yarnT;
TLKNI_YarnTransactionDetails yarnTD;
TLADM_TranactionType TranType = null;
TLKNI_YarnOrderPallets PalletStore;
if (oBtn != null && formloaded)
{
var ErrorM = core.returnMessage(MandFieldsSelected, false, MandatoryFields);
if (!String.IsNullOrEmpty(ErrorM))
{
MessageBox.Show(ErrorM);
return;
}
if (dataGridView1.RowCount == 0)
{
MessageBox.Show("Please enter a least one row in the datagrid");
return;
}
foreach (DataGridViewRow dr in dataGridView1.Rows)
{
var tst = fieldEntered.Find(x => x.rownumber == dr.Index);
if (tst.fieldComplete == null)
{
continue;
}
var cnt = tst.fieldComplete.Where(x => x == false).Count();
if (cnt == MandatoryRows.Length)
{
continue;
}
cnt = tst.fieldComplete.Where(x => x == true).Count();
if (cnt != MandatoryRows.Length)
{
MessageBox.Show("Line " + (1 + dr.Index).ToString() + " Has not been completed correctly");
return;
}
}
CommissionCust = (TLADM_Suppliers)cmbCommissionCustomers.SelectedItem;
using (var context = new TTI2Entities())
{
yarnT = new TLKNI_YarnTransaction();
yarnT.KnitY_TransactionDate = dtpDateReceived.Value;
yarnT.KnitY_Customer_FK = CommissionCust.Sup_Pk;
yarnT.KnitY_Notes = rtbComments.Text;
yarnT.KnitY_TransactionDoc = txtCustomerDoc.Text;
yarnT.KnitY_ThirdParty = true;
var LastNumber = context.TLADM_LastNumberUsed.Find(2);
if (LastNumber != null)
{
LastNumberUsed = LastNumber.col2;
yarnT.KnitY_GRNNumber = LastNumberUsed;
LastNumber.col2 += 1;
}
var YarnLastNumber = context.TLADM_LastNumberUsed.Find(1);
var Dept = context.TLADM_Departments.Where(x => x.Dep_ShortCode.Contains("KNIT")).FirstOrDefault();
if (Dept != null)
{
TranType = context.TLADM_TranactionType.Where(x => x.TrxT_Department_FK == Dept.Dep_Id && x.TrxT_Number == 200).FirstOrDefault();
}
try
{
context.TLKNI_YarnTransaction.Add(yarnT);
context.SaveChanges();
StringBuilder sb = null;
int Counter = 0;
foreach (DataGridViewRow dr in dataGridView1.Rows)
{
var tst = fieldEntered.Find(x => x.rownumber == dr.Index);
if (tst.fieldComplete == null)
{
continue;
}
var cnt = tst.fieldComplete.Where(x => x == false).Count();
if (cnt == MandatoryRows.Count())
{
continue;
}
var PalletNo = (int)dr.Cells[0].Value;
PalletStore = new TLKNI_YarnOrderPallets();
PalletStore.TLKNIOP_CommisionCust = false;
sb = new StringBuilder();
sb.Append(YarnLastNumber.col6.ToString());
sb.Append(" - ");
sb.Append((++Counter).ToString());
PalletStore.TLKNIOP_TLPalletNo = sb.ToString();
PalletStore.TLKNIOP_Cones = (int)dr.Cells[7].Value;
PalletStore.TLKNIOP_DatePacked = dtpDateReceived.Value;
PalletStore.TLKNIOP_Grade = string.Empty;
PalletStore.TLKNIOP_GrossWeight = (decimal)dr.Cells[5].Value;
PalletStore.TLKNIOP_TareWeight = 0.00M;
PalletStore.TLKNIOP_NettWeight = (decimal)dr.Cells[6].Value;
PalletStore.TLKNIOP_YarnType_FK = (int)dr.Cells[1].Value;
PalletStore.TLKNIOP_PalletNo = PalletNo;
PalletStore.TLKNIOP_Store_FK = (int)TranType.TrxT_ToWhse_FK;
PalletStore.TLKNIOP_NettWeightReserved = 0.00M;
PalletStore.TLKNIOP_HeaderRecord_FK = yarnT.KnitY_Pk;
PalletStore.TLKNIOP_ConesReserved = 0;
context.TLKNI_YarnOrderPallets.Add(PalletStore);
context.SaveChanges();
yarnTD = new TLKNI_YarnTransactionDetails();
yarnTD.KnitYD_KnitY_FK = yarnT.KnitY_Pk;
yarnTD.KnitYD_YarnType_FK = (int)dr.Cells[1].Value;
yarnTD.KnitYD_PalletNo_FK = PalletStore.TLKNIOP_Pk;
yarnTD.KnitYD_GrossWeight = (decimal)dr.Cells[5].Value;
yarnTD.KnitYD_NettWeight = (decimal)dr.Cells[6].Value;
yarnTD.KnitYD_NoOfCones = (int)dr.Cells[7].Value;
yarnTD.KnitYD_TransactionDate = dtpDateReceived.Value;
yarnTD.KnitYD_RTS = false;
yarnTD.KnitYD_TransactionNumber = LastNumberUsed;
if (TranType != null)
{
yarnTD.KnitYD_TransactionType = TranType.TrxT_Pk;
}
yarnTD.KnitYD_RTS = false;
context.TLKNI_YarnTransactionDetails.Add(yarnTD);
RecCount += 1;
}
YarnLastNumber = context.TLADM_LastNumberUsed.Find(1);
if (YarnLastNumber != null)
{
YarnLastNumber.col6 += 1;
}
context.SaveChanges();
formloaded = false;
dataGridView1.Rows.Clear();
formloaded = true;
MessageBox.Show("Records stored successfully to database");
frmKnitViewRep vRep = new frmKnitViewRep(3, yarnT.KnitY_Pk);
int h = Screen.PrimaryScreen.WorkingArea.Height;
int w = Screen.PrimaryScreen.WorkingArea.Width;
vRep.ClientSize = new Size(w, h);
vRep.ShowDialog(this);
SetUp();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
