public Task BindTask(Task model, Guid recordId)
{
tsk_tasks task = new tsk_tasks();
task = this.GetTask(recordId);
model.task_name = task.task_name;
model.task_description = task.task_description;
model.task_priority_id = task.task_priority_id.ToString();
model.task_status_id = task.task_status_id.ToString();
model.explanations = task.explanations;
model.is_active = task.is_active.Value;
model.is_task_sent = task.is_task_sent.Value;
if (task.related_project_id != null && GlobalHelper.IsGuidOrEmpty(task.related_project_id.ToString()))
{
model.related_project_id = task.related_project_id.ToString();
}
if (task.assigned_user_id != null && GlobalHelper.IsGuidOrEmpty(task.assigned_user_id.ToString()))
{
model.assigned_user_id = task.assigned_user_id.ToString();
}
if (task.task_user_id != null && GlobalHelper.IsGuidOrEmpty(task.task_user_id.ToString()))
{
model.task_user_id = task.task_user_id.ToString();
}
if (task.end_date != null)
{
model.end_date = task.end_date;
}
else
{
model.end_date = DateTime.MinValue;
}
if (task.start_date != null)
{
model.start_date = task.start_date;
}
else
{
model.start_date = DateTime.MinValue;
}
model.OrderId = task.order_id;
return(model);
}
public Task DeleteTask(Task model, Guid recordId)
{
tsk_tasks task = new tsk_tasks();
task = this.GetTask(recordId);
task.is_deleted = true;
task.is_active = false;
task.deleted_at = DateTime.UtcNow;
task.deleted_by = SessionContext.Current.ActiveUser.UserUid;
this.Kaydet();
return(model);
}
public Task UpdateExplanation(Task model, Guid recordId)
{
tsk_tasks task = new tsk_tasks();
task = this.GetTask(recordId);
DateTime lclDateTime = BaseClasses.BaseFunctions.ToLocalTime(DateTime.UtcNow, BaseDB.SessionContext.Current.ActiveUser.TimeZoneInfoUser.Id);
if (model.new_explanation != null && model.new_explanation.Trim() != "")
{
task.explanations = "~~~~ " + SessionContext.Current.ActiveUser.Name + " " + SessionContext.Current.ActiveUser.Surname + " " + lclDateTime + " ~~~~\n" + model.new_explanation + "\n\r" + task.explanations;
}
this.Kaydet();
GenelRepository gnlDB = RepositoryManager.GetRepository <GenelRepository>();
#region Notification Ekleniyor
string title = Resources.GlobalResource.task_explanation_added;
DateTime localDateTime = BaseClasses.BaseFunctions.ToLocalTime(DateTime.UtcNow, BaseDB.SessionContext.Current.ActiveUser.TimeZoneInfoUser.Id);
string body = string.Format(Resources.GlobalResource.task_explanation_added_body, task.task_name, localDateTime);
gnlDB.AddNotification(recordId, task.assigned_user_id, (int)Enums.NotificationType.Normal, (int)Enums.NotificationModuleType.Task, title, body);
gnlDB.Kaydet();
gnlDB.AddNotification(recordId, task.task_user_id, (int)Enums.NotificationType.Normal, (int)Enums.NotificationModuleType.Task, title, body);
gnlDB.Kaydet();
if (task.assigned_user_id != task.task_user_id)
{
TaskMailSend(task.assigned_user_id, task.order_id.ToString(), task.task_name, task.task_id, "Task Explanation Added", model.new_explanation, "", "2", SessionContext.Current.ActiveUser.Name + " " + SessionContext.Current.ActiveUser.Surname);
TaskMailSend(task.task_user_id, task.order_id.ToString(), task.task_name, task.task_id, "Task Explanation Added", model.new_explanation, "", "2", SessionContext.Current.ActiveUser.Name + " " + SessionContext.Current.ActiveUser.Surname);
}
else
{
TaskMailSend(task.assigned_user_id, task.order_id.ToString(), task.task_name, task.task_id, "Task Explanation Added", model.new_explanation, "", "2", SessionContext.Current.ActiveUser.Name + " " + SessionContext.Current.ActiveUser.Surname);
}
#endregion
return(model);
}
public void AddTaskHistory(tsk_tasks task)
{
tsk_tasks_history task_history = new tsk_tasks_history();
task_history.task_id = task.task_id;
task_history.related_project_id = task.related_project_id;
task_history.assigned_user_id = task.assigned_user_id;
task_history.task_type_id = task.task_type_id;
task_history.task_status_id = task.task_status_id;
task_history.task_priority_id = task.task_priority_id;
task_history.task_name = task.task_name;
task_history.task_description = task.task_description;
task_history.start_date = task.start_date;
task_history.end_date = task.end_date;
task_history.history_by = SessionContext.Current.ActiveUser.UserUid;
task_history.history_at = DateTime.UtcNow;
db.tsk_tasks_history.Add(task_history);
this.Kaydet();
}
public void AddTask(tsk_tasks task, Task model)
{
task.task_id = Guid.NewGuid();
if (GlobalHelper.IsGuidOrEmpty(model.assigned_user_id))
{
task.assigned_user_id = Guid.Parse(model.assigned_user_id);
}
if (GlobalHelper.IsGuidOrEmpty(model.related_project_id))
{
task.related_project_id = Guid.Parse(model.related_project_id);
}
if (GlobalHelper.IsGuidOrEmpty(model.task_user_id))
{
task.task_user_id = Guid.Parse(model.task_user_id);
}
if (model.end_date != null && model.end_date != DateTime.MinValue && model.end_date.ToString() != "")
{
task.end_date = Convert.ToDateTime(model.end_date);
}
if (model.start_date != null && model.start_date != DateTime.MinValue && model.start_date.ToString() != "")
{
task.start_date = Convert.ToDateTime(model.start_date);
}
task.task_name = model.task_name;
task.task_description = model.task_description;
task.task_priority_id = Convert.ToInt32(model.task_priority_id);
task.task_status_id = Convert.ToInt32(model.task_status_id);
task.is_task_sent = false;
task.is_active = model.is_active;
db.tsk_tasks.Add(task);
this.Kaydet();
this.AddTaskHistory(task);
}
public ActionResult Tasks(Task model)
{
Guid recordId = Guid.Empty;
TaskRepository tskDB = RepositoryManager.GetRepository <TaskRepository>();
CrmRepository crmDB = RepositoryManager.GetRepository <CrmRepository>();
GenelRepository gnlDB = RepositoryManager.GetRepository <GenelRepository>();
SessionContext.Current.ActiveUser.MenuId = model.MenuId;
ViewBag.Success = true;
model.activeProjects = crmDB.GetProjectList();
model.activeUsers = gnlDB.GetActiveUsers();
model.taskStatus = tskDB.GetTaskStatusList();
model.taskPriority = tskDB.GetTaskPriorityList();
ModelState.Remove("is_active");
ModelState.Remove("is_task_sent");
if (model.FromDeleteButton == "1")
{
if (GlobalHelper.IsGuid(model.RecordId))
{
tskDB.DeleteTask(model, Guid.Parse(model.RecordId));
return(RedirectToAction("ListPage", "General", new { MenuId = Dcm.Source.GlobalHelper.Encrypt(model.MenuId) }));
}
}
else if (model.FromCreateTaskButton == "1")
{
if (GlobalHelper.IsGuid(model.RecordId))
{
tskDB.UpdateTaskStatus(model, Guid.Parse(model.RecordId), (int)Enums.TaskStatus.Gonderildi, true);
model = tskDB.BindTask(model, Guid.Parse(model.RecordId));
ViewBag.ResultMessage = Resources.GlobalResource.transaction_success;
}
}
else if (model.FromAddExplanationButton == "1")
{
if (GlobalHelper.IsGuid(model.RecordId))
{
tskDB.UpdateExplanation(model, Guid.Parse(model.RecordId));
model = tskDB.BindTask(model, Guid.Parse(model.RecordId));
ViewBag.ResultMessage = Resources.GlobalResource.transaction_success;
}
}
else
{
if (ModelState.IsValid)
{
if (GlobalHelper.IsGuid(model.RecordId))
{
recordId = Guid.Parse(model.RecordId);
try
{
if (model.task_user_id != BaseDB.SessionContext.Current.ActiveUser.UserUid.ToString() && model.assigned_user_id == BaseDB.SessionContext.Current.ActiveUser.UserUid.ToString())
{
tskDB.UpdateTaskStatus(model, Guid.Parse(model.RecordId), Convert.ToInt32(model.task_status_id), model.is_active);
model = tskDB.BindTask(model, Guid.Parse(model.RecordId));
}
else
{
model = tskDB.UpdateTask(model, recordId);
model = tskDB.BindTask(model, Guid.Parse(model.RecordId));
}
ViewBag.ResultMessage = Resources.GlobalResource.transaction_success;
}
catch (Exception exp)
{
ViewBag.Success = false;
ModelState.AddModelError("Error", exp.Message);
}
}
else
{
try
{
tsk_tasks task = new tsk_tasks();
tskDB.AddTask(task, model);
model.RecordId = task.task_id.ToString();
ViewBag.ResultMessage = Resources.GlobalResource.transaction_success;
}
catch (Exception exp)
{
ViewBag.Success = false;
ModelState.AddModelError("Error", exp.Message);
}
}
}
else
{
ViewBag.Success = false;
}
}
return(View(model));
}
public void TaskMailSend(Guid user_id, string order_id, string task_name, Guid task_id, string title, string body, string task_status_name, string type, string user_name_surname = "")
{
#region Mail Gönderiliyor
GenelRepository gnlDB = RepositoryManager.GetRepository <GenelRepository>();
gnl_users userMail = gnlDB.GetUser(user_id);
string nameSurnameMail = "";
if (userMail != null)
{
nameSurnameMail = userMail.name + " " + userMail.surname;
}
DateTime localDateTimeMail = BaseClasses.BaseFunctions.ToLocalTime(DateTime.UtcNow, BaseDB.SessionContext.Current.ActiveUser.TimeZoneInfoUser.Id);
string mailBody = "";
if (type == "1")
{
mailBody = new StreamReader(AppDomain.CurrentDomain.BaseDirectory + @"Templates\TaskStatusChangeTemplate.html").ReadToEnd();
}
else if (type == "2")
{
mailBody = new StreamReader(AppDomain.CurrentDomain.BaseDirectory + @"Templates\TaskNewExplanationTemplate.html").ReadToEnd();
}
else if (type == "99")
{
mailBody = new StreamReader(AppDomain.CurrentDomain.BaseDirectory + @"Templates\TaskExpireEndDate.html").ReadToEnd();
}
if (type == "99")
{
tsk_tasks task = new tsk_tasks();
task = this.GetTask(task_id);
gnl_users taskUser = gnlDB.GetUser(task.task_user_id);
DateTime localDateTimeMailExpireTask = BaseClasses.BaseFunctions.ToLocalTime(task.end_date, BaseDB.SessionContext.Current.ActiveUser.TimeZoneInfoUser.Id);
mailBody = mailBody.Replace("%%task_end_date%%", localDateTimeMailExpireTask.ToString());
mailBody = mailBody.Replace("%%task_user_name_surname%%", taskUser.name + " " + taskUser.surname);
}
mailBody = mailBody.Replace("%%company_name%%", Dcm.Source.GlobalHelper.GetCompanyName());
mailBody = mailBody.Replace("%%ad%%", nameSurnameMail);
mailBody = mailBody.Replace("%%task_no%%", "#" + order_id.PadLeft(5, '0'));
string applicationPath = "";
if (System.Web.HttpContext.Current.Request.ApplicationPath == "/")
{
applicationPath = "http://" + System.Web.HttpContext.Current.Request.ServerVariables["HTTP_HOST"] + "/";
}
else
{
applicationPath = "http://" + System.Web.HttpContext.Current.Request.ServerVariables["HTTP_HOST"] + "/" + System.Web.HttpContext.Current.Request.ApplicationPath + "/";
}
mailBody = mailBody.Replace("%%path_url%%", applicationPath);
mailBody = mailBody.Replace("%%task_name%%", task_name);
mailBody = mailBody.Replace("%%task_date%%", localDateTimeMail.ToString());
mailBody = mailBody.Replace("%%task_status_name%%", task_status_name);
mailBody = mailBody.Replace("%%task_body%%", body);
mailBody = mailBody.Replace("%%user_name_surname%%", user_name_surname);
mailBody = mailBody.Replace("%%task_link%%", applicationPath + "Task/Tasks?RecordId=" + task_id + "&MenuId=" + Dcm.Source.GlobalHelper.Encrypt("149"));
#region mail gönderiliyor
if (BaseClasses.BaseFunctions.getInstance().IsEmailValid(userMail.email.Trim()))
{
BaseClasses.BaseFunctions.getInstance().SendSMTPMail(userMail.email.Trim(), "", title, mailBody, "", null, "", "genel");
}
#endregion
#endregion
}
public Task UpdateTaskStatus(Task model, Guid recordId, int statusId, bool active = true)
{
tsk_tasks task = new tsk_tasks();
task = this.GetTask(recordId);
bool statusChanged = false;
if (statusId != task.task_status_id)
{
statusChanged = true;
}
task.task_status_id = statusId;
task.is_task_sent = true;
task.is_active = active;
task.updated_at = DateTime.UtcNow;
task.updated_by = SessionContext.Current.ActiveUser.UserUid;
this.Kaydet();
if (statusChanged)
{
this.AddTaskHistory(task);
GenelRepository gnlDB = RepositoryManager.GetRepository <GenelRepository>();
#region Notification Ekleniyor
if (statusId == (int)Enums.TaskStatus.Gonderildi)
{
#region Notification Statu Gönderildi
string title = Resources.GlobalResource.new_task_notification;
gnl_users user = gnlDB.GetUser(task.task_user_id);
string nameSurname = "";
if (user != null)
{
nameSurname = user.name + " " + user.surname;
}
DateTime localDateTime = BaseClasses.BaseFunctions.ToLocalTime(DateTime.UtcNow, BaseDB.SessionContext.Current.ActiveUser.TimeZoneInfoUser.Id);
string body = string.Format(Resources.GlobalResource.new_task_notification_body, task.task_name, localDateTime, nameSurname);
gnlDB.AddNotification(recordId, task.assigned_user_id, (int)Enums.NotificationType.Normal, (int)Enums.NotificationModuleType.Task, title, body);
gnlDB.Kaydet();
TaskMailSend(task.assigned_user_id, task.order_id.ToString(), task.task_name, task.task_id, "Task Status Change", "", "Sent", "1");
#endregion
}
else if (Convert.ToInt32(model.task_status_id) == (int)Enums.TaskStatus.Gonderildi)
{
#region Notification Statu Gönderildi
string title = Resources.GlobalResource.new_task_notification;
gnl_users user = gnlDB.GetUser(task.task_user_id);
string nameSurname = "";
if (user != null)
{
nameSurname = user.name + " " + user.surname;
}
DateTime localDateTime = BaseClasses.BaseFunctions.ToLocalTime(DateTime.UtcNow, BaseDB.SessionContext.Current.ActiveUser.TimeZoneInfoUser.Id);
string body = string.Format(Resources.GlobalResource.new_task_notification_body, task.task_name, localDateTime, nameSurname);
gnlDB.AddNotification(recordId, task.assigned_user_id, (int)Enums.NotificationType.Normal, (int)Enums.NotificationModuleType.Task, title, body);
gnlDB.Kaydet();
TaskMailSend(task.assigned_user_id, task.order_id.ToString(), task.task_name, task.task_id, "Task Status Change", "", "Sent", "1");
#endregion
}
else
{
#region Notification Statu Değişikliği
if (Convert.ToInt32(model.task_status_id) == (int)Enums.TaskStatus.Calismaya_Baslandi)
{
string title = Resources.GlobalResource.task_status_notification;
DateTime localDateTime = BaseClasses.BaseFunctions.ToLocalTime(DateTime.UtcNow, BaseDB.SessionContext.Current.ActiveUser.TimeZoneInfoUser.Id);
string body = string.Format(Resources.GlobalResource.task_gonderildi_status_notification_body, task.task_name, Resources.GlobalResource.task_status_calismaya_baslandi, localDateTime);
gnlDB.AddNotification(recordId, task.assigned_user_id, (int)Enums.NotificationType.Normal, (int)Enums.NotificationModuleType.Task, title, body);
gnlDB.Kaydet();
gnlDB.AddNotification(recordId, task.task_user_id, (int)Enums.NotificationType.Normal, (int)Enums.NotificationModuleType.Task, title, body);
gnlDB.Kaydet();
if (task.assigned_user_id != task.task_user_id)
{
TaskMailSend(task.assigned_user_id, task.order_id.ToString(), task.task_name, task.task_id, "Task Status Change", "", "Work Started", "1");
TaskMailSend(task.task_user_id, task.order_id.ToString(), task.task_name, task.task_id, "Task Status Change", "", "Work Started", "1");
}
else
{
TaskMailSend(task.assigned_user_id, task.order_id.ToString(), task.task_name, task.task_id, "Task Status Change", "", "Work Started", "1");
}
}
else if (Convert.ToInt32(model.task_status_id) == (int)Enums.TaskStatus.Tamamlandi)
{
string title = Resources.GlobalResource.task_status_notification;
DateTime localDateTime = BaseClasses.BaseFunctions.ToLocalTime(DateTime.UtcNow, BaseDB.SessionContext.Current.ActiveUser.TimeZoneInfoUser.Id);
string body = string.Format(Resources.GlobalResource.task_gonderildi_status_notification_body, task.task_name, Resources.GlobalResource.task_status_tamamlandi, localDateTime);
task.task_completed_by = SessionContext.Current.ActiveUser.UserUid;
task.task_completed_date = DateTime.UtcNow;
this.Kaydet();
gnlDB.AddNotification(recordId, task.assigned_user_id, (int)Enums.NotificationType.Normal, (int)Enums.NotificationModuleType.Task, title, body);
gnlDB.Kaydet();
gnlDB.AddNotification(recordId, task.task_user_id, (int)Enums.NotificationType.Normal, (int)Enums.NotificationModuleType.Task, title, body);
gnlDB.Kaydet();
if (task.assigned_user_id != task.task_user_id)
{
TaskMailSend(task.assigned_user_id, task.order_id.ToString(), task.task_name, task.task_id, "Task Status Change", "", "Finished", "1");
TaskMailSend(task.task_user_id, task.order_id.ToString(), task.task_name, task.task_id, "Task Status Change", "", "Finished", "1");
}
else
{
TaskMailSend(task.assigned_user_id, task.order_id.ToString(), task.task_name, task.task_id, "Task Status Change", "", "Finished", "1");
}
}
else if (Convert.ToInt32(model.task_status_id) == (int)Enums.TaskStatus.Reddedildi)
{
string title = Resources.GlobalResource.task_status_notification;
DateTime localDateTime = BaseClasses.BaseFunctions.ToLocalTime(DateTime.UtcNow, BaseDB.SessionContext.Current.ActiveUser.TimeZoneInfoUser.Id);
string body = string.Format(Resources.GlobalResource.task_gonderildi_status_notification_body, task.task_name, Resources.GlobalResource.task_status_reddedildi, localDateTime);
gnlDB.AddNotification(recordId, task.assigned_user_id, (int)Enums.NotificationType.Normal, (int)Enums.NotificationModuleType.Task, title, body);
gnlDB.Kaydet();
gnlDB.AddNotification(recordId, task.task_user_id, (int)Enums.NotificationType.Normal, (int)Enums.NotificationModuleType.Task, title, body);
gnlDB.Kaydet();
if (task.assigned_user_id != task.task_user_id)
{
TaskMailSend(task.assigned_user_id, task.order_id.ToString(), task.task_name, task.task_id, "Task Status Change", "", "Rejected", "1");
TaskMailSend(task.task_user_id, task.order_id.ToString(), task.task_name, task.task_id, "Task Status Change", "", "Rejected", "1");
}
else
{
TaskMailSend(task.assigned_user_id, task.order_id.ToString(), task.task_name, task.task_id, "Task Status Change", "", "Rejected", "1");
}
}
#endregion
}
#endregion
}
return(model);
}
public ActionResult Index()
{
Index model = new Models.Index();
SessionContext.Current.ActiveUser.MenuId = "0";
DataSet totalActiveTask = BaseDB.DBManager.AppConnection.GetDataSet("select count(*) kayit_sayisi from tsk_tasks_v where is_active_bit=@is_active_bit ", new ArrayList {
"is_active_bit"
}, new ArrayList {
1
});
DataSet totalActiveFinishedTask = BaseDB.DBManager.AppConnection.GetDataSet("select count(*) kayit_sayisi from tsk_tasks_v where is_active_bit=@is_active_bit and task_status_id=@task_status_id ", new ArrayList {
"is_active_bit", "task_status_id"
}, new ArrayList {
1, 6
});
DataSet totalActiveClosedTask = BaseDB.DBManager.AppConnection.GetDataSet("select count(*) kayit_sayisi from tsk_tasks_v where is_active_bit=@is_active_bit and task_status_id=@task_status_id ", new ArrayList {
"is_active_bit", "task_status_id"
}, new ArrayList {
1, 7
});
DataSet totalActiveProcessedTask = BaseDB.DBManager.AppConnection.GetDataSet("select count(*) kayit_sayisi from tsk_tasks_v where is_active_bit=@is_active_bit and task_status_id in (2,3,4,8) ", new ArrayList {
"is_active_bit"
}, new ArrayList {
1
});
model.totalActiveTask = (totalActiveTask != null && totalActiveTask.Tables[0].Rows.Count > 0) ? totalActiveTask.Tables[0].Rows[0]["kayit_sayisi"].ToString():"0";
model.totalActiveFinishedTask = (totalActiveFinishedTask != null && totalActiveFinishedTask.Tables[0].Rows.Count > 0) ? totalActiveFinishedTask.Tables[0].Rows[0]["kayit_sayisi"].ToString():"0";
model.totalActiveClosedTask = (totalActiveClosedTask != null && totalActiveClosedTask.Tables[0].Rows.Count > 0) ? totalActiveClosedTask.Tables[0].Rows[0]["kayit_sayisi"].ToString():"0";
model.totalActiveProcessedTask = (totalActiveProcessedTask != null && totalActiveProcessedTask.Tables[0].Rows.Count > 0) ? totalActiveProcessedTask.Tables[0].Rows[0]["kayit_sayisi"].ToString() : "0";
DataSet totalActiveTaskMy = BaseDB.DBManager.AppConnection.GetDataSet("select count(*) kayit_sayisi from tsk_tasks_v where is_active_bit=@is_active_bit and assigned_user_id=@assigned_user_id", new ArrayList {
"is_active_bit", "assigned_user_id"
}, new ArrayList {
1, SessionContext.Current.ActiveUser.UserUid
});
DataSet totalActiveFinishedTaskMy = BaseDB.DBManager.AppConnection.GetDataSet("select count(*) kayit_sayisi from tsk_tasks_v where is_active_bit=@is_active_bit and task_status_id=@task_status_id and assigned_user_id=@assigned_user_id", new ArrayList {
"is_active_bit", "task_status_id", "assigned_user_id"
}, new ArrayList {
1, 6, SessionContext.Current.ActiveUser.UserUid
});
DataSet totalActiveClosedTaskMy = BaseDB.DBManager.AppConnection.GetDataSet("select count(*) kayit_sayisi from tsk_tasks_v where is_active_bit=@is_active_bit and task_status_id=@task_status_id and assigned_user_id=@assigned_user_id", new ArrayList {
"is_active_bit", "task_status_id", "assigned_user_id"
}, new ArrayList {
1, 7, SessionContext.Current.ActiveUser.UserUid
});
DataSet totalActiveProcessedTaskMy = BaseDB.DBManager.AppConnection.GetDataSet("select count(*) kayit_sayisi from tsk_tasks_v where is_active_bit=@is_active_bit and task_status_id in (2,3,4,8) and assigned_user_id=@assigned_user_id", new ArrayList {
"is_active_bit", "assigned_user_id"
}, new ArrayList {
1, SessionContext.Current.ActiveUser.UserUid
});
model.totalActiveTaskMy = (totalActiveTaskMy != null && totalActiveTaskMy.Tables[0].Rows.Count > 0) ? totalActiveTaskMy.Tables[0].Rows[0]["kayit_sayisi"].ToString() : "0";
model.totalActiveFinishedTaskMy = (totalActiveFinishedTaskMy != null && totalActiveFinishedTaskMy.Tables[0].Rows.Count > 0) ? totalActiveFinishedTaskMy.Tables[0].Rows[0]["kayit_sayisi"].ToString() : "0";
model.totalActiveClosedTaskMy = (totalActiveClosedTaskMy != null && totalActiveClosedTaskMy.Tables[0].Rows.Count > 0) ? totalActiveClosedTaskMy.Tables[0].Rows[0]["kayit_sayisi"].ToString() : "0";
model.totalActiveProcessedTaskMy = (totalActiveProcessedTaskMy != null && totalActiveProcessedTaskMy.Tables[0].Rows.Count > 0) ? totalActiveProcessedTaskMy.Tables[0].Rows[0]["kayit_sayisi"].ToString() : "0";
#region Görev Bitiş Tarihi Geçmiş Olanların Bildirimleri Oluşturuluyor
try
{
TaskRepository tskDB = RepositoryManager.GetRepository <TaskRepository>();
GenelRepository gnlDB = RepositoryManager.GetRepository <GenelRepository>();
DataSet dsExpireTask = tskDB.SendTaskExpireNotification();
foreach (DataRow row in dsExpireTask.Tables[0].Rows)
{
gnlDB.AddNotification(Guid.Parse(row["task_id"].ToString()), Guid.Parse(row["task_user_id"].ToString()), (int)Enums.NotificationType.Expire, (int)Enums.NotificationModuleType.Task, Resources.GlobalResource.task_expire_end_date_title, Resources.GlobalResource.task_expire_end_date_body);
gnlDB.Kaydet();
gnlDB.AddNotification(Guid.Parse(row["task_id"].ToString()), Guid.Parse(row["assigned_user_id"].ToString()), (int)Enums.NotificationType.Expire, (int)Enums.NotificationModuleType.Task, Resources.GlobalResource.task_expire_end_date_title, Resources.GlobalResource.task_expire_end_date_body);
gnlDB.Kaydet();
tsk_tasks task = new tsk_tasks();
task = tskDB.GetTask(Guid.Parse(row["task_id"].ToString()));
tskDB.TaskMailSend(Guid.Parse(row["task_user_id"].ToString()), task.order_id.ToString(), task.task_name, task.task_id, "Task End Date Expired", "", "", "99");
tskDB.TaskMailSend(Guid.Parse(row["assigned_user_id"].ToString()), task.order_id.ToString(), task.task_name, task.task_id, "Task End Date Expired", "", "", "99");
}
}
catch (Exception exp)
{
}
#endregion
return(View(model));
}
