Example #1
0
        private void button1_Click(object sender, EventArgs e)
        {
            Button oBtn = sender as Button;

            if (oBtn != null && FormLoaded)
            {
                if (comboReportOptions.SelectedValue != null)
                {
                    parms.RepSortOption = Int32.Parse(comboReportOptions.SelectedValue.ToString());
                }
                else
                {
                    parms.RepSortOption = 1;
                }

                frmCutViewRep vRep = new frmCutViewRep(10, parms);
                int           h    = Screen.PrimaryScreen.WorkingArea.Height;
                int           w    = Screen.PrimaryScreen.WorkingArea.Width;
                vRep.ClientSize = new Size(w, h);
                vRep.ShowDialog(this);

                comboCutSheets.Items.Clear();
                comboGreige.Items.Clear();
                comboMachines.Items.Clear();
                comboOperator.Items.Clear();

                FrmBierriebiSel_Load(this, null);
            }
        }
Example #2
0
        private void btnSubmit_Click(object sender, EventArgs e)
        {
            Button oBtn = sender as Button;

            if (oBtn != null && formloaded)
            {
                CutReportOptions cutOpts = new CutReportOptions();
                cutOpts.C3SortOption = sortOptions;
                cutOpts.RepNo        = _RepNo;

                if (_RepNo == 1)
                {
                    frmCutViewRep vRep = new frmCutViewRep(7, cutOpts);
                    int           h    = Screen.PrimaryScreen.WorkingArea.Height;
                    int           w    = Screen.PrimaryScreen.WorkingArea.Width;
                    vRep.ClientSize = new Size(w, h);
                    vRep.ShowDialog();
                }
                else
                {
                    cutOpts.fromDate = Convert.ToDateTime(dtpFromDate.Value.ToShortDateString());
                    cutOpts.toDate   = Convert.ToDateTime(dtpToDate.Value.ToShortDateString());
                    cutOpts.toDate   = cutOpts.toDate.AddHours(23);
                    frmCutViewRep vRep = new frmCutViewRep(8, cutOpts);
                    int           h    = Screen.PrimaryScreen.WorkingArea.Height;
                    int           w    = Screen.PrimaryScreen.WorkingArea.Width;
                    vRep.ClientSize = new Size(w, h);
                    vRep.ShowDialog();
                }
                sortOptions = 1;
            }
        }
Example #3
0
        private void btnSubmit_Click(object sender, EventArgs e)
        {
            Button oBtn = sender as Button;

            if (oBtn != null)
            {
                var selected = (TLCUT_CutSheet)cmboReprint.SelectedItem;
                if (selected != null)
                {
                    frmCutViewRep vRep = new frmCutViewRep(1, selected.TLCutSH_Pk);
                    int           h    = Screen.PrimaryScreen.WorkingArea.Height;
                    int           w    = Screen.PrimaryScreen.WorkingArea.Width;
                    vRep.ClientSize = new Size(w, h);
                    vRep.ShowDialog(this);

                    vRep            = new frmCutViewRep(2, selected.TLCutSH_Pk);
                    h               = Screen.PrimaryScreen.WorkingArea.Height;
                    w               = Screen.PrimaryScreen.WorkingArea.Width;
                    vRep.ClientSize = new Size(w, h);
                    vRep.ShowDialog(this);
                }
                else
                {
                    MessageBox.Show("Please select a Cut sheet from the drop down box");
                }
            }
        }
Example #4
0
        private void btnSubmit_Click(object sender, EventArgs e)
        {
            Button oBtn = sender as Button;

            if (oBtn != null && formloaded)
            {
                using (var context = new TTI2Entities())
                {
                    CutReportOptions repOptions = new CutReportOptions();
                    if (chkQAReport.Checked)
                    {
                        repOptions.QAReport = true;
                    }

                    repOptions.fromDate     = Convert.ToDateTime(dtpFromDate.Value.ToShortDateString());
                    repOptions.toDate       = Convert.ToDateTime(dtpToDate.Value.ToShortDateString());
                    repOptions.toDate       = repOptions.toDate.AddHours(23);
                    repOptions.C4SortOption = RepSortOption;

                    frmCutViewRep vRep = new frmCutViewRep(5, repOptions);
                    int           h    = Screen.PrimaryScreen.WorkingArea.Height;
                    int           w    = Screen.PrimaryScreen.WorkingArea.Width;
                    vRep.ClientSize = new Size(w, h);
                    vRep.ShowDialog(this);
                    repOptions = new CutReportOptions();
                }
            }
        }
