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 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 dynamic Post(Trans_TicketDTO objtasktransactionDTO)
{
Trans_Ticket objtasktransaction = new Trans_Ticket {
TaskID = objtasktransactionDTO.TaskID, Comments = objtasktransactionDTO.Comments, AttachmentName = objtasktransactionDTO.AttachmentName, AttachmentPath = objtasktransactionDTO.AttachmentPath, CreatedBy = objtasktransactionDTO.CreatedBy, CreatedDate = objtasktransactionDTO.CreatedDate
};
return(TaskTransactionRepository.AddComment(objtasktransaction));
}
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);
}
}
