public MProjectPresentationStub(m_project dbItem) { this.Id = dbItem.id; this.Name = dbItem.name; this.ContractorId = dbItem.contractor_id; this.Photo = dbItem.photo; this.Description = dbItem.description; this.StartDate = dbItem.start_date; this.FinishDate = dbItem.finish_date; this.Highlight = dbItem.highlight; this.ProjectStage = dbItem.project_stage; this.Status = dbItem.status; this.Budget = dbItem.budget; this.Currency = dbItem.currency; this.Num = dbItem.num; this.PmcId = dbItem.pmc_id; this.Summary = dbItem.summary; this.CompanyId = dbItem.company_id; this.StatusNonTechnical = dbItem.status_non_technical; this.IsCompleted = dbItem.is_completed; this.CompletedDate = dbItem.completed_date; this.ProjectId = dbItem.project_id; this.SubmitForApprovalTime = dbItem.submit_for_approval_time; this.ApprovalStatus = dbItem.approval_status; this.ApprovalTime = dbItem.approval_time; this.Deleted = dbItem.deleted; this.ApprovalMessage = dbItem.approval_message; this.StatusTechnical = dbItem.status_technical; this.ScurveData = dbItem.scurve_data; this.CompanyName = dbItem.company != null ? dbItem.company.name : ""; this.ContractorName = dbItem.contractor != null ? dbItem.contractor.name : ""; this.ProjectName = dbItem.project != null ? dbItem.project.name : ""; }
public ActionResult Create(MProjectFormStub model) { //bool isNameExist = RepoMProject.Find().Where(p => p.name == model.Name).Count() > 0; if (ModelState.IsValid) { m_project dbItem = new m_project(); dbItem = model.GetDbObject(dbItem); try { RepoMProject.Save(dbItem); } catch (Exception e) { model.FillCompanyOptions(RepoCompany.FindAll()); model.FillContractorOptions(RepoContractor.FindAll()); model.FillProjectOptions(RepoProject.FindAll()); return(View("Form", model)); } //message string template = HttpContext.GetGlobalResourceObject("MyGlobalMessage", "CreateSuccess").ToString(); this.SetMessage(model.Name, template); return(RedirectToAction("Index")); } else { model.FillCompanyOptions(RepoCompany.FindAll()); model.FillContractorOptions(RepoContractor.FindAll()); model.FillProjectOptions(RepoProject.FindAll()); return(View("Form", model)); } }
public m_project GetDbObject(m_project dbItem) { dbItem.id = this.Id; dbItem.name = this.Name; dbItem.contractor_id = this.ContractorId; dbItem.photo = this.Photo; dbItem.description = this.Description; dbItem.start_date = this.StartDate; dbItem.finish_date = this.FinishDate; dbItem.highlight = this.Highlight; dbItem.project_stage = this.ProjectStage; dbItem.status = this.Status; dbItem.budget = this.Budget; dbItem.currency = this.Currency; dbItem.num = this.Num; dbItem.pmc_id = this.PmcId; dbItem.summary = this.Summary; dbItem.company_id = this.CompanyId; dbItem.status_non_technical = this.StatusNonTechnical; dbItem.is_completed = this.IsCompleted; dbItem.completed_date = this.CompletedDate; dbItem.project_id = this.ProjectId; dbItem.submit_for_approval_time = this.SubmitForApprovalTime; dbItem.approval_status = this.ApprovalStatus; dbItem.approval_time = this.ApprovalTime; dbItem.deleted = this.Deleted; dbItem.approval_message = this.ApprovalMessage; dbItem.status_technical = this.StatusTechnical; dbItem.scurve_data = this.ScurveData; return(dbItem); }
public MProjectFormStub(m_project dbItem, List <Business.Entities.company> listCompany, List <Business.Entities.contractor> listContractor, List <Business.Entities.project> listProject) : this(listCompany, listContractor, listProject) { this.Id = dbItem.id; this.Name = dbItem.name; this.ContractorId = dbItem.contractor_id; this.Photo = dbItem.photo; this.Description = dbItem.description; this.StartDate = dbItem.start_date; this.FinishDate = dbItem.finish_date; this.Highlight = dbItem.highlight; this.ProjectStage = dbItem.project_stage; this.Status = dbItem.status; this.Budget = dbItem.budget; this.Currency = dbItem.currency; this.Num = dbItem.num; this.PmcId = dbItem.pmc_id; this.Summary = dbItem.summary; this.CompanyId = dbItem.company_id; this.StatusNonTechnical = dbItem.status_non_technical; this.IsCompleted = dbItem.is_completed; this.CompletedDate = dbItem.completed_date; this.ProjectId = dbItem.project_id; this.SubmitForApprovalTime = dbItem.submit_for_approval_time; this.ApprovalStatus = dbItem.approval_status; this.ApprovalTime = dbItem.approval_time; this.Deleted = dbItem.deleted; this.ApprovalMessage = dbItem.approval_message; this.StatusTechnical = dbItem.status_technical; this.ScurveData = dbItem.scurve_data; }
public ActionResult ImportExcel(MProjectImportExcelStub model) { if (ModelState.IsValid) { XSSFSheet sheet; int colCount; int rowCount; int startRow = 3; int colNum; int id; List <string> messageList = new List <string>(); string currentFilePathInServer = Server.MapPath(model.ExcelFilePath); XSSFWorkbook book; try { using (FileStream file = new FileStream(currentFilePathInServer, FileMode.Open, FileAccess.Read)) { book = new XSSFWorkbook(file); } sheet = (XSSFSheet)book.GetSheet("Data"); rowCount = sheet.LastRowNum; colNum = 0; id = 0; bool allowSave = true; for (int row = startRow; row <= rowCount; row++) { colNum = 0; var dt = (XSSFCell)sheet.GetRow(row).GetCell(colNum); if (dt != null) { allowSave = true; sheet.GetRow(row).GetCell(colNum).SetCellType(CellType.String); if (sheet.GetRow(row).GetCell(colNum).StringCellValue != "") { m_project insertData = new m_project(); m_project filledData = this.FillDataFromExcel(insertData, sheet, row, colNum, ref messageList, ref allowSave); if (allowSave == true) { RepoMProject.Save(filledData); } } } } } catch (Exception e) { messageList.Add("An error has occurred. Please contact administrator."); } ViewBag.MessageList = messageList; return(View("ImportExcelForm", model)); //return ret; } else { ViewBag.MessageList = null; return(View("ImportExcelForm", model)); } }
public JsonResult Delete(int id) { string template = ""; ResponseModel response = new ResponseModel(true); m_project dbItem = RepoMProject.FindByPk(id); RepoMProject.Delete(dbItem); return(Json(response)); }
public ActionResult Edit(int id) { m_project m_project = RepoMProject.FindByPk(id); List <Business.Entities.company> listCompany = RepoCompany.FindAll(); List <Business.Entities.contractor> listContractor = RepoContractor.FindAll(); List <Business.Entities.project> listProject = RepoProject.FindAll(); MProjectFormStub formStub = new MProjectFormStub(m_project, listCompany, listContractor, listProject); return(View("Form", formStub)); }
public void Save(m_project dbItem) { if (dbItem.id == 0) //create { context.m_project.Add(dbItem); } else //edit { var entry = context.Entry(dbItem); entry.State = EntityState.Modified; } context.SaveChanges(); }
public int GetIdByNameAndInsert(string name) { int id; m_project data = (from a in context.m_project where a.name == name select a).FirstOrDefault(); if (data == null) { //Uncomment the following function if inserting new data by using just name is possible //m_project insert = new m_project(); //insert.name = name; //context.m_project.Add(insert); //context.SaveChanges(); //id = insert.id; id = 0; } else { id = data.id; } return(id); }
private m_project FillDataFromExcel(m_project insertData, XSSFSheet sheet, int row, int colNum, ref List <string> messageList, ref bool allowSave) { bool test; var dt = (XSSFCell)sheet.GetRow(row).GetCell(colNum); //required non-foreign key Name (string) colNum = 0; dt = (XSSFCell)sheet.GetRow(row).GetCell(colNum); if (dt != null) { sheet.GetRow(row).GetCell(colNum).SetCellType(CellType.String); if (sheet.GetRow(row).GetCell(colNum).StringCellValue != String.Empty) { insertData.name = sheet.GetRow(row).GetCell(colNum).StringCellValue; } else { allowSave = false; messageList.Add(GetExcelMessage(row, "Name", "Must be filled")); } } //optional foreign key Contractor Id colNum = 1; dt = (XSSFCell)sheet.GetRow(row).GetCell(colNum); if (dt != null) { sheet.GetRow(row).GetCell(colNum).SetCellType(CellType.String); if (sheet.GetRow(row).GetCell(colNum).StringCellValue != String.Empty) { //insertData.contractor_id = RepoContractor.GetIdByNameAndInsert(sheet.GetRow(row).GetCell(colNum).StringCellValue); //if(insertData.contractor_id == 0) //{ // allowSave = false; // messageList.Add(GetExcelMessage(row, "Contractor", "Does not exist")); //} } } //required non-foreign key Photo (string) colNum = 2; dt = (XSSFCell)sheet.GetRow(row).GetCell(colNum); if (dt != null) { sheet.GetRow(row).GetCell(colNum).SetCellType(CellType.String); if (sheet.GetRow(row).GetCell(colNum).StringCellValue != String.Empty) { insertData.photo = sheet.GetRow(row).GetCell(colNum).StringCellValue; } else { allowSave = false; messageList.Add(GetExcelMessage(row, "Photo", "Must be filled")); } } //required non-foreign key Description (string) colNum = 3; dt = (XSSFCell)sheet.GetRow(row).GetCell(colNum); if (dt != null) { sheet.GetRow(row).GetCell(colNum).SetCellType(CellType.String); if (sheet.GetRow(row).GetCell(colNum).StringCellValue != String.Empty) { insertData.description = sheet.GetRow(row).GetCell(colNum).StringCellValue; } else { allowSave = false; messageList.Add(GetExcelMessage(row, "Description", "Must be filled")); } } //required non-foreign key Start Date (System.DateTime) colNum = 4; dt = (XSSFCell)sheet.GetRow(row).GetCell(colNum); if (dt != null) { sheet.GetRow(row).GetCell(colNum).SetCellType(CellType.String); if (sheet.GetRow(row).GetCell(colNum).StringCellValue != String.Empty) { DateTime dateVal; double dateOA; test = Double.TryParse(sheet.GetRow(row).GetCell(colNum).StringCellValue, out dateOA); if (test == false) { allowSave = false; messageList.Add(GetExcelMessage(row, "Start Date", "Invalid value")); } else { test = DateTime.TryParse(DateTime.FromOADate(dateOA).ToString(), out dateVal); insertData.start_date = dateVal; } } else { allowSave = false; messageList.Add(GetExcelMessage(row, "Start Date", "Must be filled")); } } //required non-foreign key Finish Date (System.DateTime) colNum = 5; dt = (XSSFCell)sheet.GetRow(row).GetCell(colNum); if (dt != null) { sheet.GetRow(row).GetCell(colNum).SetCellType(CellType.String); if (sheet.GetRow(row).GetCell(colNum).StringCellValue != String.Empty) { DateTime dateVal; double dateOA; test = Double.TryParse(sheet.GetRow(row).GetCell(colNum).StringCellValue, out dateOA); if (test == false) { allowSave = false; messageList.Add(GetExcelMessage(row, "Finish Date", "Invalid value")); } else { test = DateTime.TryParse(DateTime.FromOADate(dateOA).ToString(), out dateVal); insertData.finish_date = dateVal; } } else { allowSave = false; messageList.Add(GetExcelMessage(row, "Finish Date", "Must be filled")); } } //optional non-foreign key Highlight (bool?) colNum = 6; dt = (XSSFCell)sheet.GetRow(row).GetCell(colNum); if (dt != null) { sheet.GetRow(row).GetCell(colNum).SetCellType(CellType.String); if (sheet.GetRow(row).GetCell(colNum).StringCellValue != String.Empty) { string boolValue = sheet.GetRow(row).GetCell(colNum).StringCellValue; if (boolValue.ToLower() != "yes" && boolValue.ToLower() != "no") { allowSave = false; messageList.Add(GetExcelMessage(row, "Highlight", "Must be filled with Yes or No")); } else { bool val = false; if (boolValue.ToLower() == "yes") { val = true; } insertData.highlight = val; } } } //required non-foreign key Project Stage (string) colNum = 7; dt = (XSSFCell)sheet.GetRow(row).GetCell(colNum); if (dt != null) { sheet.GetRow(row).GetCell(colNum).SetCellType(CellType.String); if (sheet.GetRow(row).GetCell(colNum).StringCellValue != String.Empty) { insertData.project_stage = sheet.GetRow(row).GetCell(colNum).StringCellValue; } else { allowSave = false; messageList.Add(GetExcelMessage(row, "Project Stage", "Must be filled")); } } //optional non-foreign key Status (byte?) colNum = 8; dt = (XSSFCell)sheet.GetRow(row).GetCell(colNum); if (dt != null) { sheet.GetRow(row).GetCell(colNum).SetCellType(CellType.String); if (sheet.GetRow(row).GetCell(colNum).StringCellValue != String.Empty) { int val = 0; test = Int32.TryParse(sheet.GetRow(row).GetCell(colNum).StringCellValue, out val); if (test == false) { allowSave = false; messageList.Add(GetExcelMessage(row, "Status", "Invalid value")); } else { insertData.status = (byte)val; } } } //optional non-foreign key Budget (double?) colNum = 9; dt = (XSSFCell)sheet.GetRow(row).GetCell(colNum); if (dt != null) { sheet.GetRow(row).GetCell(colNum).SetCellType(CellType.String); if (sheet.GetRow(row).GetCell(colNum).StringCellValue != String.Empty) { double val = 0; test = Double.TryParse(sheet.GetRow(row).GetCell(colNum).StringCellValue, out val); if (test == false) { allowSave = false; messageList.Add(GetExcelMessage(row, "Budget", "Invalid value")); } else { insertData.budget = val; } } } //required non-foreign key Currency (string) colNum = 10; dt = (XSSFCell)sheet.GetRow(row).GetCell(colNum); if (dt != null) { sheet.GetRow(row).GetCell(colNum).SetCellType(CellType.String); if (sheet.GetRow(row).GetCell(colNum).StringCellValue != String.Empty) { insertData.currency = sheet.GetRow(row).GetCell(colNum).StringCellValue; } else { allowSave = false; messageList.Add(GetExcelMessage(row, "Currency", "Must be filled")); } } //optional non-foreign key Num (int?) colNum = 11; dt = (XSSFCell)sheet.GetRow(row).GetCell(colNum); if (dt != null) { sheet.GetRow(row).GetCell(colNum).SetCellType(CellType.String); if (sheet.GetRow(row).GetCell(colNum).StringCellValue != String.Empty) { int val = 0; test = Int32.TryParse(sheet.GetRow(row).GetCell(colNum).StringCellValue, out val); if (test == false) { allowSave = false; messageList.Add(GetExcelMessage(row, "Num", "Invalid value")); } else { insertData.num = val; } } } //optional foreign key Pmc Id colNum = 12; dt = (XSSFCell)sheet.GetRow(row).GetCell(colNum); if (dt != null) { sheet.GetRow(row).GetCell(colNum).SetCellType(CellType.String); if (sheet.GetRow(row).GetCell(colNum).StringCellValue != String.Empty) { //insertData.pmc_id = RepoPmc.GetIdByNameAndInsert(sheet.GetRow(row).GetCell(colNum).StringCellValue); //if(insertData.pmc_id == 0) //{ // allowSave = false; // messageList.Add(GetExcelMessage(row, "Pmc", "Does not exist")); //} } } //required non-foreign key Summary (string) colNum = 13; dt = (XSSFCell)sheet.GetRow(row).GetCell(colNum); if (dt != null) { sheet.GetRow(row).GetCell(colNum).SetCellType(CellType.String); if (sheet.GetRow(row).GetCell(colNum).StringCellValue != String.Empty) { insertData.summary = sheet.GetRow(row).GetCell(colNum).StringCellValue; } else { allowSave = false; messageList.Add(GetExcelMessage(row, "Summary", "Must be filled")); } } //optional foreign key Company Id colNum = 14; dt = (XSSFCell)sheet.GetRow(row).GetCell(colNum); if (dt != null) { sheet.GetRow(row).GetCell(colNum).SetCellType(CellType.String); if (sheet.GetRow(row).GetCell(colNum).StringCellValue != String.Empty) { //insertData.company_id = RepoCompany.GetIdByNameAndInsert(sheet.GetRow(row).GetCell(colNum).StringCellValue); //if(insertData.company_id == 0) //{ // allowSave = false; // messageList.Add(GetExcelMessage(row, "Company", "Does not exist")); //} } } //required non-foreign key Status Non Technical (string) colNum = 15; dt = (XSSFCell)sheet.GetRow(row).GetCell(colNum); if (dt != null) { sheet.GetRow(row).GetCell(colNum).SetCellType(CellType.String); if (sheet.GetRow(row).GetCell(colNum).StringCellValue != String.Empty) { insertData.status_non_technical = sheet.GetRow(row).GetCell(colNum).StringCellValue; } else { allowSave = false; messageList.Add(GetExcelMessage(row, "Status Non Technical", "Must be filled")); } } //required non-foreign key Is Completed (bool) colNum = 16; dt = (XSSFCell)sheet.GetRow(row).GetCell(colNum); if (dt != null) { sheet.GetRow(row).GetCell(colNum).SetCellType(CellType.String); if (sheet.GetRow(row).GetCell(colNum).StringCellValue != String.Empty) { string boolValue = sheet.GetRow(row).GetCell(colNum).StringCellValue; if (boolValue.ToLower() != "yes" && boolValue.ToLower() != "no") { allowSave = false; messageList.Add(GetExcelMessage(row, "Is Completed", "Must be filled with Yes or No")); } else { bool val = false; if (boolValue.ToLower() == "yes") { val = true; } insertData.is_completed = val; } } else { allowSave = false; messageList.Add(GetExcelMessage(row, "Is Completed", "Must be filled")); } } //optional non-foreign key Completed Date (System.DateTime?) colNum = 17; dt = (XSSFCell)sheet.GetRow(row).GetCell(colNum); if (dt != null) { sheet.GetRow(row).GetCell(colNum).SetCellType(CellType.String); if (sheet.GetRow(row).GetCell(colNum).StringCellValue != String.Empty) { DateTime dateVal; double dateOA; test = Double.TryParse(sheet.GetRow(row).GetCell(colNum).StringCellValue, out dateOA); if (test == false) { allowSave = false; messageList.Add(GetExcelMessage(row, "Completed Date", "Invalid value")); } else { test = DateTime.TryParse(DateTime.FromOADate(dateOA).ToString(), out dateVal); insertData.completed_date = dateVal; } } } //required foreign key Project Id colNum = 18; dt = (XSSFCell)sheet.GetRow(row).GetCell(colNum); if (dt != null) { sheet.GetRow(row).GetCell(colNum).SetCellType(CellType.String); if (sheet.GetRow(row).GetCell(colNum).StringCellValue != String.Empty) { insertData.project_id = RepoProject.GetIdByNameAndInsert(sheet.GetRow(row).GetCell(colNum).StringCellValue); if (insertData.project_id == 0) { allowSave = false; messageList.Add(GetExcelMessage(row, "Project", "Does not exist")); } } else { allowSave = false; messageList.Add(GetExcelMessage(row, "Project", "Must be filled")); } } //required non-foreign key Submit For Approval Time (System.DateTime) colNum = 19; dt = (XSSFCell)sheet.GetRow(row).GetCell(colNum); if (dt != null) { sheet.GetRow(row).GetCell(colNum).SetCellType(CellType.String); if (sheet.GetRow(row).GetCell(colNum).StringCellValue != String.Empty) { DateTime dateVal; double dateOA; test = Double.TryParse(sheet.GetRow(row).GetCell(colNum).StringCellValue, out dateOA); if (test == false) { allowSave = false; messageList.Add(GetExcelMessage(row, "Submit For Approval Time", "Invalid value")); } else { test = DateTime.TryParse(DateTime.FromOADate(dateOA).ToString(), out dateVal); insertData.submit_for_approval_time = dateVal; } } else { allowSave = false; messageList.Add(GetExcelMessage(row, "Submit For Approval Time", "Must be filled")); } } //required non-foreign key Approval Status (string) colNum = 20; dt = (XSSFCell)sheet.GetRow(row).GetCell(colNum); if (dt != null) { sheet.GetRow(row).GetCell(colNum).SetCellType(CellType.String); if (sheet.GetRow(row).GetCell(colNum).StringCellValue != String.Empty) { insertData.approval_status = sheet.GetRow(row).GetCell(colNum).StringCellValue; } else { allowSave = false; messageList.Add(GetExcelMessage(row, "Approval Status", "Must be filled")); } } //optional non-foreign key Approval Time (System.DateTime?) colNum = 21; dt = (XSSFCell)sheet.GetRow(row).GetCell(colNum); if (dt != null) { sheet.GetRow(row).GetCell(colNum).SetCellType(CellType.String); if (sheet.GetRow(row).GetCell(colNum).StringCellValue != String.Empty) { DateTime dateVal; double dateOA; test = Double.TryParse(sheet.GetRow(row).GetCell(colNum).StringCellValue, out dateOA); if (test == false) { allowSave = false; messageList.Add(GetExcelMessage(row, "Approval Time", "Invalid value")); } else { test = DateTime.TryParse(DateTime.FromOADate(dateOA).ToString(), out dateVal); insertData.approval_time = dateVal; } } } //required non-foreign key Deleted (bool) colNum = 22; dt = (XSSFCell)sheet.GetRow(row).GetCell(colNum); if (dt != null) { sheet.GetRow(row).GetCell(colNum).SetCellType(CellType.String); if (sheet.GetRow(row).GetCell(colNum).StringCellValue != String.Empty) { string boolValue = sheet.GetRow(row).GetCell(colNum).StringCellValue; if (boolValue.ToLower() != "yes" && boolValue.ToLower() != "no") { allowSave = false; messageList.Add(GetExcelMessage(row, "Deleted", "Must be filled with Yes or No")); } else { bool val = false; if (boolValue.ToLower() == "yes") { val = true; } insertData.deleted = val; } } else { allowSave = false; messageList.Add(GetExcelMessage(row, "Deleted", "Must be filled")); } } //required non-foreign key Approval Message (string) colNum = 23; dt = (XSSFCell)sheet.GetRow(row).GetCell(colNum); if (dt != null) { sheet.GetRow(row).GetCell(colNum).SetCellType(CellType.String); if (sheet.GetRow(row).GetCell(colNum).StringCellValue != String.Empty) { insertData.approval_message = sheet.GetRow(row).GetCell(colNum).StringCellValue; } else { allowSave = false; messageList.Add(GetExcelMessage(row, "Approval Message", "Must be filled")); } } //required non-foreign key Status Technical (string) colNum = 24; dt = (XSSFCell)sheet.GetRow(row).GetCell(colNum); if (dt != null) { sheet.GetRow(row).GetCell(colNum).SetCellType(CellType.String); if (sheet.GetRow(row).GetCell(colNum).StringCellValue != String.Empty) { insertData.status_technical = sheet.GetRow(row).GetCell(colNum).StringCellValue; } else { allowSave = false; messageList.Add(GetExcelMessage(row, "Status Technical", "Must be filled")); } } //required non-foreign key Scurve Data (string) colNum = 25; dt = (XSSFCell)sheet.GetRow(row).GetCell(colNum); if (dt != null) { sheet.GetRow(row).GetCell(colNum).SetCellType(CellType.String); if (sheet.GetRow(row).GetCell(colNum).StringCellValue != String.Empty) { insertData.scurve_data = sheet.GetRow(row).GetCell(colNum).StringCellValue; } else { allowSave = false; messageList.Add(GetExcelMessage(row, "Scurve Data", "Must be filled")); } } return(insertData); }
public void Delete(m_project dbItem) { context.m_project.Remove(dbItem); context.SaveChanges(); }