public void SaveCommentRecords(AdminNewsViewModel model)
{
if (model.Id > 0)
{
News_Comments _skills = _db.News_Comments.Where(x => x.Id == model.Id).FirstOrDefault();
_skills.NewsId = model.NewsId;
_skills.Archived = false;
_skills.UserIDLastModifiedBy = model.CurrentUserId;
_skills.Comments = model.Comments;
_skills.LastModified = DateTime.Now;
_db.SaveChanges();
}
else
{
News_Comments _skills = new News_Comments();
_skills.NewsId = model.NewsId;
_skills.Archived = false;
_skills.UserIDCreatedBy = model.CurrentUserId;
_skills.Comments = model.Comments;
_skills.CreatedDate = DateTime.Now;
_db.News_Comments.Add(_skills);
_db.SaveChanges();
if (model.NotifyEmployeeViaEmail == true)
{
Mail.NewsCommentNotificationSendEmailAsync(model.NewsId, model.Comments);
}
}
}
public ActionResult AddComments(int Id)
{
AdminNewsViewModel model = new AdminNewsViewModel();
model.NewsId = Id;
return(PartialView("_PartialAddNewsCommentViewSet", model));
}
public ActionResult getWorker_CustomerList()
{
AdminNewsViewModel model = new AdminNewsViewModel();
foreach (var item in _employeeMethod.GetAllResourceEmployeeList().Where(x => x.AspNetUserRoles.Count() > 0 ? x.AspNetUserRoles.FirstOrDefault().RoleId != (int)Roles.SuperAdmin ? x.CreatedBy == SessionProxy.UserId : true : x.CreatedBy == SessionProxy.UserId).ToList())
{
if (_RolesManagementMethod.GetLoginUserRoleType(item.Id) != "Manager")
{
model.WorkerList.Add(new SelectListItem()
{
Text = item.FirstName + item.LastName + "-" + item.SSOID, Value = item.Id.ToString()
});
}
}
foreach (var item in _RolesManagementMethod.GetManagersList())
{
model.ManagerList.Add(new SelectListItem()
{
Text = item.FirstName + item.LastName + "-" + item.SSOID, Value = item.Id.ToString()
});
}
foreach (var item in _employeeMethod.GetAllCoustomerEmployeeList().Where(x => x.AspNetUserRoles.Count() > 0 ? x.AspNetUserRoles.FirstOrDefault().RoleId != (int)Roles.SuperAdmin ? x.CreatedBy == SessionProxy.UserId : true : x.CreatedBy == SessionProxy.UserId).ToList())
{
if (_RolesManagementMethod.GetLoginUserRoleType(item.Id) != "Manager")
{
model.CustomerList.Add(new SelectListItem()
{
Text = item.FirstName + item.LastName + "-" + item.SSOID, Value = item.Id.ToString()
});
}
}
return(Json(model, JsonRequestBehavior.AllowGet));
}
public ActionResult SaveCommentsRecvords(AdminNewsViewModel model)
{
model.CurrentUserId = SessionProxy.UserId;
_adminNewsMethod.SaveCommentRecords(model);
return(List());
//List<AdminNewsViewModel> modellist = modelList();
//return PartialView("_partialAdminNewsList", modellist);
}
public void DeleteNewsrecord(int Id, int Users)
{
AdminNewsViewModel model = new AdminNewsViewModel();
News _skills = _db.News.Where(x => x.Id == Id).FirstOrDefault();
_skills.Archived = true;
_skills.LastModifiedDate = DateTime.Now;
_skills.LastModifiedBy = Users;
_db.SaveChanges();
}
// public IList<News> getActiveListbyUserId(string UserId)
// {
// }
public void saveData(AdminNewsViewModel model, int userId)
{
if (model.Id > 0)
{
News news = _db.News.Where(x => x.Id == model.Id).FirstOrDefault();
news.Subject = model.Subject;
news.Description = model.Description;
news.EmployeeAccess = model.EmployeeAccess;
news.ManagerAccess = model.ManagerAccess;
news.CustomerAccess = model.CustomerAccess;
news.CustomerID = model.CustomerID;
news.ManagerID = model.ManagerID;
news.WorkerID = model.WorkerID;
news.SpecificWorker = model.SpecificWorker;
news.SpecificManager = model.SpecificManager;
news.SpecificCustomer = model.SpecificCustomer;
news.NotifyEmployeeViaEmail = model.NotifyEmployeeViaEmail;
news.AllowCustomer = model.AllowCustomer;
news.LastModifiedBy = userId;
news.LastModifiedDate = DateTime.Now;
_db.SaveChanges();
}
else
{
News news = new News();
news.Subject = model.Subject;
news.Description = model.Description;
news.EmployeeAccess = model.EmployeeAccess;
news.ManagerAccess = model.ManagerAccess;
news.CustomerAccess = model.CustomerAccess;
news.NotifyEmployeeViaEmail = model.NotifyEmployeeViaEmail;
news.AllowCustomer = model.AllowCustomer;
news.CustomerID = model.CustomerID;
news.ManagerID = model.ManagerID;
news.WorkerID = model.WorkerID;
news.SpecificWorker = model.SpecificWorker;
news.SpecificManager = model.SpecificManager;
news.SpecificCustomer = model.SpecificCustomer;
news.Archived = false;
news.CreatedBy = userId;
news.CreatedDate = DateTime.Now;
news.LastModifiedBy = userId;
news.LastModifiedDate = DateTime.Now;
_db.News.Add(news);
_db.SaveChanges();
if (news.NotifyEmployeeViaEmail == true)
{
Mail.NewsNotificationSendEmailAsync(model);
}
}
}
public ActionResult EditCommentsRecord(int Id)
{
int Users = SessionProxy.UserId;
AdminNewsViewModel model = new AdminNewsViewModel();
model.Id = Id;
var record = _adminNewsMethod.Editcomments(Id);
foreach (var item in record)
{
model.Id = item.Id;
model.Comments = item.Comments;
model.NewsId = (int)item.NewsId;
}
return(PartialView("_PartialAddNewsCommentViewSet", model));
}
internal static Task NewsCommentNotificationSendEmailAsync(int Id, string Comment)
{
EvolutionEntities _db = new EvolutionEntities();
var data = _db.News.Where(x => x.Id == Id).FirstOrDefault();
AdminNewsViewModel model = new AdminNewsViewModel();
model.EmployeeAccess = data.EmployeeAccess;
model.ManagerAccess = data.ManagerAccess;
model.CustomerAccess = data.CustomerAccess;
model.SpecificWorker = data.SpecificWorker;
model.SpecificManager = data.SpecificManager;
model.SpecificCustomer = data.SpecificCustomer;
model.WorkerID = data.WorkerID;
model.ManagerID = data.ManagerID;
model.CustomerID = data.CustomerID;
model.Description = Comment;
return(NewsCommentNotification(model));
}
private static Task NewsNotification(AdminNewsViewModel model)
{
try
{
EvolutionEntities _db = new EvolutionEntities();
var emaildetails = _db.Email_Setting.ToList();
if (emaildetails.Count > 0)
{
MailMessage msg = new MailMessage();
msg.From = new MailAddress(emaildetails[0].From_Email);
msg.Subject = "There is news for you!";
string EmpEmail = AllEmployeeEmailString();
string MngEmail = AllManagerEmailString();
string CumEmail = AllCustomerEmailString();
if (model.EmployeeAccess == true)
{
foreach (var address in EmpEmail.Split(new[] { "," }, StringSplitOptions.RemoveEmptyEntries))
{
msg.To.Add(address);
}
}
if (model.ManagerAccess == true)
{
foreach (var address in MngEmail.Split(new[] { "," }, StringSplitOptions.RemoveEmptyEntries))
{
msg.To.Add(address);
}
}
if (model.CustomerAccess == true)
{
foreach (var address in CumEmail.Split(new[] { "," }, StringSplitOptions.RemoveEmptyEntries))
{
msg.To.Add(address);
}
}
if (model.SpecificWorker == true)
{
var data = _db.AspNetUsers.Where(x => x.Id == model.WorkerID).FirstOrDefault();
if (data != null)
{
msg.To.Add(data.UserName);
}
}
if (model.SpecificManager == true)
{
var data = _db.AspNetUsers.Where(x => x.Id == model.ManagerID).FirstOrDefault();
if (data != null)
{
msg.To.Add(data.UserName);
}
}
if (model.SpecificCustomer == true)
{
var data = _db.AspNetUsers.Where(x => x.Id == model.CustomerID).FirstOrDefault();
if (data != null)
{
msg.To.Add(data.UserName);
}
}
msg.AlternateViews.Add(AlternateView.CreateAlternateViewFromString(StripHTML(model.Description), null, MediaTypeNames.Text.Html));
SmtpClient smtpClient = new SmtpClient(emaildetails[0].Server, Convert.ToInt32(25));
//System.Net.NetworkCredential credentials = new System.Net.NetworkCredential(ConfigurationManager.AppSettings["mailAccount"], ConfigurationManager.AppSettings["secretPassword"]);
System.Net.NetworkCredential credentials = new System.Net.NetworkCredential(emaildetails[0].From_Email, emaildetails[0].Email_Password);
smtpClient.Credentials = credentials;
msg.IsBodyHtml = true;
msg.Body = StripHTML(model.Description);
smtpClient.EnableSsl = (bool)emaildetails[0].Enable_SSL;
System.Net.ServicePointManager.ServerCertificateValidationCallback = delegate(object s, X509Certificate certificate, X509Chain chain, SslPolicyErrors sslPolicyErrors) { return(true); };
smtpClient.Send(msg);
}
}
catch (Exception ex)
{
return(Task.FromResult(0));
}
return(Task.FromResult(0));
}
internal static Task NewsNotificationSendEmailAsync(AdminNewsViewModel model)
{
return(NewsNotification(model));
}
public ActionResult SaveData(AdminNewsViewModel model)
{
_adminNewsMethod.saveData(model, SessionProxy.UserId);
//List<AdminNewsViewModel> returnModel = modelList();
return(List()); //PartialView("_partialAdminNewsList", returnModel);
}
public List <AdminNewsViewModel> modelList()
{
List <AdminNewsViewModel> model = new List <AdminNewsViewModel>();
int CurrentUser = SessionProxy.UserId;
int SuperAdmin = _RolesManagementMethod.GetSuperAdminId();
var details = _RolesManagementMethod.GetLoginUserRoleType(CurrentUser);
bool Super = false;
if (Convert.ToInt32(CurrentUser) == SuperAdmin)
{
Super = true;
}
var data = _adminNewsMethod.getActiveList();
foreach (var item in data)
{
AdminNewsViewModel m = new AdminNewsViewModel();
m.Super = Super;
m.Id = item.Id;
var detail = _db.AspNetUsers.Where(x => x.Id == item.CreatedBy).FirstOrDefault();
if (detail.SSOID.Contains('W'))
{
m.Emp = true;
}
if (detail.SSOID.Contains('C'))
{
m.Cus = true;
}
if (_RolesManagementMethod.GetLoginUserRoleType(detail.Id) == "Manager")
{
m.Man = true;
}
m.CurrentImage = detail.image;
m.Subject = item.Subject;
m.Description = item.Description;
m.EmployeeAccess = item.EmployeeAccess;
m.ManagerAccess = item.ManagerAccess;
m.CustomerAccess = item.CustomerAccess;
m.SpecificWorker = item.SpecificWorker;
m.WorkerID = item.WorkerID;
m.SpecificCustomer = item.SpecificCustomer;
m.CustomerID = item.CustomerID;
m.SpecificManager = item.SpecificManager;
m.ManagerID = item.ManagerID;
m.NotifyEmployeeViaEmail = item.NotifyEmployeeViaEmail;
m.AllowCustomer = item.AllowCustomer;
var employee = _employeeMethod.getEmployeeById(item.CreatedBy);
m.CreateUserId = item.CreatedBy;
m.CreatedBy = string.Format("{0} {1} - {2}", employee.FirstName, employee.LastName, employee.SSOID);
m.CreatedDate = String.Format("{0:dd-MMM-yyy}", item.CreatedDate);
m.CommentCount = _adminNewsMethod.GetCommentCount(item.Id);
var listComment = _adminNewsMethod.GetCommentList(item.Id);
foreach (var itemComment in listComment)
{
NewCommentViewModel modelComment = new NewCommentViewModel();
if (itemComment.Comments != null)
{
//string noHTML = Regex.Replace(itemComment.Comments, @"<[^>]+>| ", "").Trim();
modelComment.Comments = itemComment.Comments;
}
modelComment.Id = itemComment.Id;
modelComment.UserCreate = itemComment.UserIDCreatedBy;
modelComment.SuperAdmin = SuperAdmin;
var diff = DateTimeSpan.CompareDates((DateTime)itemComment.CreatedDate, DateTime.Now);
if (diff.Years != 0)
{
modelComment.Time = diff.Years + " " + "a year ago";
}
else
{
if (diff.Months != 0)
{
modelComment.Time = diff.Months + " " + "Months ago";
}
else
{
if (diff.Days != 0)
{
modelComment.Time = diff.Days + " " + "Days ago";
}
else
{
if (diff.Hours != 0)
{
modelComment.Time = diff.Hours + " " + "Hours ago";
}
else
{
if (diff.Minutes > 1)
{
modelComment.Time = diff.Minutes + " " + "Minutes ago";
}
else
{
modelComment.Time = diff.Minutes + " " + "Few Minutes ago";
}
}
}
}
}
m.NewCommantsList.Add(modelComment);
}
model.Add(m);
}
return(model.OrderByDescending(x => x.CreatedDate).ToList());
}
public ActionResult AddEditAdminNews(int Id)
{
AdminNewsViewModel model = new AdminNewsViewModel();
int CurrentUser = SessionProxy.UserId;
var SuperAdmin = _RolesManagementMethod.GetSuperAdminId();
foreach (var item in _employeeMethod.GetAllResourceEmployeeList().Where(x => x.AspNetUserRoles.Count() > 0 ? x.AspNetUserRoles.FirstOrDefault().RoleId != (int)Roles.SuperAdmin ? x.CreatedBy == SessionProxy.UserId : true : x.CreatedBy == SessionProxy.UserId).ToList())
{
if (_RolesManagementMethod.GetLoginUserRoleType(item.Id) != "Manager")
{
model.WorkerList.Add(new SelectListItem()
{
Text = item.FirstName + item.LastName + "-" + item.SSOID, Value = item.Id.ToString()
});
}
}
foreach (var item in _RolesManagementMethod.GetManagersList())
{
model.ManagerList.Add(new SelectListItem()
{
Text = item.FirstName + item.LastName + "-" + item.SSOID, Value = item.Id.ToString()
});
}
foreach (var item in _employeeMethod.GetAllCoustomerEmployeeList().Where(x => x.AspNetUserRoles.Count() > 0 ? x.AspNetUserRoles.FirstOrDefault().RoleId != (int)Roles.SuperAdmin ? x.CreatedBy == SessionProxy.UserId : true : x.CreatedBy == SessionProxy.UserId).ToList())
{
if (_RolesManagementMethod.GetLoginUserRoleType(item.Id) != "Manager")
{
model.CustomerList.Add(new SelectListItem()
{
Text = item.FirstName + item.LastName + "-" + item.SSOID, Value = item.Id.ToString()
});
}
}
if (Id > 0)
{
var record = _adminNewsMethod.GetNewsRecordById(Id);
if (record.CreatedBy == CurrentUser || CurrentUser == SuperAdmin)
{
model.Id = record.Id;
model.Subject = record.Subject;
model.Description = record.Description;
model.EmployeeAccess = record.EmployeeAccess;
model.ManagerAccess = record.ManagerAccess;
model.CustomerAccess = record.CustomerAccess;
model.CustomerID = record.CustomerID;
model.ManagerID = record.ManagerID;
model.WorkerID = record.WorkerID;
model.SpecificCustomer = record.SpecificCustomer;
model.SpecificManager = record.SpecificManager;
model.SpecificWorker = record.SpecificWorker;
model.NotifyEmployeeViaEmail = record.NotifyEmployeeViaEmail;
model.AllowCustomer = record.AllowCustomer;
if (record.WorkerID != 0 && record.WorkerID != null)
{
int CmpId = Convert.ToInt32(record.WorkerID);
if (CmpId != 0)
{
var Employee = _db.AspNetUsers.Where(x => x.Id == CmpId && x.Archived == false).FirstOrDefault();
if (Employee != null)
{
model.SpecificWorkerName = Employee.FirstName + " " + Employee.LastName + "-" + Employee.SSOID;
model.WorkerID = record.WorkerID;
}
}
}
if (record.ManagerID != 0 && record.ManagerID != null)
{
int ManId = Convert.ToInt32(record.ManagerID);
if (ManId != 0)
{
var Employee = _db.AspNetUsers.Where(x => x.Id == ManId && x.Archived == false).FirstOrDefault();
if (Employee != null)
{
model.SpecificManagerName = Employee.FirstName + " " + Employee.LastName + " " + Employee.SSOID;
model.ManagerID = record.ManagerID;
}
}
}
if (record.CustomerID != 0 && record.CustomerID != null)
{
int CustId = Convert.ToInt32(record.CustomerID);
if (CustId != 0)
{
var Employee = _db.AspNetUsers.Where(x => x.Id == CustId && x.Archived == false).FirstOrDefault();
if (Employee != null)
{
model.SpecificCustomerName = Employee.FirstName + " " + Employee.LastName + " " + Employee.SSOID;
model.CustomerID = record.CustomerID;
}
}
}
return(PartialView("_partialAddAdminNews", model));
}
else
{
return(Json("Error", JsonRequestBehavior.AllowGet));
}
}
else
{
return(PartialView("_partialAddAdminNews", model));
}
//foreach (var item in _RolesManagementMethod.GetEmployeesList())
//{
// model.WorkerList.Add(new SelectListItem() { Text = item.FirstName + item.LastName + "-" + item.SSOID, Value = item.Id.ToString() });
//}
//foreach (var item in _RolesManagementMethod.GetManagersList())
//{
// model.ManagerList.Add(new SelectListItem() { Text = item.FirstName + item.LastName + "-" + item.SSOID, Value = item.Id.ToString() });
//}
//foreach (var item in _RolesManagementMethod.GetCustomerList())
//{
// model.CustomerList.Add(new SelectListItem() { Text = item.FirstName + item.LastName + "-" + item.SSOID, Value = item.Id.ToString() });
//}
}