Example #5
0
        private void btnSubmit_Click(object sender, EventArgs e)
        {
            Button        oBtn = sender as Button;
            frmCutViewRep vRep = null;

            if (oBtn != null && formloaded)
            {
                if (rbFullDetail.Checked)
                {
                    parms.QAFullDetail = true;
                }
                else
                {
                    parms.QAFullDetail = false;
                }

                parms.FromDate = Convert.ToDateTime(dtpFromDate.Value.ToShortDateString());
                parms.ToDate   = Convert.ToDateTime(dtpToDate.Value.ToShortDateString());
                parms.ToDate   = parms.ToDate.AddHours(23);


                vRep = new frmCutViewRep(8, parms);
                int h = Screen.PrimaryScreen.WorkingArea.Height;
                int w = Screen.PrimaryScreen.WorkingArea.Width;
                vRep.ClientSize = new Size(w, h);
                vRep.ShowDialog(this);

                cmboCutSheets.Items.Clear();
                cmboSizes.Items.Clear();
                cmboStyles.Items.Clear();

                frmQaReportSelection_Load(this, null);
                parms = new CuttingQueryParameters();
            }
        }
Example #6
0
        private void btnSubmit_Click(object sender, EventArgs e)
        {
            Button oBtn = sender as Button;

            if (oBtn != null && formloaded)
            {
                frmCutViewRep vRep = new frmCutViewRep(9, QueryParms);
                int           h    = Screen.PrimaryScreen.WorkingArea.Height;
                int           w    = Screen.PrimaryScreen.WorkingArea.Width;
                vRep.ClientSize = new Size(w, h);
                vRep.ShowDialog(this);
            }
        }
Example #7
0
        private void btnSubmit_Click(object sender, EventArgs e)
        {
            Button oBtn = (Button)sender;

            if (oBtn != null && FormLoaded)
            {
                if (txtCutSheetNo.Text.Length != 0)
                {
                    using (var context = new TTI2Entities())
                    {
                        var CutSheet = context.TLCUT_CutSheet.Where(x => x.TLCutSH_No == txtCutSheetNo.Text).FirstOrDefault();
                        if (CutSheet == null)
                        {
                            MessageBox.Show("Cut Sheet does not exist");
                            return;
                        }

                        //This form is the CMT Issued to line document
                        //==============================================================
                        var vRep = new frmCutViewRep(14, CutSheet.TLCutSH_Pk);
                        var h    = Screen.PrimaryScreen.WorkingArea.Height;
                        var w    = Screen.PrimaryScreen.WorkingArea.Width;
                        vRep.ClientSize = new Size(w, h);
                        vRep.ShowDialog();
                    }
                }
                else
                {
                    foreach (DataGridViewRow Row in dataGridView1.Rows)
                    {
                        if ((bool)Row.Cells[1].Value == true)
                        {
                            int Pk = (int)Row.Cells[0].Value;

                            using (var context = new TTI2Entities())
                            {
                                Cutting.frmCutViewRep vRepx = new Cutting.frmCutViewRep(13, Pk);
                                int h = Screen.PrimaryScreen.WorkingArea.Height;
                                int w = Screen.PrimaryScreen.WorkingArea.Width;
                                vRepx.ClientSize = new Size(w, h);
                                vRepx.ShowDialog();
                            }
                        }
                    }
                }
                frmCMTPanelReissue_Load(this, null);
            }
        }
Example #8
0
        private void btnSubmit_Click(object sender, EventArgs e)
        {
            Button oBtn = (Button)sender;

            if (oBtn != null && formloaded)
            {
                CutReportOptions repOptions = new CutReportOptions();
                parms.FromDate = Convert.ToDateTime(dtpFromDate.Value.ToShortDateString());
                parms.ToDate   = Convert.ToDateTime(dtpToDate.Value.ToShortDateString());
                parms.ToDate   = parms.ToDate.AddHours(23);

                frmCutViewRep vRep = new frmCutViewRep(15, repOptions, parms);
                int           h    = Screen.PrimaryScreen.WorkingArea.Height;
                int           w    = Screen.PrimaryScreen.WorkingArea.Width;
                vRep.ClientSize = new Size(w, h);
                vRep.ShowDialog(this);
            }
        }
Example #9
0
        private void btnSubmit_Click(object sender, EventArgs e)
        {
            Button oBtn = sender as Button;

            if (oBtn != null && formloaded)
            {
                CutReportOptions cutOpts = new CutReportOptions();
                cutOpts.C2SortOption = sortOptions;

                frmCutViewRep vRep = new frmCutViewRep(6, cutOpts, parms);
                int           h    = Screen.PrimaryScreen.WorkingArea.Height;
                int           w    = Screen.PrimaryScreen.WorkingArea.Width;
                vRep.ClientSize = new Size(w, h);
                vRep.ShowDialog();

                sortOptions = 1;
                cmboWareHouseStore.Items.Clear();
                frmSelPanelStock_Load(this, null);
            }
        }
