/// <summary>
/// Thêm một bài giảng/bài tập/đề thi tin học
/// </summary>
/// <param name="_title"></param>
/// <param name="_type"></param>
/// <param name="_content"></param>
/// <param name="_author"></param>
/// <param name="_posted"></param>
/// <param name="_location"></param>
/// <returns></returns>
public Boolean insertInformatic(string _title, int _type, string _content,
string _author, DateTime _posted, int _leitmotif, string _location, string _tag, string _folderID)
{
LTDHDataContext DB = new LTDHDataContext(@strPathDB);
try
{
using (TransactionScope ts = new TransactionScope())
{
tblInformatic record = new tblInformatic();
record.Title = _title;
record.Type = _type;
record.Contents = _content;
record.Leitmotif = _leitmotif;
record.Author = _author;
record.Posted = _posted;
record.Point = 0;
record.State = CommonConstants.STATE_UNCHECK;
record.Location = _location;
record.Tag = _tag;
record.StickyFlg = false;
record.Score = 0;
record.DeleteFlg = false;
record.FolderID = _folderID;
DB.tblInformatics.InsertOnSubmit(record);
DB.SubmitChanges();
ts.Complete();
ltktDAO.Statistics statisticDAO = new ltktDAO.Statistics();
statisticDAO.add(CommonConstants.SF_NUM_UPLOAD, CommonConstants.CONST_ONE);
log.writeLog(DBHelper.strPathLogFile, record.Author,
BaseServices.createMsgByTemplate(CommonConstants.SQL_INSERT_SUCCESSFUL_TEMPLATE,
_title,
CommonConstants.SQL_TABLE_INFORMATICS));
}
}
catch (Exception e)
{
log.writeLog(DBHelper.strPathLogFile, _author, e.Message
+ CommonConstants.NEWLINE
+ e.Source
+ CommonConstants.NEWLINE
+ e.StackTrace
+ CommonConstants.NEWLINE
+ e.HelpLink);
return false;
}
return true;
}
/// <summary>
/// Thêm một bài giảng/bài tập/đề thi anh văn
/// </summary>
/// <param name="_title"></param>
/// <param name="_type"></param>
/// <param name="_content"></param>
/// <param name="_author"></param>
/// <param name="_posted"></param>
/// <param name="_location"></param>
/// <param name="_tag"></param>
/// <returns></returns>
public Boolean insertEnglish(string _title, int _type, string _content,
string _author, DateTime _posted, int _class, string _location, string _tag, string folderId)
{
LTDHDataContext DB = new LTDHDataContext(@strPathDB);
try
{
using (TransactionScope ts = new TransactionScope())
{
tblEnglish record = new tblEnglish();
record.Title = _title;
record.Type = _type;
record.Contents = _content;
record.Author = _author;
record.Posted = _posted;
record.Class = _class;
record.Location = _location;
record.State = 0;
record.Point = 0;
record.Score = 0;
record.Tag = _tag;
record.StickyFlg = false;
record.Class = _class;
record.FolderID = folderId;
record.DeleteFlg = false;
DB.tblEnglishes.InsertOnSubmit(record);
DB.SubmitChanges();
ts.Complete();
}
ltktDAO.Statistics statisticDAO = new ltktDAO.Statistics();
statisticDAO.add(CommonConstants.SF_NUM_UPLOAD, CommonConstants.CONST_ONE);
}
catch (Exception e)
{
log.writeLog(DBHelper.strPathLogFile, _author, e.Message
+ CommonConstants.NEWLINE
+ e.Source
+ CommonConstants.NEWLINE
+ e.StackTrace
+ CommonConstants.NEWLINE
+ e.HelpLink);
return false;
}
return true;
}
/// <summary>
/// Thêm một đề thi
/// </summary>
/// <param name="_title"></param>
/// <param name="_content"></param>
/// <param name="_author"></param>
/// <param name="_posted"></param>
/// <param name="_isUniversity"></param>
/// <param name="_branch"></param>
/// <param name="_year"></param>
/// <param name="_location"></param>
/// <returns></returns>
public Boolean insertContest(string _title, string _content, string _author,
DateTime _posted, Boolean _isUniversity, string _sub, int _year, string _location,
string _tag, string fileSolved, string _folderID)
{
LTDHDataContext DB = new LTDHDataContext(@strPathDB);
try
{
using (TransactionScope ts = new TransactionScope())
{
tblContestForUniversity record = new tblContestForUniversity();
record.Title = _title;
record.Contents = _content;
record.Author = _author;
record.Posted = _posted;
record.State = CommonConstants.STATE_UNCHECK;//Chưa duyệt
record.isUniversity = _isUniversity;
record.Subject = _sub;
record.Year = _year;
record.Point = 0;//điểm = số người view
record.Location = _location;
record.Tag = _tag;
record.StickyFlg = false;
record.Score = 0;//điểm của checker
record.Solving = fileSolved;
record.FolderID = _folderID;
DB.tblContestForUniversities.InsertOnSubmit(record);
DB.SubmitChanges();
ts.Complete();
ltktDAO.Statistics statisticDAO = new ltktDAO.Statistics();
statisticDAO.add(CommonConstants.SF_NUM_UPLOAD, CommonConstants.CONST_ONE);
log.writeLog(DBHelper.strPathLogFile,
_author,
BaseServices.createMsgByTemplate(CommonConstants.SQL_INSERT_SUCCESSFUL_TEMPLATE,
record.ID.ToString(),
CommonConstants.SQL_TABLE_CONTEST_UNIVERSITY));
}
}
catch (Exception e)
{
log.writeLog(DBHelper.strPathLogFile, _author, e.Message
+ CommonConstants.NEWLINE
+ e.Source
+ CommonConstants.NEWLINE
+ e.StackTrace
+ CommonConstants.NEWLINE
+ e.HelpLink);
return false;
}
return true;
}
