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 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 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 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 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);
}
}
// 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 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 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 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);
}
}
public static dynamic AddComment(Trans_Ticket objtasktransaction)
{
CustomResponse objres = new CustomResponse();
try
{
using (var objcontext = new Db_Zon_Test_techsupportEntities())
{
objcontext.Trans_Ticket.Add(objtasktransaction);
objcontext.SaveChanges();
objres.Message = "Success";
objres.Response = objtasktransaction;
objres.Status = CustomResponseStatus.Successful;
return(objres);
}
}
catch (Exception ex)
{
objres.Message = ex.Message;
objres.Response = null;
objres.Status = CustomResponseStatus.UnSuccessful;
return(objres);
}
}
