public ActionResult Delete(int[] cbxItem) { qtSubstitutesService _substitute = new qtSubstitutesService(); qtSubstitute substitute = new qtSubstitute(); if (cbxItem != null && cbxItem.Count() > 0) { qtSubstituteDetailService _substitutedetail = new qtSubstituteDetailService(); foreach (int item in cbxItem) { try { substitute = _substitute.FindByKey(item); if (substitute != null) { _substitutedetail.DeleteObject(_substitutedetail.FindList().Where(m => m.SubstituteId == item).ToList()); _substitute.Delete(substitute); } } catch (Exception) { } } } return(RedirectToAction("Index")); }
private string checkUser(int?SubstituteId, int UserId) { qtSubstituteDetailService _user = new qtSubstituteDetailService(); var item = _user.FindList().Where(m => m.UserId == UserId && m.SubstituteId == SubstituteId).Count(); if (item > 0) { return("checked='checked'"); } return(""); }
public ActionResult Save(int?id, int?SubstituteId, string AppName, string AppCode, bool IsActive, int DepartmentId, string[] cbxItem) { qtSubstitutesService _Substitutes = new qtSubstitutesService(); qtSubstitute substitute = new qtSubstitute(); if (SubstituteId.HasValue && SubstituteId.Value > 0) { substitute = _Substitutes.FindByKey(SubstituteId); } substitute.AppName = AppName; substitute.AppCode = AppCode; substitute.IsActive = IsActive; substitute.DepartmentId = DepartmentId; if (SubstituteId.HasValue && SubstituteId.Value > 0) { _Substitutes.Update(substitute); } else { _Substitutes.Insert(substitute); } if (cbxItem.Count() > 0) { qtSubstituteDetailService _detail = new qtSubstituteDetailService(); _detail.RunSql("Delete SubstituteDetail where SubstituteId=" + substitute.SubstituteId); foreach (string item in cbxItem) { qtSubstituteDetail detail = new qtSubstituteDetail(); detail.SubstituteId = substitute.SubstituteId; detail.UserId = TypeHelper.ToInt32(item); _detail.Insert(detail); } } return(RedirectToAction("Index")); }