public ActionResult AcknowledgementForm()
{
BCBSClient client = new BCBSClient();
string customerlist = client.GetcustomerList();
if (!string.IsNullOrEmpty(customerlist))
{
ViewBag.Customers = JsonConvert.DeserializeObject<List<CustomerModel>>(customerlist).Select(x => new { x.Id, x.Name });
}
else
{
ViewBag.Customers = "";
}
//string servicelist = client.GetServiceTypeList();
//if (!string.IsNullOrEmpty(servicelist))
//{
// ViewBag.Services = JsonConvert.DeserializeObject<List<ServiceModel>>(servicelist).Select(x => new { x.Id, x.Name });
//}
//else
//{
// ViewBag.Services = "";
//}
string projectList = client.GetProjectList();
if (!string.IsNullOrEmpty(projectList))
{
ViewBag.Projects = JsonConvert.DeserializeObject<List<ProjectModel>>(projectList).Select(x => new { x.Id, x.Name });
}
else
{
ViewBag.Projects = "";
}
return View();
}
public ActionResult Edit(long id)
{
BCBSClient client = new BCBSClient();
string customerlist = client.GetcustomerList();
ContractModel contract = new ContractModel();
contract.FromDate = DateTime.Now;
contract.EndDate = DateTime.Now;
if (!string.IsNullOrEmpty(customerlist))
{
ViewBag.Customers = JsonConvert.DeserializeObject<List<CustomerModel>>(customerlist).Select(x => new { x.Id, x.Name });
}
else
{
ViewBag.Customers = "";
}
string projectList = client.GetProjectList();
if (!string.IsNullOrEmpty(projectList))
{
ViewBag.Projects = JsonConvert.DeserializeObject<List<ProjectModel>>(projectList).Select(x => new { x.Id, x.Name });
}
else
{
ViewBag.Projects = "";
}
if (id > 0)
{
string ContractData = client.GetcontractById(id);
if (!string.IsNullOrEmpty(ContractData))
{
contract = JsonConvert.DeserializeObject<ContractModel>(ContractData);
string servicelist = client.GetServiceTypesByProjectId(contract.ProjectId);
if (!string.IsNullOrEmpty(servicelist))
{
ViewBag.Services = JsonConvert.DeserializeObject<List<ServiceModel>>(servicelist).Select(x => new { x.Id, x.Name });
}
else
{
ViewBag.Services = "";
}
}
else
{
TempData["Error"] = "Requested contract not available!!";
return RedirectToAction("Index", "Contract");
}
}
return View(contract);
}
public ActionResult New()
{
BCBSClient client = new BCBSClient();
string customerlist = client.GetcustomerList();
ContractModel contract = new ContractModel();
contract.FromDate = DateTime.Now;
contract.EndDate = DateTime.Now;
contract.ContractCode = GenerateUniqueContractCode().ToUpper();
if (!string.IsNullOrEmpty(customerlist))
{
ViewBag.Customers = JsonConvert.DeserializeObject<List<CustomerModel>>(customerlist).Select(x => new { x.Id, x.Name });
}
else
{
ViewBag.Customers = "";
}
//string servicelist = client.GetServiceTypeList();
//if (!string.IsNullOrEmpty(servicelist))
//{
// ViewBag.Services = JsonConvert.DeserializeObject<List<ServiceModel>>(servicelist).Select(x => new { x.Id, x.Name });
//}
//else
//{
// ViewBag.Services = "";
//}
string projectList = client.GetProjectList();
if (!string.IsNullOrEmpty(projectList))
{
ViewBag.Projects = JsonConvert.DeserializeObject<List<ProjectModel>>(projectList).Select(x => new { x.Id, x.Name });
}
else
{
ViewBag.Projects = "";
}
return View(contract);
}
public ActionResult New()
{
BCBSClient client = new BCBSClient();
string customerlist = client.GetcustomerList();
string servicelist = client.GetServiceTypeList();
if (!string.IsNullOrEmpty(customerlist))
{
ViewBag.Customers = JsonConvert.DeserializeObject<List<CustomerModel>>(customerlist).Select(x => new { x.Id, x.Name });
}
else
{
ViewBag.Customers = "";
}
if (!string.IsNullOrEmpty(servicelist))
{
ViewBag.Services = JsonConvert.DeserializeObject<List<ServiceModel>>(servicelist).Select(x => new { x.Id, x.Name });
}
else
{
ViewBag.Services = "";
}
string projectList = client.GetProjectList();
if (!string.IsNullOrEmpty(projectList))
{
ViewBag.Projects = JsonConvert.DeserializeObject<List<ProjectModel>>(projectList).Select(x => new { x.Id, x.Name });
}
else
{
ViewBag.Projects = "";
}
string contractList = client.GetcontractList();
if (!string.IsNullOrEmpty(contractList))
{
ViewBag.Contracts = JsonConvert.DeserializeObject<List<ContractModel>>(contractList).Select(x => new { x.Id, x.ContractCode });
}
else
{
ViewBag.Contracts = "";
}
ViewBag.Months = new List<SelectListItem> {
new SelectListItem { Text = "January", Value = "1" },
new SelectListItem { Text = "February", Value = "2" },
new SelectListItem { Text = "March", Value = "3" },
new SelectListItem{Text="April",Value="4"},
new SelectListItem{Text="May",Value="5"},
new SelectListItem{Text="June",Value="6"},
new SelectListItem{Text="July",Value="7"},
new SelectListItem{Text="August",Value="8"},
new SelectListItem{Text="September",Value="9"},
new SelectListItem{Text="October",Value="10"},
new SelectListItem{Text="November",Value="11"},
new SelectListItem{Text="December",Value="12"}
};
string years = client.GetAccuralReportMonthYear();
List<MonthYear> ContractList = new List<MonthYear>();
if (!string.IsNullOrEmpty(years))
{
ContractList = JsonConvert.DeserializeObject<List<MonthYear>>(years);
int currentexist = ContractList.Where(x => x.Year == DateTime.Now.Year.ToString()).Count();
if (!(currentexist > 0))
{
MonthYear monthYear = new MonthYear();
monthYear.Year = DateTime.Now.Year.ToString();
monthYear.Month = "";
ContractList.Add(monthYear);
}
}
else
{
ContractList = JsonConvert.DeserializeObject<List<MonthYear>>(years);
MonthYear monthYear = new MonthYear();
monthYear.Year = DateTime.Now.Year.ToString();
monthYear.Month = "";
ContractList.Add(monthYear);
}
ViewBag.Years = ContractList.GroupBy(cust => cust.Year).Select(grp => grp.First());
return View();
}
public JsonResult GetCustomerList()
{
try
{
BCBSClient client = new BCBSClient();
string result = client.GetcustomerList();
List<CustomerModel> CustomerList = JsonConvert.DeserializeObject<List<CustomerModel>>(result);
return Json(CustomerList, JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
return Json(ex.Message, JsonRequestBehavior.AllowGet);
}
}
public ActionResult ViewAcknowledgeForm(AcknowledgementModel avm, FormCollection fc)
{
bool isResult = false;
if (avm.Id > 0)
{
BCBSClient client = new BCBSClient();
List<CustomerAcknowledgementServicesModel> ackService = new List<CustomerAcknowledgementServicesModel>();
string dataResult = client.GetAcknowledgementServicesbyAcknowledgemetnId(Convert.ToInt64(avm.Id));
if (!string.IsNullOrEmpty(dataResult))
{
ackService = JsonConvert.DeserializeObject<List<CustomerAcknowledgementServicesModel>>(dataResult);
}
if (ackService.Count > 0)
{
foreach (CustomerAcknowledgementServicesModel ack in ackService)
{
string ContractCode = GenerateUniqueContractCode().ToUpper();
long id = client.Insertcontract(ack.CustomerId, ack.ServiceId, ack.FromDate, ack.EndDate, true, false, "Active", ack.Volume, ack.Total, ack.ProjectId, "", ContractCode, "", ack.FeesType);
//long id = client.Insertcontract(ack.CustomerId, ack.ServiceId, ack.FromDate, ack.EndDate, true, false, "Active", "", ack.Total, ack.ProjectId, "", ContractCode, "", "");
if (id > 0)
{
isResult = true;
}
else
{
break;
}
}
if (isResult == true)
{
long id = client.AcknowledgementApprove(Convert.ToInt64(avm.Id));
TempData["Message"] = "Acknowledgement Approved ! Contract Added Successfully!!";
return RedirectToAction("acknowledgements", "customer");
}
else
{
string customerlist = client.GetcustomerList();
if (!string.IsNullOrEmpty(customerlist))
{
ViewBag.Customers = JsonConvert.DeserializeObject<List<CustomerModel>>(customerlist).Select(x => new { x.Id, x.Name });
}
else
{
ViewBag.Customers = "";
}
string servicelist = client.GetServiceTypeList();
if (!string.IsNullOrEmpty(servicelist))
{
ViewBag.Services = JsonConvert.DeserializeObject<List<ServiceModel>>(servicelist).Select(x => new { x.Id, x.Name });
}
else
{
ViewBag.Services = "";
}
string projectList = client.GetProjectList();
if (!string.IsNullOrEmpty(projectList))
{
ViewBag.Projects = JsonConvert.DeserializeObject<List<ProjectModel>>(projectList).Select(x => new { x.Id, x.Name });
}
else
{
ViewBag.Projects = "";
}
}
}
}
//BCBSClient client = new BCBSClient();
//string removedProjects = fc["RemovedProjects"].ToString();
//string removedServices = fc["RemovedServices"].ToString();
//List<string> removedProjectList = new List<string>();
//if (!string.IsNullOrEmpty(removedProjects))
//{
// removedProjectList = removedProjects.Split(',').ToList();
//}
//List<string> removedServiceList = new List<string>();
//if (!string.IsNullOrEmpty(removedServices))
//{
// removedServiceList = removedServices.Split(',').ToList();
//}
//long ackid = avm.Id;
////long ackId = client.InsertCustomerAcknoeledgement(avm.CustomerId);
//if (ackid > 0)
//{
// if (avm.Projects != null)
// {
// for (int i = 0; i < avm.Projects.Count(); i++)
// {
// if (removedProjectList.Count > 0)
// {
// var r = removedProjectList.Where(x => x.Equals(avm.Projects[i].Project.Id + "@" + i));
// if (r != null)
// {
// if (r.Count() > 0)
// {
// continue;
// }
// }
// }
// if (avm.Projects[i].Services != null)
// {
// for (int j = 0; j < avm.Projects[i].Services.Count; j++)
// {
// var r = removedServiceList.Where(x => x.Equals(i + "_" + j));
// if (r != null)
// {
// if (r.Count() > 0)
// {
// continue;
// }
// }
// long ackserviceId = avm.Projects[i].Services[j].Id;
// //long ackServiceId = client.InsertAcknowledgementServices(ackid, avm.Projects[i].Project.Id, avm.Projects[i].Services[j].Id, avm.Projects[i].Services[j].Total, avm.Projects[i].FromDate, avm.Projects[i].EndDate);
// }
// }
// }
// string fileName = "Ack_" + DateTime.Now.ToString("MM_dd_yyyy_HH_mm_ss");
// string retunfileName = CreateAcknowledgementExcel(avm, fileName, removedProjects, removedServices);
// if (!string.IsNullOrEmpty(retunfileName))
// {
// string path = Path.Combine(Server.MapPath("~/UploadDocuments/Acknowledgements"), retunfileName);
// //return File(path, "text/csv", retunfileName);
// }
// else
// {
// TempData["Message"] = "Customer grand bill generated successfully..!";
// //string fileName = "SBF_" + invoiceModel.InvoiceNumber + "_" + DateTime.Now.ToString("MM-dd-yyyy");
// //
// return RedirectToAction("acknowledgements", "customer");
// }
// //TempData["Message"] = "Acknowledgement Bill generated successfully..";
// }
//}
return View(avm);
}
public ActionResult ViewAcknowledgeForm(string Id)
{
BCBSClient client = new BCBSClient();
AcknowledgementModel avm = new AcknowledgementModel();
string customerlist = client.GetcustomerList();
if (!string.IsNullOrEmpty(customerlist))
{
ViewBag.Customers = JsonConvert.DeserializeObject<List<CustomerModel>>(customerlist).Select(x => new { x.Id, x.Name });
}
else
{
ViewBag.Customers = "";
}
string servicelist = client.GetServiceTypeList();
if (!string.IsNullOrEmpty(servicelist))
{
ViewBag.Services = JsonConvert.DeserializeObject<List<ServiceModel>>(servicelist).Select(x => new { x.Id, x.Name });
}
else
{
ViewBag.Services = "";
}
string projectList = client.GetProjectList();
if (!string.IsNullOrEmpty(projectList))
{
ViewBag.Projects = JsonConvert.DeserializeObject<List<ProjectModel>>(projectList).Select(x => new { x.Id, x.Name });
}
else
{
ViewBag.Projects = "";
}
if (!string.IsNullOrEmpty(Id))
{
List<CustomerAcknowledgementServicesModel> ackService = new List<CustomerAcknowledgementServicesModel>();
string dataResult = client.GetAcknowledgementServicesbyAcknowledgemetnId(Convert.ToInt64(Id));
if (!string.IsNullOrEmpty(dataResult))
{
ackService = JsonConvert.DeserializeObject<List<CustomerAcknowledgementServicesModel>>(dataResult);
if (ackService.Count > 0)
{
avm.Id = ackService[0].AcknowledementId;
avm.CustomerId = ackService[0].CustomerId;
avm.Status = ackService[0].Status;
}
}
if (ackService.Count > 0)
{
List<long> Projects = ackService.Select(x => x.ProjectId).Distinct().ToList();
var ServicebyProjects = ackService.ToList();
ViewBag.SelectedProjects = JsonConvert.SerializeObject(Projects);
ViewBag.ProjectServices = dataResult;
}
}
return View(avm);
}
