public static dynamic UpdateTaskStatus(int taskid, int status, string updatedby)
{
CustomResponse objres = new CustomResponse();
try
{
using (var objcontext = new Db_Zon_Test_techsupportEntities())
{
Mst_Task objtask = objcontext.Mst_Task.Where(x => x.ID == taskid).FirstOrDefault();
Trans_Ticket objtasktrans = new Trans_Ticket();
objtasktrans.TaskID = taskid;
objtasktrans.CreatedBy = updatedby;
objtasktrans.CreatedDate = DateTime.Now;
objtasktrans.O_Task_Status = objtask.Task_Status;
objtasktrans.N_Task_Statuus = status;
objcontext.Trans_Ticket.Add(objtasktrans);
objtask.Task_Status = status;
objtask.UpdatedBy = updatedby;
objcontext.SaveChanges();
objres.Message = "Success";
objres.Response = objtask;
objres.Status = CustomResponseStatus.Successful;
return(objres);
}
}
catch (Exception ex)
{
objres.Message = ex.Message;
objres.Response = null;
objres.Status = CustomResponseStatus.UnSuccessful;
return(objres);
}
}
public static dynamic AddNewProject(Mst_Project objnewproject)
{
CustomResponse objres = new CustomResponse();
try
{
using (var objcontext = new Db_Zon_Test_techsupportEntities())
{
objcontext.Mst_Project.Add(objnewproject);
objcontext.SaveChanges();
objres.Message = "Success";
objres.Response = objnewproject;
objres.Status = CustomResponseStatus.Successful;
return(objres);
}
}
catch (Exception ex)
{
objres.Message = ex.Message;
objres.Response = null;
objres.Status = CustomResponseStatus.UnSuccessful;
return(objres);
}
}
public static dynamic AddNewTicket(Mst_Task objnewTask)
{
CustomResponse objres = new CustomResponse();
try
{
using (var objcontext = new Db_Zon_Test_techsupportEntities())
{
// get short name of the project and get the max count of the tickets and use it as display name
string shortname = objcontext.Mst_Project.Where(x => x.ID == objnewTask.ProjectID).FirstOrDefault().ShortName;
int maxcount = objcontext.Mst_Task.Where(x => x.ProjectID == objnewTask.ProjectID).Count();
objnewTask.TaskDisplayName = shortname + '-' + (maxcount + 1);
objcontext.Mst_Task.Add(objnewTask);
objcontext.SaveChanges();
Trans_Ticket objtrans = new Trans_Ticket {
TaskID = objnewTask.ID, N_Title = objnewTask.Title, N_Description = objnewTask.Description, DisplayName = objnewTask.TaskDisplayName, CreatedDate = DateTime.Now, CreatedBy = objnewTask.CreatedBy
};
objcontext.Trans_Ticket.Add(objtrans);
objcontext.SaveChanges();
objres.Message = "Success";
objres.Response = objnewTask;
objres.Status = CustomResponseStatus.Successful;
return(objres);
}
}
catch (Exception ex)
{
objres.Message = ex.Message;
objres.Response = null;
objres.Status = CustomResponseStatus.UnSuccessful;
return(objres);
}
}
public static dynamic UpdateProfile(UserDTO objuser)
{
CustomResponse objres = new CustomResponse();
try
{
using (var objcontext = new Db_Zon_Test_techsupportEntities())
{
// get short name of the project and get the max count of the tickets and use it as display name
string uid = objuser.Id;
AspNetUser objuinfo = objcontext.AspNetUsers.Where(x => x.Id == uid).FirstOrDefault();
objuinfo.FirstName = objuser.FirstName;
objuinfo.LastName = objuser.LastName;
objuinfo.MobileNumber = objuser.MobileNumber;
objuinfo.CreatedBy = objuser.CreatedBy;
objcontext.SaveChanges();
objres.Message = "Success";
objres.Response = objuinfo;
objres.Status = CustomResponseStatus.Successful;
return(objres);
}
}
catch (Exception ex)
{
objres.Message = ex.Message;
objres.Response = null;
objres.Status = CustomResponseStatus.UnSuccessful;
return(objres);
}
}
public static bool CompareResetToken(string userid, string key)
{
using (var context = new Db_Zon_Test_techsupportEntities())
{
return(context.AspNetUsers.Where(x => x.Id == userid && x.PasswordHash == key).Any());
}
}
// Method to update user profile
public static dynamic EditProfile(UserDTO objuserinfo)
{
CustomResponse objres = new CustomResponse();
try
{
using (var objcontext = new Db_Zon_Test_techsupportEntities())
{
string uid = objuserinfo.Id;
AspNetUser objuser = objcontext.AspNetUsers.Where(x => x.Id == uid).FirstOrDefault();
objuser.FirstName = objuserinfo.FirstName;
objuser.LastName = objuserinfo.LastName;
objuser.MobileNumber = objuserinfo.MobileNumber;
objcontext.SaveChanges();
objres.Message = "Success";
objres.Response = objuser;
objres.Status = CustomResponseStatus.Successful;
return(objres);
}
}
catch (Exception ex)
{
objres.Message = ex.Message;
objres.Response = null;
objres.Status = CustomResponseStatus.UnSuccessful;
return(objres);
}
}
public static CustomResponse GetProjectTicketUsersCount()
{
CustomResponse objres = new CustomResponse();
List <ProjectTicketUsersDTO> StatisticsDTO = new List <ProjectTicketUsersDTO>();
try
{
using (var objcontext = new Db_Zon_Test_techsupportEntities())
{
List <Mst_Project> ProjectsList = objcontext.Mst_Project.ToList();
foreach (Mst_Project proj in ProjectsList)
{
int ticketscount = objcontext.Mst_Task.Where(x => x.ProjectID == proj.ID && x.Task_Status != 4).Count();
int userscount = objcontext.Mst_ProjectUsers.Where(x => x.ProjectID == proj.ID).Count() + 2;
StatisticsDTO.Add(new ProjectTicketUsersDTO {
ProjectName = proj.Name, ProjectID = proj.ID, TicketsCount = ticketscount, UsersCount = userscount
});
}
objres.Message = "Success";
objres.Response = StatisticsDTO;
objres.Status = CustomResponseStatus.Successful;
return(objres);
}
}
catch (Exception ex)
{
objres.Message = ex.Message;
objres.Response = null;
objres.Status = CustomResponseStatus.UnSuccessful;
return(objres);
}
}
public static dynamic EDIT(string Userid)
{
CustomResponse objres = new CustomResponse();
try
{
using (var objcontext = new Db_Zon_Test_techsupportEntities())
{
AspNetUser objuser = objcontext.AspNetUsers.Where(x => x.Id == Userid).FirstOrDefault();
objuser.Status = "0";
objcontext.SaveChanges();
objres.Message = "Success";
objres.Response = objuser;
objres.Status = CustomResponseStatus.Successful;
return(objres);
}
}
catch (Exception ex)
{
objres.Message = ex.Message;
objres.Response = null;
objres.Status = CustomResponseStatus.UnSuccessful;
return(objres);
}
}
public static int GetProjectidByTaskid(int Tid)
{
using (var objts = new Db_Zon_Test_techsupportEntities())
{
return(objts.Mst_Task.Where(a => a.ID == Tid).FirstOrDefault().ProjectID);
}
}
// Get Assignedto me and my tasks
public static dynamic Get(string userid, int pageno)
{
int skipcount = 10 * pageno;
UserDashboardDTO ObjUserDashboardDTO = new UserDashboardDTO();
CustomResponse objres = new CustomResponse();
try
{
using (var objcontext = new Db_Zon_Test_techsupportEntities())
{
ObjUserDashboardDTO.AssignedToMe = (from task in objcontext.Mst_Task
join user in objcontext.AspNetUsers on task.AssignedTo equals user.Id
join user1 in objcontext.AspNetUsers on task.RefereedTo equals user1.Id
where task.AssignedTo == userid
select new TaskDTO {
Title = task.Title, ID = task.ID, Task_Status = task.Task_Status, Description = task.Description, TaskDisplayName = task.TaskDisplayName, AssignedToName = user.FirstName, RefereedToName = user1.FirstName, PriorityName = task.Mst_TaskPriority.PriorityName, TaskTypeName = task.Mst_TaskType.Type, AssigndedDate = task.AssigndedDate
}).ToList();
List <Trans_TicketDTO> ActivityDTO = (from objtrans in objcontext.Trans_Ticket
join ticket in objcontext.Mst_Task on objtrans.TaskID equals ticket.ID
join userprojects in objcontext.Mst_ProjectUsers on ticket.ProjectID equals userprojects.ProjectID
join user2 in objcontext.AspNetUsers on ticket.CreatedBy equals user2.Id
where userprojects.UserID == userid
select new Trans_TicketDTO {
CreatedBy = user2.Email, CreatedDate = objtrans.CreatedDate, TaskID = objtrans.TaskID, DisplayName = ticket.TaskDisplayName, O_Title = objtrans.O_Title, N_Title = objtrans.N_Title, AttachmentName = objtrans.AttachmentName, AttachmentPath = objtrans.AttachmentPath, Comments = objtrans.Comments, O_Description = objtrans.O_Description, O_Task_Status = objtrans.O_Task_Status, N_Description = objtrans.N_Description, N_Task_Statuus = objtrans.N_Task_Statuus
}).ToList().OrderByDescending(x => x.TaskID).Skip(skipcount).Take(10).ToList(); // Get Actual Data in place of ids
//List<Trans_TicketDTO> NewActivityDTO = new List<Trans_TicketDTO>();
//foreach (Trans_TicketDTO objtransaction in ActivityDTO)
//{
// Trans_TicketDTO objtrdto=new Trans_TicketDTO{TaskID=objtransaction.TaskID,DisplayName=objtransaction.DisplayName,AttachmentName=objtransaction.AttachmentName,AttachmentPath=objtransaction.AttachmentPath,Comments=objtransaction.Comments,N_Title=objtransaction.N_Title,O_Title=objtransaction.O_Title,N_Description=objtransaction.N_Description,O_Description=objtransaction.O_Description,CreatedDate=objtransaction.CreatedDate,O_Task_Status=objtransaction.O_Task_Status,N_Task_Statuus=objtransaction.N_Task_Statuus};
// if (objtransaction.CreatedBy !=null)
// {
// string id = objtransaction.CreatedBy.ToString();
// objtrdto.CreatedBy = objcontext.AspNetUsers.Where(x => x.Id == id).FirstOrDefault().UserName;
// }
// NewActivityDTO.Add(objtrdto);
//}
ObjUserDashboardDTO.ActivityDTO = ActivityDTO;
objres.Message = "Success";
objres.Response = ObjUserDashboardDTO;
objres.Status = CustomResponseStatus.Successful;
return(objres);
}
}
catch (Exception ex)
{
objres.Message = ex.Message;
objres.Response = null;
objres.Status = CustomResponseStatus.UnSuccessful;
return(objres);
}
}
public static void ChangeStatus(string Email)
{
var objcontext = new Db_Zon_Test_techsupportEntities();
AspNetUser objUser = objcontext.AspNetUsers.Where(x => x.Email == Email).First();
objUser.Status = "1";
objcontext.SaveChanges();
}
public static void AddPasswordResetToken(string userid, string token)
{
using (var context = new Db_Zon_Test_techsupportEntities())
{
AspNetUser objuser = context.AspNetUsers.Where(x => x.Id == userid).FirstOrDefault();
objuser.PasswordHash = token;
context.SaveChanges();
}
}
public static string GetFnameByEmail(string email)
{
using(var objts=new Db_Zon_Test_techsupportEntities())
{
return objts.AspNetUsers.Where(a => a.Email==email ).FirstOrDefault().FirstName;
}
}
public static dynamic GetAllAdmins()
{
CustomResponse objres = new CustomResponse();
try
{
using (var objcontext = new Db_Zon_Test_techsupportEntities())
{
List <AspNetUser> objuser = objcontext.AspNetUsers.ToList();
List <AspNetUser> objoutput = new List <AspNetUser>();
List <UserDTO> objusersdto = new List <UserDTO>();
foreach (AspNetUser user in objuser)
{
if (user.Status == "1")
{
SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["Db_Zon_Test_techsupportEntities"].ToString());
// 1. Instantiate a new command with a query and connection
con.Open();
SqlCommand cmd = new SqlCommand("select RoleId from AspNetUserRoles where UserId=@uid", con);
cmd.Parameters.AddWithValue("@uid", user.Id);
// 2. Call Execute reader to get query results
SqlDataReader rdr = cmd.ExecuteReader();
// print the CategoryName of each record
while (rdr.Read())
{
if (rdr[0].ToString() == "594875d4-5d30-4d84-bdb3-6a9309799ae2")
{
string rolename = "Administrator";
objusersdto.Add(new UserDTO {
Id = user.Id, Email = user.Email, RoleName = rolename, MobileNumber = user.MobileNumber, FirstName = user.FirstName, LastName = user.LastName
});
}
continue;
}
con.Close();
}
}
objres.Message = "Success";
objres.Response = objusersdto;
objres.Status = CustomResponseStatus.Successful;
return(objres);
}
objres.Message = "Success";
objres.Response = null;
objres.Status = CustomResponseStatus.Successful;
return(objres);
}
catch (Exception ex)
{
objres.Message = ex.Message;
objres.Response = null;
objres.Status = CustomResponseStatus.UnSuccessful;
return(objres);
}
}
// Based on userrole we need to generate report data ,
public static dynamic GetReportData(string userid , int tasktype, int taskstatus, DateTime? fromdate, DateTime? todate)
{
List<ReportData> objreportdata = new List<ReportData>();
CustomResponse objres = new CustomResponse();
try
{
using (var objcontext = new Db_Zon_Test_techsupportEntities())
{
objreportdata = (from t in objcontext.Mst_Task
join tt in objcontext.Mst_TaskType on t.TypeID equals tt.ID
join ts in objcontext.Mst_TaskStatus on t.Task_Status equals ts.ID
join p in objcontext.Mst_Project on t.ProjectID equals p.ID
join u in objcontext.AspNetUsers on t.AssignedTo equals u.Id
join u1 in objcontext.AspNetUsers on t.RefereedTo equals u1.Id
where ( userid.Length==1 || t.AssignedTo == userid) &&
(0 == tasktype || t.TypeID == tasktype) &&
(0 == taskstatus || t.Task_Status == taskstatus)
&& System.Data.Entity.Core.Objects.EntityFunctions.TruncateTime(t.AssigndedDate) >= EntityFunctions.TruncateTime(fromdate)
&& EntityFunctions.TruncateTime(t.AssigndedDate) <= EntityFunctions.TruncateTime(todate)
select new ReportData
{
ProjectName = p.Name,
TicketDisplayName = t.TaskDisplayName,
AssignedDate = t.AssigndedDate,
AssignedTo = u.FirstName,
RefereerTo = u1.FirstName,
TaskStatus = ts.Task_Status,
TicketType = tt.Type,
TicketID = t.ID
}).OrderByDescending(x=>x.TicketID).Take(5000).ToList();
objres.Message = "Success";
objres.Response = objreportdata;
objres.Status = CustomResponseStatus.Successful;
return objres;
}
}
catch (Exception ex)
{
objres.Message = ex.Message;
objres.Response = null;
objres.Status = CustomResponseStatus.UnSuccessful;
return objres;
}
}
public static dynamic GetAllUsers()
{
CustomResponse objres = new CustomResponse();
List <UserDTO> ObjFilteredUsers = new List <UserDTO>();
try
{
using (var objcontext = new Db_Zon_Test_techsupportEntities())
{
//return all projects information
string comp = "1";
List <UserDTO> objuserdetails = (from user in objcontext.AspNetUsers where user.Status == "1"
select new UserDTO
{
Id = user.Id,
FirstName = user.FirstName,
LastName = user.LastName,
Email = user.Email,
MobileNumber = user.MobileNumber,
CreatedBy = user.CreatedBy,
Status = user.Status
}).ToList();
for (int i = 0; i < objuserdetails.Count; i++)
{
string uid = objuserdetails[i].CreatedBy;
if (uid != null)
{
objuserdetails[i].CreatedBy = objcontext.AspNetUsers.Where(x => x.Id == uid).FirstOrDefault().UserName;
}
}
objres.Message = "Success";
objres.Response = objuserdetails;
objres.Status = CustomResponseStatus.Successful;
return(objres);
}
objres.Message = "Success";
objres.Response = null;
objres.Status = CustomResponseStatus.Successful;
return(objres);
}
catch (Exception ex)
{
objres.Message = ex.Message;
objres.Response = null;
objres.Status = CustomResponseStatus.UnSuccessful;
return(objres);
}
}
public static CustomResponse GetDashboardStatistics()
{
CustomResponse objres = new CustomResponse();
List <DashBoardStatisticsDTO> StatisticsDTO = new List <DashBoardStatisticsDTO>();
try
{
using (var objcontext = new Db_Zon_Test_techsupportEntities())
{
// projects
StatisticsDTO.Add(new DashBoardStatisticsDTO {
Type = "1", Count = objcontext.Mst_Project.Count()
});
// clients
SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["Db_Zon_Test_techsupportEntities"].ToString());
con.Open();
SqlCommand cmd = new SqlCommand("select count (distinct ur.UserId) from AspNetUserRoles ur,AspNetUsers u where ur.RoleId=@roleid and ur.Userid =u.Id and u.Status=1", con);
cmd.Parameters.AddWithValue("@roleid", "294e2276-384e-4844-ad8a-7a4c4dd9fcdc");
StatisticsDTO.Add(new DashBoardStatisticsDTO {
Type = "2", Count = Convert.ToInt32(cmd.ExecuteScalar())
});
// admins
SqlCommand cmd1 = new SqlCommand("select count (distinct ur.UserId) from AspNetUserRoles ur,AspNetUsers u where ur.RoleId=@roleid and ur.Userid =u.Id and u.Status=1", con);
cmd1.Parameters.AddWithValue("@roleid", "594875d4-5d30-4d84-bdb3-6a9309799ae2");
StatisticsDTO.Add(new DashBoardStatisticsDTO {
Type = "3", Count = Convert.ToInt32(cmd1.ExecuteScalar())
});
// users-developers
SqlCommand cmd2 = new SqlCommand("select count (distinct ur.UserId) from AspNetUserRoles ur,AspNetUsers u where ur.RoleId=@roleid and ur.Userid =u.Id and u.Status=1", con);
cmd2.Parameters.AddWithValue("@roleid", "15d2fcc9-23c3-4ad8-b93d-d134d3f9349e");
StatisticsDTO.Add(new DashBoardStatisticsDTO {
Type = "4", Count = Convert.ToInt32(cmd2.ExecuteScalar())
});
con.Close();
objres.Message = "Success";
objres.Response = StatisticsDTO;
objres.Status = CustomResponseStatus.Successful;
return(objres);
}
}
catch (Exception ex)
{
objres.Message = ex.Message;
objres.Response = null;
objres.Status = CustomResponseStatus.UnSuccessful;
return(objres);
}
}
public static string GetTaskNameByID(int?task_Id)
{
using (var objconext = new Db_Zon_Test_techsupportEntities())
{
try
{
return(objconext.Mst_TaskStatus.Where(x => x.ID == task_Id).FirstOrDefault().Task_Status);
}
catch (Exception ex)
{
return(ex.Message.ToString());
}
}
}
public static dynamic GetEmailAddressesByUserIds(List <string> objuserids)
{
List <string> EmailAddresses = new List <string>();
try
{
using (var objcontext = new Db_Zon_Test_techsupportEntities())
{
EmailAddresses = (from p in objcontext.AspNetUsers where objuserids.Contains(p.Id) select p).Select(x => x.Email).ToList();
return(EmailAddresses);
}
}
catch (Exception ex)
{
return(null);
}
}
public static dynamic GetActivityByPageNo(int pageno)
{
int skipcount = 10 * pageno;
CustomResponse objres = new CustomResponse();
try
{
using (var objcontext = new Db_Zon_Test_techsupportEntities())
{
List <Trans_TicketDTO> ActivityDTO = (from objtrans in objcontext.Trans_Ticket
join ticket in objcontext.Mst_Task on objtrans.TaskID equals ticket.ID
join user2 in objcontext.AspNetUsers on ticket.CreatedBy equals user2.Id
select new Trans_TicketDTO {
CreatedBy = user2.Email, CreatedDate = objtrans.CreatedDate, TaskID = objtrans.TaskID, DisplayName = ticket.TaskDisplayName, O_Title = objtrans.O_Title, N_Title = objtrans.N_Title, AttachmentName = objtrans.AttachmentName, AttachmentPath = objtrans.AttachmentPath, Comments = objtrans.Comments, O_Description = objtrans.O_Description, O_Task_Status = objtrans.O_Task_Status, N_Description = objtrans.N_Description, N_Task_Statuus = objtrans.N_Task_Statuus
}).ToList().OrderByDescending(x => x.TaskID).Distinct().Skip(skipcount).Take(10).ToList(); // Get Actual Data in place of ids
//List<Trans_TicketDTO> NewActivityDTO = new List<Trans_TicketDTO>();
//foreach (Trans_TicketDTO objtransaction in ActivityDTO)
//{
// Trans_TicketDTO objtrdto=new Trans_TicketDTO{TaskID=objtransaction.TaskID,DisplayName=objtransaction.DisplayName,AttachmentName=objtransaction.AttachmentName,AttachmentPath=objtransaction.AttachmentPath,Comments=objtransaction.Comments,N_Title=objtransaction.N_Title,O_Title=objtransaction.O_Title,N_Description=objtransaction.N_Description,O_Description=objtransaction.O_Description,CreatedDate=objtransaction.CreatedDate,O_Task_Status=objtransaction.O_Task_Status,N_Task_Statuus=objtransaction.N_Task_Statuus};
// if (objtransaction.CreatedBy !=null)
// {
// string id = objtransaction.CreatedBy.ToString();
// objtrdto.CreatedBy = objcontext.AspNetUsers.Where(x => x.Id == id).FirstOrDefault().UserName;
// }
// NewActivityDTO.Add(objtrdto);
//}
objres.Message = "Success";
//objres.Response = NewDTO;
objres.Status = CustomResponseStatus.Successful;
return(objres);
}
}
catch (Exception ex)
{
objres.Message = ex.Message;
objres.Response = null;
objres.Status = CustomResponseStatus.UnSuccessful;
return(objres);
}
}
// get particular project detail
public static dynamic GetProjectDetails(int projectid)
{
CustomResponse objres = new CustomResponse();
try
{
ProjectDTO objproject = new ProjectDTO();
using (var objcontext = new Db_Zon_Test_techsupportEntities())
{
objproject = (from proj in objcontext.Mst_Project
where proj.ID == projectid
select new ProjectDTO {
ID = proj.ID,
Name = proj.Name,
Description = proj.Description,
ShortName = proj.ShortName,
ProjectManager = proj.AspNetUser.FirstName,
Client = proj.AspNetUser.FirstName,
ClientID = proj.ClientID,
PManagerID = proj.PManagerID,
SignUpDate = proj.SignUpDate,
StartDate = proj.StartDate,
Duration = proj.Duration,
ProposedEndDate = proj.ProposedEndDate,
ActualEndDate = proj.ActualEndDate,
Status = proj.Status
}).First();
objproject.ProjectUsers = objcontext.Mst_ProjectUsers.Where(x => x.ProjectID == projectid).Select(x => x.UserID).ToList();
objres.Message = "Success";
objres.Response = objproject;
objres.Status = CustomResponseStatus.Successful;
return(objres);
}
}
catch (Exception ex)
{
objres.Message = ex.Message;
objres.Response = null;
objres.Status = CustomResponseStatus.UnSuccessful;
return(objres);
}
}
public static dynamic GetTicketDetails(int ticketid)
{
CustomResponse objres = new CustomResponse();
try
{
TaskDTO objtasks = new TaskDTO();
using (var objcontext = new Db_Zon_Test_techsupportEntities())
{
objtasks = (from task in objcontext.Mst_Task
join task_type in objcontext.Mst_TaskType on task.TypeID equals task_type.ID
join task_status in objcontext.Mst_TaskStatus on task.Task_Status equals task_status.ID
where task.ID == ticketid
select new TaskDTO {
Title = task.Title, ID = task.ID, Task_Status = task.Task_Status, Description = task.Description, TaskDisplayName = task.TaskDisplayName, AssignedTo = task.AssignedTo, RefereedTo = task.RefereedTo, PriorityID = task.PriorityID, ProjectID = task.ProjectID, TaskTypeName = task.Mst_TaskType.Type, TypeID = task.TypeID, DueDate = task.DueDate, AssigndedDate = task.AssigndedDate, Task_Status_Name = task_status.Task_Status, Task_Type_Name = task_type.Type, Attachment1_Name = task.Attachment1_Name, Attachment1_Path = task.Attachment1_Path, Attachment2_Name = task.Attachment2_Name, Attachment2_Path = task.Attachment2_Path, Attachment3_Name = task.Attachment3_Name, Attachment3_Path = task.Attachment3_Path
}).First();
objtasks.Comments = (from comment in objcontext.Trans_Ticket
where comment.TaskID == ticketid && comment.Comments != null
select
new CommentsDTO {
CreatedBy = comment.AspNetUser.UserName,
CreatedTime = comment.CreatedDate,
FileName = comment.AttachmentName,
FilePath = comment.AttachmentPath,
Comment = comment.Comments
}).ToList();
objres.Message = "Success";
objres.Response = objtasks;
objres.Status = CustomResponseStatus.Successful;
return(objres);
}
}
catch (Exception ex)
{
objres.Message = ex.Message;
objres.Response = null;
objres.Status = CustomResponseStatus.UnSuccessful;
return(objres);
}
}
public static List<ReportData> GetReportDataAsync(string userid, int tasktype, int taskstatus, DateTime? fromdate, DateTime? todate)
{
List<ReportData> objreportdata = new List<ReportData>();
try
{
using (var objcontext = new Db_Zon_Test_techsupportEntities())
{
objreportdata=(from user in objcontext.Mst_ProjectUsers
join t in objcontext.Mst_Task on user.ProjectID equals t.ProjectID
where (null == userid || user.UserID == userid.ToString()) && (0 == tasktype || t.TypeID == tasktype) && (0 == taskstatus || t.Task_Status == taskstatus)
&& EntityFunctions.TruncateTime(t.AssigndedDate) >= EntityFunctions.TruncateTime(fromdate)
&& EntityFunctions.TruncateTime(t.AssigndedDate) <= EntityFunctions.TruncateTime(todate)
select new ReportData
{
ProjectName = user.ProjectID.ToString(),
TicketDisplayName = t.TaskDisplayName,
AssignedDate = t.AssigndedDate,
AssignedTo = t.AspNetUser.FirstName,
RefereerTo = t.AspNetUser.FirstName,
TaskStatus = t.Mst_TaskStatus.Task_Status,
TicketType = t.Mst_TaskType.Type,
TicketID = t.ID
}).OrderByDescending(x => x.TicketID).Take(20).ToList();
return objreportdata;
}
}
catch (Exception ex)
{
return null;
}
}
public static dynamic GetUserIdByEmail(string email)
{
CustomResponse objresponse = new CustomResponse();
try
{
using (var objcontext = new Db_Zon_Test_techsupportEntities())
{
objresponse.Status = CustomResponseStatus.Successful;
objresponse.Response = objcontext.AspNetUsers.Where(x => x.Email == email).FirstOrDefault().Id;
objresponse.Message = "Success";
}
}
catch (Exception ex)
{
objresponse.Status = CustomResponseStatus.Exception;
objresponse.Response = null;
objresponse.Message = ex.Message;
}
return(objresponse);
}
public static List<UserDTO> GetUserProjectDetailsByProejectid(int ProjectID)
{
var objcontext = new Db_Zon_Test_techsupportEntities();
List<UserDTO> users = new List<UserDTO>();
{
string projectmanagerid = objcontext.Mst_Project.Where(x => x.ID == ProjectID).FirstOrDefault().PManagerID;
string clientid = objcontext.Mst_Project.Where(x => x.ID == ProjectID).FirstOrDefault().PManagerID;
users.Add(new UserDTO { Email = objcontext.AspNetUsers.Where(x => x.Id == projectmanagerid).FirstOrDefault().Email, RoleName = "2" });
users.Add(new UserDTO { Email = objcontext.AspNetUsers.Where(x => x.Id == clientid).FirstOrDefault().Email, RoleName = "1" });
}
List<Mst_ProjectUsers> objuserproejct = objcontext.Mst_ProjectUsers.Where(x => x.ProjectID == ProjectID).ToList();
foreach (Mst_ProjectUsers uproj in objuserproejct)
{
string uid = uproj.UserID;
users.Add(new UserDTO { Email = objcontext.AspNetUsers.Where(x => x.Id == uid).FirstOrDefault().Email, RoleName = "5" });
}
return users;
}
public static dynamic UpdateProject(Mst_Project objupdateproject)
{
CustomResponse objres = new CustomResponse();
try
{
using (var objcontext = new Db_Zon_Test_techsupportEntities())
{
int pid = objupdateproject.ID;
Mst_Project objdbproject = objcontext.Mst_Project.Where(x => x.ID == pid).FirstOrDefault();
objdbproject.Name = objupdateproject.Name;
objdbproject.Description = objupdateproject.Description;
objdbproject.PManagerID = objupdateproject.PManagerID;
objdbproject.ClientID = objupdateproject.ClientID;
objdbproject.SignUpDate = objupdateproject.SignUpDate;
objdbproject.StartDate = objupdateproject.StartDate;
objdbproject.Duration = objupdateproject.Duration;
objdbproject.ShortName = objupdateproject.ShortName;
objdbproject.ProposedEndDate = objupdateproject.ProposedEndDate;
for (int i = 0; i < objdbproject.Mst_ProjectUsers.Count(); i++)
{
objdbproject.Mst_ProjectUsers.ElementAt(i).Status = false;
}
objdbproject.Mst_ProjectUsers = objupdateproject.Mst_ProjectUsers;
objcontext.SaveChanges();
objres.Message = "Success";
objres.Response = objdbproject;
objres.Status = CustomResponseStatus.Successful;
return(objres);
}
}
catch (Exception ex)
{
objres.Message = ex.Message;
objres.Response = null;
objres.Status = CustomResponseStatus.UnSuccessful;
return(objres);
}
}
public static List <ReportData> GetReportDataAsync(int projectid, int tasktype, int taskstatus, DateTime?fromdate, DateTime?todate)
{
List <ReportData> objreportdata = new List <ReportData>();
try
{
using (var objcontext = new Db_Zon_Test_techsupportEntities())
{
objreportdata = (from t in objcontext.Mst_Task
join tt in objcontext.Mst_TaskType on t.TypeID equals tt.ID
join ts in objcontext.Mst_TaskStatus on t.Task_Status equals ts.ID
join p in objcontext.Mst_Project on t.ProjectID equals p.ID
join u in objcontext.AspNetUsers on t.AssignedTo equals u.Id
join u1 in objcontext.AspNetUsers on t.RefereedTo equals u1.Id
where (0 == projectid || t.ProjectID == projectid) && (0 == tasktype || t.TypeID == tasktype) && (0 == taskstatus || t.Task_Status == taskstatus) &&
EntityFunctions.TruncateTime(t.AssigndedDate) >= EntityFunctions.TruncateTime(fromdate) &&
EntityFunctions.TruncateTime(t.AssigndedDate) <= EntityFunctions.TruncateTime(todate)
select new ReportData
{
ProjectName = p.Name,
TicketDisplayName = t.TaskDisplayName,
AssignedDate = t.AssigndedDate,
AssignedTo = u.FirstName,
RefereerTo = u1.FirstName,
TaskStatus = ts.Task_Status,
TicketType = tt.Type,
TicketID = t.ID
}).OrderByDescending(x => x.TicketID).Take(5000).ToList();
return(objreportdata);
}
}
catch (Exception ex)
{
return(null);
}
}
public static dynamic GetTaskStatus()
{
CustomResponse objresponse = new CustomResponse();
try
{
using (var objcontext = new Db_Zon_Test_techsupportEntities())
{
objresponse.Status = CustomResponseStatus.Successful;
objresponse.Response = (from status in objcontext.Mst_TaskStatus select new TypeAndPriorityDTO {
Name = status.Task_Status, ID = status.ID
}).ToList();
objresponse.Message = "Success";
}
}
catch (Exception ex)
{
objresponse.Status = CustomResponseStatus.Exception;
objresponse.Response = null;
objresponse.Message = ex.Message;
}
return(objresponse);
}
// get particular project detail
public static List <string> GetProjectUsers(int projectid)
{
CustomResponse objres = new CustomResponse();
try
{
List <string> objUserIds = new List <string>();
using (var objcontext = new Db_Zon_Test_techsupportEntities())
{
// Add ProjectManager and Client Info
Mst_Project objproject = objcontext.Mst_Project.Where(x => x.ID == projectid).FirstOrDefault();
objUserIds.Add(objproject.PManagerID);
objUserIds.Add(objproject.ClientID);
// Add ProjectUsers info
objUserIds.AddRange(objcontext.Mst_ProjectUsers.Where(x => x.ProjectID == projectid).Select(x => x.UserID).ToList());
return(objUserIds);
}
}
catch (Exception ex)
{
return(null);
}
}
public static dynamic UpdateTicket(Mst_Task objupdateTask)
{
CustomResponse objres = new CustomResponse();
try
{
using (var objcontext = new Db_Zon_Test_techsupportEntities())
{
// get short name of the project and get the max count of the tickets and use it as display name
int tid = objupdateTask.ID;;
Mst_Task objtask = objcontext.Mst_Task.Where(x => x.ID == tid).FirstOrDefault();
objtask.Title = objupdateTask.Title;
objtask.Description = objupdateTask.Description;
objtask.AssigndedDate = objupdateTask.AssigndedDate;
objtask.DueDate = objupdateTask.DueDate;
objtask.AssignedTo = objupdateTask.AssignedTo;
objtask.RefereedTo = objupdateTask.RefereedTo;
objtask.Task_Status = objupdateTask.Task_Status;
objtask.TypeID = objupdateTask.TypeID;
objtask.ProjectID = objupdateTask.ProjectID;
objtask.PriorityID = objupdateTask.PriorityID;
objcontext.SaveChanges();
objres.Message = "Success";
objres.Response = objupdateTask;
objres.Status = CustomResponseStatus.Successful;
return(objres);
}
}
catch (Exception ex)
{
objres.Message = ex.Message;
objres.Response = null;
objres.Status = CustomResponseStatus.UnSuccessful;
return(objres);
}
}
