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"));
}
//To delete Release
public bool DeleteSubReleases(int SubreleaseId)
{
try
{
T_SubReleases data = entities.T_SubReleases.Where(m => m.C_SubReleaseID == SubreleaseId).FirstOrDefault();
entities.T_SubReleases.Remove(data);
entities.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
//To add new Project
public bool AddSubRelease(T_SubReleases tsubrelease)
{
try
{
//Populate T_SubReleases with NewSubReleaseModel
T_SubReleases srelobj = new T_SubReleases()
{
C_SubReleaseID = tsubrelease.C_SubReleaseID,
C_ReleaseID = tsubrelease.C_ReleaseID,
C_SubReleaseName = tsubrelease.C_SubReleaseName,
C_StatusID = tsubrelease.C_StatusID,
C_LastModified = DateTime.Now
};
entities.T_SubReleases.Add(srelobj);
entities.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
//To add new Project
public bool AddSubRelease(T_SubReleases tsubrelease)
{
try
{
//Populate T_SubReleases with NewSubReleaseModel
T_SubReleases srelobj = new T_SubReleases()
{
C_SubReleaseID = tsubrelease.C_SubReleaseID,
C_ReleaseID = tsubrelease.C_ReleaseID,
C_SubReleaseName = tsubrelease.C_SubReleaseName,
C_StatusID = tsubrelease.C_StatusID,
C_LastModified = DateTime.Now
};
entities.T_SubReleases.Add(srelobj);
entities.SaveChanges();
return true;
}
catch (Exception e)
{
return false;
}
}
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");
}
/// <summary>
/// This method will display the view having
/// development status
/// </summary>
/// <param name="id">Project Id</param>
/// <returns>GetTreeView view</returns>
public ActionResult GetTreeView(int id)
{
DBHelper dataObj = new DBHelper();
ProjectParentModel parentProjectModel;
T_Status t = new T_Status();
using (ContinuousIntegrationEntities ci = new ContinuousIntegrationEntities())
{
var userId = Convert.ToInt32(Session["LoggedUserID"]);
//Linq to check user has access to given project or not
var isUser = (from a in ci.T_UserProjectMappings
where a.C_RegisterID == userId && a.C_ProjectID == id
select a).FirstOrDefault();
var isAdmin = (from t1 in ci.T_UserRoleMappings
where t1.C_RoleID == 1 && t1.C_RegisterID == userId
select t1).FirstOrDefault();
var doesProjectExists = (from t1 in ci.T_Projects
where t1.C_ProjectID == id
select t1).FirstOrDefault();
if (doesProjectExists == null)
{
ViewBag.Msg = "This project does not exists!";
return(View("ErrorPage"));
}
else if (isAdmin == null && isUser == null)
{
ViewBag.Msg = "You are not assigned this project.";
return(View("ErrorPage"));
}
else
{
var projectDetails = ci.ProjectDetails(userId, id);
parentProjectModel = new ProjectParentModel
{
Releases = new List <T_Releases>(),
SubReleases = new List <T_SubReleases>(),
ProjectStatus = new List <T_Status>(),
Streams = new List <T_Streams>()
};
parentProjectModel.Statuses = dataObj.GetAllStatuses();
foreach (var item in projectDetails) //loop to populate with Pdetails
{
#region Streams
var stream = new T_Streams()
{
C_StreamName = item.C_StreamName,
C_StreamID = item.C_StreamID
};
parentProjectModel.Streams.Add(stream);
#endregion
#region Release
var release = new T_Releases()
{
C_ReleaseName = item.C_ReleaseName,
C_StreamID = item.C_StreamID,
C_ReleaseID = Convert.ToInt32(item.C_ReleaseID)
};
parentProjectModel.Releases.Add(release);
#endregion
#region SubRelease
T_SubReleases subRelease = new T_SubReleases()
{
C_SubReleaseName = item.C_SubReleaseName,
C_ReleaseID = Convert.ToInt32(item.C_ReleaseID),
C_StatusID = Convert.ToInt32(item.C_StatusID)
};
parentProjectModel.SubReleases.Add(subRelease);
#endregion
#region ProjectStatus
T_Status status = new T_Status()
{
C_StatusName = item.C_StatusName,
C_StatusID = Convert.ToInt32(item.C_StatusID)
};
parentProjectModel.ProjectStatus.Add(status);
#endregion
}
return(View("GetTreeView", parentProjectModel));
}
}
}
/// <summary>
/// This method will display the view having
/// development status
/// </summary>
/// <param name="id">Project Id</param>
/// <returns>GetTreeView view</returns>
public ActionResult GetTreeView(int id)
{
DBHelper dataObj = new DBHelper();
ProjectParentModel parentProjectModel;
T_Status t = new T_Status();
using (ContinuousIntegrationEntities ci = new ContinuousIntegrationEntities())
{
var userId = Convert.ToInt32(Session["LoggedUserID"]);
//Linq to check user has access to given project or not
var isUser = (from a in ci.T_UserProjectMappings
where a.C_RegisterID == userId && a.C_ProjectID == id
select a).FirstOrDefault();
var isAdmin = (from t1 in ci.T_UserRoleMappings
where t1.C_RoleID == 1 && t1.C_RegisterID == userId
select t1).FirstOrDefault();
var doesProjectExists = (from t1 in ci.T_Projects
where t1.C_ProjectID == id
select t1).FirstOrDefault();
if (doesProjectExists == null)
{
ViewBag.Msg = "This project does not exists!";
return View("ErrorPage");
}
else if (isAdmin == null && isUser == null)
{
ViewBag.Msg = "You are not assigned this project.";
return View("ErrorPage");
}
else
{
var projectDetails = ci.ProjectDetails(userId, id);
parentProjectModel = new ProjectParentModel
{
Releases = new List<T_Releases>(),
SubReleases = new List<T_SubReleases>(),
ProjectStatus = new List<T_Status>(),
Streams = new List<T_Streams>()
};
parentProjectModel.Statuses = dataObj.GetAllStatuses();
foreach (var item in projectDetails) //loop to populate with Pdetails
{
#region Streams
var stream = new T_Streams()
{
C_StreamName = item.C_StreamName,
C_StreamID = item.C_StreamID
};
parentProjectModel.Streams.Add(stream);
#endregion
#region Release
var release = new T_Releases()
{
C_ReleaseName = item.C_ReleaseName,
C_StreamID = item.C_StreamID,
C_ReleaseID = Convert.ToInt32(item.C_ReleaseID)
};
parentProjectModel.Releases.Add(release);
#endregion
#region SubRelease
T_SubReleases subRelease = new T_SubReleases()
{
C_SubReleaseName = item.C_SubReleaseName,
C_ReleaseID = Convert.ToInt32(item.C_ReleaseID),
C_StatusID = Convert.ToInt32(item.C_StatusID)
};
parentProjectModel.SubReleases.Add(subRelease);
#endregion
#region ProjectStatus
T_Status status = new T_Status()
{
C_StatusName = item.C_StatusName,
C_StatusID = Convert.ToInt32(item.C_StatusID)
};
parentProjectModel.ProjectStatus.Add(status);
#endregion
}
return View("GetTreeView", parentProjectModel);
}
}
}
