private void cmboCurrentPI_SelectedIndexChanged(object sender, EventArgs e)
{
ComboBox oCmbo = sender as ComboBox;
TLCMT_PanelIssueDetail result = null;
if (oCmbo != null && formloaded)
{
using (var context = new TTI2Entities())
{
dataGridView1.Rows.Clear();
var selected = (TLCMT_PanelIssue)cmboCurrentPI.SelectedItem;
if (selected != null)
{
cmboCMTDepartment.SelectedValue = selected.CMTPI_Department_FK;
label1.Text = selected.CMTPI_Number.ToString();
var Current = context.TLCMT_PanelIssueDetail.Where(x => x.CMTPID_PI_FK == selected.CMTPI_Pk).ToList();
var Existing = context.TLCUT_CutSheetReceipt.ToList();
foreach (var CutSheetR in Existing)
{
result = (from u in Current
where u.CMTPID_CutSheet_FK == CutSheetR.TLCUTSHR_Pk
select u).FirstOrDefault();
if (CutSheetR.TLCUTSHR_Issued && result == null)
{
continue;
}
var index = dataGridView1.Rows.Add();
if (result == null)
{
dataGridView1.Rows[index].Cells[0].Value = 0;
}
else
{
dataGridView1.Rows[index].Cells[0].Value = result.CMTPID_Pk;
}
dataGridView1.Rows[index].Cells[1].Value = CutSheetR.TLCUTSHR_Pk;
if (CutSheetR.TLCUTSHR_Issued)
{
dataGridView1.Rows[index].Cells[2].Value = true;
}
else
{
dataGridView1.Rows[index].Cells[2].Value = false;
}
//-------------------------------------------------------
//find the Original CutSheet
//--------------------------------------------------
var CS = context.TLCUT_CutSheet.Find(CutSheetR.TLCUTSHR_CutSheet_FK);
if (CS != null)
{
dataGridView1.Rows[index].Cells[3].Value = "CS" + CS.TLCutSH_No.Remove(0, 2).ToString();
}
dataGridView1.Rows[index].Cells[4].Value = CutSheetR.TLCUTSHR_Date.ToShortDateString();
var xColour = context.TLADM_Colours.Find(CutSheetR.TLCUTSHR_Colour_FK);
if (xColour != null)
{
dataGridView1.Rows[index].Cells[5].Value = xColour.Col_Display;
}
if (CutSheetR.TLCUTSHR_Issued)
{
var Grp = context.TLCUT_CutSheetReceiptDetail.Where(x => x.TLCUTSHRD_CutSheet_FK == CutSheetR.TLCUTSHR_Pk);
if (Grp.Count() != 0)
{
// dataGridView1.Rows[index].Cells[10].Value = Grp.Sum(x => x.TLCUTSHRD_BoxUnits);
txtPanels.Text = (Convert.ToInt32(txtPanels.Text) + Grp.Sum(x => x.TLCUTSHRD_BoxUnits)).ToString();
}
var Boxes = context.TLCUT_CutSheetReceiptBoxes.Where(x => x.TLCUTSHB_CutSheet_FK == CutSheetR.TLCUTSHR_Pk).FirstOrDefault();
if (Boxes != null)
{
int TotalBoxes = Convert.ToInt32(txtTotalBoxes.Text);
txtAdultsBoxes.Text = (Convert.ToInt32(txtAdultsBoxes.Text) + Boxes.TLCUTSHB_AdultBoxes).ToString();
TotalBoxes += Boxes.TLCUTSHB_AdultBoxes;
txtKidsBoxes.Text = (Convert.ToInt32(txtKidsBoxes.Text) + Boxes.TLCUTSHB_KidBoxes).ToString();
TotalBoxes += Boxes.TLCUTSHB_KidBoxes;
txtTotalBoxes.Text = TotalBoxes.ToString();
}
}
}
}
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
Button oBtn = sender as Button;
TLADM_LastNumberUsed LNU = null;
TLCMT_PanelIssue pi = new TLCMT_PanelIssue();
TLCMT_PanelIssueDetail pid = new TLCMT_PanelIssueDetail();
TLCUT_CutSheetReceipt CSR = new TLCUT_CutSheetReceipt();
bool Add = false;
if (oBtn != null && formloaded)
{
var selected = (TLADM_Departments)cmboCMTDepartment.SelectedItem;
if (selected == null)
{
MessageBox.Show("Please select a CMT from the drop downlist");
return;
}
if (((TLADM_WhseStore)cmboDepartments.SelectedItem) == null)
{
MessageBox.Show("Please select Store from which to make an selection");
return;
}
using (var context = new TTI2Entities())
{
int Number = Convert.ToInt32(label1.Text);
pi = context.TLCMT_PanelIssue.Where(x => x.CMTPI_Number == Number).FirstOrDefault();
if (pi == null)
{
pi = new TLCMT_PanelIssue();
Add = true;
}
pi.CMTPI_Number = Number;
pi.CMTPI_Date = dtpTransDate.Value;
pi.CMTPI_Department_FK = selected.Dep_Id;
pi.CMTPI_Closed = false;
pi.CMTPI_DeliveryNumber = 0;
pi.CMTPI_CutSheetSummary = false;
pi.CMTPI_FromWhse_FK = ((TLADM_WhseStore)cmboDepartments.SelectedItem).WhStore_Id;
var TransType = context.TLADM_TranactionType.Where(x => x.TrxT_Number == 100 && x.TrxT_Department_FK == selected.Dep_Id).FirstOrDefault();
if (TransType != null)
{
pi.CMTPI_TranType_FK = TransType.TrxT_Pk;
}
pi.CMTPI_Display = "DN -" + "0".PadLeft(4, ' ') + " - TL " + Number.ToString().PadLeft(5, '0');
if (Add)
{
context.TLCMT_PanelIssue.Add(pi);
}
if (Add && selected != null)
{
LNU = context.TLADM_LastNumberUsed.Where(x => x.LUN_Department_FK == selected.Dep_Id).FirstOrDefault();
if (LNU != null)
{
LNU.col1 += 1;
}
}
try
{
context.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
foreach (DataGridViewRow row in dataGridView1.Rows)
{
//---------------------------------------------------------------
if ((bool)row.Cells[2].Value == false)
{
continue;
}
Add = true;
pid = new TLCMT_PanelIssueDetail();
if ((int)row.Cells[0].Value != 0)
{
var index = (int)row.Cells[0].Value;
pid = context.TLCMT_PanelIssueDetail.Find(index);
if (pid == null)
{
pid = new TLCMT_PanelIssueDetail();
}
else
{
Add = false;
}
}
//--------------------------------------------------------
pid.CMTPID_CutSheet_FK = (int)row.Cells[1].Value;
pid.CMTPID_PI_FK = pi.CMTPI_Pk;
pid.CMTPID_Receipted = false;
pid.CMTPID_BIFabric = false;
CSR = context.TLCUT_CutSheetReceipt.Find(pid.CMTPID_CutSheet_FK);
if (CSR != null)
{
CSR.TLCUTSHR_Issued = true;
}
if (Add)
{
context.TLCMT_PanelIssueDetail.Add(pid);
}
}
try
{
var SelectedRows = (
from Rows in dataGridView1.Rows.Cast <DataGridViewRow>()
where (bool)Rows.Cells[2].Value == true
select Rows).ToList();
foreach (var SelectedRow in SelectedRows)
{
var index = SelectedRow.Index;
dataGridView1.Rows.RemoveAt(index);
}
context.SaveChanges();
MessageBox.Show("Data saved successfully to to database");
//This report has been housed in the the Cutting Form View Program....
Cutting.frmCutViewRep vRep = new Cutting.frmCutViewRep(12, pi.CMTPI_Pk);
int h = Screen.PrimaryScreen.WorkingArea.Height;
int w = Screen.PrimaryScreen.WorkingArea.Width;
vRep.ClientSize = new Size(w, h);
vRep.ShowDialog();
}
catch (System.Data.Entity.Validation.DbEntityValidationException en)
{
foreach (var eve in en.EntityValidationErrors)
{
MessageBox.Show("following validation errors: Type" + eve.Entry.Entity.GetType().Name.ToString() + "State " + eve.Entry.State.ToString());
foreach (var ve in eve.ValidationErrors)
{
MessageBox.Show("- Property" + ve.PropertyName + " Message " + ve.ErrorMessage);
}
}
}
catch (Exception ex)
{
var exceptionMessages = new StringBuilder();
do
{
exceptionMessages.Append(ex.Message);
ex = ex.InnerException;
}while (ex != null);
MessageBox.Show(exceptionMessages.ToString());
}
}
}
}