Example #10
0
        private void btnSubmit_Click(object sender, EventArgs e)
        {
            Button oBtn = sender as Button;

            if (oBtn != null)
            {
                if (chkAllWIP.Checked)
                {
                    parms.AllWIP = true;
                }

                parms.FromDate      = Convert.ToDateTime(dtpFromDate.Value.ToShortDateString());
                parms.ToDate        = Convert.ToDateTime(dtpToDate.Value.ToShortDateString());
                parms.ToDate        = parms.ToDate.AddHours(23);
                parms.RepSortOption = _RepSortOption;

                frmCutViewRep vRep = new frmCutViewRep(4, parms);
                int           h    = Screen.PrimaryScreen.WorkingArea.Height;
                int           w    = Screen.PrimaryScreen.WorkingArea.Width;
                vRep.ClientSize = new Size(w, h);
                vRep.ShowDialog(this);
            }
        }
Example #11
0
        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            DataGridView oDgv = sender as DataGridView;

            if (oDgv.Focused && oDgv.CurrentCell is DataGridViewCheckBoxCell)
            {
                if (oDgv.CurrentCell.ColumnIndex == 1)
                {
                    if ((bool)oDgv.CurrentCell.EditedFormattedValue)
                    {
                        var CurrentRow = oDgv.CurrentRow;
                        var Pk         = (int)CurrentRow.Cells[0].Value;

                        frmCutViewRep vRep = new frmCutViewRep(1, Pk);
                        int           h    = Screen.PrimaryScreen.WorkingArea.Height;
                        int           w    = Screen.PrimaryScreen.WorkingArea.Width;
                        vRep.ClientSize = new Size(w, h);
                        vRep.ShowDialog(this);
                    }
                }
                else
                {
                    if ((bool)oDgv.CurrentCell.EditedFormattedValue)
                    {
                        var CurrentRow = oDgv.CurrentRow;
                        int Pk         = (int)CurrentRow.Cells[0].Value;

                        frmSplitCutSheet SplitCS = new frmSplitCutSheet(Pk);
                        DialogResult     dr      = SplitCS.ShowDialog(this);
                        if (dr == DialogResult.OK)
                        {
                        }
                    }
                }
            }
        }
