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 }));
}