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; } }