public int AddProjectAllocation(ProjectAllocationEntity _ProjectAllocation)
{
int retVal = 0;
UserProject ProjectAllocation = new UserProject();
using (var db = new DbContext(CONNECTION_NAME))
{
try
{
ProjectAllocation = db.Set <UserProject>().Where(s => s.UProj_UserProjectID == ProjectAllocation.UProj_UserProjectID).FirstOrDefault <UserProject>();
if (ProjectAllocation != null)
{
return(retVal);
}
#region Saving ProjectAllocation info Table
db.Set <UserProject>().Add(new UserProject
{
UProj_ProjectID = _ProjectAllocation.UProj_ProjectID,
UProj_UserID = _ProjectAllocation.UProj_UserID,
UProj_ParticipationPercentage = Convert.ToByte(_ProjectAllocation.UProj_ParticipationPercentage),
UProj_StartDate = Convert.ToDateTime(_ProjectAllocation.UProj_StartDate),
UProj_EndDate = _ProjectAllocation.UProj_EndDate,
UProj_ActiveStatus = _ProjectAllocation.UProj_ActiveStatus,
UProj_Version = _ProjectAllocation.UProj_Version,
UProj_CreatedDate = System.DateTime.Now,
UProj_CreatedBy = _ProjectAllocation.UProj_CreatedBy,
UProj_ModifiedDate = System.DateTime.Now,
UProj_ModifiedBy = _ProjectAllocation.UProj_ModifiedBy,
UProj_isDeleted = _ProjectAllocation.UProj_isDeleted,
Is_L1_Manager = _ProjectAllocation.Is_L1_Manager,
Is_L2_Manager = _ProjectAllocation.Is_L2_Manager,
UProj_L1_ManagerId = _ProjectAllocation.UProj_L1_ManagerId,
UProj_L2_ManagerId = _ProjectAllocation.UProj_L2_ManagerId
#endregion
});
retVal = db.SaveChanges();
//retVal = 1;
}
catch (Exception ex)
{
retVal = -1;
}
return(retVal);
}
}
public string UpdateProjectAllocation(ProjectAllocationEntity ProjectDtl)
{
string strResponse = string.Empty;
short UsTCurrentVersion = 0;
try
{
var projectAllocationComponent = new ProjectAssignComponent();
var currentRecordDetails = projectAllocationComponent.GetProjectAllocationDetailByID(ProjectDtl.UProj_UserProjectID);
int recID = currentRecordDetails.UProj_UserProjectID;
UsTCurrentVersion = Convert.ToInt16(currentRecordDetails.UProj_Version);
//bool _currentStatus = false;
if (ModelState.IsValid)
{
UserSessionInfo _objSessioninfo = Session["UserSessionInfo"] as UserSessionInfo;
int _userID = 0;
if (_objSessioninfo.UserId > 0)
{
_userID = _objSessioninfo.UserId;
}
ProjectDtl.UProj_ModifiedBy = _userID;
//while udating increment version by1
ProjectDtl.UProj_Version = ++UsTCurrentVersion;
//ProjectDtl.Ufp_ActiveStatus = _currentStatus;
int r = projectAllocationComponent.UpdateProjectAllocationDetail(ProjectDtl);
if (r > 0)
{
strResponse = "Project updated successfully";
}
else if (r == 0)
{
strResponse = "Project does not exists";
}
else if (r < 0)
{
strResponse = "Error occured in UpdateProjectAllocation";
}
}
}
catch (Exception ex)
{
return(strResponse);
}
return(strResponse);
}
public ProjectAllocationEntity GetProjectAllocationDetailByID(int ID)
{
ProjectAllocationEntity response = new ProjectAllocationEntity();
using (var db = new EvolutyzCornerDataEntities())
{
try
{
response = (from ufp in db.UserProjects
join p in db.Projects on ufp.UProj_ProjectID equals p.Proj_ProjectID
join u in db.Users on ufp.UProj_UserID equals u.Usr_UserID
where ufp.UProj_isDeleted == false && ufp.UProj_ActiveStatus == true &&
ufp.UProj_UserProjectID == ID
select new ProjectAllocationEntity
{
Proj_ProjectCode = p.Proj_ProjectCode,
UProj_UserProjectID = ufp.UProj_UserProjectID,
UProj_ProjectID = ufp.UProj_ProjectID,
ProjectName = p.Proj_ProjectName,
UProj_UserID = ufp.UProj_UserID,
Username = u.Usr_Username,
UProj_StartDate = ufp.UProj_StartDate,
UProj_EndDate = ufp.UProj_EndDate,
UProj_ParticipationPercentage = ufp.UProj_ParticipationPercentage,
UProj_ActiveStatus = ufp.UProj_ActiveStatus,
UProj_Version = ufp.UProj_Version,
UProj_CreatedBy = ufp.UProj_CreatedBy,
UProj_CreatedDate = ufp.UProj_CreatedDate,
UProj_ModifiedBy = ufp.UProj_ModifiedBy,
UProj_ModifiedDate = ufp.UProj_ModifiedDate,
UProj_isDeleted = ufp.UProj_isDeleted,
Is_L1_Manager = ufp.Is_L1_Manager,
Is_L2_Manager = ufp.Is_L2_Manager,
UProj_L1_ManagerId = ufp.UProj_L1_ManagerId,
UProj_L2_ManagerId = ufp.UProj_L2_ManagerId
}).FirstOrDefault();
response.IsSuccessful = true;
return(response);
}
catch (Exception ex)
{
response.IsSuccessful = false;
response.Message = "Error Occured in GetProjectAllocationDetailByID(ID)";
response.Detail = ex.Message.ToString();
return(response);
}
}
}
public JsonResult GetProjectByID(int catID)
{
ProjectAllocationEntity ProjectDetails = null;
try
{
var objDtl = new ProjectAssignComponent();
ProjectDetails = objDtl.GetProjectAllocationDetailByID(catID);
}
catch (Exception ex)
{
return(null);
}
return(Json(ProjectDetails, JsonRequestBehavior.AllowGet));
}
public string CreateProjectAllocation([Bind(Exclude = "Ufp_UsersForProjectsID")] ProjectAllocationEntity ProjectDtl)
{
string strResponse = string.Empty;
try
{
//var ProjectComponent = new ProjectAssignComponent();
//if (ModelState.IsValid)
//{
UserSessionInfo _objSessioninfo = Session["UserSessionInfo"] as UserSessionInfo;
int _userID = _objSessioninfo.UserId;
ProjectDtl.UProj_CreatedBy = _userID;
var Org = new ProjectAssignComponent();
int r = Org.AddProjectAllocation(ProjectDtl);
if (r > 0)
{
strResponse = "Project created successfully";
}
else if (r == 0)
{
strResponse = "Project already exists";
}
else if (r < 0)
{
strResponse = "Error occured in CreateProjectAllocation";
}
// }
}
catch (Exception ex)
{
return(strResponse);
}
return(strResponse);
}
public int AddManager(ProjectAllocationEntity _ProjectAllocation)
{
var ClientDAC = new ClientDAC();
return(ClientDAC.AddManager(_ProjectAllocation));
}
public int UpdateProjectAllocationDetail(ProjectAllocationEntity ProjectAllocation)
{
UserProject _ProjectAllocationDtl = new UserProject();
ProjectAllocationEntity response = new ProjectAllocationEntity();
int retVal = 0;
//using (var db = new EvolutyzCornerDataEntities())
//{
// try
// {
// response = (from ufp in db.UserProjects
// join p in db.Projects on ufp.UProj_ProjectID equals p.Proj_ProjectID
// join u in db.Users on ufp.UProj_UserID equals u.Usr_UserID
// where ufp.UProj_isDeleted == false && ufp.UProj_ActiveStatus == true
// && ufp.UProj_UserProjectID == ProjectAllocation.UProj_UserProjectID
// select new ProjectAllocationEntity
// {
// UProj_UserProjectID = ufp.UProj_UserProjectID,
// UProj_ProjectID = ufp.UProj_ProjectID,
// //Proj_ProjectName = p.Proj_ProjectName,
// UProj_UserID = ufp.UProj_UserID,
// //us = u.Usr_Username,
// UProj_StartDate = ufp.UProj_StartDate,
// UProj_EndDate = ufp.UProj_EndDate,
// UProj_ParticipationPercentage = ufp.UProj_ParticipationPercentage,
// UProj_ActiveStatus = ufp.UProj_ActiveStatus,
// UProj_Version = ufp.UProj_Version,
// UProj_CreatedBy = ufp.UProj_CreatedBy,
// UProj_CreatedDate = ufp.UProj_CreatedDate,
// UProj_ModifiedBy = ufp.UProj_ModifiedBy,
// UProj_ModifiedDate = ufp.UProj_ModifiedDate,
// UProj_isDeleted = ufp.UProj_isDeleted,
// UProj_L1_ManagerId=ufp.UProj_L1_ManagerId,
// UProj_L2_ManagerId=ufp.UProj_L2_ManagerId
// }).FirstOrDefault();
// response.IsSuccessful = true;
// History_UserProjects _ProjectAllocationMoveTohistory = new History_UserProjects();
// if (_ProjectAllocationMoveTohistory == null)
// {
// return retVal;
// }
// _ProjectAllocationMoveTohistory.HUProj_ProjectID = response.UProj_ProjectID;
// _ProjectAllocationMoveTohistory.HUProj_UserID = response.UProj_UserID;
// _ProjectAllocationMoveTohistory.HUProj_ParticipationPercentage = Convert.ToByte(response.UProj_ParticipationPercentage);
// _ProjectAllocationMoveTohistory.HUProj_StartDate = response.UProj_StartDate;
// _ProjectAllocationMoveTohistory.HUProj_EndDate = response.UProj_EndDate;
// _ProjectAllocationMoveTohistory.HUProj_ActiveStatus = response.UProj_ActiveStatus;
// _ProjectAllocationMoveTohistory.HUProj_Version = response.UProj_Version;
// _ProjectAllocationMoveTohistory.HUProj_ModifiedDate = System.DateTime.Now;
// _ProjectAllocationMoveTohistory.HUProj_CreatedDate = System.DateTime.Now;
// _ProjectAllocationMoveTohistory.HUProj_ModifiedBy = response.UProj_ModifiedBy;
// _ProjectAllocationMoveTohistory.HUProj_isDeleted = response.UProj_isDeleted;
// db.History_UserProjects.Add(_ProjectAllocationMoveTohistory);
// retVal = db.SaveChanges();
// //db.Entry(_ProjectAllocationMoveTohistory).State = System.Data.Entity.EntityState.Modified;
// //retVal = db.History_UserProjects.SaveChanges();
// }
// catch (Exception ex)
// {
// string excep = ex.InnerException.Message.ToString();
// //response.IsSuccessful = false;
// //response.Message = "Error Occured in GetProjectAllocationDetailByID(ID)";
// //response.Detail = ex.Message.ToString();
// //return response;
// }
//}
using (var db = new DbContext(CONNECTION_NAME))
{
try
{
_ProjectAllocationDtl = db.Set <UserProject>().Where(s => s.UProj_UserProjectID == ProjectAllocation.UProj_UserProjectID).FirstOrDefault <UserProject>();
if (_ProjectAllocationDtl == null)
{
return(retVal);
}
#region Saving ProjectAllocation info Table
_ProjectAllocationDtl.UProj_ProjectID = ProjectAllocation.UProj_ProjectID;
_ProjectAllocationDtl.UProj_UserID = ProjectAllocation.UProj_UserID;
_ProjectAllocationDtl.UProj_ParticipationPercentage = Convert.ToByte(ProjectAllocation.UProj_ParticipationPercentage);
_ProjectAllocationDtl.UProj_StartDate = Convert.ToDateTime(ProjectAllocation.UProj_StartDate);
_ProjectAllocationDtl.UProj_EndDate = ProjectAllocation.UProj_EndDate;
_ProjectAllocationDtl.UProj_ActiveStatus = ProjectAllocation.UProj_ActiveStatus;
_ProjectAllocationDtl.UProj_Version = ProjectAllocation.UProj_Version;
_ProjectAllocationDtl.UProj_CreatedDate = System.DateTime.Now;
_ProjectAllocationDtl.UProj_CreatedBy = ProjectAllocation.UProj_CreatedBy;
_ProjectAllocationDtl.UProj_ModifiedDate = System.DateTime.Now;
_ProjectAllocationDtl.UProj_ModifiedBy = ProjectAllocation.UProj_ModifiedBy;
_ProjectAllocationDtl.UProj_isDeleted = ProjectAllocation.UProj_isDeleted;
_ProjectAllocationDtl.Is_L1_Manager = ProjectAllocation.Is_L1_Manager;
_ProjectAllocationDtl.Is_L2_Manager = ProjectAllocation.Is_L2_Manager;
_ProjectAllocationDtl.UProj_L1_ManagerId = ProjectAllocation.UProj_L1_ManagerId;
_ProjectAllocationDtl.UProj_L2_ManagerId = ProjectAllocation.UProj_L2_ManagerId;
#endregion
db.Entry(_ProjectAllocationDtl).State = System.Data.Entity.EntityState.Modified;
retVal = db.SaveChanges();
//retVal = 1;
}
catch (Exception ex)
{
retVal = -1;
}
return(retVal);
}
}
public int UpdateProjectAllocationDetail(ProjectAllocationEntity _ProjectAllocation)
{
var ProjectAssignDAC = new ProjectAssignDAC();
return(ProjectAssignDAC.UpdateProjectAllocationDetail(_ProjectAllocation));
}
public int AddProjectAllocation(ProjectAllocationEntity _ProjectAllocation)
{
var ProjectAssignDAC = new ProjectAssignDAC();
return(ProjectAssignDAC.AddProjectAllocation(_ProjectAllocation));
}