Example #12
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            bool Update = false;

            Button oBtn = sender as Button;

            if (oBtn != null && formloaded)
            {
                var selected = (TLCUT_CutSheet)cmboCutSheet.SelectedItem;
                if (selected == null)
                {
                    MessageBox.Show("Please select a cut sheet from the drop down list ");
                    return;
                }

                var WhseSelected = (TLADM_WhseStore)cmboRejectStore.SelectedItem;
                if (WhseSelected == null)
                {
                    MessageBox.Show("Please select a reject store from the drop down list");
                    return;
                }

                if (String.IsNullOrEmpty(txtAuthorisedBy.Text))
                {
                    MessageBox.Show("Please complete the approved by details");
                    return;
                }

                using (var context = new TTI2Entities())
                {
                    var CSR = context.TLCUT_CutSheetReceipt.Where(x => x.TLCUTSHR_CutSheet_FK == selected.TLCutSH_Pk).FirstOrDefault();

                    CutReportOptions cropts = new CutReportOptions();
                    cropts.remarks    = rtbNotes.Text;
                    cropts.TransDate  = dtpTransDate.Value;
                    cropts.ApprovedBy = txtAuthorisedBy.Text;
                    cropts.Pk         = CSR.TLCUTSHR_Pk;
                    cropts.CutSheetPk = selected.TLCutSH_Pk;
                    cropts.ReturnedTo = context.TLADM_WhseStore.Find(WhseSelected.WhStore_Id).WhStore_Description;

                    var cs = context.TLCUT_CutSheet.Find(selected.TLCutSH_Pk);
                    if (cs != null)
                    {
                        cs.TLCutSH_Notes = rtbNotes.Text;
                    }

                    foreach (DataGridViewRow row in dataGridView1.Rows)
                    {
                        if ((bool)row.Cells[1].Value == false)
                        {
                            continue;
                        }

                        //------------------------------------------------------
                        // 1st Step reduce the SOH with what was written off
                        //-----------------------------------------------------------
                        var index = (int)row.Cells[0].Value;
                        var CSRD  = context.TLCUT_CutSheetReceiptDetail.Find(index);
                        if (CSRD != null)
                        {
                            CSRD.TLCUTSHRD_RejectQty   += (int)row.Cells[6].Value;
                            CSRD.TLCUTSHRD_RejectDate   = dtpTransDate.Value;
                            CSRD.TLCUTSHRD_RejectReason = (int)row.Cells[5].Value;
                        }

                        //-------------------------------------------------
                        // Now create a new Record of the written off value
                        //---------------------------------------------------
                        TLCUT_CutSheetReceiptDetail NewCSR = new TLCUT_CutSheetReceiptDetail();
                        NewCSR.TLCUTSHRD_CutSheet_FK     = CSR.TLCUTSHR_Pk;
                        NewCSR.TLCUTSHRD_Description     = row.Cells[2].Value.ToString() + "R";
                        NewCSR.TLCUTSHRD_Size_FK         = (int)row.Cells[3].Value;
                        NewCSR.TLCUTSHRD_BundleQty       = (int)row.Cells[4].Value;
                        NewCSR.TLCUTSHRD_BoxUnits        = 0;
                        NewCSR.TLCUTSHRD_TransactionType = 55;
                        NewCSR.TLCUTSHRD_CurrentStore_FK = WhseSelected.WhStore_Id;
                        NewCSR.TLCUTSHRD_PanelRejected   = true;
                        NewCSR.TLCUTSHRD_RejectDate      = dtpTransDate.Value;
                        NewCSR.TLCUTSHRD_RejectQty       = (int)row.Cells[6].Value;
                        NewCSR.TLCUTSHRD_RejectReason    = (int)row.Cells[5].Value;

                        context.TLCUT_CutSheetReceiptDetail.Add(NewCSR);

                        Update = true;
                    }

                    //-------------------------------------------------------
                    //
                    //-----------------------------------------------------------
                    string Mach_IP = Dns.GetHostEntry(Dns.GetHostName())
                                     .AddressList.First(f => f.AddressFamily == AddressFamily.InterNetwork)
                                     .ToString();

                    var Dept = context.TLADM_Departments.Where(x => x.Dep_ShortCode.Contains("CUT")).FirstOrDefault();

                    TLADM_DailyLog DailyLog = new TLADM_DailyLog();
                    DailyLog.TLDL_IPAddress    = Mach_IP;
                    DailyLog.TLDL_Dept_Fk      = Dept.Dep_Id;
                    DailyLog.TLDL_Date         = DateTime.Now;
                    DailyLog.TLDL_TransDetail  = "Cutting Dept Panel Rejected";
                    DailyLog.TLDL_AuthorisedBy = txtAuthorisedBy.Text;;
                    DailyLog.TLDL_Comments     = rtbNotes.Text;
                    context.TLADM_DailyLog.Add(DailyLog);

                    //----------------------------------------------------------
                    if (Update)
                    {
                        try
                        {
                            context.SaveChanges();
                            MessageBox.Show("Data saved successfully to database");
                            frmCutViewRep vRep = new frmCutViewRep(3, cropts);
                            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);
                        }
                    }
                }
            }
        }
