Esempio n. 1
0
 private void metroButton2_Click(object sender, EventArgs e)
 {
     FormHelpers.CursorWait(true);
     try
     {
         if (mgridRights.SelectedRows.Count < 1)
         {
             throw new Exception("No selected User Rights!");
         }
         else
         {
             var usrgrpcode = BPSUtilitiesV1.NZ(mgridRights.SelectedRows[0].Cells["colUserGroupCode"].Value, "").ToString();
             var menuid = Convert.ToInt32(BPSUtilitiesV1.NZ(mgridRights.SelectedRows[0].Cells["colMenuID"].Value, 0));
             if (usrgrpcode != "" && menuid != 0)
             {
                 Removeright(usrgrpcode, menuid);
             }
         }
     }
     catch (Exception ex)
     {
         MessageHelpers.ShowError(ex.Message);
     }
     finally
     {
         FormHelpers.CursorWait(false);
     }
 }
Esempio n. 2
0
 public Boolean Save(tbl_100_WIP record)
 {
     using (var dbContextTransaction = db.Database.BeginTransaction())
     {
         try
         {
             if (BPSUtilitiesV1.NZ(record.WIPMaterials, "").ToString() != "")
             {
                 foreach (tbl_100_WIP_Materials wipmat in record.WIPMaterials)
                 {
                     db.WIPMaterialsList.Add(wipmat);
                     db.SaveChanges();
                 }
             }
             db.WIPList.Add(record);
             db.SaveChanges();
             dbContextTransaction.Commit();
             return(true);
         }
         catch (Exception ex)
         {
             dbContextTransaction.Rollback();
             throw ex;
         }
     }
 }
Esempio n. 3
0
 public Boolean Delete(tbl_100_WIP record)
 {
     using (var dbContextTransaction = db.Database.BeginTransaction())
     {
         try
         {
             var existrecord = GetByID(record.YEARUSED, record.ItemNo, record.PartCode);
             if (BPSUtilitiesV1.NZ(record.WIPMaterials, "").ToString() != "")
             {
                 foreach (tbl_100_WIP_Materials mat in record.WIPMaterials)
                 {
                     db.WIPMaterialsList.Remove(mat);
                     db.SaveChanges();
                 }
             }
             db.WIPList.Remove(existrecord);
             db.SaveChanges();
             dbContextTransaction.Commit();
             return(true);
         }
         catch (Exception ex)
         {
             dbContextTransaction.Rollback();
             throw ex;
         }
     }
 }
