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