public async Task <IActionResult> Edit(int id, [Bind("Id,AssignedTo,TaskName,DueDate,TaskStatusId,TaskTypeId,AssociatedRecordId,DateCreated,LastModified,CreatedBy,ModifiedBy,Archived")] TblTask tblTask)
{
if (id != tblTask.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(tblTask);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TblTaskExists(tblTask.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(tblTask));
}
public static void UpdateIssueStatus(int IssueId, int CurrentUserId, int statusValue)
{
DataContext db = new DataContext();
TblTask result = (from t in db.TblTasks
where t.Id == IssueId
select t).Single();
result.Status = statusValue;
result.StatusChangedBy = CurrentUserId;
db.SubmitChanges();
}
public async Task <IActionResult> Create([Bind("Id,AssignedTo,TaskName,DueDate,TaskStatusId,TaskTypeId,AssociatedRecordId,DateCreated,LastModified,CreatedBy,ModifiedBy,Archived")] TblTask tblTask)
{
if (ModelState.IsValid)
{
_context.Add(tblTask);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(tblTask));
}
public static void DeleteTask(int Id)
{
try
{
DataContext db = new DataContext();
TblTask result = (from t in db.TblTasks
where t.Id == Id
select t).Single();
result.IsDeleted = true;
db.SubmitChanges();
db.Dispose();
}
catch (Exception e)
{
}
}
public static void AddTask(string name, string discription, string imgURL, int assignee, string proirity, int postedby)
{
DataContext db = new DataContext();
TblTask tbl = new TblTask();
tbl.Name = name;
tbl.Discription = discription;
tbl.ImageLink = imgURL;
tbl.IsDeleted = false;
tbl.Assignee = assignee;
tbl.Priority = proirity;
tbl.Status = 1; //1 for remaining
tbl.UserId = postedby;
db.TblTasks.InsertOnSubmit(tbl);
db.SubmitChanges();
db.Dispose();
}
public static void UpdateEvent(int EventId, string title, string discription, string imgURL, string Eventdate, int postedby)
{
DataContext db = new DataContext();
TblTask tbl = new TblTask();
TblEvent result = (from t in db.TblEvents
where t.Id == EventId
select t).SingleOrDefault();
result.Title = title;
result.Discription = discription;
result.imageURL = imgURL;
result.EventDate = Convert.ToDateTime(Eventdate);
result.UpdatedBy = postedby;
db.SubmitChanges();
db.Dispose();
}
public static void UpdateTask(int taskId, string name, string discription, string imgURL, int assignee, string proirity, int postedby)
{
DataContext db = new DataContext();
TblTask tbl = new TblTask();
TblTask result = (from t in db.TblTasks
where t.Id == taskId
select t).SingleOrDefault();
result.Name = name;
result.Discription = discription;
result.ImageLink = imgURL;
result.Assignee = assignee;
result.Priority = proirity;
result.UpdatedBy = postedby;
db.SubmitChanges();
db.Dispose();
}
public static long ReturnLastIssueId()
{
DataContext db = new DataContext();
TblTask obj = new TblTask();
var result = (from e in db.TblTasks
orderby e.Id descending
select e).FirstOrDefault();
obj = result;
if (result != null)
{
return(obj.Id);
}
else
{
return(0);
}
}
