public int Tasks_DeleteDAL(Sls_Task _objTasks)
{
return(ExecuteScalarInt32Sp("CRM_Task_Delete",
ParamBuilder.Par("ID", _objTasks.ID),
ParamBuilder.Par("ModifiedBy", _objTasks.ModifiedBy),
ParamBuilder.Par("ModifiedDate", _objTasks.ModifiedOn)));
}
public ActionResult Task_Create([DataSourceRequest] DataSourceRequest request, Sls_Task _objTasks)
{
if (ModelState.IsValid)
{
Sls_Task objTask = new Sls_Task
{
LeadID = _objTasks.LeadID,
DueDate = _objTasks.DueDate,
OrganizationID = CurrentUser.CompanyID,
Status = 3,
Description = _objTasks.Description,
TaskType = _objTasks.TaskType,
CompletionTime = DateTime.Now,
CreatedBy = CurrentUser.NameIdentifierInt64,
CreatedOn = DateTime.Now,
ModifiedBy = CurrentUser.NameIdentifierInt64,
ModifiedOn = DateTime.Now,
IsDeleted = false,
IsActive = true,
AssignedBy = CurrentUser.NameIdentifierInt64,
AssignedTo = _objTasks.AssignedTo
};
_objTasks.ID = _TaskBAL.Task_CreateBAL(objTask);
if (_objTasks.ID == -1)
{
ModelState.AddModelError(lr.ErrorServerError, lr.ResourceUpdateValidationError);
}
}
var resultData = new[] { _objTasks };
return(Json(resultData.ToDataSourceResult(request, ModelState)));
}
//[DisableValidation]
public ActionResult EditStatusRescheduled(Sls_Task _objTask)
{
_objTask.ModifiedBy = CurrentUser.NameIdentifierInt64;
_objTask.ModifiedOn = DateTime.Now;
var result = this._TaskBAL.ChangeStatus_RescheduleBAL(_objTask);
if (result == -1)
{
ModelState.AddModelError(lr.ErrorServerError, lr.ErrorServerError);
}
else
{
var results = this._TaskBAL.Task_GetBALbyOrganization(CurrentCulture.ToString(), CurrentUser.CompanyID.ToString(), CurrentUser.NameIdentifierInt64, _objTask.ID);
var r = results.First();
Library.TMS.Notifications nof = new Library.TMS.Notifications();
nof.NotificationText = "Your Task has rescheduled to " + _objTask.DueDate.Date;
nof.Organization_ID = CurrentUser.CompanyID;
nof.ToUser = Convert.ToInt64(r.AssignedTo);
nof.FromUser = CurrentUser.NameIdentifierInt64;
nof.ActionUrl = "../Task/Detail?pid=" + _objTask.ID;
nof.Event_ID = 3;
nof.CreatedDate = DateTime.Now;
BALNotification.create_NotificationsBAL(nof);
var notificationHub = GlobalHost.ConnectionManager.GetHubContext <NotificationHub>();
notificationHub.Clients.All.notify("added");
}
var resultData = new[] { _objTask };
return(RedirectToAction("Index"));
}
public int ChangeStatus_UnderwayBAL(Sls_Task _objTask)
{
return(ExecuteScalarInt32Sp("TMS_Task_Update",
ParamBuilder.Par("ID", _objTask.ID),
ParamBuilder.Par("Status", 3),
ParamBuilder.Par("ModifiedBy", _objTask.ModifiedBy),
ParamBuilder.Par("ModifiedOn", _objTask.ModifiedOn)));
}
public int ChangeStatus_RescheduleBAL(Sls_Task _objTask)
{
return(ExecuteScalarInt32Sp("TMS_Task_ReScheduled",
ParamBuilder.Par("ID", _objTask.ID),
ParamBuilder.Par("Status", 2),
ParamBuilder.Par("DueDate", _objTask.DueDate),
ParamBuilder.Par("ModifiedBy", _objTask.ModifiedBy),
ParamBuilder.Par("ModifiedOn", _objTask.ModifiedOn)));
}
public ActionResult EditStatusRescheduled(string ID, string DueDate)
{
Sls_Task objtask = new Sls_Task();
objtask.ID = int.Parse(ID);
DateTime date = DateTime.ParseExact(DueDate, "{0:MM-dd-yyyy}", null);
objtask.DueDate = date;
return(View(objtask));
}
public ActionResult Task_Create([DataSourceRequest] DataSourceRequest request, Sls_Task _objTasks)
{
if (ModelState.IsValid)
{
if (_objTasks.LeadID == null)
{
_objTasks.LeadID = "";
}
if (_objTasks.Description == null)
{
_objTasks.Description = "";
}
Sls_Task objTask = new Sls_Task
{
LeadID = _objTasks.LeadID,
DueDate = _objTasks.DueDate,
OrganizationID = CurrentUser.CompanyID,
Status = 3,
Description = _objTasks.Description,
TaskType = _objTasks.TaskType,
CompletionTime = DateTime.Now,
CreatedBy = CurrentUser.NameIdentifierInt64,
CreatedOn = DateTime.Now,
ModifiedBy = CurrentUser.NameIdentifierInt64,
ModifiedOn = DateTime.Now,
IsDeleted = false,
IsActive = true,
AssignedBy = CurrentUser.NameIdentifierInt64,
AssignedTo = _objTasks.AssignedTo
};
_objTasks.ID = _TaskBAL.Task_CreateBAL(objTask);
Library.TMS.Notifications nof = new Library.TMS.Notifications();
nof.NotificationText = "Your have assigned a New Task";
nof.Organization_ID = CurrentUser.CompanyID;
nof.ToUser = Convert.ToInt64(_objTasks.AssignedTo);
nof.FromUser = CurrentUser.NameIdentifierInt64;
nof.ActionUrl = "../Task/Detail?pid=" + _objTasks.ID;
nof.Event_ID = 3;
nof.CreatedDate = DateTime.Now;
BALNotification.create_NotificationsBAL(nof);
var notificationHub = GlobalHost.ConnectionManager.GetHubContext <NotificationHub>();
notificationHub.Clients.All.notify("added");
if (_objTasks.ID == -1)
{
ModelState.AddModelError(lr.ErrorServerError, lr.ErrorServerError);
}
}
var resultData = new[] { _objTasks };
return(Json(resultData.ToDataSourceResult(request, ModelState)));
}
public ActionResult EditStatusRescheduled(Sls_Task _objTask)
{
_objTask.ModifiedBy = 216;
_objTask.ModifiedOn = DateTime.Now;
var result = this._TaskBAL.ChangeStatus_RescheduleBAL(_objTask);
if (result == -1)
{
ModelState.AddModelError(lr.ErrorServerError, lr.ResourceUpdateValidationError);
}
var resultData = new[] { _objTask };
return(RedirectToAction("Index"));
}
public int Tasks_UpdateDAL(Sls_Task _objTasks)
{
return(ExecuteScalarInt32Sp("CRM_Task_Update",
ParamBuilder.Par("ID", _objTasks.ID),
ParamBuilder.Par("LeadID", _objTasks.LeadID),
ParamBuilder.Par("ModifiedBy", _objTasks.ModifiedBy),
ParamBuilder.Par("TaskType", _objTasks.TaskType),
ParamBuilder.Par("DueDate", _objTasks.DueDate),
ParamBuilder.Par("Description", _objTasks.Description),
ParamBuilder.Par("AssignedBy", _objTasks.AssignedBy),
// ParamBuilder.Par("DueDate", _objTasks.DueDate),
ParamBuilder.Par("AssignedTo", _objTasks.AssignedTo),
ParamBuilder.Par("ModifiedDate", _objTasks.ModifiedOn)));
}
public long Task_CreateDAL(Sls_Task _objTasks)
{
var parameters = new[] { ParamBuilder.Par("ID", 0) };
return(ExecuteInt64withOutPutparameterSp("TMS_Task_Create", parameters,
ParamBuilder.Par("LeadID", _objTasks.LeadID),
ParamBuilder.Par("OrganizationID", _objTasks.OrganizationID),
ParamBuilder.Par("Status", 3),
ParamBuilder.Par("DueDate", _objTasks.DueDate),
ParamBuilder.Par("Description", _objTasks.Description),
ParamBuilder.Par("TaskType", _objTasks.TaskType),
ParamBuilder.Par("CompletionTime", _objTasks.CompletionTime),
ParamBuilder.Par("IsDeleted", _objTasks.IsDeleted),
ParamBuilder.Par("IsActive", _objTasks.IsActive),
ParamBuilder.Par("AssignedBy", _objTasks.AssignedBy),
ParamBuilder.Par("AssignedTo", _objTasks.AssignedTo),
ParamBuilder.Par("CreatedBy", _objTasks.CreatedBy),
ParamBuilder.Par("CreatedOn", _objTasks.CreatedOn),
ParamBuilder.Par("ModifiedBy", _objTasks.ModifiedBy),
ParamBuilder.Par("ModifiedOn", _objTasks.ModifiedOn)));
}
public int ChangeStatus_DoneBAL(Sls_Task _objTask)
{
return(_DAL.ChangeStatus_DoneBAL(_objTask));
}
public int ChangeStatus_UnderwayBAL(Sls_Task _objTask)
{
return(_DAL.ChangeStatus_UnderwayBAL(_objTask));
}
public int ChangeStatus_RescheduleBAL(Sls_Task _objTask)
{
return(_DAL.ChangeStatus_RescheduleBAL(_objTask));
}
public long Task_CreateBAL(Sls_Task _objTasks)
{
return(_DAL.Task_CreateDAL(_objTasks));
}
public JsonResult EditStatusUnderway([DataSourceRequest] DataSourceRequest request, Sls_Task _objTask, string ID)
{
long _viewID = long.Parse(ID);
_objTask.ModifiedBy = 216;
_objTask.ModifiedOn = DateTime.Now;
var result = this._TaskBAL.ChangeStatus_UnderwayBAL(_objTask);
if (result == -1)
{
ModelState.AddModelError(lr.ErrorServerError, lr.ResourceUpdateValidationError);
}
var resultData = new[] { _objTask };
return(Json(resultData, JsonRequestBehavior.AllowGet));
}
public int Tasks_UpdateBAL(Sls_Task _objTasks)
{
return(_DAL.Tasks_UpdateDAL(_objTasks));
}
public ActionResult Sls_Tasks_Destroy([DataSourceRequest] DataSourceRequest request, Sls_Task _objTasks)
{
if (ModelState.IsValid)
{
_objTasks.ModifiedBy = CurrentUser.NameIdentifierInt64;
_objTasks.ModifiedOn = DateTime.Now;
_objTasks.ID = _TaskBAL.Tasks_DeleteBAL(_objTasks);
if (_objTasks.ID == -1)
{
ModelState.AddModelError(lr.ErrorServerError, lr.ErrorServerError);
}
}
var resultData = new[] { _objTasks };
return(Json(resultData.ToDataSourceResult(request, ModelState)));
}