Esempio n. 4
0
 private void AssignRecord(Boolean IsSave)
 {
     try
     {
         if (IsSave)
         {
             tbl_000_H_PART existcom = new tbl_000_H_PART();
             existcom = combal.GetAll().Where(m => m.YEARUSED == UserSettings.LogInYear && m.PartNo == mtxtPartNo.Text).FirstOrDefault();
             if (existcom == null)
             {
                 com.YEARUSED    = UserSettings.LogInYear;
                 com.PartNo      = mtxtPartNo.Text;
                 com.CreatedDate = DateTime.Now;
                 com.CreatedBy   = UserSettings.Username;
                 com.IsCopied    = false;
                 com.CopyDate    = DateTime.Now;
                 com.IsImported  = false;
                 com.ImportDate  = DateTime.Now;
                 com.ImportBy    = UserSettings.Username;
             }
             com.PartName        = mtxtPartName.Text;
             com.WholeQty        = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtWholeQty.Text, 0));
             com.WholeUnit       = mtxtWholeUnit.Text;
             com.ConversionQty   = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtConversionQty.Text, 0));
             com.ConversionUnit  = mtxtConversionUnit.Text;
             com.WholePrice      = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtWholePrice.Text, 0));
             com.ConversionPrice = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtConversionPrice.Text, 0));
             com.PreviousPrice   = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtPreviousPrice.Text, 0));
             com.IsLocked        = mcbLocked.Checked;
             com.ExpDate         = DateTime.Now;
             com.UpdatedDate     = DateTime.Now;
             com.UpdatedBy       = UserSettings.Username;
         }
         else
         {
             com = combal.GetByID(yearused, partno);
             if (com != null)
             {
                 mtxtPartNo.Text          = com.PartNo;
                 mtxtPartName.Text        = com.PartName;
                 mcbLocked.Checked        = com.IsLocked;
                 mtxtPreviousPrice.Text   = String.Format("{0:n4}", com.PreviousPrice);
                 mtxtWholePrice.Text      = String.Format("{0:n4}", com.WholePrice);
                 mtxtWholeQty.Text        = String.Format("{0:n2}", com.WholeQty);
                 mtxtWholeUnit.Text       = com.WholeUnit;
                 mtxtConversionPrice.Text = String.Format("{0:n4}", com.ConversionPrice);
                 mtxtConversionQty.Text   = String.Format("{0:n2}", com.ConversionQty);
                 mtxtConversionUnit.Text  = com.ConversionUnit;
             }
             else
             {
                 throw new Exception("Record doesn't exist!");
             }
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Esempio n. 5
0
 public Boolean Update(tbl_100_WIP record)
 {
     using (var dbContextTransaction = db.Database.BeginTransaction())
     {
         try
         {
             if (BPSUtilitiesV1.NZ(record.WIPMaterials, "").ToString() != "")
             {
                 foreach (tbl_100_WIP_Materials wipmat in record.WIPMaterials)
                 {
                     if (wipmat.state == "update")
                     {
                         db.Entry(wipmat).State = EntityState.Modified;
                         db.SaveChanges();
                     }
                     else if (wipmat.state == "add")
                     {
                         db.WIPMaterialsList.Add(wipmat);
                         db.SaveChanges();
                     }
                 }
             }
             dbContextTransaction.Commit();
             return(true);
         }
         catch (Exception ex)
         {
             dbContextTransaction.Rollback();
             throw ex;
         }
     }
 }
Esempio n. 6
0
 private void AssignRecord(Boolean IsSave)
 {
     try
     {
         if (IsSave)
         {
             mt.YEARUSED = UserSettings.LogInYear;
             mt.PartNo   = mtxtPartNo.Text;
             mt.PartName = mtxtPartName.Text;
             mt.Usage    = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtUsage.Text, 0));
             mt.Process  = mtxtProcess.Text;
             mt.Vendor   = mtxtVendor.Text;
         }
         else
         {
             mt = mtbal.GetByID(UserSettings.LogInYear, pno);
             if (mt != null)
             {
                 mtxtPartNo.Text   = mt.PartNo;
                 mtxtPartName.Text = mt.PartName;
                 mtxtUsage.Text    = mt.Usage.ToString();
                 mtxtProcess.Text  = mt.Process;
                 mtxtVendor.Text   = mt.Vendor;
             }
             else
             {
                 throw new Exception("Record doesn't exist!");
             }
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Esempio n. 7
0
 private void AssignRecord(Boolean IsSave)
 {
     try
     {
         if (IsSave)
         {
             cat.CATCODE           = mtxtCategoryCode.Text;
             cat.CATDESC           = mtxtCategoryDesc.Text;
             cat.RATECONVERSION    = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtPhp.Text, 0));
             cat.FIXEDCHARGELABOR  = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtFCLabor.Text, 0));
             cat.FIXEDCHARGEFO     = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtFCFOverhead.Text, 0));
             cat.PRODALLOWANCETIME = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtPTAllowance.Text, 0));
             cat.FIXEDRATELOSS     = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtFRLMProcess.Text, 0));
             cat.FIXEDRATEPROFIT   = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtFPRate.Text, 0));
             cat.YENRATECONVERSION = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtYen.Text, 0));
             cat.FIXEDRATEDEPNMOLD = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtFCDMold.Text, 0));
             cat.FIXEDRATEDEPNFILM = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtFCDFilm.Text, 0));
             cat.OTHERPROCESSCOST  = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtOPCost.Text, 0));
             cat.YEARUSED          = UserSettings.LogInYear;
             cat.MoldSetup         = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtMoldSetup.Text, 0));
             cat.LotSize           = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtLotSize.Text, 0));
             cat.IsDependent       = mcbDependent.Checked;
             cat.IsActive          = mcbActive.Checked;
         }
         else
         {
             cat = catbal.GetByID(CategoryCode, YearUsed);
             if (cat != null)
             {
                 mtxtCategoryCode.Text = cat.CATCODE;
                 mtxtCategoryDesc.Text = cat.CATDESC;
                 mtxtPhp.Text          = cat.RATECONVERSION.ToString();
                 mtxtFCLabor.Text      = cat.FIXEDCHARGELABOR.ToString();
                 mtxtFCFOverhead.Text  = cat.FIXEDCHARGEFO.ToString();
                 mtxtPTAllowance.Text  = cat.PRODALLOWANCETIME.ToString();
                 mtxtFRLMProcess.Text  = cat.FIXEDRATELOSS.ToString();
                 mtxtFPRate.Text       = cat.FIXEDRATEPROFIT.ToString();
                 mtxtYen.Text          = cat.YENRATECONVERSION.ToString();
                 mtxtFCDMold.Text      = cat.FIXEDRATEDEPNMOLD.ToString();
                 mtxtFCDFilm.Text      = cat.FIXEDRATEDEPNFILM.ToString();
                 mtxtOPCost.Text       = cat.OTHERPROCESSCOST.ToString();
                 mtxtMoldSetup.Text    = cat.MoldSetup.ToString();
                 mtxtLotSize.Text      = cat.LotSize.ToString();
                 mcbDependent.Checked  = cat.IsDependent;
                 mcbActive.Checked     = cat.IsActive;
             }
             else
             {
                 throw new Exception("Record doesn't exist!");
             }
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Esempio n. 8
0
        private void mtxtCatCode_TextChanged(object sender, EventArgs e)
        {
            string selectedcatcode = BPSUtilitiesV1.NZ(mtxtCatCode.Text, "").ToString();

            cat = catbal.GetByID(selectedcatcode, selyear);
            if (cat != null)
            {
                mtxtCatDesc.Text = BPSUtilitiesV1.NZ(cat.CATDESC, "").ToString();
            }
        }
        private void ItemDesc()
        {
            string selecteditemno = BPSUtilitiesV1.NZ(mtxtItemNo.Text, "").ToString();

            itm = itmbal.GetByID(UserSettings.LogInYear, selecteditemno);
            if (itm != null)
            {
                mtxtItemDesc.Text = BPSUtilitiesV1.NZ(itm.Description, "").ToString();
            }
        }
Esempio n. 10
0
        private void mtxtItemNo_TextChanged(object sender, EventArgs e)
        {
            string selecteditemno = BPSUtilitiesV1.NZ(mtxtItemNo.Text, "").ToString();

            itm = itmbal.GetByID(selyear, selecteditemno);
            if (itm != null)
            {
                mtxtItemDesc.Text = BPSUtilitiesV1.NZ(itm.Description, "").ToString();
            }
        }
Esempio n. 11
0
 private void AssignRecord(Boolean IsSave)
 {
     try
     {
         if (IsSave)
         {
             usr.UserID        = usr.UserID;
             usr.Username      = mtxtUsername.Text;
             usr.Password      = mtxtPassword.Text;
             usr.FullName      = mtxtFullName.Text;
             usr.UserGroupCode = mcboUserGroupCode.SelectedValue.ToString();
             usr.UserGroupDesc = mcboUserGroupCode.Text;
             usr.SectionCode   = BPSUtilitiesV1.NZ(mcboSectionCode.SelectedValue, "").ToString();
             usr.SectionDesc   = BPSUtilitiesV1.NZ(mcboSectionCode.Text, "").ToString();
             usr.AccessLevel   = mtxtAccessLevel.Text;
             usr.IsActive      = mcbActive.Checked;
             if (ofdImage.FileName != "")
             {
                 usr.UserPhoto = BPSolutionsTools.BPSUtilitiesV1.ImageToByte(Image.FromFile(ofdImage.FileName));
             }
         }
         else
         {
             usr = userbal.GetByUsername(username);
             if (usr != null)
             {
                 mtxtUsername.Text               = usr.Username;
                 mtxtPassword.Text               = usr.Password;
                 mtxtConfirmPassword.Text        = usr.Password;
                 mtxtFullName.Text               = usr.FullName;
                 mcboUserGroupCode.SelectedValue = usr.UserGroupCode;
                 mcboSectionCode.SelectedValue   = usr.SectionCode;
                 //mcboSectionCode.Text=usr.SectionDesc;
                 mtxtAccessLevel.Text = usr.AccessLevel;
                 mcbActive.Checked    = usr.IsActive;
                 if (usr.UserPhoto != null)
                 {
                     picUser.BackgroundImage = BPSolutionsTools.BPSUtilitiesV1.BytesToImage(usr.UserPhoto);
                 }
             }
             else
             {
                 throw new Exception("Record doesn't exist!");
             }
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
     finally
     {
     }
 }
        public void Init_Form()
        {
            FormHelpers.FormatForm(this.Controls);
            minid = Convert.ToInt64(BPSUtilitiesV1.NZ(signabal.GetAll().Select(s => s.RecID).FirstOrDefault(), 1));
            GetList();
            MyState         = FormState.View;
            mbtnModify.Text = "Modify";
            LockFields(true);

            err.BlinkRate = 7;
        }
Esempio n. 13
0
 private void KeyColumnLocker()
 {
     for (int i = 0; i < mgridList.RowCount; i++)
     {
         var yearused = mgridList.Rows[i].Cells["colYEARUSED"].Value;
         if (Convert.ToInt32(BPSUtilitiesV1.NZ(yearused, 0)) != 0)
         {
             mgridList.Rows[i].Cells["colSubProcessCode"].ReadOnly = true;
         }
     }
 }
Esempio n. 14
0
        private void FilltxtAutoComplete()
        {
            selyear = Convert.ToInt32(BPSUtilitiesV1.NZ(mcboYear.SelectedValue, 0));
            AutoCompleteStringCollection collection = new AutoCompleteStringCollection();
            var source = itmbal.GetItemNos(selyear);

            foreach (string i in source)
            {
                collection.Add(i);
            }
            mtxtItemNo.AutoCompleteMode         = AutoCompleteMode.Suggest;
            mtxtItemNo.AutoCompleteSource       = AutoCompleteSource.CustomSource;
            mtxtItemNo.AutoCompleteCustomSource = collection;
        }
Esempio n. 15
0
 private void AssignRecord(Boolean IsSave)
 {
     try
     {
         if (IsSave)
         {
             tbl_000_H_ASSY existassy = new tbl_000_H_ASSY();
             existassy = assybal.GetAll().Where(w => w.YEARUSED == UserSettings.LogInYear && w.PartNo == mtxtPartNo.Text).FirstOrDefault();
             if (existassy == null)
             {
                 assy.CreatedDate = DateTime.Now;
                 assy.CreatedBy   = UserSettings.Username;
                 assy.IsCopied    = false;
                 assy.CopyDate    = DateTime.Now;
                 assy.IsImported  = false;
                 assy.ImportDate  = DateTime.Now;
                 assy.ImportBy    = UserSettings.Username;
             }
             assy.YEARUSED    = UserSettings.LogInYear;
             assy.PartNo      = mtxtPartNo.Text;
             assy.PartName    = mtxtPartName.Text;
             assy.HC          = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtHC.Text, 0));
             assy.Qty         = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtQty.Text, 0));
             assy.RATEPERHOUR = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtRatePerHour.Text, 0));
             assy.IsLocked    = mcbLocked.Checked;
             assy.UpdatedDate = DateTime.Now;
             assy.UpdatedBy   = UserSettings.Username;
         }
         else
         {
             assy = assybal.GetByID(yearused, partno);
             if (assy != null)
             {
                 mtxtPartNo.Text      = assy.PartNo;
                 mtxtPartName.Text    = assy.PartName;
                 mtxtHC.Text          = ((double)assy.HC).ToString();
                 mtxtQty.Text         = ((double)assy.Qty).ToString();
                 mtxtRatePerHour.Text = assy.RATEPERHOUR.ToString();
                 mcbLocked.Checked    = assy.IsLocked;
                 assy.UpdatedDate     = DateTime.Now;
                 assy.UpdatedBy       = UserSettings.Username;
             }
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Esempio n. 16
0
        private void GetComponents()
        {
            try
            {
                FormHelpers.CursorWait(true);
                var itemno    = BPSUtilitiesV1.NZ(mtxtItemNo.Text, "").ToString();
                var partscode = BPSUtilitiesV1.NZ(mtxtPartCode.Text, "").ToString();
                ListHelper.FillMetroCombo(mcboCatCode, catbal.GetAll().Select(i => new { i.CATCODE, i.CATDESC }).
                                          Where(w => w.CATCODE == "BULK").Distinct().ToList(), "CATCODE", "CATCODE");
                var catcode = BPSUtilitiesV1.NZ(mcboCatCode.SelectedValue, "").ToString();
                item = itembal.GetWithCat(UserSettings.LogInYear, itemno, catcode);

                GetRefCompDetails();
                if (item != null && item.itemCom.Count > 0)
                {
                    if (partscode != "")
                    {
                        itemcom = item.itemCom.Where(w => w.PartNo == partscode).OrderBy(o => o.ItemAddress).FirstOrDefault();
                        if (itemcom != null)
                        {
                            var sourceTable = item.itemCom.Where(w => w.ItemAddress.StartsWith(itemcom.ItemAddress) && w.ItemAddress != itemcom.ItemAddress).ToList();
                            using (var reader = ObjectReader.Create(sourceTable,
                                                                    "DocID",
                                                                    "MatCode",
                                                                    "MatDescription",
                                                                    "ItemUsage",
                                                                    "UnitPrice",
                                                                    "Amount",
                                                                    "Address"))
                            {
                                dt.Load(reader);
                                mgridMatList.DataSource = dt;
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MessageHelpers.ShowError(ex.Message);
            }
            finally
            {
                FormHelpers.CursorWait(false);
            }
        }
Esempio n. 17
0
 private void AssignMain()
 {
     wip = wipbal.GetByRecID(recid);
     if (wip == null)
     {
         wip          = new tbl_100_WIP();
         wip.YEARUSED = UserSettings.LogInYear;
         wip.ItemNo   = mtxtItemNo.Text;
         wip.PartCode = mtxtPartCode.Text;
         GetRefCompDetails();
         wip.PartName      = mtxtPartName.Text;
         wip.CatCode       = BPSUtilitiesV1.NZ(mcboCatCode.SelectedValue, "").ToString();
         wip.MaterialLabor = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtSubTotal.Text, 0));
         wip.ProfitRate    = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtProfitRate.Text, 0));
         wip.SellingPrice  = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtSellingPrice.Text, 0));
         wip.ForexRate     = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtForex.Text, 0));
         wip.CreatedBy     = UserSettings.Username;
         wip.UpdatedBy     = UserSettings.Username;
         wip.Remarks       = mtxtRemarks.Text;
     }
 }
