public bool CreateNews(NewsModels news, SysUserModels userSession)
{
if (news.newsImageFile != null && !StringUtils.IsEmpty(news.newsImageFile.FileName))
{
news.newsImageName = news.newsImageFile.FileName;
news.newsImage = new byte[news.newsImageFile.InputStream.Length];
long bytesRead = news.newsImageFile.InputStream.Read(news.newsImage, 0, (int)news.newsImageFile.InputStream.Length);
news.newsImageFile.InputStream.Close();
}
news.newsCode = Utils.UtilsDAO.GenerateCode(Constants.CodePrefix.NewNews);
news.postedBy = userSession.userCode;
news.createdBy = userSession.userCode;
news.updatedBy = userSession.userCode;
news.newsStatus = Constants.Status.Active;
news.newsType = Constants.Type.Public;
news.newsContent = HttpUtility.HtmlDecode(news.newsContent);
news.localeID = Constants.Language.Vietnamese;
mapper.Insert("New.insertNews", news);
// insert other languages
NewsModels enNews = TranslateUtils.TranslateNews(news, Constants.Language.English);
mapper.Insert("New.insertNews", enNews);
NewsModels ruNews = TranslateUtils.TranslateNews(news, Constants.Language.Russian);
mapper.Insert("New.insertNews", ruNews);
NewsModels chNews = TranslateUtils.TranslateNews(news, Constants.Language.Chinese);
mapper.Insert("New.insertNews", chNews);
return true;
}
public bool AdminUserLogin(SysUserLoginModels loginUser, out SysUserModels user)
{
user = mapper.QueryForObject<SysUserModels>("Sys.getUser", loginUser.userCode);
if (user == null || !MD5Utils.VerifyMd5Hash(loginUser.password, user.userPassword) || !user.userType.Equals(Constants.Type.Admin))
{
loginUser.errorMessage = Resource.MsgLoginFailed;
return false;
}
return true;
}
public void updateNews(NewsModels news, SysUserModels userSession)
{
if (news.newsImageFile != null && !StringUtils.IsEmpty(news.newsImageFile.FileName))
{
news.newsImageName = news.newsImageFile.FileName;
news.newsImage = new byte[news.newsImageFile.InputStream.Length];
long bytesRead = news.newsImageFile.InputStream.Read(news.newsImage, 0, (int)news.newsImageFile.InputStream.Length);
news.newsImageFile.InputStream.Close();
}
news.postedBy = userSession.userCode;
news.createdBy = userSession.userCode;
news.updatedBy = userSession.userCode;
news.newsStatus = Constants.Status.Active;
news.newsType = Constants.Type.Public;
news.newsContent = HttpUtility.HtmlDecode(news.newsContent);
news.localeID = Constants.Language.Vietnamese;
mapper.Update("New.updateNews", news);
NewsModels oldNews = this.getNews(news.newsCode, Constants.Language.Vietnamese);
// update other languages
if (news.newsImageFile == null || StringUtils.IsEmpty(news.newsImageFile.FileName))
{
news.newsImageName = oldNews.newsImageName;
news.newsImage = oldNews.newsImage;
}
news.postedDate = oldNews.postedDate;
NewsModels enNews = TranslateUtils.TranslateNews(news, Constants.Language.English);
if (this.getNews(enNews.newsCode, Constants.Language.English) != null)
{
mapper.Update("New.updateNews", enNews);
}
else
{
mapper.Insert("New.insertNews", enNews);
}
NewsModels ruNews = TranslateUtils.TranslateNews(news, Constants.Language.Russian);
if (this.getNews(ruNews.newsCode, Constants.Language.Russian) != null)
{
mapper.Update("New.updateNews", ruNews);
}
else
{
mapper.Insert("New.insertNews", ruNews);
}
NewsModels chNews = TranslateUtils.TranslateNews(news, Constants.Language.Chinese);
if (this.getNews(chNews.newsCode, Constants.Language.Chinese) != null)
{
mapper.Update("New.updateNews", chNews);
}
else
{
mapper.Insert("New.insertNews", chNews);
}
}
public SysUserProfileModels GetUserProfile(SysUserModels user)
{
SysUserProfileModels result = new SysUserProfileModels();
result.birthDateList = DateUtils.genDateList();
result.birthMonthList = DateUtils.genMonthList();
result.birthYearList = DateUtils.genYearList();
if (user.birthday.Day < 10)
{
result.birthDate = "0" + user.birthday.Date.Day.ToString();
}
else
{
result.birthDate = user.birthday.Date.Day.ToString();
}
if (user.birthday.Month < 10)
{
result.birthMonth = "0" + user.birthday.Date.Month.ToString();
}
else
{
result.birthMonth = user.birthday.Date.Month.ToString();
}
result.birthYear = user.birthday.Year.ToString();
result.emailAddress = user.emailAddress;
result.fullName = user.fullName;
result.phoneNo = user.phoneNo;
result.sex = user.sex;
result.userCode = user.userCode;
return result;
}
public bool NormalUserLogin(SysUserLoginModels loginUser, out SysUserModels user)
{
user = mapper.QueryForObject<SysUserModels>("Sys.getUser", loginUser.userCode);
if (user == null || !MD5Utils.VerifyMd5Hash(loginUser.password, user.userPassword) || !user.userType.Equals(Constants.Type.NO))
{
return false;
}
return true;
}
private void SaveMoney(IdxIndexModels index, SysUserModels userSession)
{
// Check exist index
IDictionary<string, object> param = new Dictionary<string, object>();
string timeFormat = Resource.DateFormat;
string displayTimeFormat = Resource.DateFormat;
Int32 precision = Int32.Parse(Resource.Precision);
MstIndexTypeDAO indexTypeDAO = new MstIndexTypeDAO(this.mapper);
MstIndexTypeModels indexTypeModel = indexTypeDAO.GetIndexType(index.indexTypeCode);
if (indexTypeModel != null)
{
displayTimeFormat = indexTypeModel.displayTimeFormat;
timeFormat = indexTypeModel.typeTimeFormat;
precision = indexTypeModel.precisionField;
// Check exist index
param.Add("indexCode", index.indexCode);
param.Add("term", index.term);
param.Add("indexTypeCode", index.indexTypeCode);
param.Add("seqNo", index.seqNo);
param.Add("indexTime", index.indexTime);
param.Add("displayTimeFormat", Int32.Parse(displayTimeFormat));
Hashtable obj = (Hashtable)mapper.QueryForObject("Idx.selectIndex", param);
index.updatedBy = userSession.userCode;
index.createdBy = userSession.userCode;
index.indexStatus = Constants.Status.Active;
// If not exist -> Insert
if (obj == null)
{
mapper.Insert("Idx.insertIndex", index);
}
else // If exist -> Update
{
param.Add("indexMoney", index.indexMoney);
param.Add("updatedBy", index.updatedBy);
mapper.Update("Idx.updateIndex", param);
}
}
else
{
mapper.Insert("Idx.insertIndex", index);
}
}
public void ReadMoneyFile(MoneyFileUploadModels moneyFileUpload, SysUserModels userSession, string uploadFolder)
{
try
{
if (moneyFileUpload.moneyFile != null)
{
//...
IExcelDataReader excelReader = null;
if (moneyFileUpload.moneyFile.ContentType.Contains("ms-excel"))
{
//1. Reading from a binary Excel file ('97-2003 format; *.xls)
excelReader = ExcelReaderFactory.CreateBinaryReader(moneyFileUpload.moneyFile.InputStream);
}
else
{
//2. Reading from a OpenXml Excel file (2007 format; *.xlsx)
excelReader = ExcelReaderFactory.CreateOpenXmlReader(moneyFileUpload.moneyFile.InputStream);
}
//...
//4. DataSet - Create column names from first row
excelReader.IsFirstRowAsColumnNames = true;
DataSet result = excelReader.AsDataSet();
DataTable dtData = result.Tables[0];
// Old
ExcelIndexReaderUtils excelUtils = new ExcelIndexReaderUtils();
if (StringUtils.IsEmpty(moneyFileUpload.moneyFile.FileName))
{
moneyFileUpload.errorMessage = Resource.MsgErrEmptyFile;
return;
}
string errorMsg = string.Empty;
IList<IdxIndexModels> indexList = excelUtils.GetMoneyFromExcel(dtData, this.mapper, out errorMsg);
if (!StringUtils.IsEmpty(errorMsg))
{
moneyFileUpload.errorMessage = errorMsg;
}
if (indexList != null)
{
// Save to db
for (int i = 0; i < indexList.Count; i++)
{
IdxIndexModels index = indexList[i];
try
{
this.SaveMoney(index, userSession);
}
catch (Exception e)
{
Console.WriteLine(e.StackTrace);
moneyFileUpload.errorMessage = e.Message;
break;
}
}
}
//6. Free resources (IExcelDataReader is IDisposable)
excelReader.Close();
}
if (StringUtils.IsEmpty(moneyFileUpload.errorMessage))
{
moneyFileUpload.infoMessage = Resource.MsgSuccess;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
//indexFileUpload.errorMessage = Resource.MsgErrUploadExcelFile;
moneyFileUpload.errorMessage = ex.StackTrace;
}
}
private void persistUser(SysUserModels user, bool rememberMe)
{
// Create ticket
FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(
1,
"user",
DateTime.Now,
DateTime.Now.AddMinutes(3),
rememberMe,
user.userCode,
FormsAuthentication.FormsCookiePath);
// Create encrypted cookie
string hash = FormsAuthentication.Encrypt(ticket);
HttpCookie cookie = new HttpCookie(FormsAuthentication.FormsCookieName, hash);
if (ticket.IsPersistent)
{
cookie.Expires = ticket.Expiration;
}
// Set and done
Response.Cookies.Add(cookie); //Necessary, otherwise UserData property gets lost
}