public ActionResult DeleteConfirmed(int id)
{
tbl_ISW_Data tbl_ISW_Data = db.tbl_ISW_Data.Find(id);
db.tbl_ISW_Data.Remove(tbl_ISW_Data);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "ID,CustomerName,CategoryName,ScheduledDate,ActivityName,MigrationWindow,MigrationGroup,TotalUnits,MigrationDate,SubStatus,Review,Status,UserName,UpdatedDate")] tbl_ISW_Data tbl_ISW_Data)
{
if (ModelState.IsValid)
{
db.tbl_ISW_Data.Add(tbl_ISW_Data);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tbl_ISW_Data));
}
public ActionResult Create([Bind(Include = "ID,CustomerName,CategoryName,MigrationType,MigrationWindow,MigrationGroup,ExpectedKickOff,MigratorName,PeerReviewer,DMName,LastKickOffEmailSent,KickOffStatus,ScheduleCount,SuccessCount,InProgressCount,FailedCount,CurrentPowerBICount,PreviousPowerBICount,EventStatus,UpdateStatus,LastUpdateEmailSent,CurrentSummary,CommentsForDelayKickOff,NextUpdateTime,ScheduledDate,ActivityName,updatedby,updateddate,MigrationApplied,KBUsed,Effort,PowerBIUpdated")] tbl_ISW_Data tbl_ISW_Data)
{
if (ModelState.IsValid)
{
db.tbl_ISW_Data.Add(tbl_ISW_Data);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tbl_ISW_Data));
}
// GET: Event/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_ISW_Data tbl_ISW_Data = db.tbl_ISW_Data.Find(id);
if (tbl_ISW_Data == null)
{
return(HttpNotFound());
}
return(View(tbl_ISW_Data));
}
public ActionResult Edit([Bind(Include = "ID,CustomerName,CategoryName,MigrationType,MigrationWindow,MigrationGroup,ExpectedKickOff,MigratorName,PeerReviewer,DMName,LastKickOffEmailSent,KickOffStatus,ScheduleCount,SuccessCount,InProgressCount,FailedCount,CurrentPowerBICount,PreviousPowerBICount,EventStatus,UpdateStatus,LastUpdateEmailSent,CurrentSummary,CommentsForDelayKickOff,NextUpdateTime,ScheduledDate,ActivityName,updatedby,updateddate,MigrationApplied,KBUsed,Effort,PowerBIUpdated,AssignBy,AssignDate,transferredDate,migrationCompleted,unitId")] tbl_ISW_Data tbl_ISW_Data)
{
var kstatus = new Dictionary <string, string>();
kstatus.Add("0", "Please select");
kstatus.Add("1", "Sent");
kstatus.Add("2", "Delayed");
kstatus.Add("3", "Canceled");
kstatus.Add("4", "Rescheduled");
kstatus.Add("5", "Final Sent");
ViewData["KStatus"] = kstatus;
var estatus = new Dictionary <string, string>();
estatus.Add("1", "Assigned");
estatus.Add("2", "Completed");
estatus.Add("3", "Customer Cancelled");
// estatus.Add("4", "Outflow");
estatus.Add("4", "Started");
// estatus.Add("6", "Task Cancelled");
// estatus.Add("7", "Transferred");
estatus.Add("5", "Unassigned ");
estatus.Add("", "");
estatus.Add("0", "");
ViewData["EStatus"] = estatus;
//if (tbl_ISW_Data.PowerBIUpdated == true && tbl_ISW_Data.InProgressCount != 0)
//{
// ModelState.AddModelError("powerBIerror", "Inprogress count should be zero");
//}
if (tbl_ISW_Data.ScheduleCount != tbl_ISW_Data.FailedCount + tbl_ISW_Data.SuccessCount + tbl_ISW_Data.InProgressCount)
{
ModelState.AddModelError("ScheduleCountError", "Schedule Count should be equals to sum of SuccessCount,FailedCount,InProgressCount");
}
if (ModelState.IsValid)
{
tbl_ISW_Data.updateddate = DateTime.Now;
tbl_ISW_Data.updatedby = System.Security.Principal.WindowsIdentity.GetCurrent().Name.Substring(System.Security.Principal.WindowsIdentity.GetCurrent().Name.LastIndexOf("\\") + 1);;
db.Entry(tbl_ISW_Data).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tbl_ISW_Data));
}
public ActionResult Edit([Bind(Include = "ID,CustomerName,CategoryName,ScheduledDate,ActivityName,MigrationWindow,MigrationGroup,TotalUnits,MigrationDate,SubStatus,Review,Status,UserName,UpdatedDate,completed,inprogress,failed")] tbl_ISW_Data tbl_ISW_Data)
{
if (ModelState.IsValid)
{
try
{
db.Entry(tbl_ISW_Data).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
}
}
return(View(tbl_ISW_Data));
}
// GET: EventData/Edit/5
public ActionResult Edit(int?id)
{
var kstatus = new Dictionary <string, string>();
kstatus.Add("0", "Please select");
kstatus.Add("1", "Sent");
kstatus.Add("2", "Delayed");
kstatus.Add("3", "Canceled");
kstatus.Add("4", "Rescheduled");
ViewData["KStatus"] = kstatus;
var estatus = new Dictionary <string, string>();
estatus.Add("1", "Assigned");
estatus.Add("2", "Completed");
estatus.Add("3", "Customer Cancelled");
// estatus.Add("4", "Outflow");
estatus.Add("4", "Started");
// estatus.Add("6", "Task Cancelled");
// estatus.Add("7", "Transferred");
estatus.Add("5", "Unassigned ");
ViewData["EStatus"] = estatus;
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_ISW_Data tbl_ISW_Data = db.tbl_ISW_Data.Find(id);
if (tbl_ISW_Data == null)
{
return(HttpNotFound());
}
return(View(tbl_ISW_Data));
}
