public HttpResponseMessage GetDashboardCardsInverterTable(Guid hdLoginID, string plantDate, bool isRequiredDevide) { ENT.DashboardCards m_Total = new ENT.DashboardCards(); BAL.DeviceDataBAL objDashboard = new BAL.DeviceDataBAL(); DateTime dttm = DateTime.ParseExact(plantDate, "dd/MM/yyyy", CultureInfo.InvariantCulture); //List<ENT.DashboardCards> lstResult = new List<ENT.DashboardCards>(); //if (hdLoginID.ToString().ToUpper() == "CDADA587-1678-4128-B37D-BA9E2B04E508" || hdLoginID.ToString().ToUpper() == "DBF3D275-0110-4D03-A519-7A777D18020E") //{ // lstResult = objDashboard.GetDashboardCardsInverterTable(dttm, dttm, true, hdLoginID); //} //else if (hdLoginID.ToString().ToUpper() == "654F9AC4-601D-4530-BB54-E667D037B1F3") //{ // lstResult = objDashboard.GetDashboardCardsInverterTableExcluded(dttm, dttm, false, hdLoginID, "('1900763842','1900764245')"); // List<ENT.DashboardCards> lstResultTop = new List<ENT.DashboardCards>(); // lstResultTop = objDashboard.GetDashboardCardsInverterTableTop(dttm, dttm, true, hdLoginID, "('1900763842','1900764245')"); // lstResult = lstResult.Concat(lstResultTop).ToList<ENT.DashboardCards>(); //} //else //{ // lstResult = objDashboard.GetDashboardCardsInverterTable(dttm, dttm, false, hdLoginID); //} List <ENT.InverterDateTable> lstTemp = new List <ENT.InverterDateTable>(); List <ENT.InverterDateTable> lstTable = new List <ENT.InverterDateTable>(); // if (hdLoginID.ToString().ToUpper().ToUpper() == "CDADA587-1678-4128-B37D-BA9E2B04E508" || hdLoginID.ToString().ToUpper() == "DBF3D275-0110-4D03-A519-7A777D18020E") if (hdLoginID.ToString().ToUpper() == "CDADA587-1678-4128-B37D-BA9E2B04E508" || hdLoginID.ToString().ToUpper() == "DBF3D275-0110-4D03-A519-7A777D18020E" || hdLoginID.ToString().ToUpper() == "307F425E-2A71-45DC-A528-0E45AAF510F2" || hdLoginID.ToString().ToUpper() == "E0A6FF76-F989-4CA6-AE90-EC32AAA0D33C" || hdLoginID.ToString().ToUpper() == "EB3123B4-6D53-42C5-BF2A-AEBA11257B51" || hdLoginID.ToString().ToUpper() == "B683B70B-5C1A-4275-96DE-9DCDE9101B3E" || hdLoginID.ToString().ToUpper() == "B29E4E42-17CB-4826-9E68-34A8B7236651" || hdLoginID.ToString().ToUpper() == "85C86141-B7C2-410D-A5C8-ECD7A5F325B9" || hdLoginID.ToString().ToUpper() == "A1B8C6E4-D5E4-44EC-8887-5A5227ED5AB4" || hdLoginID.ToString().ToUpper() == "36A5DCF4-A23D-404B-858C-65CBCBAEADE7" || hdLoginID.ToString().ToUpper() == "B4E5DB34-ADE6-4F0F-B5D1-4E0080479721" || hdLoginID.ToString().ToUpper() == "E8B87944-C9F9-4993-9655-830A6ECB4131" || hdLoginID.ToString().ToUpper() == "8C025B11-582B-4039-B923-CA343ECF01E7" || hdLoginID.ToString().ToUpper() == "6050DC30-4534-4F21-8D15-1EB40CBD28A8" || hdLoginID.ToString().ToUpper() == "9FE675A5-8021-4153-ADBB-A6A912365220" || hdLoginID.ToString().ToUpper() == "037BBBCC-435F-41A6-A962-02A2CFCD1257" || hdLoginID.ToString().ToUpper() == "AEACB764-2913-4B77-800E-9A300F4B2B5B" || hdLoginID.ToString().ToUpper() == "878FC146-7F86-434D-A82F-5F5AF79BE298" || hdLoginID.ToString().ToUpper() == "55A3AD81-3361-47E1-820F-ACC45547E810") { lstTemp = objDashboard.Get7DaysTableAPI(dttm, dttm, true, hdLoginID); } else if (hdLoginID.ToString().ToUpper().ToUpper() == "654F9AC4-601D-4530-BB54-E667D037B1F3") { lstTemp = objDashboard.Get7DaysTableExcluded(dttm, dttm, false, hdLoginID, "('1900763842','1900764245')"); List <ENT.InverterDateTable> lstTempTop = new List <ENT.InverterDateTable>(); lstTempTop = objDashboard.Get7DaysTableTop(dttm, dttm, true, hdLoginID, "('1900763842','1900764245')"); lstTemp = lstTemp.Concat(lstTempTop).ToList <ENT.InverterDateTable>(); } else { lstTemp = objDashboard.Get7DaysTableAPI(dttm, dttm, false, hdLoginID); } foreach (ENT.InverterDateTable el in lstTemp) { ENT.InverterDateTable obj = new ENT.InverterDateTable(); obj.SerialNo = el.SerialNo; obj.Day1 = el.Day1; if (isRequiredDevide) { obj.Day1 = decimal.Round((obj.Day1 / el.PerformsOfPlantUniteVolume), 2, MidpointRounding.AwayFromZero); } obj.Day2 = el.Day2; obj.Day3 = el.Day3; obj.Day4 = el.Day4; obj.Day5 = el.Day5; obj.Day6 = el.Day6; obj.Day7 = el.Day7; obj.Total7Days = el.Total7Days; obj.DeviceName = el.DeviceName; obj.Make = el.Make; obj.InvStatus = el.InvStatus; lstTable.Add(obj); } var intResult = objDashboard.GetPlantActiveMinutes(hdLoginID); objDashboard = null; return(ControllerContext.Request.CreateResponse(HttpStatusCode.OK, new { //Entire = m_Total, lstTable = lstTable, //lstResult = lstResult, LastDateTime = intResult.FirstOrDefault().LastDateTime.GetFormatedDateTime(), ActiveMinutes = intResult.Sum(x => x.LastActMinutes) })); }
public void ConvertCSV(Guid hdLoginID, string plantDate) { //ENT.DashboardCards m_SingleDay = new ENT.DashboardCards(); ENT.DashboardCards m_Total = new ENT.DashboardCards(); objDashboard = new Josheph.Framework.BusinessLayer.DeviceDataBAL(); List <ENT.DashboardCards> lstResult = new List <ENT.DashboardCards>(); DateTime dttm = DateTime.ParseExact(plantDate, "dd/MM/yyyy", CultureInfo.InvariantCulture); //if (hdLoginID.ToString().ToUpper() == "CDADA587-1678-4128-B37D-BA9E2B04E508" || hdLoginID.ToString().ToUpper() == "DBF3D275-0110-4D03-A519-7A777D18020E" || hdLoginID.ToString().ToUpper() == "307F425E-2A71-45DC-A528-0E45AAF510F2") //{ // lstResult = objDashboard.GetDashboardCardsInverterTable(dttm, dttm, true, hdLoginID); // // m_SingleDay.EAC = lstResult.Sum(x => x.EAC); //} //else //{ // lstResult = objDashboard.GetDashboardCardsInverterTable(dttm, dttm, false, hdLoginID); // // m_SingleDay.EAC = lstResult.Sum(x => x.EAC); //} ////m_SingleDay.EACString = m_SingleDay.EAC.ToString() + " kWh"; //if (hdLoginID.ToString().ToUpper() == "CDADA587-1678-4128-B37D-BA9E2B04E508" || hdLoginID.ToString().ToUpper() == "DBF3D275-0110-4D03-A519-7A777D18020E" || hdLoginID.ToString().ToUpper() == "307F425E-2A71-45DC-A528-0E45AAF510F2") //{ // lstResult = objDashboard.GetDashboardCardsInverterTable(dttm, dttm, true, hdLoginID); // //m_Total.EAC = lstResult.Sum(x => x.EAC); //} //else //{ // lstResult = objDashboard.GetDashboardCardsInverterTable(dttm, dttm, false, hdLoginID); // //m_Total.EAC = lstResult.Sum(x => x.EAC); //} List <ENT.InverterDateTable> lstTemp = new List <ENT.InverterDateTable>(); List <ENT.InverterDateTable> lstTable = new List <ENT.InverterDateTable>(); if (hdLoginID.ToString().ToUpper().ToUpper() == "CDADA587-1678-4128-B37D-BA9E2B04E508") { lstTemp = objDashboard.Get7DaysTable(dttm, dttm, true, hdLoginID); foreach (ENT.InverterDateTable el in lstTemp) { ENT.InverterDateTable obj = new ENT.InverterDateTable(); obj.SerialNo = el.SerialNo; obj.Day1 = el.Day1; obj.Day2 = el.Day2; obj.Day3 = el.Day3; obj.Day4 = el.Day4; obj.Day5 = el.Day5; obj.Day6 = el.Day6; obj.Day7 = el.Day7; obj.Total7Days = el.Total7Days; obj.DeviceName = el.DeviceName; lstTable.Add(obj); } } else { lstTemp = objDashboard.Get7DaysTable(dttm, dttm, false, hdLoginID); lstTable = lstTemp; } int intResult = objDashboard.GetPlantActiveMinutes(hdLoginID).Sum(x => x.LastActMinutes); objDashboard = null; DataTable students = ToDataTable(lstTable); students.Columns.Remove("Day2"); students.Columns.Remove("Day3"); students.Columns.Remove("Day4"); students.Columns.Remove("Day5"); students.Columns.Remove("Day6"); students.Columns.Remove("Day7"); students.Columns.Remove("Total7Days"); DataSetToExcel(students, "INVERTERDATA.xls"); //MemoryStream stream = DataSetToExcel(students); //var filename = "ExampleCSV.csv"; //var contenttype = "text/csv"; //Response.Clear(); //Response.ContentType = contenttype; //Response.AddHeader("content-disposition", "attachment;filename=" + filename); //Response.Cache.SetCacheability(HttpCacheability.NoCache); //Response.ContentType = "text/csv"; ////Response.BinaryWrite(stream.ToArray()); //Response.Write(stream); //Response.End(); }
public JsonResult GetDashboardCards() { ENT.DashboardCards m_SingleDay = new ENT.DashboardCards(); ENT.DashboardCards m_Total = new ENT.DashboardCards(); BAL.ChartReportBAL objDashboard = new BAL.ChartReportBAL(); List <ENT.DashboardCards> lstResult = new List <ENT.DashboardCards>(); string ClientID = "d1b28dda-2cd0-44c8-af8f-b8914624ee5d"; if (ClientID == "d1b28dda-2cd0-44c8-af8f-b8914624ee5d") { lstResult = objDashboard.GetDashboardCards(true, true); m_SingleDay.EAC = lstResult.Sum(x => x.EAC) / 10; } else { lstResult = objDashboard.GetDashboardCards(true, false); m_SingleDay.EAC = lstResult.Sum(x => x.EAC); } m_SingleDay.EACString = m_SingleDay.EAC.ToString() + " kWh"; if (ClientID == "d1b28dda-2cd0-44c8-af8f-b8914624ee5d") { lstResult = objDashboard.GetDashboardCards(false, true); m_Total.EAC = lstResult.Sum(x => x.EAC) / 10; } else { lstResult = objDashboard.GetDashboardCards(false, false); m_Total.EAC = lstResult.Sum(x => x.EAC); } m_Total.EACString = m_Total.EAC.ToString() + " kWh"; List <ENT.InverterDateTable> lstTemp = new List <ENT.InverterDateTable>(); List <ENT.InverterDateTable> lstTable = new List <ENT.InverterDateTable>(); if (ClientID == "d1b28dda-2cd0-44c8-af8f-b8914624ee5d") { lstTemp = objDashboard.Get7DaysTable(true); foreach (ENT.InverterDateTable el in lstTemp) { ENT.InverterDateTable obj = new ENT.InverterDateTable(); obj.SerialNo = el.SerialNo; obj.Day1 = el.Day1 / 10; obj.Day2 = el.Day2 / 10; obj.Day3 = el.Day3 / 10; obj.Day4 = el.Day4 / 10; obj.Day5 = el.Day5 / 10; obj.Day6 = el.Day6 / 10; obj.Day7 = el.Day7 / 10; obj.Total7Days = el.Total7Days / 10; obj.DeviceName = el.DeviceName; lstTable.Add(obj); } } else { lstTemp = objDashboard.Get7DaysTable(false); lstTable = lstTemp; } objDashboard = null; return(Json(new { Today = m_SingleDay, Entire = m_Total, lstTable = lstTable, lstResult = lstResult }, JsonRequestBehavior.AllowGet)); }
public JsonResult GetDashboardCards(Guid hdLoginID, string plantDate) { ENT.DashboardCards m_SingleDay = new ENT.DashboardCards(); ENT.DashboardCards m_Total = new ENT.DashboardCards(); objDashboard = new Josheph.Framework.BusinessLayer.DeviceDataBAL(); List <ENT.DashboardCards> lstResult = new List <ENT.DashboardCards>(); DateTime dttm = DateTime.ParseExact(plantDate, "dd/MM/yyyy", CultureInfo.InvariantCulture); if (hdLoginID.ToString().ToUpper() == "CDADA587-1678-4128-B37D-BA9E2B04E508" || hdLoginID.ToString().ToUpper() == "DBF3D275-0110-4D03-A519-7A777D18020E" || hdLoginID.ToString().ToUpper() == "307F425E-2A71-45DC-A528-0E45AAF510F2" || hdLoginID.ToString().ToUpper() == "E0A6FF76-F989-4CA6-AE90-EC32AAA0D33C" || hdLoginID.ToString().ToUpper() == "EB3123B4-6D53-42C5-BF2A-AEBA11257B51" || hdLoginID.ToString().ToUpper() == "B683B70B-5C1A-4275-96DE-9DCDE9101B3E" || hdLoginID.ToString().ToUpper() == "B29E4E42-17CB-4826-9E68-34A8B7236651" || hdLoginID.ToString().ToUpper() == "85C86141-B7C2-410D-A5C8-ECD7A5F325B9" || hdLoginID.ToString().ToUpper() == "A1B8C6E4-D5E4-44EC-8887-5A5227ED5AB4" || hdLoginID.ToString().ToUpper() == "36A5DCF4-A23D-404B-858C-65CBCBAEADE7" || hdLoginID.ToString().ToUpper() == "B4E5DB34-ADE6-4F0F-B5D1-4E0080479721" || hdLoginID.ToString().ToUpper() == "E8B87944-C9F9-4993-9655-830A6ECB4131" || hdLoginID.ToString().ToUpper() == "8C025B11-582B-4039-B923-CA343ECF01E7" || hdLoginID.ToString().ToUpper() == "6050DC30-4534-4F21-8D15-1EB40CBD28A8" || hdLoginID.ToString().ToUpper() == "9FE675A5-8021-4153-ADBB-A6A912365220" || hdLoginID.ToString().ToUpper() == "037BBBCC-435F-41A6-A962-02A2CFCD1257" || hdLoginID.ToString().ToUpper() == "AEACB764-2913-4B77-800E-9A300F4B2B5B" || hdLoginID.ToString().ToUpper() == "878FC146-7F86-434D-A82F-5F5AF79BE298" || hdLoginID.ToString().ToUpper() == "55A3AD81-3361-47E1-820F-ACC45547E810") { lstResult = objDashboard.GetDashboardCards(true, true, hdLoginID); m_SingleDay.EAC = lstResult.Sum(x => x.EAC); } else if (hdLoginID.ToString().ToUpper() == "654F9AC4-601D-4530-BB54-E667D037B1F3") { lstResult = objDashboard.GetDashboardCardsExcluded(true, false, hdLoginID, "('1900763842','1900764245')"); // geting top record List <ENT.DashboardCards> lstResultTop = new List <ENT.DashboardCards>(); lstResultTop = objDashboard.GetDashboardCardsTop(true, true, hdLoginID, "('1900763842','1900764245')"); lstResult = lstResult.Concat(lstResultTop).ToList <ENT.DashboardCards>(); m_SingleDay.EAC = lstResult.Sum(x => x.EAC); } else { lstResult = objDashboard.GetDashboardCards(true, false, hdLoginID); m_SingleDay.EAC = lstResult.Sum(x => x.EAC); } m_SingleDay.EACString = m_SingleDay.EAC.ToString() + " kWh"; List <ENT.InverterDateTable> lstTemp = new List <ENT.InverterDateTable>(); List <ENT.InverterDateTable> lstTable = new List <ENT.InverterDateTable>(); if (hdLoginID.ToString().ToUpper() == "CDADA587-1678-4128-B37D-BA9E2B04E508") { lstTemp = objDashboard.Get7DaysTable(dttm, dttm, true, hdLoginID); foreach (ENT.InverterDateTable el in lstTemp) { ENT.InverterDateTable obj = new ENT.InverterDateTable(); obj.SerialNo = el.SerialNo; obj.Day1 = el.Day1; obj.Day2 = el.Day2; obj.Day3 = el.Day3; obj.Day4 = el.Day4; obj.Day5 = el.Day5; obj.Day6 = el.Day6; obj.Day7 = el.Day7; obj.Total7Days = el.Total7Days; obj.DeviceName = el.DeviceName; lstTable.Add(obj); } } else { lstTemp = objDashboard.Get7DaysTable(dttm, dttm, false, hdLoginID); lstTable = lstTemp; } var intResult = objDashboard.GetPlantActiveMinutes(hdLoginID); objDashboard = null; return(Json(new { Today = m_SingleDay, Entire = m_Total, lstTable = lstTable, lstResult = lstResult, LastDateTime = intResult.FirstOrDefault().LastDateTime.GetFormatedDateTime(), ActiveMinutes = intResult.Sum(x => x.LastActMinutes) }, JsonRequestBehavior.AllowGet)); }