public ActionResult AccuralWorkShhet()
{
ViewBag.currentMonth = DateTime.Now.Month.ToString();
ViewBag.currentYear = DateTime.Now.Year.ToString();
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"}
};
BCBSClient client = new BCBSClient();
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.Select(x => new MonthYear { Year = x.Year });
return View();
}
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();
}
