//Gen script
public static bool GenScriptMilestone(List <ExcelRow> listExcelRows)
{
var milestoneRepository = new MilestoneRepository();
var id = 0;
using (StreamWriter stream = File.AppendText(PathFileExport))
{
foreach (var item in listExcelRows)
{
if (!string.IsNullOrEmpty(item.IdMilestone) && !string.IsNullOrEmpty(item.MilestoneName))
{
id = Convert.ToInt32(item.IdMilestone);
var data = milestoneRepository.GetById(id);
if (data == null)
{
if (!ListIdMilestoneAdd.Contains(id))
{
ListIdMilestoneAdd.Add(id);
stream.WriteLine(
"INSERT INTO `milestone`(`Id`,`Name`,`CreatedById`,`LastUserId`,`LastTime`,`CreatedOn`,`LastModified`) " +
"VALUES ({0},'{1}',{2},{3},'{4}','{5}','{6}');",
item.IdMilestone, item.MilestoneName, CreateById, LastUserId, LastTime, CreatedOn,
LastModified);
}
}
else
{
if (!ListIdMilestoneUpdate.Contains(id))
{
ListIdMilestoneUpdate.Add(id);
stream.WriteLine("UPDATE `milestone` SET `Name` = '{0}' WHERE `Id` = {1};",
item.MilestoneName, id);
}
}
}
}
stream.WriteLine();
return(true);
}
}
