private void microAvailYes_CheckedChanged(object sender, EventArgs e)
{
RadioButton oRb = sender as RadioButton;
if (oRb != null && formloaded)
{
if (oRb.Checked)
{
var ErrorM = core.returnMessage(MandSelected, true, MandatoryFields);
if (!string.IsNullOrEmpty(ErrorM))
{
MessageBox.Show(ErrorM);
}
else
{
TLSPN_CottonTransactions cotTrans = new TLSPN_CottonTransactions();
cotTrans.cotrx_LotNo = Convert.ToInt32(txtLotNo.Text);
cotTrans.cotrx_Return_No = Convert.ToInt32(txtGrnNumber.Text);
cotTrans.cotrx_GrossAveBaleWeight = Convert.ToDecimal(txtGrossAvgBaleWeight.Text);
cotTrans.cottrx_NettAveBaleWeight = Convert.ToDecimal(txtNetAvgBaleWeight.Text);
cotTrans.cotrx_NoBales = Convert.ToInt32(txtNoOfBales.Text);
frmCottonBales cb = new frmCottonBales(cotTrans);
cb.ShowDialog(this);
}
}
}
}
private void cmbContractNo_SelectedIndexChanged(object sender, EventArgs e)
{
ComboBox oCmbo = sender as ComboBox;
;
if (oCmbo != null && formloaded)
{
dataGridView1.Rows.Clear();
cmbLotNo.SelectedValue = 0;
using (var context = new TTI2Entities())
{
var selectedRecord = (TLADM_CottonContracts)oCmbo.SelectedItem;
if (selectedRecord != null)
{
IList <TLSPN_CottonTransactions> cotreceived = new List <TLSPN_CottonTransactions>();
dataGridView1.Rows.Clear();
var existing = context.SelectCottonRecords1(selectedRecord.CottonCon_Pk, selectedRecord.CottonCon_ConSupplier_FK);
foreach (var row in existing)
{
TLSPN_CottonTransactions cr = new TLSPN_CottonTransactions();
cr.cotrx_ContractNo_Fk = row.cotrx_ContractNo_Fk;
cr.cotrx_Customer_FK = row.cotrx_Customer_FK;
cr.cotrx_GrossAveBaleWeight = row.cotrx_GrossAveBaleWeight;
cr.cotrx_GrossWeight = row.cotrx_GrossWeight;
cr.cotrx_LotNo = row.cotrx_LotNo;
cr.cotrx_NettPerWB = row.cotrx_NettPerWB;
cr.cotrx_NetWeight = row.cotrx_NetWeight;
cr.cotrx_NoBales = row.cotrx_NoBales;
cr.cotrx_Notes = row.cotrx_Notes;
cr.cotrx_pk = row.cotrx_pk;
cr.cotrx_Return_No = row.cotrx_Return_No;
cr.cotrx_Supplier_FK = row.cotrx_Supplier_FK;
cr.cotrx_TransDate = row.cotrx_TransDate;
cr.cotrx_TranType = row.cotrx_TranType;
cr.cotrx_WeighBridgeEmpty = row.cotrx_WeighBridgeEmpty;
cr.cotrx_WeighBridgeFull = row.cotrx_WeighBridgeFull;
cr.cotrx_WriteOff = row.cotrx_WriteOff;
cr.cottrx_NettAveBaleWeight = row.cottrx_NettAveBaleWeight;
cotreceived.Add(cr);
}
cmbLotNo.DataSource = cotreceived.ToList();
//cmbLotNo.DataSource = context.TLSPN_CottonReceived.Where(x => x.CotRec_Contract_FK == selectedRecord.CottonCon_Pk).ToList();
cmbLotNo.ValueMember = "cotrx_LotNo";
cmbLotNo.DisplayMember = "cotrx_LotNo";
var result = (from u in MandatoryFields
where u[0] == oCmbo.Name
select u).FirstOrDefault();
if (result != null)
{
int nbr = Convert.ToInt32(result[2].ToString());
MandSelected[nbr] = true;
}
}
}
}
}
public frmCottonBalesInStock()
{
InitializeComponent();
using (var context = new TTI2Entities())
{
var existing = context.AltSelectCottonRecords().OrderBy(x => x.cotrx_LotNo).ToList();
foreach (var row in existing)
{
cotreceived = new TLSPN_CottonTransactions();
cotreceived.cotrx_pk = row.cotrx_pk;
cotreceived.cotrx_LotNo = row.cotrx_LotNo;
comboLotNo.Items.Add(cotreceived);
}
comboLotNo.ValueMember = "cotrx_LotNo";
comboLotNo.DisplayMember = "cotrx_LotNo";
}
}
private void button1_Click(object sender, EventArgs e)
{
Button oBtn = sender as Button;
if (oBtn != null && formloaded)
{
var ErrorM = core.returnMessage(MandSelected, true, MandatoryFields);
if (!string.IsNullOrEmpty(ErrorM))
{
MessageBox.Show(ErrorM);
return;
}
TLSPN_CottonTransactions cotTrans = new TLSPN_CottonTransactions();
frmCottonBales cb = new frmCottonBales(cotTrans);
cb.ShowDialog(this);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
bool success = true;
Button oBtn = sender as Button;
TLSPN_CottonReceivedBales bales;
TLADM_TranactionType trantypes = new TLADM_TranactionType();
if (oBtn != null)
{
var cnt = RowsSelected.Where(x => x == false).Count();
if (cnt == RowsSelected.Count())
{
MessageBox.Show("Please select at least one row from the grid as shown");
return;
}
var errorM = core.returnMessage(MandSelected, true, MandatoryFields);
if (!string.IsNullOrEmpty(errorM))
{
MessageBox.Show(errorM);
return;
}
var CottonContract = (TLADM_CottonContracts)cmbContractNo.SelectedItem;
var CottonTrans = (TLSPN_CottonTransactions)cmbLotNo.SelectedItem;
var Supplier = (TLADM_Cotton)cmbSupplierDetails.SelectedItem;
//Dont forget last number used
//----------------------------------------------
using (var context = new TTI2Entities())
{
//Hard Coded at the moment
// See Table TLADM_TranactionType for a complete List of the Transaction Type Per Department
//--------------------------------------------------------------------------------------------------
var DeptDetails = context.TLADM_Departments.Where(x => x.Dep_ShortCode == "SPIN").FirstOrDefault();
if (DeptDetails != null)
{
trantypes = context.TLADM_TranactionType.Where(x => x.TrxT_Number == 200 && x.TrxT_Department_FK == DeptDetails.Dep_Id).FirstOrDefault();
}
var Haulier = (TLADM_CottonHauliers)cmbTransporter.SelectedItem;
var TransDet = (TLSPN_CottonTransactions)cmbLotNo.SelectedItem;
int noBales = 0;
//-------------------------------------------------------------------------------------------
// Up date the records from DataGridView....If Not in Edit Mode
//--------------------------------------------------
if (!_EditMode)
{
var LastNumber = context.TLADM_LastNumberUsed.Find(1);
if (LastNumber != null)
{
LastNumber.col2 += 1;
}
foreach (DataGridViewRow row in dataGridView1.Rows)
{
if (row.Cells[1].Value == null || (bool)row.Cells[1].Value == false)
{
continue;
}
bales = context.TLSPN_CottonReceivedBales.Find((int)row.Cells[0].Value);
if (bales != null)
{
if ((bool)row.Cells[1].Value == true)
{
bales.CoBales_CottonReturned = true;
bales.CoBales_CottonSequence = Convert.ToInt32(txtReturnNoteNumber.Text);
noBales += 1;
try
{
context.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
success = false;
}
}
}
}
}
else
{
foreach (DataGridViewRow row in dataGridView1.Rows)
{
if ((bool)row.Cells[1].Value == false)
{
bales = context.TLSPN_CottonReceivedBales.Find((int)row.Cells[0].Value);
if (bales != null)
{
bales.CoBales_CottonReturned = false;
bales.CoBales_CottonSequence = 0;
try
{
context.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
success = false;
}
}
}
else
{
noBales += 1;
}
}
}
//----------------------------------------------------------------
// Now onto the main transaction
// Edit Mode plays a role!!!!!
//-------------------------------------------------------------------
TLSPN_CottonTransactions CTS = new TLSPN_CottonTransactions();
if (_EditMode)
{
var prev = (TLSPN_CottonTransactions)cmbPrevious.SelectedItem;
if (prev != null)
{
CTS = context.TLSPN_CottonTransactions.Find(prev.cotrx_pk);
}
}
//------------------------------------------------------------------
CTS.cotrx_ContractNo_Fk = CottonContract.CottonCon_Pk;
CTS.cotrx_Customer_FK = null;
CTS.cotrx_GrossAveBaleWeight = (Convert.ToDecimal(txtGrossWeightReturned.Text) / noBales);
CTS.cotrx_GrossWeight = Convert.ToDecimal(txtGrossWeightReturned.Text);
CTS.cotrx_LotNo = TransDet.cotrx_LotNo;
CTS.cotrx_NetWeight = Convert.ToDecimal(txtNettWeightReturned.Text);
CTS.cotrx_NoBales = noBales;
CTS.cotrx_Notes = string.Empty;
CTS.cotrx_Haulier_FK = Haulier.Haul_Pk;
CTS.cotrx_Return_No = Convert.ToInt32(txtReturnNoteNumber.Text);
CTS.cotrx_Supplier_FK = Supplier.Cotton_Pk;
CTS.cotrx_TransDate = dtpDateReturned.Value;
CTS.cotrx_TranType = trantypes.TrxT_Pk;
CTS.cotrx_VehReg = txtVehReg.Text;
CTS.cotrx_WeighBridgeEmpty = Convert.ToDecimal(txtWeighBridgeEmpty.Text);
CTS.cotrx_WeighBridgeFull = Convert.ToDecimal(txtWeighBridgeFull.Text);
CTS.cotrx_WriteOff = true;
CTS.cottrx_NettAveBaleWeight = Convert.ToDecimal(txtNettWeightReturned.Text) / noBales;
CTS.cotrx_NettPerWB = CTS.cotrx_WeighBridgeFull - CTS.cotrx_WeighBridgeEmpty;
//----------------------------------------------------------------------------------
if (!_EditMode)
{
context.TLSPN_CottonTransactions.Add(CTS);
}
try
{
context.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
success = false;
}
//----------------------------------------------------------------------
}
if (success)
{
MessageBox.Show("Records stored to database successfully");
var ReturnNo = Convert.ToInt32(txtReturnNoteNumber.Text);
frmViewReport vRep = new frmViewReport(3, ReturnNo);
int h = Screen.PrimaryScreen.WorkingArea.Height;
int w = Screen.PrimaryScreen.WorkingArea.Width;
vRep.ClientSize = new Size(w, h);
vRep.ShowDialog(this);
SetUp();
}
}
}
//-------------------------------------------------------------------------------------------------
public frmCottonBales(TLSPN_CottonTransactions cts)
{
InitializeComponent();
_CTrns = cts;
SetUp();
}
private void btnSave_Click(object sender, EventArgs e)
{
TLSPN_CottonReceivedBales bales;
Button oBtn = sender as Button;
if (oBtn != null & formloaded)
{
if (RowsSelected != null && rbWriteOff.Checked)
{
var cnt = RowsSelected.Where(x => x == false).Count();
if (cnt == RowsSelected.Count())
{
MessageBox.Show("Please select at least one row from the grid as shown");
return;
}
}
var errorM = core.returnMessage(MandSelected, true, MandatoryFields);
if (!string.IsNullOrEmpty(errorM))
{
MessageBox.Show(errorM);
return;
}
var LotDetails = (TLSPN_CottonTransactions)cmbLotNo.SelectedItem;
//dont forget last number used
//-------------------------------------------
using (var context = new TTI2Entities())
{
var LastNumber = context.TLADM_LastNumberUsed.Find(1);
if (LastNumber != null)
{
LastNumber.col3 += 1;
}
// 0
// 1 Selected
// 2 Bales Numeric
// 3 MIC Decimal
// 4 kgs (NETT) Decimal
// 5 Staple Decimal
// 6 kgs (GROSS) decimal
int NoBales = 0;
decimal NettMass = 0M;
decimal GrossMass = 0M;
var ContractDetails = (TLADM_CottonContracts)cmbContractNo.SelectedItem;
foreach (DataGridViewRow row in dataGridView1.Rows)
{
if (row.Cells[1].Value == null || (bool)row.Cells[1].Value == false)
{
continue;
}
NoBales += 1;
NettMass += (decimal)row.Cells[4].Value;
GrossMass += (decimal)row.Cells[6].Value;
if (rbWriteOn.Checked)
{
TLSPN_CottonReceivedBales Bales = new TLSPN_CottonReceivedBales();
Bales.CotBales_BaleNo = (int)row.Cells[2].Value;
Bales.CotBales_Mic = (decimal)row.Cells[3].Value;
Bales.CotBales_Staple = (decimal)row.Cells[5].Value;
Bales.CotBales_Weight_Nett = (decimal)row.Cells[4].Value;
Bales.CotBales_LotNo = LotDetails.cotrx_LotNo;
Bales.CotBales_Weight_Gross = (decimal)row.Cells[6].Value;
Bales.CoBales_CottonSequence = Convert.ToInt32(txtAdjustmentNumber.Text);
context.TLSPN_CottonReceivedBales.Add(Bales);
}
else
{
bales = context.TLSPN_CottonReceivedBales.Find((int)row.Cells[0].Value);
if (bales != null)
{
if ((bool)row.Cells[1].Value == true)
{
bales.CoBales_CottonReturned = true;
bales.CoBales_CottonSequence = Convert.ToInt32(txtAdjustmentNumber.Text);
try
{
context.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
}
//----------------------------------------------------------------------------
//
//------------------------------------------------------------------------------
TLSPN_CottonTransactions cotTrans = new TLSPN_CottonTransactions();
cotTrans.cotrx_TransDate = dateTimePicker1.Value;
cotTrans.cotrx_ContractNo_Fk = ContractDetails.CottonCon_Pk;
cotTrans.cotrx_LotNo = Convert.ToInt32(cmbLotNo.SelectedValue);
cotTrans.cotrx_NetWeight = NettMass;
cotTrans.cotrx_GrossWeight = GrossMass;
cotTrans.cotrx_NoBales = NoBales;
//cotTrans.cotrx_VehReg_FK = null;
cotTrans.cotrx_WeighBridgeFull = 0;
cotTrans.cotrx_WeighBridgeEmpty = 0;
cotTrans.cotrx_NettPerWB = 0;
cotTrans.cotrx_Return_No = Convert.ToInt32(txtAdjustmentNumber.Text);
cotTrans.cotrx_Supplier_FK = ContractDetails.CottonCon_ConSupplier_FK;
cotTrans.cotrx_Notes = rtbNotes.Text;
//-------------------------------------------------------------------------
// Consult Table TLADM_TranTypes
//----------------------------------------------------------------------------
var DepDetail = context.TLADM_Departments.Where(x => x.Dep_ShortCode == "SPIN").FirstOrDefault();
if (DepDetail != null)
{
var Trantype = context.TLADM_TranactionType.Where(x => x.TrxT_Number == 400 && x.TrxT_Department_FK == DepDetail.Dep_Id).FirstOrDefault();
if (Trantype != null)
{
cotTrans.cotrx_TranType = Trantype.TrxT_Pk;
}
}
if (rbWriteOff.Checked)
{
cotTrans.cotrx_WriteOff = true;
}
else
{
cotTrans.cotrx_WriteOff = false;
}
//------------------------------------------------------------------------
context.TLSPN_CottonTransactions.Add(cotTrans);
//-----------------------------------------------------------
//
//------------------------------------------------------------
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 = DepDetail.Dep_Id;
DailyLog.TLDL_Date = DateTime.Now;
DailyLog.TLDL_TransDetail = "Cotton Adjustment";
DailyLog.TLDL_AuthorisedBy = txtAdjustmentNumber.Text;
DailyLog.TLDL_Comments = txtAdjustmentNumber.Text;
context.TLADM_DailyLog.Add(DailyLog);
try
{
context.SaveChanges();
var Retno = Convert.ToInt32(txtAdjustmentNumber.Text);
frmViewReport vRep = new frmViewReport(4, Retno);
int h = Screen.PrimaryScreen.WorkingArea.Height;
int w = Screen.PrimaryScreen.WorkingArea.Width;
vRep.ClientSize = new Size(w, h);
vRep.ShowDialog(this);
SetUp();
MessageBox.Show("Data saved to database successfully");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
Button oBtn = sender as Button;
bool success = true;
if (oBtn != null)
{
var CottonRec = (TLSPN_CottonTransactions)cmbLotNo.SelectedItem;
using (var context = new TTI2Entities())
{
//Hard Coded at the moment
// See Table TLADM_TranactionType for a complete List of the Transaction Type Per Department
//--------------------------------------------------------------------------------------------------
var DeptDetail = context.TLADM_Departments.Where(x => x.Dep_ShortCode == "SPIN").FirstOrDefault();
var TranType = context.TLADM_TranactionType.Where(x => x.TrxT_Number == 500 && x.TrxT_Department_FK == DeptDetail.Dep_Id).FirstOrDefault();
var LastNumber = context.TLADM_LastNumberUsed.Find(1);
if (LastNumber != null)
{
LastNumber.col5 += 1;
}
var NoBales = 0;
var GrossWeight = 0M;
var NettWeight = 0M;
foreach (DataGridViewRow rw in dataGridView1.Rows)
{
if (rw.Cells[1].Value == null || (bool)rw.Cells[1].Value == false)
{
continue;
}
TLSPN_CottonReceivedBales bales = context.TLSPN_CottonReceivedBales.Find((int)rw.Cells[0].Value);
if (bales != null)
{
bales.CoBales_IssuedToProd = true;
bales.CoBales_BlowRoomPosition = 0;
bales.CoBales_CottonSequence = Convert.ToInt32(txtIssueToProdNo.Text);
NoBales += 1;
NettWeight += (decimal)rw.Cells[5].Value;
GrossWeight += (decimal)rw.Cells[7].Value;
try
{
context.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
success = false;
}
}
}
//------------------------------------------------------------------
TLSPN_CottonTransactions cotTrans = new TLSPN_CottonTransactions();
cotTrans.cotrx_TransDate = dtpTransDate.Value;
cotTrans.cotrx_Supplier_FK = CottonRec.cotrx_Supplier_FK;
cotTrans.cotrx_Return_No = Convert.ToInt32(txtIssueToProdNo.Text);
cotTrans.cotrx_ContractNo_Fk = CottonRec.cotrx_ContractNo_Fk;
cotTrans.cotrx_LotNo = CottonRec.cotrx_LotNo;
cotTrans.cotrx_NoBales = NoBales;
cotTrans.cotrx_GrossWeight = GrossWeight;
cotTrans.cotrx_NetWeight = NettWeight;
cotTrans.cotrx_WeighBridgeFull = 0M;
cotTrans.cotrx_WeighBridgeEmpty = 0M;
cotTrans.cotrx_NettPerWB = 0M;
cotTrans.cotrx_GrossAveBaleWeight = (GrossWeight / NoBales);
cotTrans.cottrx_NettAveBaleWeight = (NettWeight / NoBales);
cotTrans.cotrx_TranType = TranType.TrxT_Pk;
cotTrans.cotrx_WriteOff = true;
//---------------------------------------------
// Need to store this to the laydown file
//-----------------------------------------------------------
TLSPN_YarnOrderLayDown ld = new TLSPN_YarnOrderLayDown();
ld.YarnLD_BaleAvgWeight = cotTrans.cottrx_NettAveBaleWeight;
ld.YarnLD_Date = dtpTransDate.Value;
ld.YarnLD_LayDownNo = Convert.ToInt32(txtIssueToProdNo.Text);
ld.YarnLD_LotNo = CottonRec.cotrx_LotNo;
ld.YarnLD_NoOfBales = NoBales;
ld.YarnLD_WeightKg = NettWeight;
try
{
context.TLSPN_CottonTransactions.Add(cotTrans);
context.TLSPN_YarnOrderLayDown.Add(ld);
context.SaveChanges();
SetUp();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
success = false;
}
}
if (success)
{
MessageBox.Show("Records stored successfully to database");
}
}
}
void SetUp()
{
formloaded = false;
IndexPos = 0;
dataGridView1.Rows.Clear();
using (var context = new TTI2Entities())
{
IList <TLSPN_CottonTransactions> cotreceived = new List <TLSPN_CottonTransactions>();
var LastNumber = context.TLADM_LastNumberUsed.Find(1);
if (LastNumber != null)
{
txtIssueToProdNo.Text = LastNumber.col5.ToString();
}
var existing = context.AltSelectCottonRecords().ToList();
foreach (var row in existing)
{
TLSPN_CottonTransactions cr = new TLSPN_CottonTransactions();
cr.cotrx_ContractNo_Fk = row.cotrx_ContractNo_Fk;
cr.cotrx_Customer_FK = row.cotrx_Customer_FK;
cr.cotrx_GrossAveBaleWeight = row.cotrx_GrossAveBaleWeight;
cr.cotrx_GrossWeight = row.cotrx_GrossWeight;
cr.cotrx_LotNo = row.cotrx_LotNo;
cr.cotrx_NettPerWB = row.cotrx_NettPerWB;
cr.cotrx_NetWeight = row.cotrx_NetWeight;
cr.cotrx_NoBales = row.cotrx_NoBales;
cr.cotrx_Notes = row.cotrx_Notes;
cr.cotrx_pk = row.cotrx_pk;
cr.cotrx_Return_No = row.cotrx_Return_No;
cr.cotrx_Supplier_FK = row.cotrx_Supplier_FK;
cr.cotrx_TransDate = row.cotrx_TransDate;
cr.cotrx_TranType = row.cotrx_TranType;
//cr.cotrx_VehReg_FK = row.cotrx_VehReg_FK;
cr.cotrx_WeighBridgeEmpty = row.cotrx_WeighBridgeEmpty;
cr.cotrx_WeighBridgeFull = row.cotrx_WeighBridgeFull;
cr.cotrx_WriteOff = row.cotrx_WriteOff;
cr.cottrx_NettAveBaleWeight = row.cottrx_NettAveBaleWeight;
cotreceived.Add(cr);
}
cmbLotNo.DataSource = cotreceived.OrderBy(x => x.cotrx_LotNo).ToList();
cmbLotNo.ValueMember = "cotrx_LotNo";
cmbLotNo.DisplayMember = "cotrx_LotNo";
cmbLotNo.SelectedValue = -1;
}
oChk = new DataGridViewCheckBoxColumn(); //1
oChk.HeaderText = "Select";
oChk.ValueType = typeof(Boolean);
oTxtBoxA = new DataGridViewTextBoxColumn();
oTxtBoxA.Visible = false;
oTxtBoxB = new DataGridViewTextBoxColumn(); //2
oTxtBoxB.HeaderText = "Lay down position";
oTxtBoxB.ValueType = typeof(int);
oTxtBoxB.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
oTxtBoxB.Width = 50;
oTxtBoxC = new DataGridViewTextBoxColumn(); //3
oTxtBoxC.HeaderText = "Bale No";
oTxtBoxC.ValueType = typeof(int);
oTxtBoxC.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
oTxtBoxC.ReadOnly = true;
oTxtBoxD = new DataGridViewTextBoxColumn(); //4
oTxtBoxD.HeaderText = "Mic";
oTxtBoxD.ValueType = typeof(Decimal);
oTxtBoxD.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
oTxtBoxD.ReadOnly = true;
oTxtBoxE = new DataGridViewTextBoxColumn(); //5
oTxtBoxE.HeaderText = "Kgs (NETT)";
oTxtBoxE.ValueType = typeof(Decimal);
oTxtBoxE.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
oTxtBoxE.ReadOnly = true;
oTxtBoxF = new DataGridViewTextBoxColumn(); //6
oTxtBoxF.HeaderText = "Staple";
oTxtBoxF.ValueType = typeof(Decimal);
oTxtBoxF.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
oTxtBoxF.ReadOnly = true;
oTxtBoxG = new DataGridViewTextBoxColumn(); //7
oTxtBoxG.HeaderText = "Kgs (GROSS)";
oTxtBoxG.ValueType = typeof(Decimal);
oTxtBoxG.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
oTxtBoxG.ReadOnly = true;
oTxtBoxH = new DataGridViewTextBoxColumn(); //7
oTxtBoxH.HeaderText = "Lot No";
oTxtBoxH.ValueType = typeof(string);
oTxtBoxH.ReadOnly = true;
dataGridView1.EditingControlShowing += new DataGridViewEditingControlShowingEventHandler(dataGridView1_EditingControlShowing);
dataGridView1.Columns.Add(oTxtBoxA); // 0 Index Pk value
dataGridView1.Columns.Add(oChk); // 1 Selected
dataGridView1.Columns.Add(oTxtBoxB); // 2 Lay Down Position
dataGridView1.Columns.Add(oTxtBoxC); // 3 Bales Numeric
dataGridView1.Columns.Add(oTxtBoxD); // 4 MIC Decimal
dataGridView1.Columns.Add(oTxtBoxE); // 5 kgs (NETT) Decimal
dataGridView1.Columns.Add(oTxtBoxF); // 6 Staple Decimal
dataGridView1.Columns.Add(oTxtBoxG); // 7 Kgs S(GROSS) Decimal
dataGridView1.Columns.Add(oTxtBoxH); // 8 Lot No
formloaded = true;
}
private void cmbPrevious_SelectedIndexChanged(object sender, EventArgs e)
{
ComboBox oCmbo = sender as ComboBox;
if (oCmbo != null)
{
var CTS = (TLSPN_CottonTransactions)oCmbo.SelectedItem;
if (CTS != null)
{
txtDeliveryNo.Text = CTS.cotrx_Return_No.ToString();
txtCustOrderNo.Text = CTS.cotrx_Notes;
cmbCustomerName.SelectedValue = CTS.cotrx_Customer_FK;
cmbContractNo.SelectedValue = CTS.cotrx_ContractNo_Fk;
dtpDateDelivered.Value = CTS.cotrx_TransDate;
using (var context = new TTI2Entities())
{
var cust = context.TLADM_CustomerFile.Where(x => x.Cust_Pk == CTS.cotrx_Customer_FK).FirstOrDefault();
if (cust != null)
{
rtbCustomerAddress.Text = cust.Cust_Address1;
}
IList <TLSPN_CottonTransactions> cotreceived = new List <TLSPN_CottonTransactions>();
var existing = context.SelectCottonRecords1(CTS.cotrx_ContractNo_Fk, CTS.cotrx_Supplier_FK).ToList();
if (existing != null)
{
foreach (var row in existing)
{
TLSPN_CottonTransactions cr = new TLSPN_CottonTransactions();
cr.cotrx_ContractNo_Fk = row.cotrx_ContractNo_Fk;
cr.cotrx_Customer_FK = row.cotrx_Customer_FK;
cr.cotrx_GrossAveBaleWeight = row.cotrx_GrossAveBaleWeight;
cr.cotrx_GrossWeight = row.cotrx_GrossWeight;
cr.cotrx_LotNo = row.cotrx_LotNo;
cr.cotrx_NettPerWB = row.cotrx_NettPerWB;
cr.cotrx_NetWeight = row.cotrx_NetWeight;
cr.cotrx_NoBales = row.cotrx_NoBales;
cr.cotrx_Notes = row.cotrx_Notes;
cr.cotrx_pk = row.cotrx_pk;
cr.cotrx_Return_No = row.cotrx_Return_No;
cr.cotrx_Supplier_FK = row.cotrx_Supplier_FK;
cr.cotrx_TransDate = row.cotrx_TransDate;
cr.cotrx_TranType = row.cotrx_TranType;
cr.cotrx_VehReg = row.cotrx_VehReg;
cr.cotrx_WeighBridgeEmpty = row.cotrx_WeighBridgeEmpty;
cr.cotrx_WeighBridgeFull = row.cotrx_WeighBridgeFull;
cr.cotrx_WriteOff = row.cotrx_WriteOff;
cr.cottrx_NettAveBaleWeight = row.cottrx_NettAveBaleWeight;
cotreceived.Add(cr);
}
cmbLotNo.DataSource = cotreceived;
cmbLotNo.DisplayMember = "Cotrx_LotNo";
cmbLotNo.ValueMember = "Cotrx_LotNo";
}
cmbLotNo.SelectedValue = CTS.cotrx_LotNo;
}
comboTransporter.SelectedValue = CTS.cotrx_Haulier_FK;
txtVehReg.Text = CTS.cotrx_VehReg;
txtWeighBridgeFull.Text = Math.Round(CTS.cotrx_WeighBridgeFull, 1).ToString();
txtWeighBridgeEmpty.Text = Math.Round(CTS.cotrx_WeighBridgeEmpty, 1).ToString();
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
Button oBtn = sender as Button;
if (oBtn != null && formloaded)
{
var errorM = core.returnMessage(MandSelected, true, MandatoryFields);
if (!string.IsNullOrEmpty(errorM))
{
MessageBox.Show(errorM);
return;
}
var cnt = RowsSelected.Where(x => x == false).Count();
if (cnt == RowsSelected.Count())
{
MessageBox.Show("Please select at least one row from the grid as shown");
return;
}
var CottonRec = (TLSPN_CottonTransactions)cmbLotNo.SelectedItem;
var ContractDetails = (TLADM_CottonContracts)cmbContractNo.SelectedItem;
var CustomerDetails = (TLADM_CustomerFile)cmbCustomerName.SelectedItem;
//Dont forget last number used
//----------------------------------------------
using (var context = new TTI2Entities())
{
//Hard Coded at the moment
// See Table TLADM_TranactionType for a complete List of the Transaction Type Per Department
//--------------------------------------------------------------------------------------------------
var SequenceNo = Convert.ToInt32(txtDeliveryNo.Text);
var LastNumber = context.TLADM_LastNumberUsed.Find(1);
if (LastNumber != null)
{
LastNumber.col4 += 1;
}
// 0
// 1 Selected
// 2 Bales Numeric
// 3 MIC Decimal
// 4 kgs Decimal
// 5 Staple Decimal
int NoBales = 0;
decimal Mass = 0.00M;
decimal Gross = 0.00M;
foreach (DataGridViewRow row in dataGridView1.Rows)
{
if (row.Cells[1].Value == null || (bool)row.Cells[1].Value == false)
{
continue;
}
TLSPN_CottonReceivedBales bales = context.TLSPN_CottonReceivedBales.Find((int)row.Cells[0].Value);
if (bales != null)
{
bales.CoBales_CottonSold = true;
bales.CoBales_CottonSequence = SequenceNo;
NoBales += 1;
Mass += (decimal)row.Cells[4].Value;
Gross += (decimal)row.Cells[6].Value;
try
{
context.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
TLSPN_CottonTransactions cotTrans = new TLSPN_CottonTransactions();
var haul = (TLADM_CottonHauliers)comboTransporter.SelectedItem;
cotTrans.cotrx_TransDate = dtpDateDelivered.Value;
cotTrans.cotrx_ContractNo_Fk = ContractDetails.CottonCon_Pk;
cotTrans.cotrx_LotNo = Convert.ToInt32(cmbLotNo.SelectedValue);
cotTrans.cotrx_NetWeight = Mass;
cotTrans.cotrx_GrossWeight = Mass;
cotTrans.cotrx_NoBales = NoBales;
cotTrans.cotrx_Haulier_FK = haul.Haul_Pk;
cotTrans.cotrx_VehReg = txtVehReg.Text;
cotTrans.cotrx_WeighBridgeFull = Convert.ToDecimal(txtWeighBridgeFull.Text);
cotTrans.cotrx_WeighBridgeEmpty = Convert.ToDecimal(txtWeighBridgeEmpty.Text);
cotTrans.cotrx_NettPerWB = cotTrans.cotrx_WeighBridgeFull - cotTrans.cotrx_WeighBridgeEmpty;
cotTrans.cottrx_NettAveBaleWeight = Mass / NoBales;
cotTrans.cotrx_GrossAveBaleWeight = Gross / NoBales;
cotTrans.cotrx_Return_No = SequenceNo;
cotTrans.cotrx_Customer_FK = CustomerDetails.Cust_Pk;
cotTrans.cotrx_Supplier_FK = ContractDetails.CottonCon_ConSupplier_FK;
cotTrans.cotrx_Notes = txtCustOrderNo.Text;
cotTrans.cotrx_WriteOff = true;
//-------------------------------------------------------------------------
// Consult Table TLADM_TranTypes
//----------------------------------------------------------------------------
var DeptDetails = context.TLADM_Departments.Where(x => x.Dep_ShortCode == "SPIN").FirstOrDefault();
var Trantype = context.TLADM_TranactionType.Where(x => x.TrxT_Number == 300 && x.TrxT_Department_FK == DeptDetails.Dep_Id).FirstOrDefault();
if (Trantype != null)
{
cotTrans.cotrx_TranType = Trantype.TrxT_Pk;
}
try
{
if (!_EditMode)
{
context.TLSPN_CottonTransactions.Add(cotTrans);
}
context.SaveChanges();
Setup();
frmViewReport vRep = new frmViewReport(5, SequenceNo);
int h = Screen.PrimaryScreen.WorkingArea.Height;
int w = Screen.PrimaryScreen.WorkingArea.Width;
vRep.ClientSize = new Size(w, h);
vRep.ShowDialog(this);
MessageBox.Show("Data saved to database successfully");
btnPickList.Enabled = false;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
btnSave.Enabled = false;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
bool success = true;
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())
{
TLSPN_CottonReceived cotrec = new TLSPN_CottonReceived();
var Contract = (TLADM_CottonContracts)cmbCottonContracts.SelectedItem;
var Supplier = (TLADM_Cotton)cmbCottonSuppliers.SelectedItem;
var Haulier = (TLADM_CottonHauliers)cmbHaulier.SelectedItem;
var NoOfBales = Convert.ToInt32(txtNoOfBales.Text);
//---------------------------------------------------------------------------------------------------
//Unfortunately hard coded at the moment
//--------------------------------------------------------------------------------------------------
var DeptDetail = context.TLADM_Departments.Where(x => x.Dep_ShortCode == "SPIN").FirstOrDefault();
var TranType = context.TLADM_TranactionType.Where(x => x.TrxT_Number == 100 && x.TrxT_Department_FK == DeptDetail.Dep_Id).FirstOrDefault();
if (TranType != null)
{
cotrec.CotReC_TranType_FK = TranType.TrxT_Pk;
var CountTrx = context.TLSPN_CottonTransactions.Count();
if (CountTrx == 0)
{
//--------------------------------------------
//this means that this transaction is being run for the first time ie add a record of zeros to the Opening Balance table
// This table will cater for future yearend
//--------------------------------------------------------------------------------
TLSPN_OpenBalance openBal = new TLSPN_OpenBalance();
openBal.OpenBal_Store_FK = (int)TranType.TrxT_FromWhse_FK;
openBal.OpenBal_GrossBaleWeight = 0M;
openBal.OpenBal_NettBaleWeight = 0M;
openBal.OpenBal_NoOfBales = 0;
context.TLSPN_OpenBalance.Add(openBal);
}
}
//----------------------------------------------------------------
// Now onto the main transaction
//-------------------------------------------------------------------
TLSPN_CottonTransactions CTS = new TLSPN_CottonTransactions();
CTS.cotrx_ContractNo_Fk = Contract.CottonCon_Pk;
CTS.cotrx_Customer_FK = null;
CTS.cotrx_GrossWeight = Convert.ToDecimal(txtSuppplierGrossWeight.Text);
CTS.cotrx_LotNo = Convert.ToInt32(txtLotNo.Text);
CTS.cotrx_NettPerWB = Convert.ToDecimal(txtCottonNettWeight.Text);
CTS.cotrx_NetWeight = Convert.ToDecimal(txtSupplierNettWeight.Text);
CTS.cotrx_NoBales = NoOfBales;
CTS.cotrx_Notes = string.Empty;
CTS.cotrx_Return_No = Convert.ToInt32(txtGrnNumber.Text);
CTS.cotrx_Supplier_FK = Supplier.Cotton_Pk;
CTS.cotrx_TransDate = dtpDateReceived.Value;
CTS.cotrx_TranType = TranType.TrxT_Pk;
CTS.cotrx_VehReg = txtVehReg.Text;
CTS.cotrx_Haulier_FK = Haulier.Haul_Pk;
CTS.cotrx_WeighBridgeEmpty = Convert.ToDecimal(txtWeighBridgeNett.Text);
CTS.cotrx_WeighBridgeFull = Convert.ToDecimal(txtWeighBridgeGross.Text);
CTS.cotrx_WriteOff = false;
CTS.cottrx_NettAveBaleWeight = Convert.ToDecimal(txtNetAvgBaleWeight.Text);
CTS.cotrx_GrossAveBaleWeight = Convert.ToDecimal(txtGrossAvgBaleWeight.Text);
context.TLSPN_CottonTransactions.Add(CTS);
//--------------------------------------------------------------------------------
var lastNumber = context.TLADM_LastNumberUsed.Find(1);
if (lastNumber != null)
{
lastNumber.col1 += 1;
lastNumber.col12 += 1;
}
try
{
context.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
if (microAvailNo.Checked)
{
decimal micraFrom = 0.00M;
decimal micraTo = 0.00M;
decimal micraAvg = 0.00M;
decimal staplefrom = 0.00M;
decimal stapleto = 0.00M;
decimal stapleAvg = 0.00M;
var CottonContract = (TLADM_CottonContracts)cmbCottonContracts.SelectedItem;
if (CottonContract != null)
{
micraFrom = CottonContract.CottonCon_MicraFrom;
micraTo = CottonContract.CottonCon_MicraTo;
staplefrom = CottonContract.CottonCon_StapleFrom;
stapleto = CottonContract.CottonCon_StapleTo;
if (micraFrom > 0 && micraTo > 0)
{
micraAvg = (micraFrom + micraTo) / 2;
}
else
{
micraAvg = 1;
}
if (staplefrom != 0 && stapleto != 0)
{
stapleAvg = (staplefrom + stapleto) / 2;
}
else
{
stapleAvg = 1;
}
}
var n = 0;
while (++n <= CTS.cotrx_NoBales)
{
TLSPN_CottonReceivedBales recBales = new TLSPN_CottonReceivedBales();
recBales.CotBales_BaleNo = n;
recBales.CotBales_CotReceived_FK = cotrec.CotRec_Pk;
recBales.CotBales_LotNo = Convert.ToInt32(txtLotNo.Text);
recBales.CotBales_Mic = micraAvg;
recBales.CotBales_Staple = stapleAvg;
recBales.CotBales_Weight_Gross = Convert.ToDecimal(txtGrossAvgBaleWeight.Text);
recBales.CotBales_Weight_Nett = Convert.ToDecimal(txtNetAvgBaleWeight.Text);
recBales.CoBales_CottonSequence = Convert.ToInt32(txtGrnNumber.Text);
context.TLSPN_CottonReceivedBales.Add(recBales);
try
{
context.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
if (success)
{
MessageBox.Show("Data stored to the database successfully");
int returnno = Convert.ToInt32(txtGrnNumber.Text);
frmViewReport vRep = new frmViewReport(2, returnno);
int h = Screen.PrimaryScreen.WorkingArea.Height;
int w = Screen.PrimaryScreen.WorkingArea.Width;
vRep.ClientSize = new Size(w, h);
vRep.ShowDialog(this);
MandSelected = core.PopulateArray(MandatoryFields.Length, false);
Setup();
}
}
}
void SetUp()
{
using (var context = new TTI2Entities())
{
IList <TLSPN_CottonTransactions> cotreceived = new List <TLSPN_CottonTransactions>();
var existing = context.AltSelectCottonRecords().ToList();
foreach (var row in existing)
{
TLSPN_CottonTransactions cr = new TLSPN_CottonTransactions();
cr.cotrx_ContractNo_Fk = row.cotrx_ContractNo_Fk;
cr.cotrx_Customer_FK = row.cotrx_Customer_FK;
cr.cotrx_GrossAveBaleWeight = row.cotrx_GrossAveBaleWeight;
cr.cotrx_GrossWeight = row.cotrx_GrossWeight;
cr.cotrx_LotNo = row.cotrx_LotNo;
cr.cotrx_NettPerWB = row.cotrx_NettPerWB;
cr.cotrx_NetWeight = row.cotrx_NetWeight;
cr.cotrx_NoBales = row.cotrx_NoBales;
cr.cotrx_Notes = row.cotrx_Notes;
cr.cotrx_pk = row.cotrx_pk;
cr.cotrx_Return_No = row.cotrx_Return_No;
cr.cotrx_Supplier_FK = row.cotrx_Supplier_FK;
cr.cotrx_TransDate = row.cotrx_TransDate;
cr.cotrx_TranType = row.cotrx_TranType;
//cr.cotrx_VehReg_FK = row.cotrx_VehReg_FK;
cr.cotrx_WeighBridgeEmpty = row.cotrx_WeighBridgeEmpty;
cr.cotrx_WeighBridgeFull = row.cotrx_WeighBridgeFull;
cr.cotrx_WriteOff = row.cotrx_WriteOff;
cr.cottrx_NettAveBaleWeight = row.cottrx_NettAveBaleWeight;
cotreceived.Add(cr);
}
cmbLotNo.DataSource = cotreceived.OrderBy(x => x.cotrx_LotNo).ToList();
cmbLotNo.ValueMember = "cotrx_LotNo";
cmbLotNo.DisplayMember = "cotrx_LotNo";
cmbLotNo.SelectedValue = 0;
oChk = new DataGridViewCheckBoxColumn(); //1
oChk.HeaderText = "Confirmed";
oChk.ValueType = typeof(Boolean);
oTxtBoxA = new DataGridViewTextBoxColumn();
oTxtBoxA.Visible = false;
oTxtBoxC = new DataGridViewTextBoxColumn(); //3
oTxtBoxC.HeaderText = "Bale No";
oTxtBoxC.ValueType = typeof(int);
oTxtBoxC.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
oTxtBoxC.ReadOnly = true;
oTxtBoxD = new DataGridViewTextBoxColumn(); //4
oTxtBoxD.HeaderText = "Mic";
oTxtBoxD.ValueType = typeof(Decimal);
oTxtBoxD.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
oTxtBoxD.ReadOnly = true;
oTxtBoxE = new DataGridViewTextBoxColumn(); //5
oTxtBoxE.HeaderText = "Kgs (NETT)";
oTxtBoxE.ValueType = typeof(Decimal);
oTxtBoxE.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
oTxtBoxE.ReadOnly = true;
oTxtBoxF = new DataGridViewTextBoxColumn(); //6
oTxtBoxF.HeaderText = "Staple";
oTxtBoxF.ValueType = typeof(Decimal);
oTxtBoxF.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
oTxtBoxF.ReadOnly = true;
oTxtBoxG = new DataGridViewTextBoxColumn(); //6
oTxtBoxG.HeaderText = "Kgs (GROSS)";
oTxtBoxG.ValueType = typeof(Decimal);
oTxtBoxG.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
oTxtBoxG.ReadOnly = true;
oTxtBoxG.Visible = false;
dataGridView1.EditingControlShowing += new DataGridViewEditingControlShowingEventHandler(dataGridView1_EditingControlShowing);
dataGridView1.Columns.Add(oTxtBoxA); // 0 Index Pk value
dataGridView1.Columns.Add(oChk); // 1 Selected
dataGridView1.Columns.Add(oTxtBoxC); // 2 Bales Numeric
dataGridView1.Columns.Add(oTxtBoxD); // 3 MIC Decimal
dataGridView1.Columns.Add(oTxtBoxE); // 4 kgs (NETT) Decimal
dataGridView1.Columns.Add(oTxtBoxF); // 5 Staple Decimal
dataGridView1.Columns.Add(oTxtBoxG); // 6 Kgs Gross
formloaded = true;
groupBox1.Enabled = false;
}
}
