public ActionResult CreateSubRelease(ContinousIntegration.Models.NewSubReleaseModel tsubrelease, string Command)
{
if (!ModelState.IsValid)
{
return(PartialView("_CreateSubRelease", tsubrelease));
}
else
{
T_SubReleases Obj = new T_SubReleases();
Obj.C_SubReleaseName = tsubrelease.C_SubReleaseName;
Obj.C_SubReleaseID = tsubrelease.C_SubReleaseID;
Obj.C_ReleaseID = tsubrelease.C_ReleaseID;
Obj.C_StatusID = tsubrelease.C_StatusID;
Obj.C_LastModified = DateTime.Now;
bool IsSuccess = srobjModel.AddSubRelease(Obj);
if (IsSuccess)
{
TempData["OperStatus"] = "Sub-Release added successfully";
ModelState.Clear();
return(RedirectToAction("SearchSubRelease", "ManageProjects"));
}
}
return(PartialView("_CreateSubRelease"));
}
public List <NewSubReleaseModel> GetSubReleasePage(int pageNumber, int pageSize, string searchCriteria)
{
if (pageNumber < 1)
{
pageNumber = 1;
}
var RequiredSubReleaseModel = (from a in entities.T_Releases
join b in entities.T_SubReleases
on a.C_ReleaseID equals b.C_ReleaseID
join c in entities.T_Status
on b.C_StatusID equals c.C_StatusID
join d in entities.T_Streams
on a.C_StreamID equals d.C_StreamID
join e in entities.T_Projects
on d.C_ProjectID equals e.C_ProjectID
select new
{
a.C_ReleaseID,
a.C_ReleaseName,
b.C_SubReleaseID,
b.C_SubReleaseName,
b.C_StatusID,
b.C_LastModified,
c.C_StatusName,
e.C_ProjectID,
e.C_ProjectName,
d.C_StreamID, d.C_StreamName
})
.ToList();
//Populate NewSubReleaseModel with the required properties
List <NewSubReleaseModel> Subrelease = new List <NewSubReleaseModel>();
NewSubReleaseModel newobj;
foreach (var item in RequiredSubReleaseModel)
{
newobj = new NewSubReleaseModel();
newobj.C_ReleaseID = item.C_ReleaseID;
newobj.C_ReleaseName = item.C_ReleaseName;
newobj.C_SubReleaseName = item.C_SubReleaseName;
newobj.C_SubReleaseID = item.C_SubReleaseID;
newobj.C_StatusID = item.C_StatusID;
newobj.C_StatusName = item.C_StatusName;
newobj.C_LastModified = item.C_LastModified;
newobj.C_ProjectID = item.C_ProjectID;
newobj.C_ProjectName = item.C_ProjectName;
newobj.C_StreamID = item.C_StreamID;
newobj.C_StreamName = item.C_StreamName;
Subrelease.Add(newobj);
}
return(Subrelease);
}
public ActionResult UpdateSubRelease(ContinousIntegration.Models.NewSubReleaseModel tsubrelease, string Command)
{
bool IsSuccess = srobjModel.UpdateSubRelease(tsubrelease);
if (IsSuccess)
{
TempData["OperStatus"] = "Sub-Release updated successfully";
ModelState.Clear();
return(RedirectToAction("SearchSubRelease", "ManageProjects"));
}
return(PartialView("_EditSubRelease"));
}
//To update Sub Release details
public bool UpdateSubRelease(NewSubReleaseModel tsubrelease)
{
try
{
var subrelease = entities.T_SubReleases.FirstOrDefault(x => x.C_SubReleaseID.Equals(tsubrelease.C_SubReleaseID));
//Populate T_SubReleases with NewSubRelease Model
subrelease.C_ReleaseID = tsubrelease.C_ReleaseID;
subrelease.C_SubReleaseID = tsubrelease.C_SubReleaseID;
subrelease.C_SubReleaseName = tsubrelease.C_SubReleaseName;
subrelease.C_StatusID = tsubrelease.C_StatusID;
subrelease.C_LastModified = DateTime.Now;
entities.T_SubReleases.AddOrUpdate(subrelease);
entities.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
/// <summary>
/// Method to populate the edit popup
/// </summary>
/// <param name="page"></param>
/// <param name="sort"></param>
/// <param name="sortDir"></param>
/// <returns></returns>
//Edit SubRelease
public ActionResult EditSubRelease(int subreleaseId)
{
ContinuousIntegrationEntities ci = new ContinuousIntegrationEntities();
var data = (from a in ci.T_Projects
join b in ci.T_Streams
on a.C_ProjectID equals b.C_ProjectID
join c in ci.T_Releases
on b.C_StreamID equals c.C_StreamID
join d in ci.T_SubReleases
on c.C_ReleaseID equals d.C_ReleaseID
where subreleaseId == d.C_SubReleaseID
select new
{
a.C_ProjectID,
c.C_ReleaseID,
d.C_SubReleaseName,
d.C_SubReleaseID,
d.C_StatusID,
d.C_LastModified,
b.C_StreamID,
b.C_StreamName
}).FirstOrDefault();
NewSubReleaseModel Obj;
if (Request.IsAjaxRequest())
{
Obj = new NewSubReleaseModel();
Obj.C_SubReleaseName = data.C_SubReleaseName;
Obj.C_ReleaseID = data.C_ReleaseID;
Obj.C_SubReleaseID = data.C_SubReleaseID;
Obj.C_StatusID = data.C_StatusID;
Obj.C_LastModified = data.C_LastModified;
Obj.C_ProjectID = data.C_ProjectID;
Obj.C_StreamID = data.C_StreamID;
Obj.C_StreamName = data.C_StreamName;
ViewBag.ProjectName = new SelectList(ci.T_Projects, "C_ProjectID", "C_ProjectName");
ViewBag.ReleaseName = new SelectList(ci.T_Releases.Where(x=> x.C_StreamID.Equals(data.C_StreamID)), "C_ReleaseID", "C_ReleaseName",ci.T_Releases.Where(x=> x.C_ReleaseID.Equals(data.C_ReleaseID)));
ViewBag.StatusName = new SelectList(ci.T_Status, "C_StatusID", "C_StatusName");
ViewBag.StreamName = new SelectList(ci.T_Streams.Where(x => x.C_ProjectID.Equals(data.C_ProjectID)), "C_StreamID", "C_StreamName", ci.T_Streams.Where(x => x.C_StreamID.Equals(data.C_StreamID)));
ViewBag.IsUpdate = true;
return View("_EditSubRelease", Obj);
}
else
return View(data);
}
public List<NewSubReleaseModel> GetSubReleasePage(int pageNumber, int pageSize, string searchCriteria)
{
if (pageNumber < 1)
pageNumber = 1;
var RequiredSubReleaseModel = (from a in entities.T_Releases
join b in entities.T_SubReleases
on a.C_ReleaseID equals b.C_ReleaseID
join c in entities.T_Status
on b.C_StatusID equals c.C_StatusID
join d in entities.T_Streams
on a.C_StreamID equals d.C_StreamID
join e in entities.T_Projects
on d.C_ProjectID equals e.C_ProjectID
select new
{
a.C_ReleaseID,
a.C_ReleaseName,
b.C_SubReleaseID,
b.C_SubReleaseName,
b.C_StatusID,
b.C_LastModified,
c.C_StatusName,
e.C_ProjectID,
e.C_ProjectName,
d.C_StreamID,d.C_StreamName
})
.ToList();
//Populate NewSubReleaseModel with the required properties
List<NewSubReleaseModel> Subrelease = new List<NewSubReleaseModel>();
NewSubReleaseModel newobj;
foreach (var item in RequiredSubReleaseModel)
{
newobj = new NewSubReleaseModel();
newobj.C_ReleaseID = item.C_ReleaseID;
newobj.C_ReleaseName = item.C_ReleaseName;
newobj.C_SubReleaseName = item.C_SubReleaseName;
newobj.C_SubReleaseID = item.C_SubReleaseID;
newobj.C_StatusID = item.C_StatusID;
newobj.C_StatusName = item.C_StatusName;
newobj.C_LastModified = item.C_LastModified;
newobj.C_ProjectID = item.C_ProjectID;
newobj.C_ProjectName = item.C_ProjectName;
newobj.C_StreamID = item.C_StreamID;
newobj.C_StreamName = item.C_StreamName;
Subrelease.Add(newobj);
}
return Subrelease;
}
//To update Sub Release details
public bool UpdateSubRelease(NewSubReleaseModel tsubrelease)
{
try
{
var subrelease = entities.T_SubReleases.FirstOrDefault(x => x.C_SubReleaseID.Equals(tsubrelease.C_SubReleaseID));
//Populate T_SubReleases with NewSubRelease Model
subrelease.C_ReleaseID = tsubrelease.C_ReleaseID;
subrelease.C_SubReleaseID = tsubrelease.C_SubReleaseID;
subrelease.C_SubReleaseName = tsubrelease.C_SubReleaseName;
subrelease.C_StatusID = tsubrelease.C_StatusID;
subrelease.C_LastModified = DateTime.Now;
entities.T_SubReleases.AddOrUpdate(subrelease);
entities.SaveChanges();
return true;
}
catch (Exception e)
{
return false;
}
}