//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 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 delete Release
public bool DeleteReleases(int releaseId)
{
try
{
T_Releases data = entities.T_Releases.Where(m => m.C_ReleaseID == releaseId).FirstOrDefault();
entities.T_Releases.Remove(data);
entities.SaveChanges();
return(true);
}
catch (Exception e)
{
return(false);
}
}
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");
}
/// <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);
}
}
}