Example #13
0
        private void button1_Click(object sender, EventArgs e)
        {
            BindingList <KeyValuePair <int, decimal> > CurrentRatios;
            Button oBtn = sender as Button;

            if (oBtn != null)
            {
                using (var context = new TTI2Entities())
                {
                    //------------------------------------------------------------------------------------
                    // First we must ensure that all records are removed from
                    // the expectedUnits table for this particular Cut Sheet
                    //---------------------------------------------------------------------------
                    context.TLCUT_ExpectedUnits.RemoveRange(context.TLCUT_ExpectedUnits.Where(x => x.TLCUTE_CutSheet_FK == _CsPk));
                    context.SaveChanges();
                    foreach (DataGridViewRow Row in dataGridView1.Rows)
                    {
                        var DbPk = (int)Row.Cells[1].Value;

                        if ((bool)Row.Cells[2].Value == false)
                        {
                            //------------------------------------------------------------
                            // The pieces that are left are used to recalculate
                            // the number of expected units
                            //--------------------------------------------------------------
                            decimal Nett = (decimal)Row.Cells[5].Value;
                            TLDYE_DyeBatchDetails dbd = context.TLDYE_DyeBatchDetails.Find(DbPk);
                            if (dbd != null)
                            {
                                // Based on code developed for frmCutSheet
                                // Is a body or is it a Trim Record
                                //=================================================
                                if (dbd.DYEBD_BodyTrim)
                                {
                                    //--------------------------------------------------------------
                                    // It is a body
                                    // Now calculate the yield
                                    //------------------------------------------------------------------
                                    var Yield  = core.FabricYield(dbd.DYEBO_DiskWeight, dbd.DYEBO_Width);
                                    var Rating = context.TLADM_ProductRating.Find((int)dbd.DYEBO_ProductRating_FK).Pr_numeric_Rating;

                                    var Factor = Math.Round(Yield / Rating * Nett, 0);
                                    var tst    = core.CalculateRatios((int)dbd.DYEBO_ProductRating_FK, (int)Factor);
                                    foreach (var row in tst)
                                    {
                                        bool Add = true;
                                        var  Kg  = Math.Round(0.01M * row.Value / Yield, 2);

                                        TLCUT_ExpectedUnits eUnits = new TLCUT_ExpectedUnits();
                                        eUnits = context.TLCUT_ExpectedUnits.Where(x => x.TLCUTE_CutSheet_FK == _CsPk && x.TLCUTE_Size_FK == row.Key).FirstOrDefault();
                                        if (eUnits == null)
                                        {
                                            eUnits = new TLCUT_ExpectedUnits();

                                            eUnits.TLCUTE_CutSheet_FK  = _CsPk;
                                            eUnits.TLCUTE_Size_FK      = row.Key;
                                            eUnits.TLCUTE_NoofGarments = row.Value;
                                            eUnits.TLCUTE_NoOfTrims    = Kg;
                                            eUnits.TLCUTE_NoOfBinding  = 0;
                                        }
                                        else
                                        {
                                            eUnits.TLCUTE_NoofGarments += row.Value;
                                            eUnits.TLCUTE_NoOfTrims    += Kg;
                                            Add = !Add;
                                        }

                                        if (Add)
                                        {
                                            context.TLCUT_ExpectedUnits.Add(eUnits);
                                            context.SaveChanges();
                                        }
                                    }
                                }
                                else
                                {
                                    //--------------------------------------------------------------
                                    // It is a Trim
                                    // Now calculate the yield
                                    //------------------------------------------------------------------
                                    var Yield  = core.FabricYield(dbd.DYEBO_DiskWeight, dbd.DYEBO_Width);
                                    var Rating = context.TLADM_ProductRating.Find((int)dbd.DYEBO_ProductRating_FK).Pr_numeric_Rating;
                                    CurrentRatios = core.ReturnRatios((int)dbd.DYEBO_ProductRating_FK);

                                    if (dbd.DYEBO_GVRowNumber == 1)
                                    {
                                        var NumberOf = Math.Round(Yield / Rating * Nett, 0);
                                        var TotalOf  = CurrentRatios.Sum(x => (decimal?)x.Value) ?? 0.00M;
                                        foreach (var row in CurrentRatios)
                                        {
                                            int Calc = (int)Math.Round(row.Value / TotalOf * NumberOf, 0);

                                            TLCUT_ExpectedUnits eUnits = new TLCUT_ExpectedUnits();
                                            eUnits = context.TLCUT_ExpectedUnits.Where(x => x.TLCUTE_CutSheet_FK == _CsPk && x.TLCUTE_Size_FK == row.Key).FirstOrDefault();
                                            if (eUnits != null)
                                            {
                                                // The imfamous switch
                                                //----------------------------
                                                eUnits.TLCUTE_NoOfTrims += Calc;
                                            }
                                        }
                                    }
                                    else if (dbd.DYEBO_GVRowNumber == 2)
                                    {
                                        var NumberOf = Math.Round(Yield / Rating * Nett, 0);
                                        var TotalOf  = CurrentRatios.Sum(x => (decimal?)x.Value) ?? 0.00M;
                                        foreach (var row in CurrentRatios)
                                        {
                                            int Calc = (int)Math.Round(row.Value / TotalOf * NumberOf, 0);

                                            TLCUT_ExpectedUnits eUnits = new TLCUT_ExpectedUnits();
                                            eUnits = context.TLCUT_ExpectedUnits.Where(x => x.TLCUTE_CutSheet_FK == _CsPk && x.TLCUTE_Size_FK == row.Key).FirstOrDefault();
                                            if (eUnits != null)
                                            {
                                                // The imfamous switch
                                                //----------------------------
                                                eUnits.TLCUTE_NoOfBinding += Calc;
                                            }
                                        }
                                    }
                                }
                            }

                            continue;
                        }


                        var DyeBatchDetails = context.TLDYE_DyeBatchDetails.Find(DbPk);
                        if (DyeBatchDetails != null)
                        {
                            DyeBatchDetails.DYEBO_CutSheet = false;
                        }

                        var CutSheetPk      = (int)Row.Cells[0].Value;
                        var CutSheetDetails = context.TLCUT_CutSheetDetail.Find(CutSheetPk);
                        if (CutSheetDetails != null)
                        {
                            context.TLCUT_CutSheetDetail.Remove(CutSheetDetails);
                        }
                    }

                    try
                    {
                        context.SaveChanges();
                        MessageBox.Show("Data saved to the database successfully");
                        frmCutViewRep vRep = new frmCutViewRep(1, _CsPk);
                        int           h    = Screen.PrimaryScreen.WorkingArea.Height;
                        int           w    = Screen.PrimaryScreen.WorkingArea.Width;
                        vRep.ClientSize = new Size(w, h);
                        vRep.ShowDialog(this);
                        this.Close();
                        return;
                    }
                    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)
                    {
                        MessageBox.Show(ex.Message);
                    }
                }
            }
        }
