public OperationStatus DeleteProjectAssociation(int ProjectId)
{
OperationStatus status = OperationStatus.Error;
try
{
using (dbcontext = new ResourceManagementEntities())
{
if (ProjectId != 0)
{
var rs = dbcontext.tblProjectMemberAssociations.FirstOrDefault(x => x.ProjectMemberAssociationId == ProjectId);
if (rs != null)
{
dbcontext.tblProjectMemberAssociations.Remove(rs);
dbcontext.SaveChanges();
status = OperationStatus.Success;
}
}
else
{
status = OperationStatus.Error;
}
}
}
catch (Exception ex)
{
dbcontext.Dispose();
status = OperationStatus.Exception;
throw ex;
}
return(status);
}
public OperationStatus UpdateSprintStatus(int SprintId, string Status)
{
OperationStatus status = OperationStatus.Error;
try
{
using (dbcontext = new ResourceManagementEntities())
{
if (SprintId != 0)
{
var rs = dbcontext.tblSprintMemberAssociations.FirstOrDefault(x => x.SprintMemberAssociationId == SprintId);
if (rs != null)
{
rs.Status = Status;
dbcontext.SaveChanges();
status = OperationStatus.Success;
}
}
else
{
status = OperationStatus.Error;
}
}
}
catch (Exception ex)
{
dbcontext.Dispose();
status = OperationStatus.Exception;
throw ex;
}
return(status);
}
public OperationStatus AddNewProject(ProjectCustomModel objProjectModel)
{
OperationStatus status = OperationStatus.Error;
try
{
using (dbcontext = new ResourceManagementEntities())
{
if (objProjectModel.ProjectId == 0)
{
var rs = dbcontext.tblProjects.FirstOrDefault(x => x.Title == objProjectModel.Title && x.IsDeleted == false);
if (rs == null)
{
tblProject _addProject = new tblProject
{
Title = objProjectModel.Title,
Description = objProjectModel.Description,
Documents = objProjectModel.Documents,
Image = objProjectModel.Image,
AlliasName = objProjectModel.AlliasName,
ProjectType = objProjectModel.ProjectType,
StartDate = objProjectModel.StartDate,
EndDate = objProjectModel.EndDate,
IsActive = true,
IsDeleted = false,
CreatedDate = DateTime.Now,
CreatedBy = objProjectModel.CreatedBy,
ModifiedDate = DateTime.Now,
ModifiedBy = objProjectModel.ModifiedBy,
};
dbcontext.tblProjects.Add(_addProject);
dbcontext.SaveChanges();
status = OperationStatus.Success;
}
else
{
status = OperationStatus.Duplicate;
}
}
}
}
catch (Exception ex)
{
dbcontext.Dispose();
status = OperationStatus.Exception;
throw ex;
}
return(status);
}
public OperationStatus AddNewSprint(SprintCustomModel model)
{
OperationStatus status = OperationStatus.Error;
try
{
using (dbcontext = new ResourceManagementEntities())
{
if (model.SprintId == 0)
{
var rs = dbcontext.tblProjectSprints.FirstOrDefault(x => x.Title == model.Title && x.ProjectId == model.ProjectId);
if (rs == null)
{
tblProjectSprint _addSprint = new tblProjectSprint
{
ProjectId = model.ProjectId,
Title = model.Title,
Description = model.Description,
SprintNo = model.SprintNo,
Status = model.Status,
StartDate = model.StartDate,
EndDate = model.EndDate,
IsActive = true,
IsDeleted = false,
CreatedDate = DateTime.Now,
CreatedBy = model.CreatedBy,
ModifiedDate = DateTime.Now,
ModifiedBy = model.ModifiedBy,
};
dbcontext.tblProjectSprints.Add(_addSprint);
dbcontext.SaveChanges();
status = OperationStatus.Success;
}
else
{
status = OperationStatus.Duplicate;
}
}
}
}
catch (Exception ex)
{
dbcontext.Dispose();
status = OperationStatus.Exception;
throw ex;
}
return(status);
}
/// <summary>
/// This method is used to save new members
/// </summary>
/// <returns></returns>
public OperationStatus SaveApplicationUser(ApplicationUserModel applicationUserModel)
{
OperationStatus status = OperationStatus.Error;
using (TransactionScope ts = new TransactionScope())
{
try
{
using (dbcontext = new ResourceManagementEntities())
{
if (applicationUserModel.ApplicationUserId == 0)
{
var rs = dbcontext.tblApplicationUsers.FirstOrDefault(x => x.UserName == applicationUserModel.UserName && x.IsDeleted == false);
if (rs == null)
{
tblMember _addMember = new tblMember
{
FName = applicationUserModel.FName,
LName = applicationUserModel.LName,
MemberCode = applicationUserModel.MemberCode,
UserTypeId = applicationUserModel.UserTypeId,
EmailId = applicationUserModel.EmailId,
MobileNo = applicationUserModel.MobileNo,
Address = applicationUserModel.Address,
Gender = applicationUserModel.Gender,
DateOfBirth = applicationUserModel.DateOfBirth,
FatherName = applicationUserModel.FatherName,
MotherName = applicationUserModel.MotherName,
Designation = applicationUserModel.Designation,
IsActive = true,
IsDeleted = false,
CreatedDate = DateTime.Now,
CreatedBy = applicationUserModel.CreatedBy,
ModifiedDate = DateTime.Now,
ModifiedBy = applicationUserModel.ModifiedBy,
};
dbcontext.tblMembers.Add(_addMember);
dbcontext.SaveChanges();
int userid = _addMember.MemberId;
tblApplicationUser _applicationUserinfo = new tblApplicationUser
{
FName = applicationUserModel.FName,
LName = applicationUserModel.LName,
MemberCode = applicationUserModel.MemberCode,
UserTypeId = applicationUserModel.UserTypeId,
EmailId = applicationUserModel.EmailId,
MobileNo = applicationUserModel.MobileNo,
Address = applicationUserModel.Address,
Gender = applicationUserModel.Gender,
DateOfBirth = applicationUserModel.DateOfBirth,
UserIdentityKey = userid,
UserName = applicationUserModel.UserName,
Password = applicationUserModel.Password,
IsActive = true,
IsDeleted = false,
CreatedDate = DateTime.Now,
CreatedBy = applicationUserModel.CreatedBy,
ModifiedDate = DateTime.Now,
ModifiedBy = applicationUserModel.ModifiedBy,
};
dbcontext.tblApplicationUsers.Add(_applicationUserinfo);
dbcontext.SaveChanges();
status = OperationStatus.Success;
ts.Complete();
}
else
{
status = OperationStatus.Duplicate;
//ts.Dispose();
}
}
}
}
catch (Exception ex)
{
dbcontext.Dispose();
status = OperationStatus.Exception;
ts.Dispose();
throw ex;
}
}
return(status);
}
public OperationStatus AddNewProjectMemberAssociation(ProjectMemberAssociationCustomModel objProjectMemberModel)
{
OperationStatus status = OperationStatus.Error;
try
{
using (dbcontext = new ResourceManagementEntities())
{
if (objProjectMemberModel.ProjectMemberAssociationId == 0)
{
if (objProjectMemberModel.ProjectMemberList != null)
{
List <tblProjectMemberAssociation> entityKisanLIst = objProjectMemberModel.ProjectMemberList.Select(m => new tblProjectMemberAssociation
{
ProjectId = objProjectMemberModel.ProjectId,
MemberId = m.ProjectMemberId,
StartDate = objProjectMemberModel.StartDate,
EndDate = objProjectMemberModel.EndDate,
Description = objProjectMemberModel.Description,
Status = objProjectMemberModel.Status == null ? "1" : objProjectMemberModel.Status,
IsActive = true,
IsDeleted = false,
}).ToList();
dbcontext.tblProjectMemberAssociations.AddRange(entityKisanLIst);
dbcontext.SaveChanges();
status = OperationStatus.Success;
}
//var rs = dbcontext.tblProjectMemberAssociations.FirstOrDefault(x => x.IsDeleted == false && x.ProjectId == objProjectMemberModel.ProjectId && x.MemberId == objProjectMemberModel.MemberId);
//if (rs == null)
//{
// tblProjectMemberAssociation _addProjectList = new tblProjectMemberAssociation
// {
// ProjectId = objProjectMemberModel.ProjectId,
// MemberId = objProjectMemberModel.MemberId,
// StartDate = objProjectMemberModel.StartDate,
// EndDate = objProjectMemberModel.EndDate,
// Description = objProjectMemberModel.Description,
// Status = objProjectMemberModel.Status == null ? "1" : objProjectMemberModel.Status,
// IsActive = true,
// IsDeleted = false,
// CreatedBy = objProjectMemberModel.CreatedBy,
// CreatedDate = System.DateTime.Now,
// ModifiedBy = objProjectMemberModel.ModifiedBy,
// ModifiedDate = System.DateTime.Now,
// };
// dbcontext.tblProjectMemberAssociations.Add(_addProjectList);
// dbcontext.SaveChanges();
// status = OperationStatus.Success;
//}
//else
//{
// status = OperationStatus.Duplicate;
//}
}
else
{
status = OperationStatus.Error;
}
}
}
catch (Exception ex)
{
dbcontext.Dispose();
status = OperationStatus.Exception;
throw ex;
}
return(status);
}