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"));
}