Example #14
0
        private void btnSubmit_Click(object sender, EventArgs e)
        {
            Button oBtn = (Button)sender;

            QueryParms = new CuttingQueryParameters();
            repo       = new CuttingRepository();

            if (oBtn != null)
            {
                DateTime FromDate = Convert.ToDateTime(dtpFromDate.Value.ToShortDateString());
                DateTime ToDate   = Convert.ToDateTime(dtpToDate.Value.ToShortDateString());
                ToDate = ToDate.AddHours(23);

                QueryParms.FromDate = FromDate;
                QueryParms.ToDate   = ToDate;

                if (_ProductionResults)
                {
                    if (chkProductionResults.Checked)
                    {
                        QueryParms.ProductionResults = true;
                    }

                    frmCutViewRep vRep = new frmCutViewRep(18, QueryParms);
                    int           h    = Screen.PrimaryScreen.WorkingArea.Height;
                    int           w    = Screen.PrimaryScreen.WorkingArea.Width;
                    vRep.ClientSize = new Size(w, h);
                    vRep.ShowDialog(this);
                }
                else
                {
                    using (var context = new TTI2Entities())
                    {
                        foreach (DataGridViewRow Row in dataGridView1.Rows)
                        {
                            if ((bool)Row.Cells[1].Value == false)
                            {
                                continue;
                            }

                            var Pk       = (int)Row.Cells[0].Value;
                            var Cutsheet = context.TLCUT_CutSheet.Find(Pk);

                            if (Cutsheet != null)
                            {
                                Cutsheet.TLCUTSH_RequiredDate = dtpFromDate.Value;
                            }
                        }

                        try
                        {
                            context.SaveChanges();
                            MessageBox.Show("Data successfully saved to database");
                        }
                        catch (Exception ex)
                        {
                            MessageBox.Show(ex.Message);
                            return;
                        }
                    }
                }
            }
        }
Example #15
0
        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);
                    }
                }
            }
        }
