/// <summary>
/// Assign Question
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public Message AssignQuestion(List<LOT_ExamQuestion_Section_ListeningTopic> list)
{
Message msg = null;
try
{
if (list.Count > 0)
{
int totalID = list.Count;
dbContext.LOT_ExamQuestion_Section_ListeningTopics.InsertAllOnSubmit(list);
dbContext.SubmitChanges();
// Show succes message
msg = new Message(MessageConstants.I0001, MessageType.Info, totalID.ToString() + " Question(s)", "assigned");
}
else
{
// Show system error
msg = new Message(MessageConstants.E0033, MessageType.Error, "Please select listening question(s) to assign!");
}
}
catch (Exception)
{
// Show system error
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
public Message Insert(LOT_Candidate_Exam_Result objUI)
{
Message msg = null;
try
{
if (!IsDublicateCandidateMark(objUI))
{
objUI.CreateDate = System.DateTime.Now;
objUI.UpdateDate = System.DateTime.Now;
dbContext.LOT_Candidate_Exam_Results.InsertOnSubmit(objUI);
dbContext.SubmitChanges();
msg = new Message(MessageConstants.I0001, MessageType.Info, new CandidateExamDao().GetCandidateName(objUI.LOT_Candidate_Exam) + "'s " + objUI.LOT_Section.SectionName + " mark in " + objUI.LOT_Candidate_Exam.LOT_Exam.Title + " exam", "added");
}
else
{
msg = new Message(MessageConstants.E0020, MessageType.Error, new CandidateExamDao().GetCandidateName(objUI.LOT_Candidate_Exam) + "'s " + objUI.LOT_Section.SectionName + " mark", objUI.LOT_Candidate_Exam.LOT_Exam.Title + " exam");
}
}
catch (Exception)
{
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
public Message Delete(string[] idArr)
{
Message msg = null;
DbTransaction trans = null;
try
{
dbContext.Connection.Open();
trans = dbContext.Connection.BeginTransaction();
dbContext.Transaction = trans;
foreach (string id in idArr)
Delete(ConvertUtil.ConvertToInt(id));
if (idArr.Length > 1)
msg = new Message(MessageConstants.I0011, MessageType.Info,
idArr.Length + " materials have been deleted");
else
msg = new Message(MessageConstants.I0011, MessageType.Info,
idArr.Length + " material has been deleted");
trans.Commit();
}
catch
{
trans.Rollback();
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
public Message Delete(int menuID)
{
Message msg = null;
//DbTransaction trans = null;
try
{
//dbContext.Connection.Open();
//trans = dbContext.Connection.BeginTransaction();
//dbContext.Transaction = trans;
Menu menu = GetByID(menuID, null);
if (menu == null)
msg = new Message(MessageConstants.E0005, MessageType.Error, "Selected menu", "database");
else
{
List<Menu> childList = GetChild(menuID);
foreach (var child in childList)
child.ParentId = null;
menu.DeleteFlag = true;
msg = new Message(MessageConstants.I0001, MessageType.Info, "Menu \"" + menu.Name + "\" ", "deleted");
dbContext.SubmitChanges();
}
}
catch
{
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
public Message Delete(int userAdminID)
{
DbTransaction transaction = null;
Message msg = null;
try
{
dbContext.Connection.Open();
transaction = dbContext.Connection.BeginTransaction();
dbContext.Transaction = transaction;
List<UserConfig> userConfigs = GetListUserConfig(userAdminID);
if (userConfigs != null)
{
dbContext.UserConfigs.DeleteAllOnSubmit(userConfigs);
dbContext.SubmitChanges();
}
transaction.Commit();
msg = new Message(MessageConstants.I0001, MessageType.Info, "", "updated");
}
catch (Exception exception)
{
if (transaction != null) transaction.Rollback();
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
public Message ApproveAttendee(Training_Attendee objUI)
{
Message msg = null;
try
{
if (objUI != null)
{
// Get current group in dbContext
Training_Attendee objDb = GetAttendeeByClassId(objUI.ClassId);
if (objDb != null)
{
// Update info by objUI
objDb.StatusId = Constants.TRAINING_REGISTRATION_STATUS_APPROVED;
objDb.UpdateDate = DateTime.Now;
objDb.UpdatedBy = objUI.UpdatedBy;
// Submit changes to dbContext
dbContext.SubmitChanges();
// Show success message
msg = new Message(MessageConstants.I0001, MessageType.Info, "Attendee '" + objDb.ClassId + "'", "approved");
}
}
}
catch
{
// Show system error
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
public Message EngClassRegister(Training_Attendee objUI)
{
Message msg = null;
try
{
if (!isDublicateEmpId(objUI))
{
objUI.CreateDate = DateTime.Now;
objUI.UpdateDate = DateTime.Now;
objUI.DeleteFlag = false;
objUI.StatusId = Constants.TRAINING_REGISTRATION_STATUS_NEW;
objUI.SubmittingDate = DateTime.Now;
dbContext.Training_Attendees.InsertOnSubmit(objUI);
dbContext.SubmitChanges();
// Show success message
msg = new Message(MessageConstants.I0001, MessageType.Info, "Registration for this class ", "added");
}
else
{
msg = new Message(MessageConstants.E0020, MessageType.Error, "Your name is ", "in this class");
}
}
catch (Exception ex)
{
msg = new Message(MessageConstants.E0007, MessageType.Error);
throw ex;
}
return msg;
}
public Message AssignPermission(int groupId, List<GroupPermission> groupList)
{
Message msg = null;
DbTransaction trans = null;
try
{
dbContext.Connection.Open();
trans = dbContext.Connection.BeginTransaction();
dbContext.Transaction = trans;
List<GroupPermission> deleteGroup = dbContext.GroupPermissions.Where(c => c.GroupId == groupId)
.ToList<GroupPermission>();
dbContext.GroupPermissions.DeleteAllOnSubmit(deleteGroup);
dbContext.SubmitChanges();
foreach (GroupPermission item in groupList)
{
dbContext.GroupPermissions.InsertOnSubmit(item);
// Submit changes to dbContext
dbContext.SubmitChanges();
}
// Show succes message
msg = new Message(MessageConstants.I0001, MessageType.Info, groupList.Count.ToString() + " permision(s)", "assigned");
trans.Commit();
}
catch (Exception )
{
if (trans != null) trans.Rollback();
// Show system error
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
public Message DeleteDueDate(string id)
{
Message msg = null;
DbTransaction transaction = null;
try
{
dbContext.Connection.Open();
transaction = dbContext.Connection.BeginTransaction();
dbContext.Transaction = transaction;
if (!string.IsNullOrEmpty(id))
{
id = id.TrimEnd(',');
string[] ids = id.Split(',').Distinct().ToArray();
foreach (var s in ids)
{
var dueDate = GetDueDateById(s);
if (dueDate != null)
{
dbContext.SR_DueDates.DeleteOnSubmit(dueDate);
dbContext.SubmitChanges();
}
}
msg = new Message(MessageConstants.I0011, MessageType.Info, "DueDate had been deleted successful");
transaction.Commit();
}
}
catch (Exception exception)
{
if (transaction != null) transaction.Rollback();
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
public Message DeleteList(string ids, string stUpdatedBy)
{
Message msg = null;
DbTransaction trans = null;
bool canDelete = true;
try
{
dbContext.Connection.Open();
trans = dbContext.Connection.BeginTransaction();
dbContext.Transaction = trans;
if (!string.IsNullOrEmpty(ids))
{
ids = ids.TrimEnd(',');
int groupID = 0;
string[] idArr = ids.Split(',');
int total = idArr.Count();
foreach (string id in idArr)
{
bool isValid = Int32.TryParse(id, out groupID);
Group group = GetById(groupID);
if (group != null)
{
if (group.User_Groups.Count > 0)
{
canDelete = false;
// Show succes message
msg = new Message(MessageConstants.E0006, MessageType.Error, "delete group '" + group.GroupName + "'", "this group");
break;
}
group.UpdatedBy = stUpdatedBy;
Delete(group);
}
else
{
total--;
}
}
if (canDelete)
{
// Show succes message
msg = new Message(MessageConstants.I0001, MessageType.Info, total.ToString() + " group(s)", "deleted");
trans.Commit();
}
else
{
trans.Rollback();
}
}
}
catch (Exception)
{
if (trans != null) trans.Rollback();
// Show system error
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
public Message DeleteList(string ids, string userName)
{
Message msg = null;
DbTransaction trans = null;
try
{
dbContext.Connection.Open();
trans = dbContext.Connection.BeginTransaction();
dbContext.Transaction = trans;
bool isFalse = true;
if (!string.IsNullOrEmpty(ids))
{
ids = ids.TrimEnd(',');
string[] idArr = ids.Split(',');
int total = idArr.Count();
foreach (string id in idArr)
{
string empID = id;
Training_CertificationMaster trainingCer = GetById(empID);
Employee_Certification obj = dbContext.Employee_Certifications.Where(q => q.CertificationId.Equals(ConvertUtil.ConvertToInt(empID))).FirstOrDefault();
Training_NonEmpCertification non = dbContext.Training_NonEmpCertifications.Where(p => p.TypeId.Equals(ConvertUtil.ConvertToInt(empID))).FirstOrDefault();
if (obj == null && non == null)
{
trainingCer.UpdatedBy = userName;
Delete(trainingCer);
}
else
{
isFalse = false;
break;
}
}
if (isFalse)
{
// Show succes message
msg = new Message(MessageConstants.I0001, MessageType.Info, total.ToString() + " Certification(s)", "deleted");
}
else
{
msg = new Message(MessageConstants.E0006, MessageType.Error, "delete ", "this certification");
//msg = new Message(MessageConstants.E0051, MessageType.Error);
}
trans.Commit();
}
}
catch
{
if (trans != null) trans.Rollback();
// Show system error
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
/// <summary>
/// Delete a list of job title
/// </summary>
/// <param name="ids"></param>
/// <returns></returns>
public Message DeleteList(string ids)
{
Message msg = null;
DbTransaction trans = null;
bool isOK = true;
try
{
//begin transaction
dbContext.Connection.Open();
trans = dbContext.Connection.BeginTransaction();
dbContext.Transaction = trans;
if (!string.IsNullOrEmpty(ids))
{
//split ids by char ','
ids = ids.TrimEnd(':');
string[] idArr = ids.Split(':');
int totalID = idArr.Count();
//loop each id to delete
foreach (string sID in idArr)
{
string[] array = sID.Split(',');
int role = int.Parse(array[0]);
int resolution = int.Parse(array[1]);
bool hold = bool.Parse(array[2]);
msg = Delete(resolution, role, hold);
if (msg.MsgType == MessageType.Error)
{
isOK = false;
break;
}
}
if (isOK)
{
// Show succes message
msg = new Message(MessageConstants.I0001, MessageType.Info, totalID.ToString() + " role-resolution(s)", "deleted");
trans.Commit();
}
else
{
trans.Rollback();
}
}
}
catch
{
if (trans != null) { trans.Rollback(); }
// Show system error
msg = new Message(MessageConstants.E0006, MessageType.Error, "delete", "it");
}
return msg;
}
public Message DeleteList(string ids, string stUpdatedBy)
{
Message msg = null;
DbTransaction trans = null;
bool canDelete = true;
try
{
dbContext.Connection.Open();
trans = dbContext.Connection.BeginTransaction();
dbContext.Transaction = trans;
if (!string.IsNullOrEmpty(ids))
{
ids = ids.TrimEnd(',');
string[] idArr = ids.Split(',');
int totalId = idArr.Count();
foreach (string id in idArr)
{
Candidate candidateObj = GetById(id);
if (candidateObj != null)
{
candidateObj.UpdatedBy = stUpdatedBy;
candidateObj.DeleteFlag = true;
candidateObj.UpdateDate = DateTime.Now;
candidateObj.UpdatedBy = candidateObj.UpdatedBy;
new CandidateLogDao().WriteLogForCandidate(null, candidateObj, ELogAction.Delete);
dbContext.SubmitChanges();
}
else
{
totalId--;
}
}
if (canDelete)
{
// Show succes message
msg = new Message(MessageConstants.I0001, MessageType.Info, totalId.ToString()+ " candidate(s)", "deleted");
trans.Commit();
}
else
{
trans.Rollback();
}
}
}
catch (Exception)
{
if (trans != null) trans.Rollback();
// Show system error
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
/// <summary>
/// Delete List
/// </summary>
/// <param name="ids"></param>
/// <param name="userName"></param>
/// <returns></returns>
public Message DeleteList(string ids, string userName)
{
Message msg = null;
DbTransaction trans = null;
try
{
dbContext.Connection.Open();
trans = dbContext.Connection.BeginTransaction();
dbContext.Transaction = trans;
if (!string.IsNullOrEmpty(ids))
{
ids = ids.TrimEnd(',');
string[] idArr = ids.Split(',').Distinct().ToArray();
int total = idArr.Count();
foreach (string id in idArr)
{
Training_Class objClass = GetById(ConvertUtil.ConvertToInt(id));
if (objClass != null)
{
//Check item is closed then rollback and show message
if (objClass.RegStatusId == Constants.TRAINING_CENTER_COURSE_STATUS_CLOSED)
{
if (trans != null) trans.Rollback();
msg = new Message(MessageConstants.E0050, MessageType.Error, total.ToString() + " class(es)", "");
return msg;
}
objClass.UpdatedBy = userName;
Delete(objClass);
}
else
{
total--;
}
}
// Show succes message
msg = new Message(MessageConstants.I0011, MessageType.Info, (total >1 ? total + " classes have":total + " class has") + " been deleted" );
trans.Commit();
}
}
catch
{
if (trans != null) trans.Rollback();
// Show system error
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
public Message InsertList(List<SR_Comment> comment)
{
Message msg = null;
try
{
dbContext.SR_Comments.InsertAllOnSubmit(comment);
dbContext.SubmitChanges();
msg = new Message(MessageConstants.I0001, MessageType.Info, "Comments", "added");
}
catch
{
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
/// <summary>
/// Here is update object follow by MVC, so do not pass the param into function
/// </summary>
/// <returns>Message</returns>
public Message Update()
{
Message msg = null;
try
{
dbContext.SubmitChanges();
// Show success message
msg = new Message(MessageConstants.I0001, MessageType.Info, "Candidate Topic", "updated");
}
catch (Exception ex)
{
msg = new Message(MessageConstants.E0007, MessageType.Error);
throw ex;
}
return msg;
}
/// <summary>
/// Insert a Comprehension Paragraph with its questions
/// </summary>
/// <param name="paragraph"></param>
/// <param name="questionIDs"></param>
/// <returns></returns>
public Message Insert(LOT_ComprehensionParagraph paragraph, string[] questionIDs)
{
Message msg = null;
DbTransaction trans = null;
try
{
dbContext.Connection.Open();
trans = dbContext.Connection.BeginTransaction();
dbContext.Transaction = trans;
//Insert new paragraph and get its ID
paragraph.CreateDate = DateTime.Now;
paragraph.UpdateDate = DateTime.Now;
dbContext.LOT_ComprehensionParagraphs.InsertOnSubmit(paragraph);
dbContext.SubmitChanges();
int paragraphIDInserted = paragraph.ID;
if (questionIDs != null)
{
foreach (string questionID in questionIDs)
{
//Get question from db
LOT_Question questionDB = dbContext.LOT_Questions.Single(p => p.DeleteFlag == false &&
p.ID == int.Parse(questionID));
questionDB.ParagraphID = paragraphIDInserted;
questionDB.UpdateDate = DateTime.Now;
questionDB.UpdatedBy = paragraph.UpdatedBy;
//Submit changes to db
dbContext.SubmitChanges();
}
}
msg = new Message(MessageConstants.I0001, MessageType.Info, "Comprehension paragraph \"" +
CommonFunc.SubStringRoundWord(CommonFunc.RemoveAllHtmlWithNoTagsAllowed(paragraph.ParagraphContent),
Constants.QUESTION_CONTENT_LENGTH_SHOWED_IN_MESSAGE) + "\"", "added");
trans.Commit();
}
catch
{
if (trans != null)
{
trans.Rollback();
}
// Show system error
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
/// <summary>
/// tan.tran 2011.05.25
/// </summary>
/// <param name="month"></param>
/// <returns></returns>
public Message DeleteList(int month)
{
Message msg = null;
DbTransaction trans = null;
long number = 0;
try
{
dbContext.Connection.Open();
trans = dbContext.Connection.BeginTransaction();
dbContext.Transaction = trans;
List<MasterLog> listMaster = dbContext.MasterLogs.Where(p => p.LogDate.AddMonths(month) <= DateTime.Now).ToList<MasterLog>();
foreach (MasterLog mas in listMaster)
{
List<LogDetail> listDetail = dbContext.LogDetails.Where(p => p.MasterLog.LogId == mas.LogId).ToList<LogDetail>();
foreach (LogDetail det in listDetail)
{
dbContext.LogDetails.DeleteOnSubmit(det);
number++;
}
dbContext.MasterLogs.DeleteOnSubmit(mas);
number++;
}
dbContext.SubmitChanges();
// Show succes message
if (number > 0)
{
msg = new Message(MessageConstants.I0001, MessageType.Info, number.ToString() + " log(s)", "deleted");
}
else
{
msg = new Message(MessageConstants.I0010, MessageType.Info);
}
trans.Commit();
}
catch (Exception)
{
if (trans != null) trans.Rollback();
// Show system error
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
public Message Create(UserConfig objUI)
{
Message msg = null;
try
{
dbContext.UserConfigs.InsertOnSubmit(objUI);
dbContext.SubmitChanges();
// Show success message
msg = new Message(MessageConstants.I0001, MessageType.Info, objUI.UserAdmin.UserName, "added");
}
catch (Exception ex)
{
msg = new Message(MessageConstants.E0007, MessageType.Error);
throw ex;
}
return msg;
}
public Message Delete(int id)
{
try
{
SR_Category cate = GetById(id, null);
cate.DeleteFlag = true;
cate.ParentId = null;
cate.UpdateDate = DateTime.Now;
cate.UpdatedBy = HttpContext.Current.User.Identity.Name;
Message msg = new Message(MessageConstants.I0001, MessageType.Info, "Category " + cate.Name, "deleted");
dbContext.SubmitChanges();
return msg;
}
catch
{
return new Message(MessageConstants.E0007, MessageType.Error);
}
}
public Message Assign(List<ModulePermission> list, int moduleID)
{
Message msg = null;
try
{
dbContext.sp_DeleteModulePermisson(moduleID);
dbContext.ModulePermissions.InsertAllOnSubmit(list);
dbContext.SubmitChanges();
msg = new Message(MessageConstants.I0001, MessageType.Info, "Module " + ((Modules)moduleID).ToString() + "", "update");
}
catch (Exception)
{
// Show system error
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
/// <summary>
/// Delete List
/// </summary>
/// <param name="ids"></param>
/// <returns></returns>
public Message DeleteList(string ids, string userName)
{
Message msg = null;
DbTransaction trans = null;
try
{
dbContext.Connection.Open();
trans = dbContext.Connection.BeginTransaction();
dbContext.Transaction = trans;
if (!string.IsNullOrEmpty(ids))
{
ids = ids.TrimEnd(',');
string[] idArr = ids.Split(',');
int jrID = 0;
int totalID = idArr.Count();
foreach (string id in idArr)
{
bool isInterger = Int32.TryParse(id, out jrID);
JobRequest jobRequest = GetById(jrID);
if (jobRequest != null)
{
jobRequest.UpdatedBy = userName;
Delete(jobRequest);
}
else
{
totalID--;
}
}
// Show succes message
msg = new Message(MessageConstants.I0001, MessageType.Info, totalID.ToString() + " Job Request(s)", "deleted");
trans.Commit();
}
}
catch
{
if (trans != null) trans.Rollback();
// Show system error
msg = new Message(MessageConstants.E0006, MessageType.Error, "delete", "it");
}
return msg;
}
public Message DeleteList(string ids, string stUpdatedBy)
{
Message msg = null;
DbTransaction trans = null;
try
{
dbContext.Connection.Open();
trans = dbContext.Connection.BeginTransaction();
dbContext.Transaction = trans;
if (!string.IsNullOrEmpty(ids))
{
ids = ids.TrimEnd(':');
string[] idArr = ids.Split(':');
int adminId = 0;
int total = idArr.Count();
foreach (string id in idArr)
{
bool isInterger = Int32.TryParse(id.Split(',')[0],out adminId);
UserAdmin_WFRole user = GetById(adminId);
if (user != null)
{
user.UpdatedBy = stUpdatedBy;
Delete(user);
}
else
{
total--;
}
}
// Show succes message
msg = new Message(MessageConstants.I0001, MessageType.Info, total.ToString() + " account(s)", "deleted");
}
trans.Commit();
}
catch (Exception)
{
if (trans != null) trans.Rollback();
// Show system error
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
/// <summary>
/// Delete by exam question id
/// </summary>
/// <param name="objUI"></param>
public Message DeleteByExamQuestionID(int examQuestionID)
{
Message msg = null;
try
{
// Get current group in dbContext
List<LOT_ExamQuestion_Section> list = GetListByExamQuestionID(examQuestionID);
dbContext.LOT_ExamQuestion_Sections.DeleteAllOnSubmit(list);
dbContext.SubmitChanges();
msg = new Message(MessageConstants.I0001, MessageType.Info, "Exam Question-Section ", "deleted");
}
catch (Exception)
{
// Show system error
msg = new Message(MessageConstants.E0036, MessageType.Error);
}
return msg;
}
/// <summary>
/// Delete by object
/// </summary>
/// <param name="objUI"></param>
public Message Delete(LOT_ExamQuestion_Section objGUI)
{
Message msg = null;
try
{
// Get current group in dbContext
LOT_ExamQuestion_Section item = GetByExQuestionIDAndSectionID(objGUI.ExamQuestionID, objGUI.SectionID);
dbContext.LOT_ExamQuestion_Sections.DeleteOnSubmit(item);
dbContext.SubmitChanges();
msg = new Message(MessageConstants.I0001, MessageType.Info, "Exam Question-Section ", "deleted");
}
catch (Exception)
{
// Show system error
msg = new Message(MessageConstants.E0036, MessageType.Error);
}
return msg;
}
/// <summary>
/// Delete list of purchase request
/// </summary>
/// <param name="ids">list of purchase request id</param>
/// <param name="userName">user delete</param>
/// <returns>Message</returns>
public Message DeleteList(string ids, string userName)
{
Message msg = null;
DbTransaction trans = null;
try
{
dbContext.Connection.Open();
trans = dbContext.Connection.BeginTransaction();
dbContext.Transaction = trans;
if (!string.IsNullOrEmpty(ids))
{
ids = ids.TrimEnd(',');
string[] idArr = ids.Split(',');
int total = idArr.Count();
foreach (string id in idArr)
{
PurchaseRequest emp = GetByID(int.Parse(id));
if (emp != null)
{
emp.UpdatedBy = userName;
Delete(emp);
}
else
{
total--;
}
}
// Show succes message
msg = new Message(MessageConstants.I0001, MessageType.Info, total.ToString() + " purchase request(s)", "deleted");
trans.Commit();
}
}
catch
{
if (trans != null) trans.Rollback();
// Show system error
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
public Message DeleteList(string ids)
{
Message msg = null;
DbTransaction trans = null;
try
{
dbContext.Connection.Open();
trans = dbContext.Connection.BeginTransaction();
dbContext.Transaction = trans;
if (!string.IsNullOrEmpty(ids))
{
ids = ids.TrimEnd(',');
string[] idArr = ids.Split(',');
int total = idArr.Count();
foreach (string id in idArr)
{
string empID = id;
Employee_Certification trainingCer = GetById(empID);
if (trainingCer != null)
{
Delete(trainingCer);
}
else
{
total--;
}
}
// Show succes message
msg = new Message(MessageConstants.I0001, MessageType.Info, total.ToString() + " Certification(s)", "deleted");
trans.Commit();
}
}
catch
{
if (trans != null) trans.Rollback();
// Show system error
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
/// <summary>
/// Insert a List into table LOT_Candidate_Topic
/// </summary>
/// <param name="list">List of LOT_Candidate_Topic object</param>
/// <returns>Message</returns>
public Message InsertList(List<LOT_Candidate_Topic> list)
{
Message msg = null;
try
{
if (list.Count > 0)
{
dbContext.LOT_Candidate_Topics.InsertAllOnSubmit(list);
dbContext.SubmitChanges();
// Show success message
msg = new Message(MessageConstants.I0001, MessageType.Info, "Candidate Topic", "added");
}
}
catch (Exception ex)
{
msg = new Message(MessageConstants.E0007, MessageType.Error);
throw ex;
}
return msg;
}
public Message Delete(int id)
{
try
{
Training_Material mat = GetById(id, null);
mat.DeleteFlag = true;
mat.UpdateDate = DateTime.Now;
mat.UpdatedBy = HttpContext.Current.User.Identity.Name;
Message msg = new Message(MessageConstants.I0001, MessageType.Info, "Material", "deleted");
//Delete File
string filepath = HttpContext.Current.Server.MapPath(Constants.TRAINING_CENTER_MATERIAL_UPLOAD_FOLDER + mat.UploadFile);
if (File.Exists(filepath))
File.Delete(filepath);
dbContext.SubmitChanges();
return msg;
}
catch
{
return new Message(MessageConstants.E0007, MessageType.Error);
}
}
public Message Update(SR_Comment comment)
{
Message msg = null;
try
{
SR_Comment src = GetCommentByServiceRequestID(comment.ServiceRequestID);
src.Contents += "\r\n=============================\r\n" + comment.Poster +
"(" + comment.PostTime.ToString(Constants.DATETIME_FORMAT_JR) + "):" + "\r\n" + comment.Contents;
if (comment.Files != null)
{
src.Contents += CommonFunc.SplitFileName(comment.Files, Constants.SR_UPLOAD_PATH, false).Replace("<a" ,"#begin#").Replace("</a>", "#end#");
}
dbContext.SubmitChanges();
msg = new Message(MessageConstants.I0001, MessageType.Info, "Comment", "updated");
}
catch
{
msg = new Message(MessageConstants.E0007, MessageType.Error);
}
return msg;
}
