public ActionResult _AddTask(string taskName, int groupId = 0)
{
var lastTask = _taskService.GetAllTasks()
.OrderByDescending(x => x.DisplayOrder)
.FirstOrDefault() ?? new tblTask();
var task = new tblTask
{
DisplayOrder = lastTask.DisplayOrder + 1,
GroupId = groupId,
InsertDate = DateTime.Now,
InsertUserId = 0,
IsCompleted = false,
Name = taskName
};
try
{
_taskService.AddTask(task);
_unitOfWork.SaveChanges();
}
catch (Exception ex)
{
var responseModel = CreateResponse(HttpStatusCode.InternalServerError, ex.GetBaseException().Message, ResponseStatusTypes.Danger);
return(Json(responseModel, JsonRequestBehavior.AllowGet));
}
return(PartialView("_TaskPartial", task));
}
public IHttpActionResult PutTask(int id, tblTask task)
{
if (id != task.ID)
{
return(BadRequest());
}
db.Entry(task).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!TaskExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult put(tblTask item)
{
ProjectBAL obj = new ProjectBAL();
obj.UpdateTask(item);
return(Ok("Record Updated"));
}
public ActionResult EditTask(int TaskID)
{
Task model = new Task();
List <tblPriority> list = db.tblPriorities.ToList();
ViewBag.PriorityList = new SelectList(list, "PriorityID", "Priority");
int ID = Convert.ToInt32(Session["UserID"]);
if (TaskID > 0)
{
tblTask objtblTask = db.tblTasks.SingleOrDefault(x => x.TaskID == TaskID && x.ID == ID);
model.TaskID = objtblTask.TaskID;
model.Title = objtblTask.Title;
model.TaskDetail = objtblTask.TaskDetail;
model.StartDate = objtblTask.StartDate;
model.StartTime = objtblTask.StartTime;
model.EndDate = objtblTask.EndDate;
model.EndTime = objtblTask.EndTime;
model.Completed = objtblTask.Completed;
model.PriorityID = objtblTask.PriorityID;
}
return(PartialView("EditTaskPartial", model));
}
public IHttpActionResult post(tblTask item)
{
ProjectBAL obj = new ProjectBAL();
obj.AddTask(item);
return(Ok("Record added"));
}
protected void rptTaskFile_ItemCommand(object source, RepeaterCommandEventArgs e)
{
try
{
var DC = new DataClassesDataContext();
if (e.CommandName == "Download")
{
tblTask TaskData = DC.tblTasks.Single(ob => ob.TaskID == Convert.ToInt32(e.CommandArgument));
tblModule ModuleData = DC.tblModules.Single(ob => ob.ModuleID == TaskData.ModuleID);
tblProject ProjectData = DC.tblProjects.Single(ob => ob.ProjectID == ModuleData.ProjectID);
Response.Clear();
Response.ContentType = "application/zip";
Response.AddHeader("content-disposition", "filename=" + ProjectData.Title + "_" + ModuleData.Title + "_" + TaskData.Title + ".zip");
using (ZipFile zip = new ZipFile())
{
zip.AddDirectory(Server.MapPath("UploadTaskFile/") + @TaskData.SubmittedFile);
zip.Save(Response.OutputStream);
}
}
}
catch (Exception ex)
{
int session = Convert.ToInt32(Session["EmpID"].ToString());
string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath);
string MACAddress = GetMacAddress();
AddErrorLog(ref ex, PageName, "Employee", session, 0, MACAddress);
ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true);
}
}
public void UpdateTask(tblTask taskitem)
{
try
{
using (ProjectManagerDBEntities db1 = new ProjectManagerDBEntities())
{
tblTask taskupdate = db1.tblTasks.SingleOrDefault(x => x.TaskId == taskitem.TaskId);
tblProject projectupdate = db1.tblProjects.SingleOrDefault(x => x.ProjectId == taskupdate.ProjectId);
projectupdate.Nooftasks = projectupdate.Nooftasks - 1;
taskupdate.TaskName = taskitem.TaskName;
taskupdate.TStartDate = taskitem.TStartDate;
taskupdate.TEndDate = taskitem.TEndDate;
taskupdate.TPriority = taskitem.TPriority;
taskupdate.TStatus = taskitem.TStatus;
taskupdate.ParentId = taskitem.ParentId;
taskupdate.ProjectId = taskitem.ProjectId;
taskupdate.UserId = taskitem.UserId;
taskupdate.ParentTaskName = taskitem.ParentTaskName;
tblProject projectupdate1 = db1.tblProjects.SingleOrDefault(x => x.ProjectId == taskitem.ProjectId);
projectupdate1.Nooftasks = projectupdate1.Nooftasks + 1;
db1.SaveChanges();
}
}
catch { }
}
//[Route("UpdateTaskDetails")]
public HttpResponseMessage Put(int id, [FromBody] tblTask newTask)
{
try {
using (TaskDBEntities entities = new TaskDBEntities())
{
var entity = entities.tblTask.FirstOrDefault(t => t.QuoteID == id);
if (entity == null)
{
//return 404 not found
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Task with ID=" + id.ToString() + " is not found to update."));
}
else
{
entity.QuoteType = newTask.QuoteType;
entity.ContactID = newTask.ContactID;
entity.TaskDescription = newTask.TaskDescription;
entity.TaskDueDate = newTask.TaskDueDate;
entity.TaskType = newTask.TaskType;
entities.SaveChanges();
//return 200 OK
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public ActionResult CreateStudent(tblTask std)
{
db.tblTasks.Add(std);
db.SaveChanges();
string msg = "Success";
return(Json(new { Message = msg, JsonRequestBehavior.AllowGet }));
}
public void Getbytask()
{
ProjectBL obj = new ProjectBL();
List <tblTask> Ts = obj.GetTask();
tblTask count = obj.GetTaskbyId(Ts[0].TaskId);
Assert.IsNotNull(count);
}
public ActionResult DeleteConfirmed(int id)
{
tblTask tbltask = db.tblTasks.Find(id);
db.tblTasks.Remove(tbltask);
db.SaveChanges();
return(RedirectToAction("Index"));
}
protected void LinkButton12_Click(object sender, EventArgs e)
{
var DC = new DataClassesDataContext();
tblTask TaskData = DC.tblTasks.Single(ob => ob.TaskID == Convert.ToInt32(ltrTaskID.Text));
tblModule ModuleData = DC.tblModules.Single(ob => ob.ModuleID == TaskData.ModuleID);
Session["ModuleID"] = ModuleData.ModuleID;
Response.Redirect("ModuleDetail.aspx");
}
public void Getbytask()
{
ProjectBAL obj = new ProjectBAL();
List <tblTask> Ts = obj.GetTask();
//Task count = obj.GetTaskbyId(1);
tblTask count = obj.GetTaskbyId(Ts[0].TaskId);
Assert.IsNotNull(count);
// Assert.Greater(count, 0);
}
public void AddTask(tblTask item)
{
using (FinalSBADBEntities db1 = new FinalSBADBEntities())
{
var projectupdate = db1.tblProjects.Where(x => x.ProjectId == item.ProjectId).ToList();
projectupdate.ForEach(m => m.Nooftasks = m.Nooftasks + 1);
item.TStatus = false;
db1.tblTasks.Add(item);
db1.SaveChanges();
}
}
public void DeleteTask(int TaskId)
{
using (FinalSBADBEntities db1 = new FinalSBADBEntities())
{
tblTask ts = db1.tblTasks.Where(d => d.TaskId == TaskId).FirstOrDefault();
var projectupdate = db1.tblProjects.Where(x => x.ProjectId == ts.ProjectId).ToList();
projectupdate.ForEach(m => m.completed = m.completed - 1);
db1.tblTasks.Remove(ts);
db1.SaveChanges();
}
}
public void DeleteTask()
{
ProjectBL obj = new ProjectBL();
List <tblTask> Ts = obj.GetTask();
tblTask Taskgetbyid = obj.GetTaskbyId(Ts[0].TaskId);
int count1 = obj.GetTask().Count();
obj.DeleteTask(Taskgetbyid.TaskId);
int count2 = obj.GetTask().Count();
Assert.AreEqual(count2, count1 - 1);
}
public void Endtask(int id)
{
using (ProjectManagerDBEntities db = new ProjectManagerDBEntities())
{
tblTask ts = db.tblTasks.SingleOrDefault(x => x.TaskId == id);
var projectupdate = db.tblProjects.Where(x => x.ProjectId == ts.ProjectId).ToList();
projectupdate.ForEach(m => m.Nooftasks = m.Nooftasks - 1);
projectupdate.ForEach(m => m.completed = m.completed + 1);
ts.TStatus = true;
ts.TEndDate = DateTime.Now;
db.SaveChanges();
}
}
public void AddTask()
{
ProjectBL obje = new ProjectBL();
int count = obje.GetTask().Count();
tblTask T = (new tblTask {
TaskName = "Working", TStartDate = DateTime.Now, TEndDate = DateTime.Now, TPriority = 10, TStatus = false, ParentTaskName = "Cleaning", UserId = 1
});
obje.AddTask(T);
int count1 = obje.GetTask().Count();
Assert.AreEqual(count1, count + 1);
}
public IHttpActionResult DeleteTask(int id)
{
tblTask objTask = db.tblTasks.Find(id);
if (objTask == null)
{
return(NotFound());
}
db.tblTasks.Remove(objTask);
db.SaveChanges();
return(Ok(objTask));
}
public ActionResult Edit([Bind(Include = "TaskID,ProjectID,Title,EndUser,AssignedTo,OpenedBy,OpenedDate,StatusID,SubCategoryID,PriorityID,Description,ScheduledStart,ActualStart,ScheduledFinish,EstFinish,ActualFinish,EstDurationDays,DateModified,RelatedIssues,Comments,Publicity,PctComplete,GroupName,IISR,Atch")] tblTask tbltask)
{
if (ModelState.IsValid)
{
db.Entry(tbltask).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.PriorityID = new SelectList(db.tblPriorities, "PriorityID", "PriorityName", tbltask.PriorityID);
ViewBag.ProjectID = new SelectList(db.tblProjects, "ProjectID", "ProjectName", tbltask.ProjectID);
ViewBag.StatusID = new SelectList(db.tblStatus, "StatusID", "StatusName", tbltask.StatusID);
ViewBag.SubCategoryID = new SelectList(db.tblSubCategories, "SubCategoryID", "SubCategoryName", tbltask.SubCategoryID);
return(View(tbltask));
}
// GET: /Task/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblTask tbltask = db.tblTasks.Find(id);
if (tbltask == null)
{
return(HttpNotFound());
}
return(View(tbltask));
}
public void DeleteTask()
{
ProjectBAL obj = new ProjectBAL();
List <tblTask> Ts = obj.GetTask();
tblTask Taskgetbyid = obj.GetTaskbyId(Ts[0].TaskId);
int count1 = obj.GetTask().Count();
//dynamic testtask = new (Task) list<Task>;
//Task T = (new Task { TaskId = 1015, ParentName = "ParentTaskstest", TaskName = "Testtaskname", Priority = 15, SDate = DateTime.Now, EDate = DateTime.Now });
obj.DeleteTask(Taskgetbyid.TaskId);
int count2 = obj.GetTask().Count();
Assert.AreEqual(count2, count1 - 1);
}
public void AddTask_Service()
{
var obj = new ProjectManagerAPI.Controllers.TaskController();
tblTask Ts = (new tblTask {
TaskName = "Cooking", TStartDate = DateTime.Now, TEndDate = DateTime.Now, TPriority = 10, TStatus = false, ParentTaskName = "Cleaning", UserId = 0
});
IHttpActionResult result = obj.post(Ts);
var contentresult = result as OkNegotiatedContentResult <string>;
IHttpActionResult result1 = obj.Get();
var contentresult1 = result1 as OkNegotiatedContentResult <List <tblTask> >;
Assert.IsNotNull(contentresult);
Assert.Greater(contentresult1.Content.Count, 0);
}
public JsonResult DeleteTask(int TaskID)
{
bool result = false;
tblTask objtblTask = db.tblTasks.SingleOrDefault(x => x.TaskID == TaskID);
if (objtblTask != null)
{
result = true;
db.tblTasks.Remove(objtblTask);
db.SaveChanges();
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public void AddTask()
{
ProjectBAL obje = new ProjectBAL();
int count = obje.GetTask().Count();
//dynamic testtask = new (Task) list<Task>;
tblTask T = (new tblTask {
TaskName = "Testtaskname", TStartDate = DateTime.Now, TEndDate = DateTime.Now, TPriority = 10, TStatus = false, ParentTaskName = "parenttask", UserId = 1
});
obje.AddTask(T);
int count1 = obje.GetTask().Count();
Assert.AreEqual(count1, count + 1);
}
public void UpdateTAsk()
{
var obj = new ProjectManagerAPI.Controllers.TaskController();
IHttpActionResult result = obj.Get();
var contentresult = result as OkNegotiatedContentResult <List <tblTask> >;
// tblTask ts = new tblTask { TaskId = contentresult.Content[0].TaskId, TaskName = "Updated Task", ParentName = "Updated Parent", Priority = 10, SDate = DateTime.Now, EDate = DateTime.Now, flag = true };
tblTask Ts = (new tblTask {
TaskId = contentresult.Content[0].TaskId, TaskName = "taskname", TStartDate = DateTime.Now, TEndDate = DateTime.Now, TPriority = 10, TStatus = false, ParentTaskName = "parenttask", UserId = 1
});
IHttpActionResult result1 = obj.put(Ts);
IHttpActionResult result2 = obj.Get();
var contentresult1 = result2 as OkNegotiatedContentResult <List <tblTask> >;
Assert.AreEqual(contentresult1.Content[0].TaskName, Ts.TaskName);
}
public void AddTask_Service()
{
var obj = new ProjectManagerAPI.Controllers.TaskController();
//Task ts = new tblTask { TaskName = "Task added", ParentName = "Parent added", Priority = 10, SDate = DateTime.Now, EDate = DateTime.Now, flag = true };
tblTask Ts = (new tblTask {
TaskName = "Testtaskname", TStartDate = DateTime.Now, TEndDate = DateTime.Now, TPriority = 10, TStatus = false, ParentTaskName = "parenttask", UserId = 0
});
IHttpActionResult result = obj.post(Ts);
var contentresult = result as OkNegotiatedContentResult <string>;
IHttpActionResult result1 = obj.Get();
var contentresult1 = result1 as OkNegotiatedContentResult <List <tblTask> >;
Assert.IsNotNull(contentresult);
Assert.Greater(contentresult1.Content.Count, 0);
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
var DC = new DataClassesDataContext();
if (fileUploadTask.HasFiles)
{
tblTask TaskData = DC.tblTasks.Single(ob => ob.TaskID == Convert.ToInt32(ltrTaskID.Text));
if (TaskData.SubmittedFile == null)
{
string FolderName = DateTime.Now.ToString("ddMMyyyyHmmss");
string folderPath = Server.MapPath("UploadTaskFile/" + FolderName + "/");
//check whether directory (folder) exists.
if (!Directory.Exists(folderPath))
{
//if directory (folder) does not exists. create it.
Directory.CreateDirectory(folderPath);
}
foreach (HttpPostedFile uploadedfile in fileUploadTask.PostedFiles)
{
//uploadedfile.SaveAs(System.IO.Path.Combine(Server.MapPath(folderPath), uploadedfile.FileName));
uploadedfile.SaveAs(folderPath + Path.GetFileName(uploadedfile.FileName));
lblFileName.Text += string.Format("<br />{0}", uploadedfile.FileName);
}
TaskData.SubmittedFile = FolderName;
}
else
{
foreach (HttpPostedFile uploadedfile in fileUploadTask.PostedFiles)
{
//uploadedfile.SaveAs(System.IO.Path.Combine(Server.MapPath(folderPath), uploadedfile.FileName));
uploadedfile.SaveAs(Server.MapPath("UploadTaskFile/" + TaskData.SubmittedFile + "/") + Path.GetFileName(uploadedfile.FileName));
lblFileName.Text += string.Format("<br />{0}", uploadedfile.FileName);
}
}
}
DC.SubmitChanges();
}
catch (Exception ex)
{
int session = Convert.ToInt32(Session["EmpID"].ToString());
string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath);
string MACAddress = GetMacAddress();
AddErrorLog(ref ex, PageName, "Employee", session, 0, MACAddress);
ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true);
}
}
protected void rptTask_ItemCommand(object source, RepeaterCommandEventArgs e)
{
var DC = new DataClassesDataContext();
if (e.CommandName == "View")
{
Session["TaskID"] = e.CommandArgument;
Response.Redirect("TaskDetail.aspx");
}
else if (e.CommandName == "Delete")
{
tblTask TaskData = DC.tblTasks.Single(ob => ob.TaskID == Convert.ToInt32(e.CommandArgument));
TaskData.IsActive = false;
DC.SubmitChanges();
}
}
public void updateTask()
{
ProjectBL obj = new ProjectBL();
List <tblTask> Ts = obj.GetTask();
tblTask Taskgetbyid = obj.GetTaskbyId(Ts[0].TaskId);
int count = obj.GetTask().Count();
tblTask T = (new tblTask {
TaskId = Ts[0].TaskId, TaskName = "Cooking", TStartDate = DateTime.Now, TEndDate = DateTime.Now, TPriority = 10, TStatus = false, ParentTaskName = "Cleaning", UserId = 1
});
obj.UpdateTask(T);
int count1 = obj.GetTask().Count();
List <tblTask> TS1 = obj.GetTask();
Assert.AreEqual(count1, count);
}
