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 ControlSalesEnquiryDesignBOQ()
{
InitializeComponent();
ENTITY = APP_ENTITIES.SALES_ENQUIRY;
MODEL = new SalesEnquiryDesignBOQViewModel();
MODEL.ENQUIRY_ID = this.SalesEnquiryID;
tabBOQSheets.Pages.Clear();
}
private void CreateDefaultBOQSheet()
{
try
{
MODEL = new SalesEnquiryDesignBOQViewModel();
ServiceSalesEnquiryBOQ serviceDesignBOQ = new ServiceSalesEnquiryBOQ();
MODEL.ENQUIRY_ID = this.SalesEnquiryID;
SalesEnquiryDesignBOQSheet newSheet = new SalesEnquiryDesignBOQSheet();
newSheet.SheetName = "Default".ToUpper();
newSheet.SheetDescription = string.Empty;
newSheet.BOQ_SERVICES = new BindingList <EnquiryBOQService>();
newSheet.BOQ_ITEMS = new BindingList <EnquiryBOQItem>();
if (newSheet.datatableBOQ == null)
{
newSheet.datatableBOQ = serviceDesignBOQ.GenerateBOQDataTableDefault();
}
newSheet.datatableBOQ = serviceDesignBOQ.GenerateDesignBOQDataTableWithServices(newSheet.datatableBOQ, newSheet.BOQ_SERVICES, newSheet.BOQ_ITEMS);
MODEL.SHEETS.Add(newSheet);
KryptonPage pageBOQSheet = new KryptonPage()
{
Text = newSheet.SheetName, Name = string.Format("page{0}", tabBOQSheets.Pages.Count + 1)
};
ControlSalesEnquiryDesignBOQSheet _sheetControl = new ControlSalesEnquiryDesignBOQSheet(newSheet);
pageBOQSheet.Controls.Add(_sheetControl);
_sheetControl.ParentTabPage = pageBOQSheet;
_sheetControl.Dock = DockStyle.Fill;
tabBOQSheets.Pages.Add(pageBOQSheet);
_sheetControl.PopulateBOQItemsGrid();
tabBOQSheets.SelectedPage = pageBOQSheet;
_sheetControl.Visible = true;
_sheetControl.SetBOQItemsGridColumnSizes();
if (!_ReadOnly)
{
btnAddNewBOQSheet.Enabled = btnSaveBOQ.Enabled = ButtonEnabled.True;
}
_sheetControl.ReadOnly = this.ReadOnly;
}
catch (Exception ex)
{
string errMessage = ex.Message;
if (ex.InnerException != null)
{
errMessage += string.Format("\n{0}", ex.InnerException.Message);
}
}
}
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);
}
