public ActionResult CreateQuerySheetUnit(string type, int QuerySheetId) { var repo = new QuerySheetRepository(); FillDropdowns(); //var qs = new QuerySheetRepository().GetQuerySheet(QuerySheetId); var qs = new QuerySheetRepository().GetQuerySheetItem(QuerySheetId); qs.Type = type; if (type == "Unit") { foreach (var item in qs.QuerySheetItems) { item.ProjectRoomUnits = new List <QuerySheetUnit>(); item.ProjectRoomUnits.Add(new QuerySheetUnit()); item.ProjectRoomDoors = new List <QuerySheetDoor>(); item.ProjectRoomDoors.Add(new QuerySheetDoor()); } } if (type == "Costing") { var PCList = repo.GetProjectCostingParameter(); qs.Items = new List <ProjectCost>(); foreach (var item in PCList) { var pcitem = new ProjectCost { CostingId = item.CostingId, Description = item.Description, Remarks = item.Remarks, Amount = item.Amount }; qs.Items.Add(pcitem); } } return(View("CreateQuerySheet", qs)); }
public ActionResult Delete(int Id, string type) { ViewBag.Title = "Delete"; var result1 = new QuerySheetRepository().CHECK(Id); if (result1 > 0) { TempData["error"] = "Sorry! Already Used!"; TempData["QuerySheetRefNo"] = null; return(RedirectToAction("Edit", new { id = Id })); } else { //var result2 = new QuerySheetRepository().DeleteProjectCosting(Id); try { var ref_no = new QuerySheetRepository().DeleteQuerySheet(Id, UserID.ToString(), OrganizationId, type); TempData["success"] = "Deleted Successfully (" + ref_no + ")"; //return RedirectToAction("PreviousList"); return(RedirectToAction("Index", new { type = ViewBag.Type })); } catch (Exception) { TempData["error"] = "Oops! Something went wrong!"; TempData["QuerySheetRefNo"] = null; return(RedirectToAction("Edit", new { id = Id })); } } }
// GET: QuerySheet public ActionResult ViewQuerySheet(int QuerySheetId) { //var qs = new QuerySheetRepository().GetQuerySheet(QuerySheetId); var qs = new QuerySheetRepository().GetQuerySheetItem(QuerySheetId); return(View("CreateQuerySheet", qs)); }
public ActionResult CreateQuerySheet(string type) { FillDropdowns(); string internalId = ""; try { internalId = DatabaseCommonRepository.GetNextDocNo(5, OrganizationId); } catch (NullReferenceException nx) { TempData["success"] = ""; TempData["error"] = "Some required data was missing. Please try again.|" + nx.Message; } catch (Exception ex) { TempData["success"] = ""; TempData["error"] = "Some error occurred. Please try again.|" + ex.Message; } QuerySheet qs = new QuerySheet(); qs.Type = type; qs.QuerySheetDate = DateTime.Now; var repo = new QuerySheetRepository(); qs.QuerySheetItems = new List <QuerySheetItem>(); qs.QuerySheetItems.Add(new QuerySheetItem()); qs.QuerySheetItems[0].ProjectRoomUnits = new List <QuerySheetUnit>(); qs.QuerySheetItems[0].ProjectRoomUnits.Add(new QuerySheetUnit()); qs.QuerySheetItems[0].ProjectRoomDoors = new List <QuerySheetDoor>(); qs.QuerySheetItems[0].ProjectRoomDoors.Add(new QuerySheetDoor()); qs.QuerySheetRefNo = internalId; return(View(qs)); }
public ActionResult PendingQuerySheetforCosting() { var repo = new QuerySheetRepository(); List <QuerySheet> Pending = repo.GetPendingQuerySheetforCosting(); ViewBag.Type = "Costing"; return(View("PendingQuerySheet", Pending)); }
public ActionResult Edit(QuerySheet model) { ViewBag.Title = "Edit"; model.OrganizationId = OrganizationId; model.CreatedDate = System.DateTime.Now; model.CreatedBy = UserID.ToString(); var repo = new QuerySheetRepository(); var result1 = new QuerySheetRepository().CHECK(model.QuerySheetId); if (result1 > 0) { TempData["error"] = "Sorry! Already Used!"; TempData["QuerySheetRefNo"] = null; return(View("Edit", model)); } else { try { string ref_no; if (model.Type == "Unit") { ref_no = new QuerySheetRepository().UpdateQuerySheetUnitSelection(model); } else { ref_no = new QuerySheetRepository().UpdateQuerySheet(model); } TempData["success"] = "Updated successfully. Query Sheet Reference No. is " + ref_no; TempData["error"] = ""; return(RedirectToAction("Index", new { Type = model.Type })); } catch (SqlException) { TempData["error"] = "Some error occured while saving. Please try again."; } catch (NullReferenceException) { TempData["error"] = "Some required data was missing. Please try again."; } catch (Exception) { TempData["error"] = "Some error occured. Please try again."; } return(RedirectToAction("Index", new { Type = model.Type })); } }
public ActionResult Edit(string type, int id = 0) { try { FillDropdowns(); if (id != 0) { QuerySheet QuerySheet = new QuerySheet(); var repo = new ProjectCostRepository(); QuerySheet = new QuerySheetRepository().GetQuerySheetItem(id); QuerySheet.Items = repo.GetProjectCost(id); ViewBag.Type = type; return(View(QuerySheet)); } else { TempData["error"] = "That was an invalid/unknown request. Please try again."; return(RedirectToAction("Index", "Home")); } } catch (InvalidOperationException iox) { TempData["error"] = "Sorry, we could not find the requested item. Please try again.|" + iox.Message; } catch (SqlException sx) { TempData["error"] = "Some error occured while connecting to database. Please try again after sometime.|" + sx.Message; } catch (NullReferenceException nx) { TempData["error"] = "Some required data was missing. Please try again.|" + nx.Message; } catch (Exception ex) { TempData["error"] = "Some error occured. Please try again.|" + ex.Message; } TempData["success"] = ""; return(RedirectToAction("Index", new { Type = "Unit" })); }
public ActionResult CreateQuerySheetCosting(string type) { string internalId = ""; try { internalId = DatabaseCommonRepository.GetNextDocNo(5, OrganizationId); } catch (NullReferenceException nx) { TempData["success"] = ""; TempData["error"] = "Some required data was missing. Please try again.|" + nx.Message; } catch (Exception ex) { TempData["success"] = ""; TempData["error"] = "Some error occurred. Please try again.|" + ex.Message; } QuerySheet qs = new QuerySheet(); qs.Type = type; qs.QuerySheetDate = DateTime.Now; var repo = new QuerySheetRepository(); qs.QuerySheetItems = new List <QuerySheetItem>(); qs.QuerySheetItems.Add(new QuerySheetItem()); var PCList = repo.GetProjectCostingParameter(); qs.Items = new List <ProjectCost>(); qs.QuerySheetRefNo = internalId; foreach (var item in PCList) { var pcitem = new ProjectCost { CostingId = item.CostingId, Description = item.Description, Remarks = item.Remarks, Amount = item.Amount }; qs.Items.Add(pcitem); } return(View("CreateQuerySheet", qs)); }
public ActionResult CreateQuerySheet(QuerySheet qs) { //if (qs.QuerySheetId==0) //{ try { qs.OrganizationId = OrganizationId; qs.CreatedDate = System.DateTime.Now; qs.CreatedBy = UserID.ToString(); var id = ""; int row; if (qs.Type == "Unit") { FillDropdowns(); row = new QuerySheetRepository().UpdateQuerySheetUnit(qs); TempData["success"] = "Saved Successfully (" + qs.QuerySheetRefNo + ")"; return(RedirectToAction("PendingQuerySheetforUnit")); } else if (qs.Type == "Costing") { FillDropdowns(); if (qs.Items == null || qs.Items.Count <= 0) { TempData["error"] = "Query Sheet cannot be saved without costing parameters."; return(RedirectToAction("CreateQuerySheetUnit", new { QuerySheetid = qs.QuerySheetId, type = "Costing" })); } row = new ProjectCostRepository().InsertProjectCosting(qs); TempData["success"] = "Saved Successfully (" + qs.QuerySheetRefNo + ")"; return(RedirectToAction("PendingQuerySheetforCosting")); } else if (qs.Type == "RoomDetails") { id = new QuerySheetRepository().InsertQuerySheet(qs); if (id.Split('|')[0] != "0") { qs.QuerySheetId = Convert.ToInt16(id.Split('|')[0]); qs.QuerySheetRefNo = id.Split('|')[1]; TempData["success"] = "Saved successfully. Reference No. is " + id.Split('|')[1]; TempData["error"] = ""; return(RedirectToAction("CreateQuerySheet", new { type = qs.Type })); } else { throw new Exception(); } } } catch (SqlException sx) { TempData["error"] = "Some error occured while connecting to database. Please check your network connection and try again.|" + sx.Message; } catch (NullReferenceException nx) { TempData["error"] = "Some required data was missing. Please try again.|" + nx.Message; } catch (Exception ex) { TempData["error"] = "Some error occured. Please try again.|" + ex.Message; } TempData["success"] = ""; //} return(RedirectToAction("CreateQuerySheet", new { type = qs.Type })); }