public OperationStatus UpdateProjectStatus(int ProjectId, string Status)
{
OperationStatus status = OperationStatus.Error;
try
{
using (dbcontext = new TimeManagementEntities())
{
if (ProjectId != 0)
{
var rs = dbcontext.tblProjectMemberAssociations.FirstOrDefault(x => x.ProjectMemberAssociationId == ProjectId);
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 DeleteSprint(int SprintId)
{
OperationStatus status = OperationStatus.Error;
try
{
using (dbcontext = new TimeManagementEntities())
{
if (SprintId != 0)
{
var rs = dbcontext.tblProjectSprints.FirstOrDefault(x => x.SprintId == SprintId);
if (rs != null)
{
dbcontext.tblProjectSprints.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 AddNewSprintMemberTimeAssociation(SprintMemberTimeAssociationCustomModel model)
{
OperationStatus status = OperationStatus.Error;
try
{
using (dbcontext = new TimeManagementEntities())
{
if (model.TimeId == 0)
{
tblSprintMemberTimeAssociation _addSprintList = new tblSprintMemberTimeAssociation
{
SprintId = model.SprintId,
MemberId = model.MemberId,
TimeSpend = model.TimeSpend,
DDate = model.DDate,
Description = model.Description,
IsActive = true,
IsDeleted = false,
CreatedBy = model.CreatedBy,
CreatedDate = DateTime.Now,
ModifiedBy = model.ModifiedBy,
ModifiedDate = DateTime.Now,
};
dbcontext.tblSprintMemberTimeAssociations.Add(_addSprintList);
dbcontext.SaveChanges();
status = OperationStatus.Success;
}
else
{
var rs = dbcontext.tblSprintMemberTimeAssociations.FirstOrDefault(x => x.TimeId == model.TimeId);
if (rs != null)
{
rs.MemberId = model.MemberId;
rs.SprintId = model.SprintId;
rs.TimeSpend = model.TimeSpend;
rs.DDate = model.DDate;
rs.Description = model.Description;
rs.ModifiedDate = DateTime.Now;
rs.ModifiedBy = model.ModifiedBy;
dbcontext.SaveChanges();
status = OperationStatus.Success;
}
}
}
}
catch (Exception ex)
{
dbcontext.Dispose();
status = OperationStatus.Exception;
throw ex;
}
return(status);
}
public OperationStatus ForgotPassword(ForgotPasswordCustomModel model)
{
OperationStatus status = OperationStatus.Error;
try
{
using (dbcontext = new TimeManagementEntities())
{
var rs = dbcontext.tblApplicationUsers.FirstOrDefault(x => x.UserName == model.UserName);
if (rs != null)
{
string from = "*****@*****.**"; //any valid GMail ID
string to = Convert.ToString(rs.EmailId); //any valid GMail ID
using (MailMessage mail = new MailMessage(from, to))
{
mail.Subject = "Time Management Forgot Password";
mail.Body = "Dear " + rs.FName + " " + rs.LName + " <br><br>Please use this password to login: "******"<br><br>Thanks,<br>Team";
mail.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.Port = 587;
smtp.UseDefaultCredentials = false;
smtp.Credentials = new System.Net.NetworkCredential
("*****@*****.**", "shally123");// Enter seders User name and password
smtp.EnableSsl = true;
smtp.Send(mail);
status = OperationStatus.Success;
}
}
else
{
status = OperationStatus.Duplicate;
}
}
}
catch (Exception ex)
{
dbcontext.Dispose();
status = OperationStatus.Exception;
throw ex;
}
return(status);
}
public OperationStatus AddNewProjectMemberAssociation(ProjectMemberAssociationCustomModel objProjectMemberModel)
{
OperationStatus status = OperationStatus.Error;
try
{
using (dbcontext = new TimeManagementEntities())
{
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;
}
}
else
{
status = OperationStatus.Error;
}
}
}
catch (Exception ex)
{
dbcontext.Dispose();
status = OperationStatus.Exception;
throw ex;
}
return(status);
}
public void Dispose()
{
dbcontext.Dispose();
GC.SuppressFinalize(this);
//throw new NotImplementedException();
}
public OperationStatus AddNewSprint(SprintCustomModel model)
{
OperationStatus status = OperationStatus.Error;
try
{
using (dbcontext = new TimeManagementEntities())
{
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;
}
}
else
{
var rs = dbcontext.tblProjectSprints.FirstOrDefault(x => x.SprintId == model.SprintId);
if (rs != null)
{
rs.Title = model.Title;
rs.Description = model.Description;
rs.SprintNo = model.SprintNo;
rs.Status = model.Status;
rs.StartDate = model.StartDate;
rs.EndDate = model.EndDate;
dbcontext.SaveChanges();
status = OperationStatus.Success;
}
else
{
status = OperationStatus.Duplicate;
}
}
}
}
catch (Exception ex)
{
dbcontext.Dispose();
status = OperationStatus.Exception;
throw ex;
}
return(status);
}
public OperationStatus AddNewSprintMemberAssociation(SprintMemberAssociationCustomModel objSprintMemberModel)
{
OperationStatus status = OperationStatus.Error;
try
{
using (dbcontext = new TimeManagementEntities())
{
if (objSprintMemberModel.SprintMemberAssociationId == 0)
{
if (objSprintMemberModel.SprintMemberList != null)
{
List <tblSprintMemberAssociation> entitySprintLIst = objSprintMemberModel.SprintMemberList.Select(m => new tblSprintMemberAssociation
{
SprintId = objSprintMemberModel.SprintId,
MemberId = m.SprintMemberId,
StartDate = objSprintMemberModel.StartDate,
EndDate = objSprintMemberModel.EndDate,
Description = objSprintMemberModel.Description,
Status = objSprintMemberModel.Status == null ? "1" : objSprintMemberModel.Status,
IsActive = true,
IsDeleted = false,
}).ToList();
dbcontext.tblSprintMemberAssociations.AddRange(entitySprintLIst);
dbcontext.SaveChanges();
status = OperationStatus.Success;
}
//var rs = dbcontext.tblSprintMemberAssociations.FirstOrDefault(x => x.IsDeleted == false && x.SprintId == objSprintMemberModel.SprintId && x.MemberId == objSprintMemberModel.MemberId);
//if (rs == null)
//{
// tblSprintMemberAssociation _addSprintist = new tblSprintMemberAssociation
// {
// SprintId = objSprintMemberModel.SprintId,
// MemberId = objSprintMemberModel.MemberId,
// StartDate = objSprintMemberModel.StartDate,
// EndDate = objSprintMemberModel.EndDate,
// Description = objSprintMemberModel.Description,
// Status = objSprintMemberModel.Status == null ? "1" : objSprintMemberModel.Status,
// IsActive = true,
// IsDeleted = false,
// CreatedBy = objSprintMemberModel.CreatedBy,
// CreatedDate = System.DateTime.Now,
// ModifiedBy = objSprintMemberModel.ModifiedBy,
// ModifiedDate = System.DateTime.Now,
// };
// dbcontext.tblSprintMemberAssociations.Add(_addSprintist);
// 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);
}
public OperationStatus AddNewProject(ProjectCustomModel objProjectModel)
{
OperationStatus status = OperationStatus.Error;
try
{
using (dbcontext = new TimeManagementEntities())
{
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,
StartDate = objProjectModel.StartDate,
EndDate = objProjectModel.EndDate,
AlliasName = objProjectModel.AlliasName,
ProjectType = objProjectModel.ProjectType,
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;
}
}
else
{
var rs = dbcontext.tblProjects.FirstOrDefault(x => x.ProjectId == objProjectModel.ProjectId && x.IsDeleted == false);
if (rs != null)
{
rs.Title = objProjectModel.Title;
rs.Description = objProjectModel.Description;
rs.Documents = objProjectModel.Documents;
rs.Image = objProjectModel.Image;
rs.StartDate = objProjectModel.StartDate;
rs.EndDate = objProjectModel.EndDate;
rs.AlliasName = objProjectModel.AlliasName;
rs.ProjectType = objProjectModel.ProjectType;
rs.ModifiedDate = DateTime.Now;
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 TimeManagementEntities())
{
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,
Image = applicationUserModel.Image,
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);
}