public ActionResult Export() { var masterData = new SMOScopeBLL().Todos_completos_action_plan().Where(smo => smo.O_C.ToUpper() == "O" && (smo.ActionPlan != string.Empty && smo.ActionPlan != null)).ToList(); var file = new ExcelCore().GenerarActionReport("LARCA Action Plan Report", masterData); DownloadFile(file); return(Content("<script language='javascript' type='text/javascript'>alert('Exported!');document.location = 'Index';</script>")); }
public ActionResult Index() { var model = new Larca2.Views.ViewModels.SMOScopeViewModel(); try { ViewData["MasterRows"] = new SMOScopeBLL().Todos_completos_action_plan().Where(smo => smo.O_C.ToUpper() == "O" && (smo.ActionPlan != string.Empty && smo.ActionPlan != null)).ToList(); } catch { ViewData["MasterRows"] = new List <LARCA20_SmoScope>(); } return(View(model)); }
public List <ReportRow> LARCANews(string smoFin, string buFin, string regionId) { var permisos = new List <LARCA20_UsersRoles>(); var lista = new List <ReportRow>(); var toplvl2 = new ApplicationDataBLL().TraerTopLvl2(); var lista22 = new LARCA2.Data.Services.UserOwnerDAL(); var permisostodos = lista22.Todos(); if (smoFin.Length > 0) { var items = SmoScopeDAL.Todos().Where(s => s.MasterSMO.DataFin == smoFin && s.clone != true && s.historic != true).GroupBy(p => p.MasterLvl.Code.Split(Convert.ToChar("."))[0] + "." + p.MasterLvl.Code.Split(Convert.ToChar("."))[1]); int cant = 0; foreach (var item in items) //.Take(toplvl2)) { cant++; var volumenSmo = Convert.ToDecimal(SmoDetailDAL.Todos().Where(s => s.MasterSMODetail.DataFin == smoFin && s.historic == false).Sum(s => s.Volumen)); var volumen = SmoDetailDAL.Todos().Where(s => s.MasterSMODetail.DataFin == smoFin && s.historic == false && s.MasterLvl2Detail.Code.Split(Convert.ToChar("."))[0] + "." + s.MasterLvl2Detail.Code.Split(Convert.ToChar("."))[1] == item.Key).Sum(s => s.Volumen); var row = new ReportRow(); row.SMO = item.ToList()[0].MasterSMO.DataFin; row.RBU = "TOTAL"; row.CUT = new RCClassificationBLL().Traer(item.Key).Description; row.Details = new List <ReportRow>(); row.VOLUME = (Math.Round(decimal.Parse(volumen.ToString()), 2)).ToString(); row.PROBLEM = "View Details Below"; row.GAP = Math.Round(volumen * 100 / volumenSmo, 2).ToString() + " %"; var toplvl3 = new ApplicationDataBLL().TraerTopLvl3(); decimal vol = 0; int i = 1; foreach (var subitem in item.ToList().OrderByDescending(s => s.Volumen).Take(toplvl3)) //.Take(toplvl3)) { var detailRow = new ReportRow { SMO = subitem.MasterSMO.DataFin, RBU = subitem.MasterBU.DataFin, CUT = subitem.MasterLvl.Description, VOLUME = (Math.Round(decimal.Parse(subitem.Volumen.ToString()), 2)).ToString(), PROBLEM = CheckProblem(subitem.Problem, subitem.ActionPlan, subitem.RefIdBU, subitem.RefIdSMO, subitem.RefIdOwner, subitem.partial, subitem.top_news), WHY1 = subitem.Why1, WHY2 = subitem.Why2, WHY3 = subitem.Why3, ACTIONPLAN = subitem.ActionPlan, LEVEL4 = "", RESPONSIBLE = subitem.ResponsableSmo != null ? subitem.ResponsableSmo.Responsable_user.user_name : string.Empty, GAP = Math.Round(Convert.ToDecimal(subitem.Volumen) * 100 / volumen, 2).ToString() + " %" }; try { detailRow.LEVEL4 = subitem.Level4 != null ? new Level4BLL().Traer(Convert.ToInt64(subitem.Level4)).name : string.Empty; } catch (Exception) { detailRow.LEVEL4 = ""; } var user = new UserOwnerBLL().UserPermisoCheck(subitem.RefIdBU, subitem.RefIdSMO, subitem.RefIdOwner); if (user.Id > 0) { detailRow.GAPANALYSIS = user.user_name; } else { detailRow.GAPANALYSIS = ""; } ////// Boolean paso = false; if (i == 1) { i++; vol = (Math.Round(decimal.Parse(subitem.Volumen.ToString()), 2)); row.Details.Add(detailRow); paso = true; } else { if (vol * 100 / volumen <= 80) { i++; vol += (Math.Round(decimal.Parse(subitem.Volumen.ToString()), 2)); row.Details.Add(detailRow); paso = true; } } if (paso) { // Chequeo de clones var clones = new SMOScopeBLL().Todos().Where(s => s.RefIdSMO == subitem.RefIdSMO && s.RefIdBU == subitem.RefIdBU && s.RefIdOwner == subitem.RefIdOwner && s.RefIdRC == subitem.RefIdRC && s.SmoScopeID != subitem.SmoScopeID && s.clone == true && s.historic == false); if (clones.Count() > 0) { foreach (var clon in clones) { var detail = new ReportRow { SMO = string.Empty, RBU = string.Empty, CUT = string.Empty, VOLUME = string.Empty, PROBLEM = clon.Problem, WHY1 = clon.Why1, WHY2 = clon.Why2, WHY3 = clon.Why3, ACTIONPLAN = clon.ActionPlan, RESPONSIBLE = clon.ResponsableSmo != null ? clon.ResponsableSmo.Responsable_user.user_name : string.Empty, //LEVEL4 = clon.Level4 != null ? new Level4BLL().Traer(Convert.ToInt64(clon.Level4)).name : string.Empty, LEVEL4 = "", GAP = string.Empty }; try { detail.LEVEL4 = clon.Level4 != null ? new Level4BLL().Traer(Convert.ToInt64(clon.Level4)).name : string.Empty; } catch (Exception) { detail.LEVEL4 = ""; } user = new UserOwnerBLL().UserPermisoCheck(clon.RefIdBU, clon.RefIdSMO, clon.RefIdOwner); if (user.Id > 0) { detail.GAPANALYSIS = user.user_name; } else { detail.GAPANALYSIS = ""; } row.Details.Add(detail); } } } } lista.Add(row); } } else if (buFin.Length > 0) { var items = SmoScopeDAL.Todos().Where(s => s.MasterBU.DataFin == buFin && s.historic == false && s.clone != true).GroupBy(p => p.MasterLvl.Code.Split(Convert.ToChar("."))[0] + "." + p.MasterLvl.Code.Split(Convert.ToChar("."))[1]); int cant = 0; foreach (var item in items) //.Take(toplvl2)) { cant++; var volumenBU = Convert.ToDecimal(SmoDetailDAL.Todos().Where(s => s.MasterBUDetail.DataFin == buFin && s.historic == false).Sum(s => s.Volumen)); var volumen = SmoDetailDAL.Todos().Where(s => s.MasterBUDetail.DataFin == buFin && s.historic == false && s.MasterLvl2Detail.Code.Split(Convert.ToChar("."))[0] + "." + s.MasterLvl2Detail.Code.Split(Convert.ToChar("."))[1] == item.Key).Sum(s => s.Volumen); var row = new ReportRow(); row.SMO = "TOTAL"; row.RBU = item.ToList()[0].MasterBU.DataFin; row.CUT = new RCClassificationBLL().Traer(item.Key).Description; row.Details = new List <ReportRow>(); row.VOLUME = (Math.Round(decimal.Parse(volumen.ToString()), 2)).ToString(); row.PROBLEM = "View Details Below"; row.GAP = Math.Round(volumen * 100 / volumenBU, 2).ToString() + " %"; decimal vol = 0; int i = 1; var toplvl3 = new ApplicationDataBLL().TraerTopLvl3(); foreach (var subitem in item.ToList().OrderByDescending(s => s.Volumen).Take(toplvl3)) { string SMOt = subitem.MasterSMO.DataFin; string RBUt = subitem.MasterBU.DataFin; string CUTt = subitem.MasterLvl.Description; string VOLUMEt = (Math.Round(decimal.Parse(subitem.Volumen.ToString()), 2)).ToString(); string PROBLEMt = CheckProblem(subitem.Problem, subitem.ActionPlan, subitem.RefIdBU, subitem.RefIdSMO, subitem.RefIdOwner, subitem.partial, subitem.top_news); string WHY1t = subitem.Why1; string WHY2t = subitem.Why2; string WHY3t = subitem.Why3; string ACTIONPLANt = subitem.ActionPlan; string RESPONSIBLEt = subitem.ResponsableSmo != null ? subitem.ResponsableSmo.Responsable_user.user_name : string.Empty; string LEVEL4t = ""; string GAPANALYSIS; try { LEVEL4t = subitem.Level4 != null ? new Level4BLL().Traer(Convert.ToInt64(subitem.Level4)).name : string.Empty; } catch (Exception) { LEVEL4t = ""; } var user = new UserOwnerBLL().UserPermisoCheck(subitem.RefIdBU, subitem.RefIdSMO, subitem.RefIdOwner); if (user.Id > 0) { GAPANALYSIS = user.user_name; } else { GAPANALYSIS = ""; } string GAPt = Math.Round(Convert.ToDecimal(subitem.Volumen) * 100 / volumen, 2).ToString() + " %"; var detailRow = new ReportRow { SMO = SMOt, RBU = RBUt, CUT = CUTt, VOLUME = VOLUMEt, PROBLEM = PROBLEMt, WHY1 = WHY1t, WHY2 = WHY2t, WHY3 = WHY3t, ACTIONPLAN = ACTIONPLANt, RESPONSIBLE = RESPONSIBLEt, LEVEL4 = LEVEL4t, GAP = GAPt, GAPANALYSIS = GAPANALYSIS /* * SMO = subitem.MasterSMO.DataFin, * RBU = subitem.MasterBU.DataFin, * CUT = subitem.MasterLvl.Description, * VOLUME = (Math.Round(decimal.Parse(subitem.Volumen.ToString()), 2)).ToString(), * PROBLEM = CheckProblem(subitem.Problem, subitem.RefIdBU, subitem.RefIdSMO, subitem.RefIdOwner), * WHY1 = subitem.Why1, * WHY2 = subitem.Why2, * WHY3 = subitem.Why3, * ACTIONPLAN = subitem.ActionPlan, * RESPONSIBLE = subitem.ResponsableSmo != null ? subitem.ResponsableSmo.Name.ToString() : string.Empty, * LEVEL4 = subitem.Level4 != null ? new Level4BLL().Traer(Convert.ToInt64(subitem.Level4)).name : string.Empty, * GAP = Math.Round(Convert.ToDecimal(subitem.Volumen) * 100 / volumen, 2).ToString() + " %" */ }; Boolean paso = false; if (i == 1) { i++; vol = (Math.Round(decimal.Parse(subitem.Volumen.ToString()), 2)); row.Details.Add(detailRow); paso = true; } else { if (vol * 100 / volumen <= 80) { i++; vol += (Math.Round(decimal.Parse(subitem.Volumen.ToString()), 2)); row.Details.Add(detailRow); paso = true; } } if (paso) { // Chequeo de clones var clones = new SMOScopeBLL().Todos().Where(s => s.RefIdSMO == subitem.RefIdSMO && s.RefIdBU == subitem.RefIdBU && s.RefIdOwner == subitem.RefIdOwner && s.RefIdRC == subitem.RefIdRC && s.SmoScopeID != subitem.SmoScopeID && s.clone == true && s.historic == false); if (clones.Count() > 0) { foreach (var clon in clones) { var detail = new ReportRow { SMO = string.Empty, RBU = string.Empty, CUT = string.Empty, VOLUME = string.Empty, PROBLEM = clon.Problem, WHY1 = clon.Why1, WHY2 = clon.Why2, WHY3 = clon.Why3, ACTIONPLAN = clon.ActionPlan, RESPONSIBLE = clon.ResponsableSmo != null ? clon.ResponsableSmo.Responsable_user.user_name : string.Empty, //LEVEL4 = clon.Level4 != null ? new Level4BLL().Traer(Convert.ToInt64(clon.Level4)).name : string.Empty, LEVEL4 = "", GAP = string.Empty }; try { detail.LEVEL4 = clon.Level4 != null ? new Level4BLL().Traer(Convert.ToInt64(clon.Level4)).name : string.Empty; } catch (Exception) { detail.LEVEL4 = ""; } user = new UserOwnerBLL().UserPermisoCheck(clon.RefIdBU, clon.RefIdSMO, clon.RefIdOwner); if (user.Id > 0) { detail.GAPANALYSIS = user.user_name; } else { detail.GAPANALYSIS = ""; } row.Details.Add(detail); } } } } lista.Add(row); } } else { if (regionId == "1") { var items = SmoScopeDAL.Todos().Where(p => p.clone != true && p.historic == false).GroupBy(p => p.MasterLvl.Code.Split(Convert.ToChar("."))[0] + "." + p.MasterLvl.Code.Split(Convert.ToChar("."))[1]); int cant = 0; foreach (var item in items) //.Take(toplvl2)) { cant++; var volumenTotal = Convert.ToDecimal(SmoDetailDAL.Todos().Where(s => s.historic == false).Sum(s => s.Volumen)); var volumen = SmoDetailDAL.Todos().Where(s => s.MasterLvl2Detail.Code.Split(Convert.ToChar("."))[0] + "." + s.MasterLvl2Detail.Code.Split(Convert.ToChar("."))[1] == item.Key && s.historic == false).Sum(s => s.Volumen); var row = new ReportRow(); row.SMO = "TOTAL"; row.RBU = "TOTAL"; row.CUT = new RCClassificationBLL().Traer(item.Key).Description; row.Details = new List <ReportRow>(); row.VOLUME = (Math.Round(decimal.Parse(volumen.ToString()), 2)).ToString(); row.PROBLEM = "View Details Below"; row.GAP = Math.Round(volumen * 100 / volumenTotal, 2).ToString() + " %"; decimal vol = 0; int i = 1; var toplvl3 = new ApplicationDataBLL().TraerTopLvl3(); foreach (var subitem in item.ToList().OrderByDescending(s => s.Volumen).Take(toplvl3)) { var detailRow = new ReportRow { SMO = subitem.MasterSMO.DataFin, RBU = subitem.MasterBU.DataFin, CUT = subitem.MasterLvl.Description, VOLUME = (Math.Round(decimal.Parse(subitem.Volumen.ToString()), 2)).ToString(), PROBLEM = CheckProblem(subitem.Problem, subitem.ActionPlan, subitem.RefIdBU, subitem.RefIdSMO, subitem.RefIdOwner, subitem.partial, subitem.top_news), WHY1 = subitem.Why1, WHY2 = subitem.Why2, WHY3 = subitem.Why3, ACTIONPLAN = subitem.ActionPlan, RESPONSIBLE = subitem.ResponsableSmo != null ? subitem.ResponsableSmo.Responsable_user.user_name : string.Empty, //LEVEL4 = subitem.Level4 != null ? new Level4BLL().Traer(Convert.ToInt64(subitem.Level4)).name : string.Empty, LEVEL4 = "", GAP = Math.Round(Convert.ToDecimal(subitem.Volumen) * 100 / volumen, 2).ToString() + " %" }; try { detailRow.LEVEL4 = subitem.Level4 != null ? new Level4BLL().Traer(Convert.ToInt64(subitem.Level4)).name : string.Empty; } catch (Exception) { detailRow.LEVEL4 = ""; } var user = new UserOwnerBLL().UserPermisoCheck(subitem.RefIdBU, subitem.RefIdSMO, subitem.RefIdOwner); if (user.Id > 0) { detailRow.GAPANALYSIS = user.user_name; } else { detailRow.GAPANALYSIS = ""; } Boolean paso = false; if (i == 1) { i++; vol = (Math.Round(decimal.Parse(subitem.Volumen.ToString()), 2)); row.Details.Add(detailRow); paso = true; } else { if (vol * 100 / volumen <= 80) { i++; vol += (Math.Round(decimal.Parse(subitem.Volumen.ToString()), 2)); row.Details.Add(detailRow); paso = true; } } if (paso) { // Chequeo de clones var clones = new SMOScopeBLL().Todos().Where(s => s.RefIdSMO == subitem.RefIdSMO && s.RefIdBU == subitem.RefIdBU && s.RefIdOwner == subitem.RefIdOwner && s.RefIdRC == subitem.RefIdRC && s.SmoScopeID != subitem.SmoScopeID && s.clone == true && s.historic == false); if (clones.Count() > 0) { foreach (var clon in clones) { var detail = new ReportRow { SMO = string.Empty, RBU = string.Empty, CUT = string.Empty, VOLUME = string.Empty, PROBLEM = clon.Problem, WHY1 = clon.Why1, WHY2 = clon.Why2, WHY3 = clon.Why3, ACTIONPLAN = clon.ActionPlan, RESPONSIBLE = clon.ResponsableSmo != null ? clon.ResponsableSmo.Responsable_user.user_name : string.Empty, //LEVEL4 = clon.Level4 != null ? new Level4BLL().Traer(Convert.ToInt64(clon.Level4)).name : string.Empty, LEVEL4 = "", GAP = string.Empty }; try { detail.LEVEL4 = clon.Level4 != null ? new Level4BLL().Traer(Convert.ToInt64(clon.Level4)).name : string.Empty; } catch (Exception) { detail.LEVEL4 = ""; } user = new UserOwnerBLL().UserPermisoCheck(clon.RefIdBU, clon.RefIdSMO, clon.RefIdOwner); if (user.Id > 0) { detail.GAPANALYSIS = user.user_name; } else { detail.GAPANALYSIS = ""; } row.Details.Add(detail); } } } } lista.Add(row); } } else if (regionId == "2") { var items = SmoScopeDAL.TodosConExclusiones().Where(p => p.clone != true && p.historic == false).GroupBy(p => p.MasterLvl.Code.Split(Convert.ToChar("."))[0] + "." + p.MasterLvl.Code.Split(Convert.ToChar("."))[1]); int cant = 0; foreach (var item in items) //.Take(toplvl2)) { cant++; var volumenTotal = Convert.ToDecimal(SmoDetailDAL.Todos().Where(s => s.historic == false).Sum(s => s.Volumen)); var volumen = SmoDetailDAL.Todos().Where(s => s.MasterLvl2Detail.Code.Split(Convert.ToChar("."))[0] + "." + s.MasterLvl2Detail.Code.Split(Convert.ToChar("."))[1] == item.Key && s.historic == false).Sum(s => s.Volumen); var row = new ReportRow(); row.SMO = "TOTAL"; row.RBU = "TOTAL"; row.CUT = new RCClassificationBLL().Traer(item.Key).Description; row.Details = new List <ReportRow>(); row.VOLUME = (Math.Round(decimal.Parse(volumen.ToString()), 2)).ToString(); row.PROBLEM = "View Details Below"; row.GAP = Math.Round(volumen * 100 / volumenTotal, 2).ToString() + " %"; decimal vol = 0; int i = 1; var toplvl3 = new ApplicationDataBLL().TraerTopLvl3(); foreach (var subitem in item.ToList().OrderByDescending(s => s.Volumen).Take(toplvl3)) { var detailRow = new ReportRow { SMO = subitem.MasterSMO.DataFin, RBU = subitem.MasterBU.DataFin, CUT = subitem.MasterLvl.Description, VOLUME = (Math.Round(decimal.Parse(subitem.Volumen.ToString()), 2)).ToString(), PROBLEM = CheckProblem(subitem.Problem, subitem.ActionPlan, subitem.RefIdBU, subitem.RefIdSMO, subitem.RefIdOwner, subitem.partial, subitem.top_news), WHY1 = subitem.Why1, WHY2 = subitem.Why2, WHY3 = subitem.Why3, ACTIONPLAN = subitem.ActionPlan, RESPONSIBLE = subitem.ResponsableSmo != null ? subitem.ResponsableSmo.Responsable_user.user_name : string.Empty, //LEVEL4 = subitem.Level4 != null ? new Level4BLL().Traer(Convert.ToInt64(subitem.Level4)).name : string.Empty, LEVEL4 = "", GAP = Math.Round(Convert.ToDecimal(subitem.Volumen) * 100 / volumen, 2).ToString() + " %" }; try { detailRow.LEVEL4 = subitem.Level4 != null ? new Level4BLL().Traer(Convert.ToInt64(subitem.Level4)).name : string.Empty; } catch (Exception) { detailRow.LEVEL4 = ""; } var user = new UserOwnerBLL().UserPermisoCheck(subitem.RefIdBU, subitem.RefIdSMO, subitem.RefIdOwner); if (user.Id > 0) { detailRow.GAPANALYSIS = user.user_name; } else { detailRow.GAPANALYSIS = ""; } Boolean paso = false; if (i == 1) { i++; vol = (Math.Round(decimal.Parse(subitem.Volumen.ToString()), 2)); row.Details.Add(detailRow); paso = true; } else { if (vol * 100 / volumen <= 80) { i++; vol += (Math.Round(decimal.Parse(subitem.Volumen.ToString()), 2)); row.Details.Add(detailRow); paso = true; } } if (paso) { // Chequeo de clones var clones = new SMOScopeBLL().Todos().Where(s => s.RefIdSMO == subitem.RefIdSMO && s.RefIdBU == subitem.RefIdBU && s.RefIdOwner == subitem.RefIdOwner && s.RefIdRC == subitem.RefIdRC && s.SmoScopeID != subitem.SmoScopeID && s.clone == true && s.historic == false); if (clones.Count() > 0) { foreach (var clon in clones) { var detail = new ReportRow { SMO = string.Empty, RBU = string.Empty, CUT = string.Empty, VOLUME = string.Empty, PROBLEM = clon.Problem, WHY1 = clon.Why1, WHY2 = clon.Why2, WHY3 = clon.Why3, ACTIONPLAN = clon.ActionPlan, RESPONSIBLE = clon.ResponsableSmo != null ? clon.ResponsableSmo.Responsable_user.user_name : string.Empty, //LEVEL4 = clon.Level4 != null ? new Level4BLL().Traer(Convert.ToInt64(clon.Level4)).name : string.Empty, LEVEL4 = "", GAP = string.Empty }; try { detail.LEVEL4 = clon.Level4 != null ? new Level4BLL().Traer(Convert.ToInt64(clon.Level4)).name : string.Empty; } catch (Exception) { detail.LEVEL4 = ""; } user = new UserOwnerBLL().UserPermisoCheck(clon.RefIdBU, clon.RefIdSMO, clon.RefIdOwner); if (user.Id > 0) { detail.GAPANALYSIS = user.user_name; } else { detail.GAPANALYSIS = ""; } row.Details.Add(detail); } } } } lista.Add(row); } } } return(lista.OrderByDescending(i => Convert.ToDecimal(i.VOLUME)).Take(toplvl2).ToList()); }