//Save statistic number of visitors into database
private void CountVisitors()
{
//Count 1 for each time user accessing to website
var listUserAddress = _dbContext.SYS_COUNTER.ToList();
foreach (var item in listUserAddress)
{
if (item.IPAddress.Equals(Request.UserHostAddress) && item.AccessedDate.Date == DateTime.Now.Date)
{
item.AccessedTime += 1;
_dbContext.Entry(item).State = EntityState.Modified;
_dbContext.SaveChanges();
return;
}
if (item.IPAddress.Equals("::1"))
{
item.AccessedTime = 0;
_dbContext.Entry(item).State = EntityState.Modified;
_dbContext.SaveChanges();
}
}
// if ip address and datetime are not existed in database
SYS_COUNTER counter = new SYS_COUNTER()
{
IPAddress = Request.UserHostAddress,
AccessedDate = DateTime.Now,
AccessedTime = 1
};
_dbContext.SYS_COUNTER.Add(counter);
_dbContext.SaveChanges();
}
/// <summary>
/// Update password
/// </summary>
/// <param name="password"></param>
/// <param name="userID"></param>
public void UpdatePassword(string password, int userID)
{
using (var dbContext = new OpacEntities())
{
var account = (from a in dbContext.CIR_PATRON where a.ID == userID select a).FirstOrDefault();
if (account != null)
{
account.Password = password;
dbContext.Entry(account).State = EntityState.Modified;
dbContext.SaveChanges();
}
}
}
/// <summary>
/// Update extend date and count time of extend date
/// </summary>
/// <param name="newDate"></param>
/// <param name="countRenew"></param>
/// <param name="ID"></param>
public void ExtendDate(string newDate, int countRenew, int ID)
{
using (var dbContext = new OpacEntities())
{
var item = (from t in dbContext.CIR_LOAN where t.ID == ID select t).FirstOrDefault();
if (item != null)
{
var tempDateTime = DateTime.ParseExact(newDate, "dd/MM/yyyy",
System.Globalization.CultureInfo.InvariantCulture).ToString("yyyy/MM/dd");
var newDateTime = DateTime.ParseExact(tempDateTime, "yyyy/MM/dd",
System.Globalization.CultureInfo.InvariantCulture);
item.DueDate = newDateTime;
item.RenewCount = (short)countRenew;
dbContext.Entry(item).State = EntityState.Modified;
dbContext.SaveChanges();
}
}
}
/// <summary>
/// Update password via Email
/// </summary>
/// <param name="password"></param>
/// <param name="email"></param>
/// <param name="studentCode"></param>
/// <returns></returns>
public int UpdatePasswordByEmail(string password, string email, string studentCode)
{
using (var dbContext = new OpacEntities())
{
var account = (from a in dbContext.CIR_PATRON
where a.Email.Equals(email) && a.Code.Equals(studentCode)
select a).FirstOrDefault();
if (account != null)
{
account.Password = password;
dbContext.Entry(account).State = EntityState.Modified;
dbContext.SaveChanges();
return(1);
}
}
return(-1);
}
public ActionResult CreateNotification(Notice data)
{
if (data.TypeID == 0 && data.LibID == 0)
{
TempData["ErrorMessage"] = "Vui lòng chọn mục đăng bài và thư viện!";
return(RedirectToAction("CreateNotification"));
}
if (data.TypeID == 0)
{
TempData["ErrorMessage"] = "Vui lòng chọn mục đăng bài!";
return(RedirectToAction("CreateNotification"));
}
if (data.LibID == 0)
{
TempData["ErrorMessage"] = "Vui lòng chọn thư viện!";
return(RedirectToAction("CreateNotification"));
}
if (string.IsNullOrWhiteSpace(data.Title))
{
TempData["ErrorMessage"] = "Vui lòng nhập tiêu đề!";
return(RedirectToAction("CreateNotification"));
}
if (string.IsNullOrWhiteSpace(data.Content))
{
TempData["ErrorMessage"] = "Vui lòng thêm nội dung bài viết!";
return(RedirectToAction("CreateNotification"));
}
var isExisted = _dbContext.NOTICE_STORE.ToList().Any(t => t.TypeID == data.TypeID);
if (isExisted && data.TypeID == 3 || isExisted && data.TypeID == 4 || isExisted && data.TypeID == 5 ||
isExisted && data.TypeID == 6)
{
TempData["ErrorMessage"] = "Mục " + HomeDao.GetTypeNotice(data.TypeID) + " chỉ được đăng 1 bài viết!";
return(RedirectToAction("CreateNotification"));
}
if (ModelState.IsValid)
{
NOTICE_STORE obj = new NOTICE_STORE
{
Title = data.Title,
Content = data.Content,
CreateTime = DateTime.Now,
TypeID = data.TypeID,
LibID = data.LibID
};
_dbContext.NOTICE_STORE.Add(obj);
_dbContext.SaveChanges();
}
TempData["SuccessfulMessage"] = "Đăng bài thành công!!";
return(RedirectToAction("NotificationHome", new { page = 1 }));
}
