//Method for creating new task. public int CreateProjectTaskDetail(TaskDetail projectTaskDetail) { //adding data to attechment table var attachment = new LegaSys_Attachments { AttachmentPath = projectTaskDetail.AttachmentPath, Title = projectTaskDetail.TaskTitle, Description = projectTaskDetail.Description, Created_Date = (projectTaskDetail.Created_Date != null) ? projectTaskDetail.Created_Date : DateTime.Now, AttachmentTypeID = attachmentTypeId }; db.LegaSys_Attachments.Add(attachment); //declaration of object attachmentType var Typeattachment = new LegaSys_AttachmentTypes { AttachmentType = projectTaskDetail.AttachmentType, Description = projectTaskDetail.Description, Created_Date = (projectTaskDetail.Created_Date != null) ? projectTaskDetail.Created_Date : DateTime.Now, }; db.LegaSys_AttachmentTypes.Add(Typeattachment); //adding data to project task table var taskModel = new LegaSys_ProjectTasks { Title = projectTaskDetail.TaskTitle, Description = projectTaskDetail.Description, //fk need dropdown from project TABLE DATASOURCE Attachment_ID = attachmentid, //fk need dropdown from project TABLE DATASOURCE Project_ID = projectTaskDetail.Project_ID, Created_By = projectTaskDetail.Created_By, Updated_By = projectTaskDetail.Updated_By, Created_Date = (projectTaskDetail.Created_Date != null)?projectTaskDetail.Created_Date:DateTime.Now, Updated_Date = projectTaskDetail.Updated_Date, }; //assingment of Global variable to access in any table attachmentid = attachment.AttachmentID; attachmentTypeId = Typeattachment.AttachmentTypeID; db.LegaSys_ProjectTasks.Add(taskModel); db.SaveChanges(); return(taskModel.ProjectTaskID); }
public UserLoginDetails AuthenticateAndFetchUserDetail(string Username, string Password) { //validate user credentials var user = (from login in db.LegaSys_UserLogin.Where(x => x.IsActive.Value) join details in db.LegaSys_UserDetails.Where(x => x.IsActive) on login.UserDetailID equals details.UserDetailID where login.Username.ToLower().Trim() == Username.ToLower().Trim() && login.Password.Trim() == Password.Trim() select new { login, details }).FirstOrDefault(); if (user == null) { return(null); } var lastLogin = user.login.LastLogin; user.login.LastLogin = DateTime.Now; db.SaveChanges(); return(new UserLoginDetails { UserDetailID = user.details.UserDetailID, Username = user.login.Username, Name = user.details.Firstname, LastLogin = lastLogin }); }
public void RegisterException(HttpRequestMessage request, HttpRequestContext requestContext, Exception ex) { string endpointResponse = null; if (ex is WebException) { using (var rs = new StreamReader(((WebException)ex).Response.GetResponseStream())) { endpointResponse = rs.ReadToEnd(); } } var log = new LegaSys_ErrorLogs { IsHandled = true, ResourceUri = request.RequestUri.AbsoluteUri, QueryString = request.RequestUri.AbsoluteUri.GetQueryString(), ErrorDatetimeUtc = DateTime.UtcNow, ErrorMessage = ex.Message, ExceptionDetail = ex.InnerException?.GetExceptionMessages() ?? string.Empty, StackTrace = ex.StackTrace, IpAddress = request.GetClientIpAddress(), UserID = requestContext.Principal?.Identity.Name, ReferingUrl = request.Headers.Referrer?.AbsoluteUri, UserAgent = request.Headers.UserAgent?.ToString() }; if (!string.IsNullOrEmpty(endpointResponse)) { log.ExceptionDetail += Environment.NewLine + Environment.NewLine + endpointResponse; } db.LegaSys_ErrorLogs.Add(log); db.SaveChanges(); }
public int CreateProjectDetail(ProjectDetail projectDetail) { var projectModel = new LegaSys_Projects { Title = projectDetail.Title, Description = projectDetail.Description, Client_ID = projectDetail.Client_ID, ProjectDomain_ID = projectDetail.ProjectDomain_ID, Status = 0,//projectDetail.Status, Created_By = projectDetail.Created_By, Updated_By = projectDetail.Updated_By, Created_Date = DateTime.Now, //projectDetail.Created_Date, Updated_Date = DateTime.Now, //projectDetail.Updated_Date, }; db.LegaSys_Projects.Add(projectModel); db.SaveChanges(); return(projectModel.ProjectID); }
public int AddClientDetails(ClientDetail Objclient) { //Insert User details int Result = 0; try { var model = new LegaSys_ClientDetails { ClientDetailID = Objclient.ClientDetailID, ClientName = Objclient.ClientName, Address = Objclient.Address, Country = Objclient.Country, CoClient = Objclient.CoClient, CoClient2 = Objclient.CoClient2, CoClient3 = Objclient.CoClient3, CoClient4 = Objclient.CoClient4, EmailID = Objclient.EmailID, EmailID2 = Objclient.EmailID2, EmailID3 = Objclient.EmailID3, EmailID4 = Objclient.EmailID4, Created_By = Objclient.Created_By, Updated_By = Objclient.Updated_By, Created_Date = System.DateTime.UtcNow, Updated_Date = System.DateTime.UtcNow, IsActive = true }; db.LegaSys_ClientDetails.Add(model); db.SaveChanges(); return(Result = model.ClientDetailID); } catch (Exception) { Result = 0; } return(Result); }
public bool ChangeStatus(int id) { var location = db.LegaSys_Master_Locations.FirstOrDefault(x => x.LocationID == id); if (location == null) { return(false); } if (location.IsActive) { location.IsActive = false; } else { location.IsActive = true; } db.SaveChanges(); return(true); }
public bool ChangeStatus(int id) { var domain = db.LegaSys_Master_TechDomains.FirstOrDefault(x => x.TechDomainID == id); if (domain == null) { return(false); } if (domain.IsActive) { domain.IsActive = false; } else { domain.IsActive = true; } db.SaveChanges(); return(true); }
public bool ChangeStatus(int id) { var shift = db.LegaSys_Master_Shifts.FirstOrDefault(x => x.ShiftID == id); if (shift == null) { return(false); } if (shift.IsActive) { shift.IsActive = false; } else { shift.IsActive = true; } db.SaveChanges(); return(true); }
public bool ChangeStatus(int id) { var technology = db.LegaSys_Master_Technologies.FirstOrDefault(x => x.TechnologyID == id); if (technology == null) { return(false); } if (technology.IsActive) { technology.IsActive = false; } else { technology.IsActive = true; } db.SaveChanges(); return(true); }
public bool ChangeStatus(int id) { var role = db.LegaSys_Master_Roles.FirstOrDefault(x => x.UserRoleID == id); if (role == null) { return(false); } if (role.IsActive) { role.IsActive = false; } else { role.IsActive = true; } db.SaveChanges(); return(true); }
public int CreateResoure(UserDetail userDetail) { var model = new LegaSys_UserDetails { Firstname = userDetail.Firstname, Middlename = userDetail.Middlename, Lastname = userDetail.Lastname, TotalExp = userDetail.TotalExp, EmailId = userDetail.EmailId, MobileNumber = userDetail.MobileNumber, Master_Location_ID = userDetail.Master_Location_ID, Master_Shift_ID = userDetail.Master_Shift_ID, ReportingHead_ID = userDetail.ReportingHead_ID, Master_Role_ID = userDetail.Master_Role_ID, Remarks = userDetail.Remarks, Created_Date = DateTime.Now, Created_By = userDetail.Created_By, IsActive = true }; db.SaveChanges(); return(model.UserDetailID); }
public bool ChangeLeavetypeStatus(int id) { var leave = db.LegaSys_Master_LeaveTypes.FirstOrDefault(x => x.LeaveTypeID == id); if (leave == null) { return(false); } if (leave.IsActive) { leave.IsActive = false; } else { leave.IsActive = true; } db.SaveChanges(); return(true); }