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));
}
