public HttpResponseMessage Put(TimeSheet exp) { TimeManagementEntities context = new TimeManagementEntities(); TimeSheet temp = context.TimeSheet.Where(x => x.ID == exp.ID).SingleOrDefault(); //temp.Notes = HttpUtility.HtmlDecode(exp.Notes); //temp.DateOfSheet = exp.DateOfSheet; //temp.TotalTime= exp.TotalTime; //temp.CreatedDate = exp.CreatedDate; if (temp.IsDeleted == true) { var resp = new HttpResponseMessage(HttpStatusCode.NotFound); return(resp); } else { temp.Notes = HttpUtility.HtmlEncode(exp.Notes); temp.TotalTime = exp.TotalTime; temp.DateOfSheet = exp.DateOfSheet; temp.CreatedDate = exp.CreatedDate; repository.Update(temp); var resp = new HttpResponseMessage(HttpStatusCode.OK); return(resp); } }
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); }
private bool TryGetPrincipal(string username, string password, out IPrincipal principal) { // this is the method that does the authentication //users often add a copy/paste space at the end of the username username = username.Trim(); password = password.Trim(); //TODO //Replace this with your own Authentication Code TimeManagementEntities context = new TimeManagementEntities(); User user = context.User.Where(x => x.Email == username).SingleOrDefault(); //AccountManagement.ApiLogin(username, password); if (user != null) { // once the user is verified, assign it to an IPrincipal with the identity name and applicable roles String[] roles = { "Administrator" }; principal = new GenericPrincipal(new GenericIdentity(username), roles); return(true); } else { if (!String.IsNullOrWhiteSpace(username)) { } principal = null; return(false); } }
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 ActionResult Report(string id, string fromDate, string toDate, string searchString) { LocalReport lr = new LocalReport(); string path = Path.Combine(Server.MapPath("~/"), "Report2.rdlc"); if (System.IO.File.Exists(path)) { lr.ReportPath = path; } else { return(View("Index")); } using (TimeManagementEntities context = new TimeManagementEntities()) { int userid = context.User.Where(x => x.Email == LoggedInUser.loggedInUserEmail && x.IsDeleted == false).Select(u => u.ID).SingleOrDefault(); List <TimeSheet> cn = context.TimeSheet.Where(x => x.UserID == userid && x.IsDeleted == false).ToList(); ReportDataSource rd = new ReportDataSource("TimeManagementDataSet", listForReport); lr.DataSources.Add(rd); } string reportType = id; string mimeType; string encoding; string fileNameExtension; string deviceInfo = "<DeviceInfo>" + " <OutputFormat>" + id + "</OutputFormat>" + " <PageWidth>8.5in</PageWidth>" + " <PageHeight>11in</PageHeight>" + " <MarginTop>0.5in</MarginTop>" + " <MarginLeft>1in</MarginLeft>" + " <MarginRight>1in</MarginRight>" + " <MarginBottom>0.5in</MarginBottom>" + "</DeviceInfo>"; Warning[] warnings; string[] streams; byte[] renderedBytes; renderedBytes = lr.Render( reportType, deviceInfo, out mimeType, out encoding, out fileNameExtension, out streams, out warnings); return(File(renderedBytes, mimeType)); }
public void Post(TimeSheet timesheet) { TimeManagementEntities context = new TimeManagementEntities(); // TimeSheet temp = new TimeSheet(); timesheet.Notes = HttpUtility.HtmlEncode(timesheet.Notes); //timesheet.DateOfSheet = timesheet.DateOfSheet; //timesheet.TotalTime = timesheet.TotalTime; //timesheet.CreatedDate = timesheet.CreatedDate; repository.Add(timesheet); }
public object GetMyProjectList(int MemberId) { IList <ProjectMemberAssociationCustomModel> ProjectListModel = new List <ProjectMemberAssociationCustomModel>(); using (response = new Response()) { using (dbcontext = new TimeManagementEntities()) { try { if (MemberId != 0) { response.success = true; ProjectListModel = dbcontext.tblProjectMemberAssociations.Where(x => x.MemberId == MemberId && x.IsDeleted == false) .Select(x => new ProjectMemberAssociationCustomModel { ProjectMemberAssociationId = x.ProjectMemberAssociationId, ProjectId = x.ProjectId, ProjectName = x.tblProject != null ? x.tblProject.Title : "", MemberId = x.MemberId, MemberName = x.tblMember != null ? x.tblMember.FName + " " + x.tblMember.LName: "", Description = x.Description, StartDate = x.StartDate, EndDate = x.EndDate, Status = x.Status, IsActive = x.IsActive, IsDeleted = x.IsDeleted, CreatedBy = x.CreatedBy, CreatedDate = x.CreatedDate, ModifiedBy = x.ModifiedBy, ModifiedDate = x.ModifiedDate, }).OrderByDescending(x => x.ProjectId).ToList(); return(ProjectListModel); } else { response.success = false; return(ProjectListModel); } } catch (Exception ex) { response.success = false; response.message = ex.Message; return(response); } } } }
public object GetMemberDetail(int MemberId) { using (response = new Response()) { using (dbcontext = new TimeManagementEntities()) { try { response.success = true; var rs = dbcontext.tblMembers.Where(x => x.IsDeleted == false && x.MemberId == MemberId) .Select(x => new MemberCustomModel { MemberId = x.MemberId, FName = x.FName, LName = x.LName, MemberCode = x.MemberCode, EmailId = x.EmailId, MobileNo = x.MobileNo, MotherName = x.MotherName, FatherName = x.FatherName, Address = x.Address, DateOfBirth = x.DateOfBirth, Gender = x.Gender, Designation = x.Designation, UserTypeId = x.UserTypeId, Image = x.Image, IsActive = x.IsActive, IsDeleted = x.IsDeleted, CreatedBy = x.CreatedBy, CreatedDate = x.CreatedDate, ModifiedBy = x.ModifiedBy, ModifiedDate = x.ModifiedDate, SprintList = x.tblSprintMemberAssociations.Where(s => s.MemberId == x.MemberId).Select(s => new SprintDetail { SprintName = s.tblProjectSprint != null ? s.tblProjectSprint.Title : "" }).ToList(), }).OrderByDescending(x => x.MemberId).ToList(); return(rs); } catch (Exception ex) { response.success = false; response.message = ex.Message; return(response); } } } }
public object GetMySprintList(int MemberId) { List <SprintMemberAssociationCustomModel> SprintListModel = new List <SprintMemberAssociationCustomModel>(); using (response = new Response()) { using (dbcontext = new TimeManagementEntities()) { try { if (MemberId != 0) { response.success = true; SprintListModel = dbcontext.tblSprintMemberAssociations.Where(x => x.MemberId == MemberId && x.IsDeleted == false) .Select(x => new SprintMemberAssociationCustomModel { SprintMemberAssociationId = x.SprintMemberAssociationId, SprintId = x.SprintId, SprintName = x.tblProjectSprint != null ? x.tblProjectSprint.Title : "", MemberId = x.MemberId, MemberName = x.tblMember != null ? x.tblMember.FName + " " + x.tblMember.LName : "", Description = x.tblProjectSprint.Description, StartDate = x.tblProjectSprint.StartDate, EndDate = x.tblProjectSprint.EndDate, Status = x.Status, IsActive = x.IsActive, ProjectId = x.tblProjectSprint != null ? x.tblProjectSprint.ProjectId : null, //TotalTimeSpent = (dbcontext.tblSprintMemberTimeAssociations.Where(y => y.SprintId == x.SprintId && y.MemberId == x.MemberId).Select(v => new tblSprintMemberTimeAssociation { TimeSpend = v.TimeSpend}).Sum()) TotalTimeSpent = (dbcontext.tblSprintMemberTimeAssociations.Where(y => y.SprintId == x.SprintId && y.MemberId == x.MemberId).Sum(v => v.TimeSpend)) }).OrderByDescending(x => x.SprintMemberAssociationId).ToList(); return(SprintListModel); } else { response.success = false; return(SprintListModel); } } catch (Exception ex) { response.success = false; response.message = ex.Message; return(response); } } } }
public object GetApplicationMemberList(MemberCustomModel objMemberModel) { IList <MemberCustomModel> MemberListModel = new List <MemberCustomModel>(); using (response = new Response()) { using (dbcontext = new TimeManagementEntities()) { try { response.success = true; MemberListModel = dbcontext.tblMembers.Where(x => x.IsDeleted == false) .Select(x => new MemberCustomModel { MemberId = x.MemberId, FName = x.FName, LName = x.LName, MemberCode = x.MemberCode, UserTypeId = x.UserTypeId, EmailId = x.EmailId, MobileNo = x.MobileNo, MotherName = x.MotherName, FatherName = x.FatherName, Address = x.Address, DateOfBirth = x.DateOfBirth, Gender = x.Gender, Designation = x.Designation, Image = x.Image, IsActive = x.IsActive, IsDeleted = x.IsDeleted, CreatedBy = x.CreatedBy, CreatedDate = x.CreatedDate, ModifiedBy = x.ModifiedBy, ModifiedDate = x.ModifiedDate, }).OrderByDescending(x => x.MemberId).ToList(); return(MemberListModel); } catch (Exception ex) { response.success = false; response.message = ex.Message; return(response); } } } }
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 object GetProjectListing(ProjectCustomModel objProjectModel) { List <ProjectCustomModel> ProjectListModel = new List <ProjectCustomModel>(); using (response = new Response()) { using (dbcontext = new TimeManagementEntities()) { try { response.success = true; ProjectListModel = dbcontext.tblProjects.Where(x => x.IsDeleted == false) .Select(x => new ProjectCustomModel { ProjectId = x.ProjectId, Title = x.Title, Description = x.Description, Documents = x.Documents, Image = x.Image, StartDate = x.StartDate, EndDate = x.EndDate, AlliasName = x.AlliasName, ProjectType = x.ProjectType, MemberList = x.tblProjectMemberAssociations.Where(s => s.ProjectId == x.ProjectId).Select(s => new ProjectMembers { MemberName = s.tblMember != null ? s.tblMember.FName + " " + s.tblMember.LName: "" }).ToList(), IsActive = x.IsActive, IsDeleted = x.IsDeleted, CreatedBy = x.CreatedBy, CreatedDate = x.CreatedDate, ModifiedBy = x.ModifiedBy, ModifiedDate = x.ModifiedDate, }).OrderByDescending(x => x.ProjectId).ToList(); return(ProjectListModel); } catch (Exception ex) { response.success = false; response.message = ex.Message; return(response); } } } }
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 ActionResult Index(string fromDate, string toDate, string searchString) { string g = fromDate + " " + toDate + " " + searchString; String fromDateForSQL = String.Empty; String toDateForSQL = String.Empty; if (fromDate != "" && toDate != "") { String fromDD = fromDate.Substring(0, 2); String fromMM = fromDate.Substring(3, 2); String fromYY = fromDate.Substring(6, 4); fromDateForSQL = fromYY + "/" + fromMM + "/" + fromDD; String toDD = toDate.Substring(0, 2); String toMM = toDate.Substring(3, 2); String toYY = toDate.Substring(6, 4); toDateForSQL = toYY + "/" + toMM + "/" + toDD; using (TimeManagementEntities context = new TimeManagementEntities()) { DateTime dtFrom = Convert.ToDateTime(fromDateForSQL); DateTime dtTo = Convert.ToDateTime(toDateForSQL); int userid = context.User.Where(x => x.Email == LoggedInUser.loggedInUserEmail && x.IsDeleted == false).Select(u => u.ID).SingleOrDefault(); var v = context.TimeSheet.Where(x => (x.DateOfSheet >= dtFrom.Date && x.DateOfSheet <= dtTo.Date) && x.UserID == userid && x.IsDeleted == false && x.Notes.Contains(searchString)).ToList(); listForReport = (List <TimeSheet>)v; return(View(v)); } } else { using (TimeManagementEntities context = new TimeManagementEntities()) { int userid = context.User.Where(x => x.Email == LoggedInUser.loggedInUserEmail && x.IsDeleted == false).Select(u => u.ID).SingleOrDefault(); var v = context.TimeSheet.Where(x => x.UserID == userid && x.IsDeleted == false && x.Notes.Contains(searchString)).ToList(); listForReport = (List <TimeSheet>)v; return(View(v)); } } return(null); }
public object GetProjectSprintListing(int ProjectId) { List <SprintCustomModel> SprintListModel = new List <SprintCustomModel>(); using (response = new Response()) { using (dbcontext = new TimeManagementEntities()) { try { response.success = true; SprintListModel = dbcontext.tblProjectSprints.Where(x => x.ProjectId == ProjectId) .Select(x => new SprintCustomModel { ProjectId = x.ProjectId, Title = x.Title, Description = x.Description, SprintNo = x.SprintNo, Status = x.Status, SprintId = x.SprintId, StartDate = x.StartDate, EndDate = x.EndDate, IsActive = x.IsActive, IsDeleted = x.IsDeleted, CreatedBy = x.CreatedBy, CreatedDate = x.CreatedDate, ModifiedBy = x.ModifiedBy, ModifiedDate = x.ModifiedDate, }).OrderByDescending(x => x.SprintId).ToList(); return(SprintListModel); } catch (Exception ex) { response.success = false; response.message = ex.Message; return(response); } } } }
public object GetSprintListing(int SprintId) { List <SprintCustomModel> SprintListModel = new List <SprintCustomModel>(); using (response = new Response()) { using (dbcontext = new TimeManagementEntities()) { try { response.success = true; SprintListModel = dbcontext.tblProjectSprints.Where(x => x.SprintId == SprintId) .Select(x => new SprintCustomModel { SprintId = x.SprintId, ProjectId = x.ProjectId, Title = x.Title, Description = x.Description, SprintNo = x.SprintNo, Status = x.Status, StartDate = x.StartDate, EndDate = x.EndDate, MemberList = x.tblSprintMemberAssociations.Where(s => s.SprintId == x.SprintId).Select(s => new SprintMembers { MemberId = s.MemberId, MemberName = s.tblMember != null ? s.tblMember.FName + " " + s.tblMember.LName : "", TotalTimeSpent = (dbcontext.tblSprintMemberTimeAssociations.Where(y => y.SprintId == x.SprintId && y.MemberId == s.tblMember.MemberId).Sum(v => v.TimeSpend)) }).ToList(), //TotalTimeSpent = (dbcontext.tblSprintMemberTimeAssociations.Where(y => y.SprintId == x.SprintId && y.MemberId == x.MemberId).Sum(v => v.TimeSpend)) }).OrderByDescending(x => x.SprintId).ToList(); return(SprintListModel); } catch (Exception ex) { response.success = false; response.message = ex.Message; return(response); } } } }
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); }
/// <summary> /// method is used for validate application users /// </summary> /// <param name="Logininfo"></param> /// <returns></returns> public object GetLoginUser(LoginUserModel Logininfo) { APIResponse _response = new APIResponse(); LoggedInUserModel lgAppUserDetails = new LoggedInUserModel(); object objLgAppUserDetails; try { using (dbcontext = new TimeManagementEntities()) { Logininfo.UserName = Logininfo.UserName.ToLower(); tblApplicationUser lgDetail = dbcontext.tblApplicationUsers.FirstOrDefault(x => x.UserName.ToLower() == Logininfo.UserName && x.IsDeleted == false); if (lgDetail != null) { if (lgDetail.Password == Logininfo.Password) { lgAppUserDetails.ApplicationUserId = lgDetail.ApplicationUserId; lgAppUserDetails.UserIdentityKey = lgDetail.UserIdentityKey; lgAppUserDetails.success = true; lgAppUserDetails.ErrorMessage = "User Authenticated!!"; lgAppUserDetails.FName = lgDetail.FName == null ? "" : lgDetail.FName; lgAppUserDetails.LName = lgDetail.LName == null ? "" : lgDetail.LName; lgAppUserDetails.MemberCode = lgDetail.MemberCode == null ? "" : lgDetail.MemberCode; lgAppUserDetails.UserTypeId = lgDetail.UserTypeId == null ? 0 : lgDetail.UserTypeId; lgAppUserDetails.EmailId = lgDetail.EmailId; lgAppUserDetails.MobileNo = lgDetail.MobileNo; lgAppUserDetails.Address = lgDetail.Address; lgAppUserDetails.Gender = lgDetail.Gender; lgAppUserDetails.DateOfBirth = lgDetail.DateOfBirth; lgAppUserDetails.FatherName = lgDetail.tblMember == null ? "" : lgDetail.tblMember.FatherName; lgAppUserDetails.MotherName = lgDetail.tblMember == null ? "" : lgDetail.tblMember.MotherName; lgAppUserDetails.UserTypeId = lgDetail.UserTypeId; lgAppUserDetails.UserName = lgDetail.UserName; _response.Message = "User Authenticated!!"; _response.IsSucess = true; } else { lgAppUserDetails.ErrorMessage = "Invalid password!!"; _response.Message = "Invalid password!!"; _response.IsSucess = false; } } else { lgAppUserDetails.ErrorMessage = "Invalid username!!"; _response.Message = "Invalid username!!"; _response.IsSucess = false; } } } catch (Exception ex) { lgAppUserDetails = null; objLgAppUserDetails = null; dbcontext = null; lgAppUserDetails.ErrorMessage = ex.Message.ToString(); } objLgAppUserDetails = lgAppUserDetails; return(objLgAppUserDetails); }
/// <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); }
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); }
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); }