public ProjectGeneralInfo GetProjectGeneralInfo(int ProjID) { ProjectGeneralInfo model = null; try { TBL_MP_PMC_ProjectMaster dbmodel = _dbContext.TBL_MP_PMC_ProjectMaster.Where(x => x.PK_ProjectID == ProjID).FirstOrDefault(); if (dbmodel != null) { model = new ProjectGeneralInfo(); model.ProjectID = dbmodel.PK_ProjectID; model.ProjectCode = dbmodel.ProjectNumber; model.ProjectName = dbmodel.ProjectName; if (dbmodel.ProjectDate != null) { model.EntryDate = (DateTime)dbmodel.ProjectDate; } else { model.EntryDate = null; } if (dbmodel.StartDate != null) { model.StartDate = (DateTime)dbmodel.StartDate; } else { model.StartDate = null; } if (dbmodel.EndDate != null) { model.EndDate = (DateTime)dbmodel.EndDate; } else { model.EndDate = null; } model.ProjectStatus = dbmodel.FK_ProjectStatusID.ToString(); model.BillingClientID = (int)dbmodel.BillingClientID; model.BillingClientAddressID = dbmodel.BillingClientAddressID; model.SiteClientID = (int)dbmodel.SiteClientID; model.SiteClientAddressID = dbmodel.SiteClientAddressID; model.IsActive = dbmodel.IsActive; } } catch (Exception ex) { string errMessage = ex.Message; if (ex.InnerException != null) { errMessage += string.Format("\n{0}", ex.InnerException.Message); } MessageBox.Show(errMessage, "ServiceProject::GetProjectGeneralInfo", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(model); }
public bool SetProjectGeneralInfo(ProjectGeneralInfo model) { bool result = false; try { TBL_MP_PMC_ProjectMaster dbModel = _dbContext.TBL_MP_PMC_ProjectMaster.Where(x => x.PK_ProjectID == model.ProjectID).FirstOrDefault(); if (dbModel != null) { dbModel.ProjectNumber = model.ProjectCode; dbModel.ProjectName = model.ProjectName; dbModel.ProjectDate = (DateTime)model.EntryDate; dbModel.StartDate = (DateTime)model.StartDate; dbModel.EndDate = (DateTime)model.EndDate; dbModel.BillingClientID = model.BillingClientID; dbModel.BillingClientAddressID = model.BillingClientAddressID; dbModel.SiteClientID = model.SiteClientID; dbModel.SiteClientAddressID = model.SiteClientAddressID; dbModel.FK_ProjectStatusID = int.Parse(model.ProjectStatus); dbModel.IsActive = model.IsActive; _dbContext.SaveChanges(); result = true; } } catch (Exception ex) { string errMessage = ex.Message; if (ex.InnerException != null) { errMessage += string.Format("\n{0}", ex.InnerException.Message); } MessageBox.Show(errMessage, "ServiceProject::SetProjectGeneralInfo", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(result); }