public void PopulateDesingBOQ() { MODEL = null; tabBOQSheets.Pages.Clear(); this.Cursor = Cursors.WaitCursor; try { headerBOQMenu.Values.Heading = String.Empty; TBL_MP_CRM_SalesEnquiry_BOQ dbModel = (new ServiceSalesEnquiryBOQ()).GetDesignBOQdbInfo(this.SalesEnquiryID); if (dbModel != null) { MODEL = JsonConvert.DeserializeObject <SalesEnquiryDesignBOQViewModel>(dbModel.BOQ_DESIGN_OBJECT); if (MODEL != null) // DRAW ALL SHEETS { MODEL.BOQ_ID = dbModel.DESIGN_BOQ_ID; MODEL.BOQ_NUMBER = dbModel.BOQ_NUMBER; MODEL.ENQUIRY_ID = dbModel.ENQUIRY_ID; headerBOQMenu.Values.Heading = MODEL.BOQ_NUMBER; foreach (SalesEnquiryDesignBOQSheet sheet in MODEL.SHEETS) { KryptonPage pageBOQSheet = new KryptonPage() { Text = sheet.SheetName, Name = string.Format("page{0}", tabBOQSheets.Pages.Count + 1) }; ControlSalesEnquiryDesignBOQSheet _sheetControl = new ControlSalesEnquiryDesignBOQSheet(sheet); pageBOQSheet.Controls.Add(_sheetControl); _sheetControl.Dock = DockStyle.Fill; tabBOQSheets.Pages.Add(pageBOQSheet); _sheetControl.ParentTabPage = pageBOQSheet; _sheetControl.PopulateBOQItemsGrid(); tabBOQSheets.SelectedPage = pageBOQSheet; _sheetControl.Visible = true; _sheetControl.ReadOnly = this.ReadOnly; //_sheetControl.SetBOQItemsGridColumnSizes(); _sheetControl.SetBOQItemsGridColumnSizes(); } } } else { CreateDefaultBOQSheet(); } foreach (KryptonPage page in tabBOQSheets.Pages) { ControlSalesEnquiryDesignBOQSheet sheet = (ControlSalesEnquiryDesignBOQSheet)page.Controls[0]; sheet.SetBOQItemsGridColumnSizes(); } } catch (Exception ex) { string errMessage = ex.Message; if (ex.InnerException != null) { errMessage += string.Format("\n{0}", ex.InnerException.Message); } MessageBox.Show(errMessage, "ControlSalesEnquiryDesignBOQ::PopulateDesingBOQ", MessageBoxButtons.OK, MessageBoxIcon.Error); } this.Cursor = Cursors.Default; }
public SalesEnquiryDesignBOQViewModel SaveDesignBOQ(SalesEnquiryDesignBOQViewModel MODEL, int empID) { try { if (MODEL.BOQ_ID == 0) { TBL_MP_CRM_SalesEnquiry_BOQ newBOQ = new TBL_MP_CRM_SalesEnquiry_BOQ(); newBOQ.ENQUIRY_ID = MODEL.ENQUIRY_ID; newBOQ.BOQ_DESIGN_OBJECT_CREATED_BY = empID; newBOQ.BOQ_DESIGN_OBJECT_CREATED_DATE = AppCommon.GetServerDateTime(); newBOQ.BOQ_NUMBER = this.GenerateDesignBOQNumber(MODEL.ENQUIRY_ID); _dbContext.TBL_MP_CRM_SalesEnquiry_BOQ.Add(newBOQ); _dbContext.SaveChanges(); MODEL.BOQ_ID = newBOQ.DESIGN_BOQ_ID; } // REINSTANCIATE BOQ ITEMS COLLECTION foreach (SalesEnquiryDesignBOQSheet sheet in MODEL.SHEETS) { sheet.BOQ_ITEMS = new BindingList <EnquiryBOQItem>(); } string output = JsonConvert.SerializeObject(MODEL); TBL_MP_CRM_SalesEnquiry_BOQ editBOQ = _dbContext.TBL_MP_CRM_SalesEnquiry_BOQ.Where(x => x.DESIGN_BOQ_ID == MODEL.BOQ_ID).FirstOrDefault(); editBOQ.BOQ_DESIGN_OBJECT = output; _dbContext.SaveChanges(); } catch (Exception ex) { MessageBox.Show(ex.Message, "ServiceSalesEnquiryBOQ::SaveDesignBOQ", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(MODEL); }
public TBL_MP_CRM_SalesEnquiry_BOQ GetDesignBOQdbInfo(int SelectedID) { TBL_MP_CRM_SalesEnquiry_BOQ model = null; try { model = (from xx in _dbContext.TBL_MP_CRM_SalesEnquiry_BOQ where xx.ENQUIRY_ID == SelectedID select xx).FirstOrDefault(); } catch (Exception ex) { string errMessage = ex.Message; if (ex.InnerException != null) { errMessage += string.Format("\n{0}", ex.InnerException.Message); } MessageBox.Show(errMessage, "ServiceSalesEnquiryBOQ::GetDesignBOQdbInfo", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(model); }
public SalesEnquiryDesignBOQViewModel GetDesignBOQModel(int boqID) { SalesEnquiryDesignBOQViewModel model = new SalesEnquiryDesignBOQViewModel(); try { TBL_MP_CRM_SalesEnquiry_BOQ dbModel = _dbContext.TBL_MP_CRM_SalesEnquiry_BOQ.Where(x => x.DESIGN_BOQ_ID == boqID).FirstOrDefault(); if (dbModel != null) { string json = dbModel.BOQ_DESIGN_OBJECT; model = JsonConvert.DeserializeObject <SalesEnquiryDesignBOQViewModel>(json); } } catch (Exception ex) { MessageBox.Show(ex.Message, "ServiceSalesEnquiryBOQ::GetDesignBOQModel", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(model); }