Esempio n. 18
0
 public static void UniqueRow(DataGridView dgv, string cellname)
 {
     try
     {
         string initialnamevalue = dgv.Rows[0].Cells[cellname].Value.ToString();
         for (int i = 1; i < dgv.Rows.Count; i++)
         {
             if (BPSUtilitiesV1.NZ(dgv.Rows[i].Cells[cellname].Value, "").ToString() == initialnamevalue)
             {
                 dgv.Rows.RemoveAt(i);
             }
             else
             {
                 initialnamevalue = BPSUtilitiesV1.NZ(dgv.Rows[i].Cells[cellname].Value, "").ToString();
             }
         }
     }
     catch
     {
     }
 }
Esempio n. 19
0
 private void AssignRecord()
 {
     try
     {
         AssignMain();
         for (int i = 0; i < mgridMatList.RowCount; i++)
         {
             if (mgridMatList.Rows[i].IsNewRow)
             {
                 continue;
             }
             var wmrecid = Convert.ToInt64(BPSUtilitiesV1.NZ(mgridMatList.Rows[i].Cells["colDocID"].Value.ToString(), 0));
             var wipmat  = wipmatbal.GetByRecID(wmrecid);
             if (wipmat == null)
             {
                 wipmat       = new tbl_100_WIP_Materials();
                 wipmat.state = "add";
             }
             else
             {
                 wipmat.state = "update";
             }
             wipmat.YEARUSED       = UserSettings.LogInYear;
             wipmat.ItemNo         = mtxtItemNo.Text;
             wipmat.PartNo         = mtxtPartCode.Text;
             wipmat.MatCode        = mgridMatList.Rows[i].Cells["colMoldNo"].Value.ToString();
             wipmat.MatDescroption = mgridMatList.Rows[i].Cells["colMatDescription"].Value.ToString();
             wipmat.Usage          = Convert.ToDecimal(mgridMatList.Rows[i].Cells["colUsage"].Value);
             wipmat.UnitType       = mgridMatList.Rows[i].Cells["colUnitType"].Value.ToString();
             wipmat.UnitPrice      = Convert.ToDecimal(mgridMatList.Rows[i].Cells["colUnitPrice"].Value);
             wipmat.Amount         = Convert.ToDecimal(mgridMatList.Rows[i].Cells["colAmount"].Value);
             wipmat.Address        = mgridMatList.Rows[i].Cells["colAddress"].Value.ToString();
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Esempio n. 20
0
 private void AssignRecord(Boolean IsSave)
 {
     try
     {
         if (IsSave)
         {
             fxsp.RecType       = mcboType.SelectedItem.ToString();
             fxsp.EffectiveDate = Convert.ToDateTime(mdtpEffectiveDate.Value.Date);
             fxsp.Rate          = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtRate.Text, 0));
             //For Testing
             fxsp.YearUsed    = UserSettings.LogInYear;
             fxsp.CreatedBy   = UserSettings.Username;
             fxsp.CreatedDate = DateTime.Now;
             fxsp.UpdatedBy   = UserSettings.Username;
             fxsp.UpdatedDate = DateTime.Now;
             //end
         }
         else
         {
             fxsp = fxspbal.GetByID(RecType, Convert.ToDateTime(EffectiveDate));
             if (fxsp != null)
             {
                 mcboType.SelectedItem   = fxsp.RecType;
                 mdtpEffectiveDate.Value = fxsp.EffectiveDate;
                 mtxtRate.Text           = fxsp.Rate.ToString();
             }
             else
             {
                 throw new Exception("Record doesn't exist!");
             }
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Esempio n. 21
0
 public Boolean Save_List(List <tbl_000_H_PART> record_list)
 {
     using (var dbContextTransaction = db.Database.BeginTransaction())
     {
         try
         {
             if (BPSUtilitiesV1.NZ(record_list, "").ToString() != null)
             {
                 foreach (tbl_000_H_PART c in record_list)
                 {
                     db.ComponentList.Add(c);
                     db.SaveChanges();
                 }
             }
             dbContextTransaction.Commit();
             return(true);
         }
         catch (Exception ex)
         {
             dbContextTransaction.Rollback();
             throw ex;
         }
     }
 }
Esempio n. 22
0
        private void ContinueCopy()
        {
            try
            {
                FormHelpers.CursorWait(true);
                List <tbl_000_H_ITEM> write_list_itm;
                selyear = Convert.ToInt32(mcboYear.SelectedValue.ToString());
                if (!mcbOverWrite.Checked)
                {
                    msg = "This process will copy previous components from the selected year to the current logged in year. Do you want to continue?";
                    if (MessageHelpers.ShowQuestion(msg) == DialogResult.Yes)
                    {
                        switch (YearSource)
                        {
                            #region Components to Copy
                        case YearsOf.Components:
                            Save_com(false);
                            break;

                            #endregion
                            #region Tabulation to Copy
                        case YearsOf.MaintainanceTable:
                            switch (YearofMaintenanceTable_Sub)
                            {
                            case MaintainanceTableSub.PlasticInjection:
                                Save_pi(false);
                                break;

                            case MaintainanceTableSub.VacuumPlating:
                                Save_vp(false);
                                break;

                            case MaintainanceTableSub.Assembly:
                                Save_assy(false);
                                break;
                            }
                            break;

                            #endregion
                            #region Process to Copy
                        case YearsOf.ProcessSetup:
                            Save_proc(false);
                            break;

                            #endregion
                            #region Items to Copy
                        case YearsOf.Items:
                            write_list_itm = new List <tbl_000_H_ITEM>();
                            var currentyear_list_itm = itmbal.GetByYear(UserSettings.LogInYear).ToList();
                            foreach (tbl_000_H_ITEM i in currentyear_list_itm)
                            {
                                write_list_itm.Add(itmbal.GetAll().Where(w => w.YEARUSED == selyear && w.ItemNo == i.ItemNo).FirstOrDefault());
                            }
                            foreach (tbl_000_H_ITEM i in write_list_itm)
                            {
                                if (i != null)
                                {
                                    itmlist.RemoveAll(r => r.ItemNo == i.ItemNo);
                                }
                            }
                            Save_item();
                            break;
                            #endregion
                        }
                    }
                }
                else
                {
                    msg = "This process will remove the existing components and replace it with the selected year. Do you want to continue?";
                    if (MessageHelpers.ShowQuestion(msg) == DialogResult.Yes)
                    {
                        switch (YearSource)
                        {
                            #region Components to Copy with Overwrite
                        case YearsOf.Components:
                            Save_com(true);
                            break;

                            #endregion
                            #region Tabulation to Copy with Overwrite
                        case YearsOf.MaintainanceTable:
                            switch (YearofMaintenanceTable_Sub)
                            {
                            case MaintainanceTableSub.PlasticInjection:
                                Save_pi(true);
                                break;

                            case MaintainanceTableSub.VacuumPlating:
                                Save_vp(true);
                                break;

                            case MaintainanceTableSub.Assembly:
                                Save_assy(true);
                                break;
                            }
                            break;

                            #endregion
                            #region Process to Copy with Overwrite
                        case YearsOf.ProcessSetup:
                            Save_proc(true);
                            break;

                            #endregion
                            #region Items to Copy with Overwrite
                        case YearsOf.Items:
                            write_list_itm = new List <tbl_000_H_ITEM>();
                            foreach (tbl_000_H_ITEM i in itmlist)
                            {
                                write_list_itm.Add(itmbal.GetAll().Where(w => w.YEARUSED == UserSettings.LogInYear && w.ItemNo == i.ItemNo).FirstOrDefault());
                            }
                            AssignSubItems(write_list_itm);
                            if (BPSUtilitiesV1.NZ(write_list_itm, "").ToString() != "")
                            {
                                foreach (tbl_000_H_ITEM i in write_list_itm)
                                {
                                    if (i != null)
                                    {
                                        todelete_item.Add(i);
                                    }
                                }
                                var tmptodelete_item = todelete_item;
                                itmbal.Delete_List(todelete_item);
                                //AssignSubItems(itmlist);
                                DeleteSub(todelete_item);
                                Save_item();
                            }
                            break;
                            #endregion
                        }
                    }
                }
                this.Close();
            }
            catch (Exception ex)
            {
                MessageHelpers.ShowError(ex.Message);
            }
            finally
            {
                FormHelpers.CursorWait(false);
            }
        }
        private void mbtnGenerate_Click(object sender, EventArgs e)
        {
            var msg_succ   = "Generating Successful!";
            var msg_failed = "No Data Generated!";

            if (MessageHelpers.ShowQuestion("Generate Report?") == System.Windows.Forms.DialogResult.Yes)
            {
                try
                {
                    FormHelpers.CursorWait(true);
                    if (rptdetails.SP_GeneratePriceListComparison(Convert.ToInt32(mcbofrstYear.SelectedValue), Convert.ToInt32(mcboscndYear.SelectedValue), BPSUtilitiesV1.NZ(mcboCategory.SelectedValue, "").ToString()).Rows.Count == 0)
                    {
                        throw new Exception(msg_failed);
                    }
                    else
                    {
                        MessageHelpers.ShowInfo(msg_succ);
                    }
                }
                catch (Exception ex)
                {
                    MessageHelpers.ShowError(ex.Message);
                }
                finally
                {
                    FormHelpers.CursorWait(false);
                }
            }
        }
 private void PreviewComparison(string strRptName)
 {
     try
     {
         FormHelpers.CursorWait(true);
         frm_ReportViewer frv = new frm_ReportViewer();
         frv.report             = new ReportTable();
         frv.report.ReportName  = strRptName;
         frv.report.ReportPath  = ObjectFinder.ReportPath;
         frv.report.SourceTable = rptdetails.SP_GeneratePriceListComparison(Convert.ToInt32(mcbofrstYear.SelectedValue), Convert.ToInt32(mcboscndYear.SelectedValue), BPSUtilitiesV1.NZ(mcboCategory.SelectedValue, "").ToString());
         if (frv.report.SourceTable == null || frv.report.SourceTable.Rows.Count == 0)
         {
             throw new Exception("Report no Data");
         }
         frv.Text          = "Price List Comparison Report";
         frv.StartPosition = FormStartPosition.CenterScreen;
         frv.Show();
     }
     catch (Exception ex)
     {
         MessageHelpers.ShowError(ex.Message);
     }
     finally
     {
         FormHelpers.CursorWait(false);
     }
 }
        private void AssignRecord(Boolean IsSave)
        {
            try
            {
                if (IsSave)
                {
                    string apprtag = "APPRD";
                    string preptag = "PREPRD";
                    string revitag = "REVWD";
                    signalist = new List <tbl_SIGNATORY>();

                    //Approved By
                    signa              = new tbl_SIGNATORY();
                    signa.RecID        = minid;
                    signa.SignName     = BPSUtilitiesV1.NZ(mtxtApprName1.Text, "").ToString();
                    signa.SignPosition = BPSUtilitiesV1.NZ(mtxtApprPosition1.Text, "").ToString();
                    signa.SignFor      = apprtag;
                    signalist.Add(signa);

                    signa              = new tbl_SIGNATORY();
                    signa.RecID        = minid + 1;
                    signa.SignName     = BPSUtilitiesV1.NZ(mtxtApprName2.Text, "").ToString();
                    signa.SignPosition = BPSUtilitiesV1.NZ(mtxtApprPosition2.Text, "").ToString();
                    signa.SignFor      = apprtag;
                    signalist.Add(signa);

                    //Prepared By
                    signa              = new tbl_SIGNATORY();
                    signa.RecID        = minid + 2;
                    signa.SignName     = BPSUtilitiesV1.NZ(mtxtPrepName1.Text, "").ToString();
                    signa.SignPosition = BPSUtilitiesV1.NZ(mtxtPrepPosition1.Text, "").ToString();
                    signa.SignFor      = preptag;
                    signalist.Add(signa);

                    signa              = new tbl_SIGNATORY();
                    signa.RecID        = minid + 3;
                    signa.SignName     = BPSUtilitiesV1.NZ(mtxtPrepName2.Text, "").ToString();
                    signa.SignPosition = BPSUtilitiesV1.NZ(mtxtPrepPosition2.Text, "").ToString();
                    signa.SignFor      = preptag;
                    signalist.Add(signa);

                    //Reviewed By
                    signa              = new tbl_SIGNATORY();
                    signa.RecID        = minid + 4;
                    signa.SignName     = BPSUtilitiesV1.NZ(mtxtReviName1.Text, "").ToString();
                    signa.SignPosition = BPSUtilitiesV1.NZ(mtxtReviPosition1.Text, "").ToString();
                    signa.SignFor      = revitag;
                    signalist.Add(signa);

                    signa              = new tbl_SIGNATORY();
                    signa.RecID        = minid + 5;
                    signa.SignName     = BPSUtilitiesV1.NZ(mtxtReviName2.Text, "").ToString();
                    signa.SignPosition = BPSUtilitiesV1.NZ(mtxtReviPosition2.Text, "").ToString();
                    signa.SignFor      = revitag;
                    signalist.Add(signa);

                    foreach (tbl_SIGNATORY s in signalist)
                    {
                        s.ReportName  = this.Text;
                        s.UpdatedBy   = UserSettings.Username;
                        s.UpdatedDate = DateTime.Now;
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Esempio n. 26
0
        private void GetExclData(string FilePath)
        {
            try
            {
                using (FileStream stream = File.Open(FilePath, FileMode.Open, FileAccess.Read))
                {
                    reader = ExcelReaderFactory.CreateReader(stream);
                    DataSet dirty_result = reader.AsDataSet();
                    DataSet result       = reader.AsDataSet(
                        new ExcelDataSetConfiguration
                    {
                        ConfigureDataTable = _ => new ExcelDataTableConfiguration
                        {
                            UseHeaderRow  = true,
                            ReadHeaderRow = rowReader =>      // skip 3 rows
                            {
                                rowReader.Read();
                                rowReader.Read();
                                rowReader.Read();
                            }
                        }
                    }
                        );

                    if (result.Tables.Count > 0)
                    {
                        dttemp = new DataTable();
                        dttemp = dirty_result.Tables[0];

                        tmpdatalist = new List <tbl_tmp_H_ITEM_PART>();
                        List <tbl_tmp_H_ITEM_PART> tmpdatalist_cleaned = new List <tbl_tmp_H_ITEM_PART>();
                        tbl_tmp_H_ITEM_PART        tmpdata             = new tbl_tmp_H_ITEM_PART();
                        tmpdatalist = result.Tables[0].AsEnumerable().Select(r => new tbl_tmp_H_ITEM_PART
                        {
                            ItemAddress = BPSUtilitiesV1.NZ(r.Field <object>("ADDRESS"), "").ToString(),
                            PartNo      = BPSUtilitiesV1.NZ(r.Field <object>("CODE"), "").ToString(),
                            PartName    = BPSUtilitiesV1.NZ(r.Field <object>("PARTS NAME"), "").ToString(),
                            ItemUsage   = Usage(BPSUtilitiesV1.NZ(r.Field <object>("USAGE"), "1").ToString()),
                            Process     = BPSUtilitiesV1.NZ(r.Field <object>("PROCESS"), "").ToString(),
                            ItemVendor  = BPSUtilitiesV1.NZ(r.Field <object>("VENDOR"), "").ToString(),
                            Bagging     = BPSUtilitiesV1.NZ(r.Field <object>("PARTS NAME"), "").ToString()
                        }).ToList();
                        if (BPSolutionsTools.BPSUtilitiesV1.NZ(dttemp.Rows[1][6], "").ToString() != "")
                        {
                            tmpdata.ItemAddress = "";
                            tmpdata.PartNo      = dttemp.Rows[0][1].ToString();
                            tmpdata.PartName    = "FINAL PROCESS";
                            tmpdata.ItemUsage   = 1;
                            tmpdata.Process     = "_FP";
                            tmpdata.ItemVendor  = "";
                            tmpdata.Bagging     = "";
                            tmpdatalist_cleaned.Add(tmpdata);
                        }
                        foreach (tbl_tmp_H_ITEM_PART tc in tmpdatalist)
                        {
                            string strend = "REVISED PORTION";
                            if (tc.PartNo == strend || tc.PartName == strend || tc.Process == strend)
                            {
                                break;
                            }
                            if (tc.PartNo == null || tc.PartNo == "")
                            {
                                continue;
                            }
                            if (tc.ItemAddress.ToUpper() == "Y")
                            {
                                continue;
                            }
                            if (tc.ItemAddress == null || tc.ItemAddress == "")
                            {
                                continue;
                            }
                            tc.Bagging = Bagging(tc.ItemAddress);
                            tmpdatalist_cleaned.Add(tc);
                        }
                        if (tmpdatalist_cleaned.Count == 0)
                        {
                            throw new Exception("No Data Found!");
                        }
                        else
                        {
                            tmpcombal.Save(tmpdatalist_cleaned);
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Esempio n. 27
0
 private void AssignRecord(Boolean IsSave)
 {
     try
     {
         if (IsSave)
         {
             tbl_000_H_PI existpi = new tbl_000_H_PI();
             existpi = pibal.GetAll().Where(w => w.YEARUSED == UserSettings.LogInYear && w.MoldNo == mtxtMoldNo.Text).FirstOrDefault();
             if (existpi == null)
             {
                 pi.YEARUSED    = UserSettings.LogInYear;
                 pi.CreatedDate = DateTime.Now;
                 pi.CreatedBy   = UserSettings.Username;
                 pi.IsCopied    = false;
                 pi.CopyDate    = DateTime.Now;
                 pi.IsImported  = false;
                 pi.ImportDate  = DateTime.Now;
                 pi.ImportBy    = UserSettings.Username;
             }
             pi.MoldNo       = mtxtMoldNo.Text;
             pi.MoldName     = mtxtMoldName.Text;
             pi.Oz           = mtxtOz.Text;
             pi.Cavity       = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtCavity.Text, 0));
             pi.SPH          = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtSPH.Text, 0));
             pi.PPH          = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtPPH.Text, 0));
             pi.Cavity       = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtCavity.Text, 0));
             pi.MolSetUpTime = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtMoldSetupTime.Text, 0));
             pi.Usage        = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtUsage.Text, 0));
             pi.PurgePerG    = Convert.ToDecimal(BPSUtilitiesV1.NZ(mtxtPPG.Text, 0));
             pi.IsLocked     = mcbLocked.Checked;
             pi.UpdatedDate  = DateTime.Now;
             pi.UpdatedBy    = UserSettings.Username;
         }
         else
         {
             pi = pibal.GetByID(yearused, moldno);
             if (pi != null)
             {
                 mtxtMoldNo.Text        = pi.MoldNo;
                 mtxtMoldName.Text      = pi.MoldName;
                 mtxtOz.Text            = pi.Oz;
                 mtxtPPG.Text           = pi.PurgePerG.ToString();
                 mtxtSPH.Text           = Convert.ToInt32(pi.SPH).ToString();
                 mtxtCavity.Text        = Convert.ToInt32(pi.Cavity).ToString();
                 mtxtPPH.Text           = Convert.ToInt32(pi.PPH).ToString();
                 mtxtMoldSetupTime.Text = pi.MolSetUpTime.ToString();
                 mtxtUsage.Text         = Convert.ToInt32(pi.Usage).ToString();
                 mcbLocked.Checked      = pi.IsLocked;
                 pi.UpdatedDate         = DateTime.Now;
                 pi.UpdatedBy           = UserSettings.Username;
             }
             else
             {
                 throw new Exception("Record doesn't exist!");
             }
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Esempio n. 28
0
        private void Import()
        {
            List <tbl_000_H_PART>  write_list_com;
            List <tbl_000_H_PI>    write_list_pi;
            List <tbl_000_H_VP>    write_list_vp;
            List <tbl_000_H_ASSY>  write_list_assy;
            List <tbl_000_PROCESS> write_list_proc;

            try
            {
                GetExclData(mtxtFilePath.Text);

                if (!mcbOverWrite.Checked)
                {
                    msg = "This process will import previous components from the selected year to the current logged in year. Do you want to continue?";
                    if (MessageHelpers.ShowQuestion(msg) == DialogResult.Yes)
                    {
                        switch (YearSource)
                        {
                            #region Components to Import
                        case YearsOf.Components:
                            write_list_com = new List <tbl_000_H_PART>();
                            var currentyear_list_com = combal.GetByYear(UserSettings.LogInYear).ToList();
                            //Matching by 'PartNo' or 'PartName'
                            foreach (tbl_000_H_PART c in currentyear_list_com)
                            {
                                write_list_com.Add(combal.GetAll().Where(w => w.YEARUSED == UserSettings.LogInYear && (w.PartNo == c.PartNo || w.PartName == c.PartName)).FirstOrDefault());
                            }
                            //Remove columns from excell if it exists in current year
                            foreach (tbl_000_H_PART c in write_list_com)
                            {
                                if (c != null)
                                {
                                    comlist.RemoveAll(r => r.PartNo == c.PartNo || r.PartName == c.PartName);
                                }
                            }
                            //Fill some Columns and Save them
                            Save_com();
                            break;

                            #endregion
                            #region Tabulation to Import
                        case YearsOf.MaintainanceTable:
                            switch (YearofMaintenanceTable_Sub)
                            {
                            case MaintainanceTableSub.PlasticInjection:
                                write_list_pi = new List <tbl_000_H_PI>();
                                var currentyear_list_pi = pibal.GetByYear(UserSettings.LogInYear).ToList();
                                foreach (tbl_000_H_PI p in currentyear_list_pi)
                                {
                                    write_list_pi.Add(pibal.GetAll().Where(w => w.YEARUSED == UserSettings.LogInYear && (w.MoldNo == p.MoldNo || w.MoldName == p.MoldName)).FirstOrDefault());
                                }
                                foreach (tbl_000_H_PI p in write_list_pi)
                                {
                                    if (p != null)
                                    {
                                        pilist.RemoveAll(r => r.MoldNo == p.MoldNo || r.MoldName == p.MoldName);
                                    }
                                }
                                Save_pi();
                                break;

                            case MaintainanceTableSub.VacuumPlating:
                                write_list_vp = new List <tbl_000_H_VP>();
                                var currentyear_list_vp = vpbal.GetByYear(UserSettings.LogInYear).ToList();
                                foreach (tbl_000_H_VP v in currentyear_list_vp)
                                {
                                    write_list_vp.Add(vpbal.GetAll().Where(w => w.YEARUSED == UserSettings.LogInYear && (w.PartNo == v.PartNo || w.PartName == v.PartName)).FirstOrDefault());
                                }
                                foreach (tbl_000_H_VP v in write_list_vp)
                                {
                                    if (v != null)
                                    {
                                        vplist.RemoveAll(r => r.PartNo == v.PartNo || r.PartName == v.PartName);
                                    }
                                }
                                Save_vp();
                                break;

                            case MaintainanceTableSub.Assembly:
                                write_list_assy = new List <tbl_000_H_ASSY>();
                                var currentyear_list_assy = assybal.GetByYear(UserSettings.LogInYear).ToList();
                                foreach (tbl_000_H_ASSY a in currentyear_list_assy)
                                {
                                    write_list_assy.Add(assybal.GetAll().Where(w => w.YEARUSED == UserSettings.LogInYear && (w.PartNo == a.PartNo || w.PartName == a.PartName)).FirstOrDefault());
                                }
                                foreach (tbl_000_H_ASSY a in write_list_assy)
                                {
                                    if (a != null)
                                    {
                                        assylist.RemoveAll(r => r.PartNo == a.PartNo || r.PartName == a.PartName);
                                    }
                                }
                                Save_assy();
                                break;
                            }
                            break;

                            #endregion
                            #region Process to Import
                        case YearsOf.ProcessSetup:
                            write_list_proc = new List <tbl_000_PROCESS>();
                            var currentyear_list_proc = procbal.GetByYear(UserSettings.LogInYear).ToList();
                            foreach (tbl_000_PROCESS p in currentyear_list_proc)
                            {
                                write_list_proc.Add(procbal.GetAll().Where(w => w.YEARUSED == UserSettings.LogInYear && (w.SubProcessCode == p.SubProcessCode || w.ItemDescription == p.ItemDescription)).FirstOrDefault());
                            }
                            foreach (tbl_000_PROCESS p in write_list_proc)
                            {
                                if (p != null)
                                {
                                    proclist.RemoveAll(r => r.SubProcessCode == p.SubProcessCode || r.ItemDescription == p.ItemDescription);
                                }
                            }
                            Save_proc();
                            break;
                            #endregion
                        }
                    }
                }
                else
                {
                    msg = "This process will remove the existing components and replace it with the selected year. Do you want to continue?";
                    if (MessageHelpers.ShowQuestion(msg) == DialogResult.Yes)
                    {
                        switch (YearSource)
                        {
                            #region Components to Import with Overwrite
                        case YearsOf.Components:
                            write_list_com = new List <tbl_000_H_PART>();
                            //Matching by 'PartNo' or 'PartName'
                            foreach (tbl_000_H_PART c in comlist)
                            {
                                write_list_com.Add(combal.GetAll().Where(w => w.YEARUSED == UserSettings.LogInYear && (w.PartNo == c.PartNo || w.PartName == c.PartName)).FirstOrDefault());
                            }
                            //Delete the records to be Overwritten
                            if (BPSUtilitiesV1.NZ(write_list_com, "").ToString() != "")
                            {
                                foreach (tbl_000_H_PART c in write_list_com)
                                {
                                    if (c != null)
                                    {
                                        combal.Delete(c);
                                    }
                                }
                            }
                            //Fill some Columns and Save them
                            Save_com();
                            break;

                            #endregion
                            #region Tabulation to import with Overwrite
                        case YearsOf.MaintainanceTable:
                            switch (YearofMaintenanceTable_Sub)
                            {
                            case MaintainanceTableSub.PlasticInjection:
                                write_list_pi = new List <tbl_000_H_PI>();
                                foreach (tbl_000_H_PI p in pilist)
                                {
                                    write_list_pi.Add(pibal.GetAll().Where(w => w.YEARUSED == UserSettings.LogInYear && (w.MoldNo == p.MoldNo || w.MoldName == p.MoldName)).FirstOrDefault());
                                }
                                if (BPSUtilitiesV1.NZ(write_list_pi, "").ToString() != "")
                                {
                                    foreach (tbl_000_H_PI p in write_list_pi)
                                    {
                                        if (p != null)
                                        {
                                            pibal.Delete(p);
                                        }
                                    }
                                }
                                Save_pi();
                                break;

                            case MaintainanceTableSub.VacuumPlating:
                                write_list_vp = new List <tbl_000_H_VP>();
                                foreach (tbl_000_H_VP v in vplist)
                                {
                                    write_list_vp.Add(vpbal.GetAll().Where(w => w.YEARUSED == UserSettings.LogInYear && (w.PartNo == v.PartNo || w.PartName == v.PartName)).FirstOrDefault());
                                }
                                if (BPSUtilitiesV1.NZ(write_list_vp, "").ToString() != "")
                                {
                                    foreach (tbl_000_H_VP v in write_list_vp)
                                    {
                                        if (v != null)
                                        {
                                            vpbal.Delete(v);
                                        }
                                    }
                                }
                                Save_vp();
                                break;

                            case MaintainanceTableSub.Assembly:
                                write_list_assy = new List <tbl_000_H_ASSY>();
                                foreach (tbl_000_H_ASSY a in assylist)
                                {
                                    write_list_assy.Add(assybal.GetAll().Where(w => w.YEARUSED == UserSettings.LogInYear && (w.PartNo == a.PartNo || w.PartName == a.PartName)).FirstOrDefault());
                                }
                                if (BPSUtilitiesV1.NZ(write_list_assy, "").ToString() != "")
                                {
                                    foreach (tbl_000_H_ASSY a in write_list_assy)
                                    {
                                        if (a != null)
                                        {
                                            assybal.Delete(a);
                                        }
                                    }
                                }
                                Save_assy();
                                break;
                            }
                            break;

                            #endregion
                            #region Process to Import with Overwrite
                        case YearsOf.ProcessSetup:
                            write_list_proc = new List <tbl_000_PROCESS>();
                            List <tbl_000_PROCESS> todelete_proc = new List <tbl_000_PROCESS>();
                            foreach (tbl_000_PROCESS p in proclist)
                            {
                                write_list_proc.Add(procbal.GetAll().Where(w => w.YEARUSED == UserSettings.LogInYear && (w.SubProcessCode == p.SubProcessCode || w.ItemDescription == p.ItemDescription)).FirstOrDefault());
                            }
                            if (BPSUtilitiesV1.NZ(write_list_proc, "").ToString() != "")
                            {
                                foreach (tbl_000_PROCESS p in write_list_proc)
                                {
                                    if (p != null)
                                    {
                                        todelete_proc.Add(p);
                                    }
                                }
                                procbal.Delete(todelete_proc);
                            }
                            Save_proc();
                            break;
                            #endregion
                        }
                    }
                }
                this.Close();
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Esempio n. 29
0
 public Boolean Save_List(List <tbl_000_H_ITEM> record_list)
 {
     using (var dbContextTransaction = db.Database.BeginTransaction())
     {
         try
         {
             foreach (tbl_000_H_ITEM record in record_list)
             {
                 if (BPSUtilitiesV1.NZ(record.itemCom, "").ToString() != "")
                 {
                     foreach (tbl_000_H_ITEM_PART item in record.itemCom)
                     {
                         db.ItemPartList.Add(item);
                         db.SaveChanges();
                     }
                 }
                 if (BPSUtilitiesV1.NZ(record.itemPI, "").ToString() != "")
                 {
                     foreach (tbl_000_H_ITEM_TABULATION item in record.itemPI)
                     {
                         db.ItemTabulationPIList.Add(item);
                         db.SaveChanges();
                     }
                 }
                 if (BPSUtilitiesV1.NZ(record.itemVP, "").ToString() != "")
                 {
                     foreach (tbl_000_H_ITEM_TABULATION_VP item in record.itemVP)
                     {
                         db.ItemTabulationVPList.Add(item);
                         db.SaveChanges();
                     }
                 }
                 if (BPSUtilitiesV1.NZ(record.itemAssy, "").ToString() != "")
                 {
                     foreach (tbl_000_H_ITEM_TABULATION_ASSY item in record.itemAssy)
                     {
                         db.ItemTabulationAssyList.Add(item);
                         db.SaveChanges();
                     }
                 }
                 if (BPSUtilitiesV1.NZ(record.itemMPT, "").ToString() != "")
                 {
                     foreach (tbl_000_H_ITEM_MPT item in record.itemMPT)
                     {
                         db.ItemMPTList.Add(item);
                         db.SaveChanges();
                     }
                 }
                 if (BPSUtilitiesV1.NZ(record.itemFDC, "").ToString() != "")
                 {
                     foreach (tbl_000_H_ITEM_FDC item in record.itemFDC)
                     {
                         db.ItemFDCList.Add(item);
                         db.SaveChanges();
                     }
                 }
                 db.ItemList.Add(record);
             }
             db.SaveChanges();
             dbContextTransaction.Commit();
             return(true);
         }
         catch (Exception ex)
         {
             dbContextTransaction.Rollback();
             throw ex;
         }
     }
 }
Esempio n. 30
0
 public Boolean Update(tbl_000_H_ITEM record)
 {
     using (var dbContextTransaction = db.Database.BeginTransaction())
     {
         try
         {
             if (BPSUtilitiesV1.NZ(record.itemCom, "").ToString() != "")
             {
                 foreach (tbl_000_H_ITEM_PART item in record.itemCom)
                 {
                     if (item.state == "update")
                     {
                         db.Entry(item).State = EntityState.Modified;
                         db.SaveChanges();
                     }
                     else if (item.state == "add")
                     {
                         db.ItemPartList.Add(item);
                         db.SaveChanges();
                     }
                 }
             }
             if (BPSUtilitiesV1.NZ(record.itemPI, "").ToString() != "")
             {
                 foreach (tbl_000_H_ITEM_TABULATION item in record.itemPI)
                 {
                     if (item.state == "update")
                     {
                         db.Entry(item).State = EntityState.Modified;
                         db.SaveChanges();
                     }
                     else if (item.state == "add")
                     {
                         db.ItemTabulationPIList.Add(item);
                         db.SaveChanges();
                     }
                 }
             }
             if (BPSUtilitiesV1.NZ(record.itemVP, "").ToString() != "")
             {
                 foreach (tbl_000_H_ITEM_TABULATION_VP item in record.itemVP)
                 {
                     if (item.state == "update")
                     {
                         db.Entry(item).State = EntityState.Modified;
                         db.SaveChanges();
                     }
                     else if (item.state == "add")
                     {
                         db.ItemTabulationVPList.Add(item);
                         db.SaveChanges();
                     }
                 }
             }
             if (BPSUtilitiesV1.NZ(record.itemAssy, "").ToString() != "")
             {
                 foreach (tbl_000_H_ITEM_TABULATION_ASSY item in record.itemAssy)
                 {
                     if (item.state == "update")
                     {
                         db.Entry(item).State = EntityState.Modified;
                         db.SaveChanges();
                     }
                     else if (item.state == "add")
                     {
                         db.ItemTabulationAssyList.Add(item);
                         db.SaveChanges();
                     }
                 }
             }
             if (BPSUtilitiesV1.NZ(record.itemMPT, "").ToString() != "")
             {
                 foreach (tbl_000_H_ITEM_MPT item in record.itemMPT)
                 {
                     if (item.state == "update")
                     {
                         db.Entry(item).State = EntityState.Modified;
                         db.SaveChanges();
                     }
                     else if (item.state == "add")
                     {
                         db.ItemMPTList.Add(item);
                         db.SaveChanges();
                     }
                 }
             }
             if (BPSUtilitiesV1.NZ(record.itemFDC, "").ToString() != "")
             {
                 foreach (tbl_000_H_ITEM_FDC item in record.itemFDC)
                 {
                     if (item.state == "update")
                     {
                         db.Entry(item).State = EntityState.Modified;
                         db.SaveChanges();
                     }
                     else if (item.state == "add")
                     {
                         db.ItemFDCList.Add(item);
                         db.SaveChanges();
                     }
                 }
             }
             db.Entry(record).State = EntityState.Modified;
             db.SaveChanges();
             dbContextTransaction.Commit();
             return(true);
         }
         catch (Exception ex)
         {
             dbContextTransaction.Rollback();
             throw ex;
         }
     }
 }