Example #16
0
        private void btnSubmit_Click(object sender, EventArgs e)
        {
            Button oBtn = sender as Button;

            if (oBtn != null && FormLoaded)
            {
                var FromWhse = (TLADM_WhseStore)cmboFromwarehouse.SelectedItem;
                if (FromWhse == null)
                {
                    MessageBox.Show("Please select a warehouse from which to transfer");
                    return;
                }

                var ToWhse = (TLADM_WhseStore)cmboTowareHouse.SelectedItem;
                if (ToWhse == null)
                {
                    MessageBox.Show("Please select a warehousewhich to transfer too");
                    return;
                }

                if (FromWhse.WhStore_Id == ToWhse.WhStore_Id)
                {
                    MessageBox.Show("Please select a different warehouse to transfer too");
                    return;
                }

                if (!TransferMode)
                {
                    TransferMode        = !TransferMode;
                    btnSubmit.Text      = "Transfer";
                    QueryParms.FromWhse = FromWhse.WhStore_Id;

                    //This function needs to be modified for Bought in Fabric purposes
                    //===========================================================================
                    var Existing = repo.FromWareHouse(QueryParms);
                    if (Existing.Count() == 0)
                    {
                        MessageBox.Show("No Records found for selection made", FromWhse.WhStore_Description);
                        return;
                    }

                    using (var context = new TTI2Entities())
                    {
                        foreach (var Record in Existing)
                        {
                            var index = dataGridView1.Rows.Add();
                            dataGridView1.Rows[index].Cells[0].Value = Record.TLSOH_Pk;
                            dataGridView1.Rows[index].Cells[1].Value = false;
                            dataGridView1.Rows[index].Cells[2].Value = Record.TLSOH_BoxNumber;
                            dataGridView1.Rows[index].Cells[3].Value = context.TLADM_Styles.Find(Record.TLSOH_Style_FK).Sty_Description;
                            dataGridView1.Rows[index].Cells[4].Value = context.TLADM_Colours.Find(Record.TLSOH_Colour_FK).Col_Display;
                            dataGridView1.Rows[index].Cells[5].Value = context.TLADM_Sizes.Find(Record.TLSOH_Size_FK).SI_Description;
                            dataGridView1.Rows[index].Cells[6].Value = Record.TLSOH_BoxedQty;
                        }
                    }
                }
                else
                {
                    var CountSelected = (from Rows in dataGridView1.Rows.Cast <DataGridViewRow>()
                                         where (bool)Rows.Cells[1].Value == true
                                         select Rows).Count();

                    if (CountSelected == 0)
                    {
                        MessageBox.Show("Please tick at least one box to be transferred");
                        return;
                    }



                    TransferMode   = !TransferMode;
                    btnSubmit.Text = "Submit";
                    using (var context = new TTI2Entities())
                    {
                        //Need to create a Header Record in the file
                        //=======================================================
                        TLCSV_WhseTransfer WhseTransfer = new TLCSV_WhseTransfer();

                        var Dept = context.TLADM_Departments.Where(x => x.Dep_ShortCode == "CSV").FirstOrDefault();
                        if (Dept != null)
                        {
                            var LNU = context.TLADM_LastNumberUsed.Where(x => x.LUN_Department_FK == Dept.Dep_Id).FirstOrDefault();
                            if (LNU != null)
                            {
                                WhseTransfer.TLCSVWHT_Date         = DateTime.Now;
                                WhseTransfer.TLCSVWHT_PickList     = true;
                                WhseTransfer.TLCSVWHT_FromWhse_Fk  = FromWhse.WhStore_Id;
                                WhseTransfer.TLCSVWHT_ToWhse_Fk    = ToWhse.WhStore_Id;
                                WhseTransfer.TLCSVWHT_PickListDate = DateTime.Now;
                                WhseTransfer.TLCSVWHT_PickListNo   = LNU.col6;

                                LNU.col6 += 1;

                                context.TLCSV_WhseTransfer.Add(WhseTransfer);

                                try
                                {
                                    context.SaveChanges();
                                }
                                catch (Exception ex)
                                {
                                    MessageBox.Show(ex.Message);
                                    return;
                                }


                                foreach (DataGridViewRow Row in dataGridView1.Rows)
                                {
                                    if ((bool)Row.Cells[1].Value == false)
                                    {
                                        continue;
                                    }

                                    TLCSV_WhseTransferDetail WhDetail = new TLCSV_WhseTransferDetail();

                                    WhDetail.TLCSVWHTD_WhseTranfer_FK = WhseTransfer.TLCSVWHT_Pk;
                                    WhDetail.TLCSVWHTD_TLSOH_Fk       = (int)Row.Cells[0].Value;
                                    WhDetail.TLCSVWHTD_PickList       = true;

                                    context.TLCSV_WhseTransferDetail.Add(WhDetail);
                                }

                                try
                                {
                                    context.SaveChanges();
                                    MessageBox.Show("Records successfully updated to database");

                                    FormLoaded = false;

                                    frmCutViewRep vRep = new frmCutViewRep(16, WhseTransfer.TLCSVWHT_Pk);
                                    int           h    = Screen.PrimaryScreen.WorkingArea.Height;
                                    int           w    = Screen.PrimaryScreen.WorkingArea.Width;
                                    vRep.ClientSize = new Size(w, h);
                                    vRep.ShowDialog(this);

                                    this.Close();
                                }
                                catch (Exception ex)
                                {
                                    MessageBox.Show(ex.Message);
                                }
                            }
                        }
                    }
                }
            }
        }
