public ActionResult CreateRelease(ContinousIntegration.Models.NewReleaseModel trelease, string Command)
{
if (!ModelState.IsValid)
{
return(PartialView("_CreateRelease", trelease));
}
else
{
T_Releases Obj = new T_Releases();
Obj.C_ReleaseName = trelease.C_ReleaseName;
Obj.C_StreamID = trelease.C_StreamID;
Obj.C_StatusID = trelease.C_StatusID;
Obj.C_LastModified = DateTime.Now;
bool IsSuccess = robjModel.AddRelease(trelease);
if (IsSuccess)
{
TempData["OperStatus"] = "Release added successfully";
ModelState.Clear();
return(RedirectToAction("SearchRelease", "ManageProjects"));
}
}
return(PartialView("_CreateRelease"));
}
//To add new Project
public bool AddRelease(NewReleaseModel trelease)
{
try
{
//Populate T_Releases with NewReleaseModel
T_Releases relobj = new T_Releases()
{
C_StreamID = trelease.C_StreamID,
C_ReleaseID = trelease.C_ReleaseID,
C_ReleaseName = trelease.C_ReleaseName,
C_StatusID = trelease.C_StatusID,
C_LastModified = DateTime.Now
};
entities.T_Releases.Add(relobj);
entities.SaveChanges();
//ModelState.Clear();
//trelease = null;
return true;
}
catch (Exception e)
{
return false;
}
}
//To add new Project
public bool AddRelease(NewReleaseModel trelease)
{
try
{
//Populate T_Releases with NewReleaseModel
T_Releases relobj = new T_Releases()
{
C_StreamID = trelease.C_StreamID,
C_ReleaseID = trelease.C_ReleaseID,
C_ReleaseName = trelease.C_ReleaseName,
C_StatusID = trelease.C_StatusID,
C_LastModified = DateTime.Now
};
entities.T_Releases.Add(relobj);
entities.SaveChanges();
//ModelState.Clear();
//trelease = null;
return(true);
}
catch (Exception e)
{
return(false);
}
}
public ActionResult UpdateRelease(ContinousIntegration.Models.NewReleaseModel trelease, string Command)
{
bool IsSuccess = robjModel.UpdateRelease(trelease);
if (IsSuccess)
{
TempData["OperStatus"] = "Release updated successfully";
ModelState.Clear();
return(RedirectToAction("SearchRelease", "ManageProjects"));
}
return(PartialView("_EditRelease"));
}
public List <NewReleaseModel> GetReleasePage(int pageNumber, int pageSize, string searchCriteria)
{
if (pageNumber < 1)
{
pageNumber = 1;
}
var RequiredReleaseModel = (from a in entities.T_Streams
join b in entities.T_Releases
on a.C_StreamID equals b.C_StreamID
join c in entities.T_Status
on b.C_StatusID equals c.C_StatusID
join d in entities.T_Projects
on a.C_ProjectID equals d.C_ProjectID
select new { a.C_StreamID, a.C_StreamName, b.C_ReleaseID, b.C_ReleaseName, b.C_StatusID,
b.C_LastModified, c.C_StatusName, d.C_ProjectID, d.C_ProjectName })
.ToList();
//Populate NewReleaseModel with the required properties
List <NewReleaseModel> release = new List <NewReleaseModel>();
NewReleaseModel newobj;
foreach (var item in RequiredReleaseModel)
{
newobj = new NewReleaseModel();
newobj.C_ReleaseID = item.C_ReleaseID;
newobj.C_ReleaseName = item.C_ReleaseName;
newobj.C_StreamID = item.C_StreamID;
newobj.C_StreamName = item.C_StreamName;
newobj.C_StatusName = item.C_StatusName;
newobj.C_LastModified = item.C_LastModified;
newobj.C_ProjectName = item.C_ProjectName;
newobj.C_ProjectID = item.C_ProjectID;
release.Add(newobj);
}
return(release);
}
//To update Release details
public bool UpdateRelease(NewReleaseModel trelease)
{
try
{
var release = entities.T_Releases.FirstOrDefault(x => x.C_ReleaseID.Equals(trelease.C_ReleaseID));
//Populate T_Releases with NewRelease Model
release.C_ReleaseID = trelease.C_ReleaseID;
release.C_ReleaseName = trelease.C_ReleaseName;
release.C_StatusID = trelease.C_StatusID;
release.C_StreamID = trelease.C_StreamID;
release.C_LastModified = DateTime.Now;
entities.T_Releases.AddOrUpdate(release);
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 Release
public ActionResult EditRelease(int releaseId)
{
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
where releaseId == c.C_ReleaseID
select new { a.C_ProjectID, c.C_ReleaseID, c.C_ReleaseName, c.C_StatusID, c.C_StreamID, c.C_LastModified, b.C_StreamName }).FirstOrDefault();
NewReleaseModel Obj;
if (Request.IsAjaxRequest())
{
Obj = new NewReleaseModel();
Obj.C_ReleaseName = data.C_ReleaseName;
Obj.C_ReleaseID = data.C_ReleaseID;
Obj.C_StreamID = data.C_StreamID;
Obj.C_StatusID = data.C_StatusID;
Obj.C_LastModified = data.C_LastModified;
Obj.C_ProjectID = data.C_ProjectID;
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.StatusName = new SelectList(ci.T_Status, "C_StatusID", "C_StatusName");
ViewBag.ProjectName = new SelectList(ci.T_Projects, "C_ProjectID", "C_ProjectName");
ViewBag.IsUpdate = true;
return View("_EditRelease", Obj);
}
else
return View(data);
}
public List<NewReleaseModel> GetReleasePage(int pageNumber, int pageSize, string searchCriteria)
{
if (pageNumber < 1)
pageNumber = 1;
var RequiredReleaseModel = (from a in entities.T_Streams
join b in entities.T_Releases
on a.C_StreamID equals b.C_StreamID
join c in entities.T_Status
on b.C_StatusID equals c.C_StatusID
join d in entities.T_Projects
on a.C_ProjectID equals d.C_ProjectID
select new { a.C_StreamID, a.C_StreamName, b.C_ReleaseID, b.C_ReleaseName, b.C_StatusID,
b.C_LastModified,c.C_StatusName,d.C_ProjectID,d.C_ProjectName })
.ToList();
//Populate NewReleaseModel with the required properties
List<NewReleaseModel> release = new List<NewReleaseModel>();
NewReleaseModel newobj;
foreach(var item in RequiredReleaseModel)
{
newobj = new NewReleaseModel();
newobj.C_ReleaseID = item.C_ReleaseID;
newobj.C_ReleaseName = item.C_ReleaseName;
newobj.C_StreamID = item.C_StreamID;
newobj.C_StreamName = item.C_StreamName;
newobj.C_StatusName= item.C_StatusName;
newobj.C_LastModified = item.C_LastModified;
newobj.C_ProjectName = item.C_ProjectName;
newobj.C_ProjectID = item.C_ProjectID;
release.Add(newobj);
}
return release;
}
//To update Release details
public bool UpdateRelease(NewReleaseModel trelease)
{
try
{
var release = entities.T_Releases.FirstOrDefault(x => x.C_ReleaseID.Equals(trelease.C_ReleaseID));
//Populate T_Releases with NewRelease Model
release.C_ReleaseID = trelease.C_ReleaseID;
release.C_ReleaseName = trelease.C_ReleaseName;
release.C_StatusID = trelease.C_StatusID;
release.C_StreamID = trelease.C_StreamID;
release.C_LastModified = DateTime.Now;
entities.T_Releases.AddOrUpdate(release);
entities.SaveChanges();
return true;
}
catch (Exception e)
{
return false;
}
}
