private void btnSave_Click(object sender, EventArgs e)
{
Button oBtn = sender as Button;
TLADM_TranactionType tranType = null;
if (oBtn != null && formloaded)
{
var YO = (TLSPN_YarnOrder)cmboKnitOrder.SelectedItem;
if (YO != null)
{
using (var context = new TTI2Entities())
{
var deptDetail = context.TLADM_Departments.Where(x => x.Dep_ShortCode == "SPIN").FirstOrDefault();
if (deptDetail != null)
{
tranType = context.TLADM_TranactionType.Where(x => x.TrxT_Department_FK == deptDetail.Dep_Id && x.TrxT_Number == 800).FirstOrDefault();
}
foreach (DataGridViewRow Row in dataGridView1.Rows)
{
if ((bool)Row.Cells[1].Value == false)
{
continue;
}
TLSPN_YarnTransactions YarnT = new TLSPN_YarnTransactions();
YarnT.YarnTrx_YarnOrder_FK = YO.YarnO_Pk;
YarnT.YarnTrx_SequenceNo = Convert.ToInt32(txtDelNo.Text);
YarnT.YarnTrx_Date = dateTimePicker1.Value;
if (tranType != null)
{
YarnT.YarnTrx_TranType_FK = tranType.TrxT_Pk;
YarnT.YarnTrx_FromDep_FK = tranType.TrxT_FromWhse_FK;
YarnT.YarnTrx_ToDep_FK = tranType.TrxT_ToWhse_FK;
}
var NettWeight = (Decimal)Row.Cells[4].Value;
context.TLSPN_YarnTransactions.Add(YarnT);
var index = (int)Row.Cells[0].Value;
var PalletStore = context.TLSPN_YarnOrderPallets.Find(index);
if (PalletStore != null)
{
PalletStore.YarnOP_NoOfConesSpun -= PalletStore.YarnOP_NoOfCones;
PalletStore.YarnOP_Issued = true;
PalletStore.YarnOP_DateDispatched = dateTimePicker1.Value;
PalletStore.YarnOP_Store_FK = (int)tranType.TrxT_ToWhse_FK;
PalletStore.YarnOP_YarnType_FK = YO.Yarno_YarnType_FK;
PalletStore.YarnOP_NettWeight = NettWeight;
PalletStore.YarnOP_ReservedBy = int.Parse(txtDelNo.Text);
TLKNI_YarnOrderPallets KnitYOP = new TLKNI_YarnOrderPallets();
KnitYOP.TLKNIOP_Cones = PalletStore.YarnOP_NoOfCones;
KnitYOP.TLKNIOP_PalletNo = PalletStore.YarnOP_PalletNo;
KnitYOP.TLKNIOP_NettWeight = NettWeight;
KnitYOP.TLKNIOP_YarnOrder_FK = YO.YarnO_Pk;
KnitYOP.TLKNIOP_YarnType_FK = YO.Yarno_YarnType_FK;
KnitYOP.TLKNIOP_ConesReserved = 0;
KnitYOP.TLKNIOP_NettWeightReserved = 0.00M;
KnitYOP.TLKNIOP_Grade = PalletStore.YarnOP_Grade;
KnitYOP.TLKNIOP_Store_FK = (int)tranType.TrxT_ToWhse_FK;
KnitYOP.TLKNIOP_OwnYarn = true;
context.TLKNI_YarnOrderPallets.Add(KnitYOP);
}
}
try
{
context.SaveChanges();
MessageBox.Show("Data saved to database successfully");
frmYarnwithdrawl_Load(this, null);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/*
* int TransNum = int.Parse(txtDelNo.Text);
* frmKnitViewRep vRep = new frmKnitViewRep(8, TransNum);
* int h = Screen.PrimaryScreen.WorkingArea.Height;
* int w = Screen.PrimaryScreen.WorkingArea.Width;
* vRep.ClientSize = new Size(w, h);
* vRep.ShowDialog(this);
*/
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
//Dont forget the last number used...
Button oBtn = sender as Button;
if (oBtn != null && formloaded)
{
var ErrorM = core.returnMessage(MandSelected, true, MandatoryFields);
if (!String.IsNullOrEmpty(ErrorM))
{
MessageBox.Show(ErrorM);
return;
}
using (var context = new TTI2Entities())
{
var LastNumber = context.TLADM_LastNumberUsed.Find(1);
if (LastNumber != null)
{
LastNumber.col10 += 1;
}
//---------------------------------------------------------
TLSPN_YarnTransactions YarnT = new TLSPN_YarnTransactions();
//-------------------------------------------------------------
// Review Document for a list
//-------------------------------------------------------------
var YO = (TLSPN_YarnOrder)cmbYarnOrder.SelectedItem;
if (YO != null)
{
YarnT.YarnTrx_YarnOrder_FK = YO.YarnO_Pk;
}
var deptDetail = context.TLADM_Departments.Where(x => x.Dep_ShortCode == "SPIN").FirstOrDefault();
if (deptDetail != null)
{
var tranDetail = context.TLADM_TranactionType.Where(x => x.TrxT_Department_FK == deptDetail.Dep_Id && x.TrxT_Number == 1000).FirstOrDefault();
if (tranDetail != null)
{
YarnT.YarnTrx_TranType_FK = tranDetail.TrxT_Pk;
YarnT.YarnTrx_ToDep_FK = tranDetail.TrxT_ToWhse_FK;
YarnT.YarnTrx_FromDep_FK = tranDetail.TrxT_FromWhse_FK;
}
}
YarnT.YarnTrx_SequenceNo = Convert.ToInt32(txtDeliveryNoteNumber.Text);
YarnT.YarnTrx_Date = dateTimePicker1.Value;
var PalletNo = (TLSPN_YarnOrderPallets)cmboPalletNumbers.SelectedItem;
if (PalletNo != null)
{
YarnT.YarnTrx_PalletNo_Fk = PalletNo.YarnOP_Pk;
}
YarnT.YarnTrx_ApprovedBy = txtApprovedBy.Text;
var NoCones = Convert.ToInt32(txtNumberOfCones.Text);
var NettWeight = Convert.ToDecimal(txtNettWeight.Text);
YarnT.YarnTrx_Cones = NoCones;
YarnT.YarnTrx_NettWeight = NettWeight;
YarnT.YarnTrx_Reasons = richTextBox1.Text;
var PalletStore = context.TLSPN_YarnOrderPallets.Find(PalletNo.YarnOP_Pk);
if (PalletStore != null)
{
PalletStore.YarnOP_NoOfConesSpun -= NoCones;
PalletStore.YarnOP_NettWeight -= NettWeight;
PalletStore.YarnOP_Scrapped = true;
PalletStore.YarnOP_DateDispatched = dateTimePicker1.Value;
}
//--------------------------------------------------------------------------------------
try
{
context.TLSPN_YarnTransactions.Add(YarnT);
context.SaveChanges();
SetUp();
Transactions = true;
MessageBox.Show("Records stored to database successfully");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
Button oBtn = sender as Button;
if (oBtn != null && formloaded)
{
var ErrorM = core.returnMessage(MandatorySelected, true, MandatoryFields);
if (!String.IsNullOrEmpty(ErrorM))
{
MessageBox.Show(ErrorM);
return;
}
var selected = (TLSPN_YarnOrderPallets)cmbPalettNo.SelectedItem;
if (selected != null)
{
if (cmbOperator.SelectedValue == null)
{
MessageBox.Show("Please select an operator from the drop down box");
return;
}
int NoOfCones = int.Parse(txtNoOfCones.Text);
if (NoOfCones <= 0)
{
MessageBox.Show("Please enter the number of cones spun");
return;
}
using (var context = new TTI2Entities())
{
var yo = (TLSPN_YarnOrder)cmbYarnOrder.SelectedItem;
if (yo != null)
{
var YarnInfo = context.TLADM_Yarn.Where(x => x.YA_Id == yo.Yarno_YarnType_FK).FirstOrDefault();
if (YarnInfo != null)
{
selected.YarnOP_YarnType_FK = YarnInfo.YA_Id;
}
}
selected = context.TLSPN_YarnOrderPallets.Find(selected.YarnOP_Pk);
selected.YarnOP_DatePacked = dtpDateProduced.Value;
selected.YarnOP_GrossWeight = Convert.ToDecimal(txtGrossWeight.Text);
selected.YarnOP_TareWeight = Convert.ToDecimal(txtTareWeight.Text);
selected.YarnOP_NettWeight = Convert.ToDecimal(txtGrossWeight.Text) - Convert.ToDecimal(txtTareWeight.Text);
selected.YarnOP_NoOfCones = NoOfCones;
selected.YarnOP_NoOfConesSpun = Convert.ToInt32(txtNoOfConesSpun.Text);
selected.YarnOP_Grade = txtYarnGrade.Text;
if (cmbOperator.SelectedValue != null)
{
selected.YarnOP_Operator_FK = (int)cmbOperator.SelectedValue;
}
if (selected.YarnOP_NoOfConesSpun == selected.YarnOP_NoOfCones)
{
selected.YarnOP_Complete = true;
}
else
{
selected.YarnOP_Complete = false;
}
var Dept = context.TLADM_Departments.Where(x => x.Dep_ShortCode.Contains("SPIN")).FirstOrDefault();
if (Dept != null)
{
var Trantype = context.TLADM_TranactionType.Where(x => x.TrxT_Department_FK == Dept.Dep_Id && x.TrxT_Number == 500).FirstOrDefault();
if (Trantype != null)
{
selected.YarnOP_Store_FK = (int)Trantype.TrxT_ToWhse_FK;
}
}
TLSPN_YarnTransactions YarnT = new TLSPN_YarnTransactions();
var Trx = context.TLSPN_YarnTransactions.Where(x => x.YarnTrx_YarnOrder_FK == selected.YarnOP_YarnOrder_FK &&
x.YarnTrx_PalletNo_Fk == selected.YarnOP_Pk).FirstOrDefault();
if (Trx != null)
{
YarnT = context.TLSPN_YarnTransactions.Find(Trx.YarnTrx_Pk);
YarnT.YarnTrx_Date = dtpDateProduced.Value;
YarnT.YarnTrx_NettWeight = selected.YarnOP_NettWeight;
YarnT.YarnTrx_Cones = selected.YarnOP_NoOfCones;
}
else
{
var deptDetail = context.TLADM_Departments.Where(x => x.Dep_ShortCode == "SPIN").FirstOrDefault();
if (deptDetail != null)
{
var tranDetail = context.TLADM_TranactionType.Where(x => x.TrxT_Department_FK == deptDetail.Dep_Id && x.TrxT_Number == 700).FirstOrDefault();
if (tranDetail != null)
{
YarnT.YarnTrx_TranType_FK = tranDetail.TrxT_Pk;
}
}
YarnT.YarnTrx_PalletNo_Fk = selected.YarnOP_Pk;
YarnT.YarnTrx_YarnOrder_FK = (int)selected.YarnOP_YarnOrder_FK;
YarnT.YarnTrx_SequenceNo = 0;
YarnT.YarnTrx_Cones = selected.YarnOP_NoOfCones;
YarnT.YarnTrx_WriteOff = false;
YarnT.YarnTrx_NettWeight = selected.YarnOP_NettWeight;
YarnT.YarnTrx_Date = dtpDateProduced.Value;
context.TLSPN_YarnTransactions.Add(YarnT);
}
try
{
context.SaveChanges();
formloaded = false;
yo = (TLSPN_YarnOrder)cmbYarnOrder.SelectedItem;
if (yo != null)
{
var Existing = context.TLSPN_YarnOrderPallets.Where(x => x.YarnOP_YarnOrder_FK == yo.YarnO_Pk && !x.YarnOP_Complete).ToList();
formloaded = false;
cmbPalettNo.DataSource = Existing;
formloaded = true;
}
MessageBox.Show("Records successfully updated to DataBase");
SetUp(false);
MandatorySelected[0] = true;
MandatorySelected[2] = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
// dont forget last number used~!!!!!
TLADM_Departments DeptDetail;
Button oBtn = sender as Button;
if (oBtn != null && formloaded)
{
var ErrorM = core.returnMessage(MandSelected, true, MandatoryFields);
if (!String.IsNullOrEmpty(ErrorM))
{
MessageBox.Show(ErrorM);
return;
}
using (var context = new TTI2Entities())
{
var LastNumber = context.TLADM_LastNumberUsed.Find(1);
if (LastNumber != null)
{
LastNumber.col11 += 1;
}
//---------------------------------------------------------
TLSPN_YarnTransactions YarnT = new TLSPN_YarnTransactions();
//-------------------------------------------------------------
// Review Document for a list of transaction numbers
//-------------------------------------------------------------
//-------------------------------------------------------------
var YO = (TLSPN_YarnOrder)cmboYarnNo.SelectedItem;
if (YO != null)
{
YarnT.YarnTrx_YarnOrder_FK = YO.YarnO_Pk;
}
//----------------------------------------------------------------------------------------------------
DeptDetail = context.TLADM_Departments.Where(x => x.Dep_ShortCode == "SPIN").FirstOrDefault();
if (DeptDetail != null)
{
var tranDetail = context.TLADM_TranactionType.Where(x => x.TrxT_Department_FK == DeptDetail.Dep_Id && x.TrxT_Number == 1100).FirstOrDefault();
if (tranDetail != null)
{
YarnT.YarnTrx_TranType_FK = tranDetail.TrxT_Pk;
YarnT.YarnTrx_ToDep_FK = tranDetail.TrxT_ToWhse_FK;
YarnT.YarnTrx_FromDep_FK = tranDetail.TrxT_FromWhse_FK;
}
}
//-------------------------------------------------------------------------------
YarnT.YarnTrx_SequenceNo = Convert.ToInt32(txtDeliveryNoteNumber.Text);
YarnT.YarnTrx_Date = dateTimePicker1.Value;
var PalletNo = (TLSPN_YarnOrderPallets)cmboPalletNumbers.SelectedItem;
if (PalletNo != null)
{
if (_Mode)
{
YarnT.YarnTrx_PalletNo_Fk = PalletNo.YarnOP_Pk;
}
else
{
var PLT = context.TLKNI_YarnOrderPallets.Where(x => x.TLKNIOP_PalletNo == PalletNo.YarnOP_PalletNo).FirstOrDefault();
if (PLT != null)
{
YarnT.YarnTrx_PalletNo_Fk = PLT.TLKNIOP_Pk;
}
}
}
YarnT.YarnTrx_ApprovedBy = txtApprovedBy.Text;
YarnT.YarnTrx_Reasons = rtbReasons.Text;
var NoCones = Convert.ToInt32(txtNumberOfCones.Text);
YarnT.YarnTrx_Cones = NoCones;
var NettWeight = Convert.ToDecimal(txtNettWeight.Text);
YarnT.YarnTrx_NettWeight = NettWeight;
if (_Mode)
{
var PalletStore = context.TLSPN_YarnOrderPallets.Find(PalletNo.YarnOP_Pk);
if (PalletStore != null)
{
if (rbWriteOff.Checked)
{
PalletStore.YarnOP_NoOfConesSpun -= NoCones;
PalletStore.YarnOP_NettWeight -= NettWeight;
YarnT.YarnTrx_WriteOff = true;
}
else
{
PalletStore.YarnOP_NoOfConesSpun += NoCones;
PalletStore.YarnOP_NettWeight += NettWeight;
YarnT.YarnTrx_WriteOff = false;
}
}
}
else
{
var PalletStore = context.TLKNI_YarnOrderPallets.Find(YarnT.YarnTrx_PalletNo_Fk);
if (PalletStore != null)
{
if (rbWriteOff.Checked)
{
PalletStore.TLKNIOP_Cones -= NoCones;
PalletStore.TLKNIOP_NettWeight -= NettWeight;
YarnT.YarnTrx_WriteOff = true;
}
else
{
PalletStore.TLKNIOP_Cones += NoCones;
PalletStore.TLKNIOP_NettWeight += NettWeight;
YarnT.YarnTrx_WriteOff = false;
}
}
}
String Mach_IP = Dns.GetHostEntry(Dns.GetHostName())
.AddressList.First(f => f.AddressFamily == AddressFamily.InterNetwork)
.ToString();
TLADM_DailyLog DailyLog = new TLADM_DailyLog();
DailyLog.TLDL_IPAddress = Mach_IP;
DailyLog.TLDL_Dept_Fk = DeptDetail.Dep_Id;
DailyLog.TLDL_Date = DateTime.Now;
DailyLog.TLDL_TransDetail = "Yarn Adjustment";
DailyLog.TLDL_AuthorisedBy = txtApprovedBy.Text;
DailyLog.TLDL_Comments = string.Empty;
context.TLADM_DailyLog.Add(DailyLog);
try
{
context.TLSPN_YarnTransactions.Add(YarnT);
context.SaveChanges();
Transactions = true;
SetUp();
MessageBox.Show("Records stored successfully to database");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
//dont forget last number used
Button oBtn = sender as Button;
TLADM_TranactionType tranType = null;
if (oBtn != null && formloaded)
{
var ErrorM = core.returnMessage(MandSelected, true, MandatoryFields);
if (!String.IsNullOrEmpty(ErrorM))
{
MessageBox.Show(ErrorM);
return;
}
using (var context = new TTI2Entities())
{
var LastNumberUsed = context.TLADM_LastNumberUsed.Find(1);
if (LastNumberUsed != null)
{
LastNumberUsed.col8 += 1;
}
//---------------------------------------------------------
TLSPN_YarnTransactions YarnT = new TLSPN_YarnTransactions();
var YO = (TLSPN_YarnOrder)comboYarnNo.SelectedItem;
if (YO != null)
{
YarnT.YarnTrx_YarnOrder_FK = YO.YarnO_Pk;
}
YarnT.YarnTrx_SequenceNo = Convert.ToInt32(txtDeliveryNoteNumber.Text);
YarnT.YarnTrx_Date = dateTimePicker1.Value;
var deptDetail = context.TLADM_Departments.Where(x => x.Dep_ShortCode == "SPIN").FirstOrDefault();
if (deptDetail != null)
{
//tranType = context.TLADM_TranactionType.Where(x => x.TrxT_Department_FK == deptDetail.Dep_Id && x.TrxT_Number == 800).FirstOrDefault();
tranType = context.TLADM_TranactionType.Where(x => x.TrxT_Department_FK == deptDetail.Dep_Id && x.TrxT_Number == 700).FirstOrDefault();
if (tranType != null)
{
YarnT.YarnTrx_TranType_FK = tranType.TrxT_Pk;
YarnT.YarnTrx_FromDep_FK = tranType.TrxT_FromWhse_FK;
YarnT.YarnTrx_ToDep_FK = tranType.TrxT_ToWhse_FK;
}
}
var PalletNo = (TLSPN_YarnOrderPallets)cmboPalletNumbers.SelectedItem;
if (PalletNo != null)
{
YarnT.YarnTrx_PalletNo_Fk = PalletNo.YarnOP_Pk;
}
var NoCones = Convert.ToInt32(txtNumberOfCones.Text);
YarnT.YarnTrx_Cones = NoCones;
var NettWeight = Convert.ToDecimal(txtNettWeight.Text);
YarnT.YarnTrx_NettWeight = Convert.ToDecimal(txtNettWeight.Text);
//----------------------------------------------------------------
// This Transaction updates the spinning rocords
var PalletStore = context.TLSPN_YarnOrderPallets.Find(PalletNo.YarnOP_Pk);
if (PalletStore != null)
{
PalletStore.YarnOP_NoOfConesSpun -= NoCones;
PalletStore.YarnOP_YarnAvailable = true;
PalletStore.YarnOP_Issued = false;
PalletStore.YarnOP_Store_FK = (int)tranType.TrxT_ToWhse_FK;
PalletStore.YarnOP_YarnType_FK = YO.Yarno_YarnType_FK;
PalletStore.YarnOP_NettWeight = NettWeight;
}
//---------------------------------------------------------
try
{
context.TLSPN_YarnTransactions.Add(YarnT);
context.SaveChanges();
SetUp(false);
Transactions = true;
MessageBox.Show("Data saved to database successfully");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