Example #17
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            Button oBtn = sender as Button;
            TLCUT_CutSheetReceipt CSR = null;

            if (oBtn != null && formloaded)
            {
                using (var context = new TTI2Entities())
                {
                    var Dept = context.TLADM_Departments.Where(x => x.Dep_ShortCode.Contains("CUT")).FirstOrDefault();

                    if (CutSheetSelected != 0)
                    {
                        CSR = context.TLCUT_CutSheetReceipt.Where(x => x.TLCUTSHR_CutSheet_FK == CutSheetSelected).FirstOrDefault();
                        if (CSR != null)
                        {
                            CSR.TLCUTSHR_InBundleStore      = false;
                            CSR.TLCUTSHR_InPanelStore       = true;
                            CSR.TLCUTSHR_DateIntoPanelStore = dtpTransActionDate.Value;

                            var CS = context.TLCUT_CutSheet.Find(CSR.TLCUTSHR_CutSheet_FK);
                            if (CS != null)
                            {
                                if (rtbAdditional.Text.Length != 0)
                                {
                                    CS.TLCUTSH_AddNotes = rtbAdditional.Text;
                                }

                                CS.TLCUTSH_Completed_Date = DateTime.Now;
                                CSR.TLCUTSHR_Colour_FK    = CS.TLCutSH_Colour_FK;
                                var CutStore = context.TLADM_WhseStore.Where(x => x.WhStore_DepartmentFK == CS.TLCutSH_Department_FK && x.WhStore_PanelStore).FirstOrDefault();
                                if (CutStore != null)
                                {
                                    CSR.TLCUTSHR_WhsePanStore_FK    = CutStore.WhStore_Id;
                                    CSR.TLCUTSHR_DateIntoPanelStore = dtpTransActionDate.Value;
                                }
                            }
                        }
                    }
                    else
                    {
                        MessageBox.Show("Please select a cutsheet from the drop down box");
                        return;
                    }

                    foreach (DataGridViewRow row in dataGridView1.Rows)
                    {
                        TLCUT_CutSheetReceiptDetail CSRD = new TLCUT_CutSheetReceiptDetail();

                        var index = (int)row.Cells[0].Value;
                        CSRD = context.TLCUT_CutSheetReceiptDetail.Find(index);

                        if (CSRD != null)
                        {
                            CSRD.TLCUTSHRD_BoxNumber = dataGridView1.Rows[row.Index].Cells[3].Value.ToString();
                            if ((int)dataGridView1.Rows[row.Index].Cells[4].Value == 0)
                            {
                                continue;
                            }

                            CSRD.TLCUTSHRD_BoxUnits      = (int)dataGridView1.Rows[row.Index].Cells[4].Value;
                            CSRD.TLCUTSHRD_BoxType_FK    = 1; // removed to speed up data capture (int)dataGridView1.Rows[row.Index].Cells[5].Value;
                            CSRD.TLCUTSHRD_InBundleStore = false;
                            CSRD.TLCUTSHRD_PanelDate     = dtpTransActionDate.Value;

                            if (Dept != null)
                            {
                                var TranType = context.TLADM_TranactionType.Where(x => x.TrxT_Department_FK == Dept.Dep_Id && x.TrxT_Number == 600).FirstOrDefault();
                                if (TranType != null)
                                {
                                    CSRD.TLCUTSHRD_TransactionType = TranType.TrxT_Pk;
                                    CSRD.TLCUTSHRD_CurrentStore_FK = (int)TranType.TrxT_ToWhse_FK;
                                }
                            }
                        }
                    }

                    var CSB = context.TLCUT_CutSheetReceiptBoxes.Where(x => x.TLCUTSHB_Pk == CSR.TLCUTSHR_Pk).FirstOrDefault();
                    if (CSB != null)
                    {
                        int value = 0;
                        if (int.TryParse(txtAdultBoxes.Text, out value))
                        {
                            CSB.TLCUTSHB_AdultBoxes = value;
                        }


                        value = 0;
                        if (int.TryParse(txtBinding.Text, out value))
                        {
                            CSB.TLCUTSHB_Binding = value;
                        }

                        value = 0;
                        if (int.TryParse(txtKidsBoxes.Text, out value))
                        {
                            CSB.TLCUTSHB_KidBoxes = value;
                        }
                        value = 0;
                        if (int.TryParse(txtRibbing.Text, out value))
                        {
                            CSB.TLCUTSHB_Ribbing = value;
                        }
                    }

                    try
                    {
                        context.SaveChanges();
                        MessageBox.Show("Data saved successfully to database");
                        dataGridView1.Rows.Clear();

                        //This form is the summary form for Mary in the accessories store
                        //===================================================
                        frmCutViewRep vRep = new frmCutViewRep(11, CutSheetSelected);
                        int           h    = Screen.PrimaryScreen.WorkingArea.Height;
                        int           w    = Screen.PrimaryScreen.WorkingArea.Width;
                        vRep.ClientSize = new Size(w, h);
                        vRep.ShowDialog();

                        //This form is the CMT Issued to line document
                        //==============================================================
                        vRep            = new frmCutViewRep(14, CutSheetSelected);
                        h               = Screen.PrimaryScreen.WorkingArea.Height;
                        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)
                    {
                        MessageBox.Show(ex.Message);
                    }
                }
            }
        }