public void CopyData(Request request) { SRMContext context = new SRMContext(); this.RequestId = request.Id.ToString(); this.Title = request.Title; this.RequestStatus = context.Status.FirstOrDefault(n => n.Id == request.StatusId).Status1; this.RequestType = context.RequestTypes.FirstOrDefault(n => n.Id == request.RequestTypeId).RequestType1; this.RequestDepartment = context.Department.FirstOrDefault(n => n.Id == request.DepartmentId).Name; this.RequestCategory = context.Category.FirstOrDefault(n => n.Id == request.CategoryId).Name; this.RequestSubCategory = context.Category.FirstOrDefault(n => n.Id == request.SubCategoryId).Name; this.RequestStatusId = context.Status.FirstOrDefault(n => n.Id == request.StatusId).Id; this.RequestTypeId = context.RequestTypes.FirstOrDefault(n => n.Id == request.RequestTypeId).Id; this.RequestDepartmentId = context.Department.FirstOrDefault(n => n.Id == request.DepartmentId).Id; this.RequestCategoryId = context.Category.FirstOrDefault(n => n.Id == request.CategoryId).Id; this.RequestSubCategoryId = context.Category.FirstOrDefault(n => n.Id == request.SubCategoryId).Id; this.RequestSummary = request.Summary; this.Title = request.Title; this.CreatedOn = request.CreatedOn; this.LastModifiedOn = request.LastModifiedOn; // this.CreatedEmpId = request.CreatedEmpId; this.CreatedEmpId = context.Employees.FirstOrDefault(n => n.Id == request.CreatedEmpId).Id; this.AssignedEmpId = request.AssignedEmpId; this.LastModifiedBy = request.LastModifiedBy; }
public Request GetRequestDetail(int Id) { var context = new SRMContext(); Request request = context.Request.FirstOrDefault(n => n.Id == Id); return(request); }
public void CreateRequest(Request request) { var context = new SRMContext(); if (request == null) { throw new ArgumentNullException(nameof(request)); } context.Request.Add(request); context.SaveChanges(); var email1 = context.Employees.FirstOrDefault(e => e.Id == request.CreatedEmpId).EmailId; var AdminEmail = context.Employees.FirstOrDefault(e => e.DepartmentId == request.DepartmentId && e.RoleId == (context.Roles.FirstOrDefault(r => r.Role1.Equals("Admin")).Id)).EmailId; //var fromAddress = new MailAddress("*****@*****.**", "My Name"); //var toAddress1 = new MailAddress((email1).ToString()); //var toAddress2 = new MailAddress((AdminEmail).ToString()); //const string fromPassword = "******"; string sub = "Service Request"; string content = "Request Created!" + "\nRequest Id: " + request.Id + "\nRequest Created by: " + context.Employees.FirstOrDefault(e => e.Id == request.CreatedEmpId).FirstName + "\nDepartment: " + context.Department.FirstOrDefault(d => d.Id == request.DepartmentId).Name + "\nCategory: " + context.Category.FirstOrDefault(c => c.Id == request.CategoryId).Name + "\nSubcategory: " + context.Category.FirstOrDefault(s => s.Id == request.SubCategoryId).Name + "\nTitle :" + request.Title + "\nSummary :" + request.Summary; var message = new Message(new string[] { email1, AdminEmail }, sub, content); emailSender.SendEmail(message); }
public ActionResult <Request> CreateRequest(Request createRequest) { SRMContext context = new SRMContext(); _repository.CreateRequest(createRequest); context.SaveChanges(); return(createRequest); }
public void Configuration(IAppBuilder app) { System.Data.Entity.Database.SetInitializer(new DropCreateDatabaseIfModelChanges <SRMContext>()); using (var context = new SRMContext()) { context.Database.Initialize(force: true); } ConfigureAuth(app); }
//catch (Exception ex) //{ // Console.Error.WriteLine(ex.ToString()); //} public void DeleteRequest(Request request) { var context = new SRMContext(); if (request == null) { throw new ArgumentNullException(nameof(request)); } context.Request.Remove(request); }
public void UpdateRequest(int serviceRequestId, Request serviceRequest) { var context = new SRMContext(); var oldRequest = context.Request.FirstOrDefault(n => n.Id == serviceRequestId); if (oldRequest != null) { //oldRequest.CategoryId = serviceRequest.CategoryId; oldRequest.AssignedEmpId = serviceRequest.AssignedEmpId; // oldRequest.DepartmentId = serviceRequest.DepartmentId; oldRequest.StatusId = serviceRequest.StatusId; oldRequest.Summary = serviceRequest.Summary; // oldRequest.Title = serviceRequest.Title; // oldRequest.Comments = serviceRequest.Comments; oldRequest.LastModifiedOn = serviceRequest.LastModifiedOn; oldRequest.LastModifiedBy = serviceRequest.LastModifiedBy; context.SaveChanges(); } try { string CreatedEmpEmail = context.Employees.FirstOrDefault(e => e.Id == serviceRequest.CreatedEmpId).EmailId; string AssignedEmpEmail = context.Employees.FirstOrDefault(e => e.Id == serviceRequest.AssignedEmpId).EmailId; string AdminEmail = context.Employees.FirstOrDefault(e => e.DepartmentId == serviceRequest.DepartmentId && e.RoleId == (context.Roles.FirstOrDefault(r => r.Role1.Equals("Admin")).Id)).EmailId; string sub = "Service for request " + serviceRequest.Title; //string content = JsonConvert.SerializeObject(serviceRequest); string content = "Request Id: " + serviceRequest.Id + "\nRequest Title: " + serviceRequest.Title + "\nSummary: " + serviceRequest.Summary + "\nComments: " + context.Comments.OrderByDescending(e => e.Id).FirstOrDefault(e => e.RequestId == serviceRequest.Id).Comment1 + "\nRequest Created by: " + context.Employees.FirstOrDefault(e => e.Id == serviceRequest.CreatedEmpId).FirstName + "\nRequest Assigned to: " + context.Employees.FirstOrDefault(e => e.Id == serviceRequest.AssignedEmpId).FirstName; if (serviceRequest.StatusId == 2) { content = content + "\n request is in process"; } else if (serviceRequest.StatusId == 3) { content = content + "\n request has been completed"; } var message = new Message(new string[] { CreatedEmpEmail, AssignedEmpEmail, AdminEmail }, sub, content); emailSender.SendEmail(message); } catch (Exception ex) { Console.Error.WriteLine(ex.ToString()); }// }
public Request GetRequestById(int Id) { var context = new SRMContext(); var request = context.Request .Include(stat => stat.Status) .Include(dept => dept.Department) .Include(cat => cat.Category) .Where(req => req.Id == Id).FirstOrDefault(); return(request); }
public void CopyData(Employee employee) { SRMContext context = new SRMContext(); this.Id = employee.Id; this.Department = context.Department.FirstOrDefault(e => e.Id == employee.DepartmentId).Name; this.FirstName = employee.FirstName; this.MiddleName = employee.MiddleName; this.LastName = employee.LastName; this.EmailId = employee.EmailId; }
public ActionResult <Request> DeleteRequest(int Id) { SRMContext context = new SRMContext(); var requestFromRepo = _repository.GetRequestById(Id); if (requestFromRepo == null) { return(NotFound()); } _repository.DeleteRequest(requestFromRepo); context.SaveChanges(); return(NoContent()); }
public IActionResult EmployeeByDept([FromRoute] string id) { var context = new SRMContext(); int deptId = context.Department.FirstOrDefault(s => s.Name.Equals(id)).Id; var allEmployees = _service.GetEmployeeByDept(deptId); List <AngularEmployeeModel> objList = new List <AngularEmployeeModel>(); foreach (var employee in allEmployees) { AngularEmployeeModel obj = new AngularEmployeeModel(); obj.CopyData(employee); objList.Add(obj); } return(Ok(objList)); }
public void CopyData(Employee employee) { SRMContext context = new SRMContext(); this.Id = employee.Id; if (employee.DepartmentId == null) { this.Department = "NotAssigned"; } else { this.Department = context.Department.FirstOrDefault(e => e.Id == employee.DepartmentId).Name; } this.FirstName = employee.FirstName; this.MiddleName = employee.MiddleName; this.LastName = employee.LastName; this.EmailId = employee.EmailId; }
public IActionResult UpdateRequest(int id, [FromBody] AngularRequestModel obj) { SRMContext context = new SRMContext(); //string Comment = obj.Comment; Comment c = new Comment(); c.Comment1 = obj.Comment; c.EmployeeId = obj.AssignedEmpId; c.RequestId = Int32.Parse(obj.RequestId); c.CreatedOn = DateTimeOffset.Now; c.LastModifiedOn = DateTimeOffset.Now; c.LogTime = DateTimeOffset.MinValue; c.LastModifiedBy = "MAYURESH"; context.Comments.Add(c); context.SaveChanges(); _service.UpdateRequest(id, obj.SendData()); return(Ok(obj)); }
public Request SendData() { Request request = new Request(); SRMContext context = new SRMContext(); request.Id = Int32.Parse(this.RequestId); request.Title = this.Title; request.StatusId = context.Status.FirstOrDefault(n => n.Status1.Equals(this.RequestStatus)).Id; request.RequestTypeId = context.RequestTypes.FirstOrDefault(n => n.RequestType1.Equals(this.RequestType)).Id; request.DepartmentId = context.Department.FirstOrDefault(n => n.Name.Equals(this.RequestDepartment)).Id; request.CategoryId = context.Category.FirstOrDefault(n => n.Name.Equals(this.RequestCategory)).Id; request.SubCategoryId = context.Category.FirstOrDefault(n => n.Name.Equals(this.RequestSubCategory)).Id; request.Summary = this.RequestSummary; request.CreatedOn = this.CreatedOn; request.LastModifiedOn = this.LastModifiedOn; request.CreatedEmpId = this.CreatedEmpId; request.AssignedEmpId = this.AssignedEmpId; request.LastModifiedBy = this.LastModifiedBy; return(request); }
public SqlRequestRepo(SRMContext context) { _context = context; }
public Test(SRMContext _Context) { Context = _Context; }
public EmployeeService(SRMContext context) { _context = context; }
public SqlStatusRepo(SRMContext context) { _context = context; }
public SqlCategoryRepo(SRMContext context) { _context = context; }
public List <Request> GetAllRequests(int DeptId) { var context = new SRMContext(); return(context.Request.Where(r => r.DepartmentId == DeptId).ToList()); }
public CommentsController(SRMContext context) { _context = context; }
public SqlEmployeeRepo(SRMContext context) { _context = context; }
//public IEnumerable<Request> GetRequest() // { // return _context.Request // .Include(stat => stat.Status) // .Include(dept => dept.Department) // .Include(cat => cat.Category) // .Include(cat => cat.SubCategory) // .ToList(); // } public List <Request> GetRequests() { var context = new SRMContext(); return(context.Request.ToList()); }
public List <Employee> GetAllEmployees() { var context = new SRMContext(); return(context.Employee.ToList()); }
public SqlDepartmentRepo(SRMContext context) { _context = context; }
public List <Employee> GetEmployeeByDept(int DeptId) { var context = new SRMContext(); return(context.Employee.Where(e => e.DepartmentId == DeptId).ToList()); }
public RolesController(SRMContext context) { _context = context; }
public Employee GetEmployeeDetail(int Id) { var context = new SRMContext(); return(context.Employee.FirstOrDefault(n => n.Id == Id)); }