private static SprintComment AddSprintComment(int sprintId, int i, string commentName)
{
var sprintComment = new SprintComment
{
MemberId = (int)AgileMember.AllSpaceXTeam,
Name = commentName,
SprintId = sprintId
};
if (i == 0 || i == 1)
{
sprintComment.SprintCategoryId = (int)SprintCategory.WhatDidWeDoWell;
}
else if (i == 2 || i == 3)
{
sprintComment.SprintCategoryId = (int)SprintCategory.WhatDidWeDoWrong;
}
else if (i == 4 || i == 5)
{
sprintComment.SprintCategoryId = (int)SprintCategory.WhatCouldBeImproved;
}
return(sprintComment);
}
public ActionResult Import(FormCollection formCollection)
{
if (Request != null && formCollection.Count > 0)
{
DataTable dt = new DataTable();
HttpPostedFileBase file = Request.Files["UploadedFile"];
if ((file != null) && (file.ContentLength > 0) && !string.IsNullOrEmpty(file.FileName))
{
string fileName = file.FileName;
string path = Server.MapPath("~") + "\\ExcelFiles\\" + fileName;
file.SaveAs(path);
if (!System.IO.Directory.Exists(Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["XlsFilePath"])))
{
System.IO.Directory.CreateDirectory(Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["XlsFilePath"]));
}
var excelData = new ExcelData(path);
var sData = excelData.getData(Request["sheetName"]);
dt = sData.CopyToDataTable();
var sprint = new Sprint();
var sprintComments = new List <SprintComment>();
var count = 0;
var lastCountForComment = dt.Rows.Count;
foreach (DataRow item in dt.Rows)
{
//sprint
if (count == 0)
{
AddSprint(sprint, item);
}
if (item.ItemArray[0].ToString() == "Sprint Score")
{
lastCountForComment = count;
}
//sprint comments
else if (count > 0 && count < lastCountForComment)
{
for (int columnIndex = 0; columnIndex < 6; columnIndex++)
{
var commentName = item.ItemArray[columnIndex].ToString();
if (!string.IsNullOrEmpty(commentName))
{
SprintComment sprintComment = AddSprintComment(sprint.Id, columnIndex, commentName);
sprintComments.Add(sprintComment);
}
}
}
count++;
}
// Adding actionplans and decisions
count = 0;
foreach (DataRow item in dt.Rows)
{
if (item.ItemArray[0].ToString() == "Sprint Score")
{
lastCountForComment = count;
}
//sprint comments & Action Plans & Decisions
else if (count > 0 && count < lastCountForComment)
{
var memberId = GetMemeberId(item.ItemArray[10].ToString());
var planName = item.ItemArray[11].ToString();
var sprintComment = sprintComments.FirstOrDefault(o => planName.ToLower().Contains(o.Name.ToLower()));
if (sprintComment != null)
{
AddActionPlansAndDecisions(sprint, item, memberId, planName, sprintComment);
}
else
{
var newCommentFromActionPlan = AddSprintComment(sprint.Id, 5, planName);
AddActionPlansAndDecisions(sprint, item, memberId, planName, newCommentFromActionPlan);
sprintComments.Add(newCommentFromActionPlan);
}
}
count++;
}
sprint.SprintComments = sprintComments;
SaveFromExceltoDbAsync(sprint);
}
}
return(View("Index"));
}
private static void AddActionPlansAndDecisions(Sprint sprint, DataRow item, int memberId, string planName, SprintComment sprintComment)
{
//Add Action Plan
if (!string.IsNullOrEmpty(planName))
{
var actionPlan = new ActionPlan
{
FollwingUpByMemberId = memberId,
SprintCommentId = sprint.Id
};
var actionPlanDecisions = new List <ActionPlanDecision>();
//ActionPlanDecisions
for (int k = 12; k < 18; k++)
{
var decision = item.ItemArray[k].ToString();
if (!string.IsNullOrEmpty(decision))
{
var actionPlanDecision = new ActionPlanDecision
{
ActionPlanId = actionPlan.Id,
Decision = decision
};
actionPlanDecisions.Add(actionPlanDecision);
}
}
actionPlan.ActionPlanDecisions = actionPlanDecisions;
sprintComment.ActionPlans.Add(actionPlan);
}
}
