public bool MapMakertoChecker(int MakerID, int CheckerID) { CM_MAKER_CHECKER_XREF mcx = new CM_MAKER_CHECKER_XREF(); var count = from n in db.CM_MAKER_CHECKER_XREF where (n.MAKER_ID == MakerID && n.CHECKER_ID == CheckerID) select new { n.RECORD_ID }; if (count.Count() > 0) { return(false); } else { mcx.MAKER_ID = MakerID; mcx.CHECKER_ID = CheckerID; //mcx.CREATED_DATE = DateTime.Now; //mcx.CREATED_BY = "Admin"; //mcx.PARENT_TASK = 1; db.CM_MAKER_CHECKER_XREF.Add(mcx); db.SaveChanges(); return(true); } }
public bool DeleteAssignedUsers(decimal RecID) { CM_MAKER_CHECKER_XREF rpx = new CM_MAKER_CHECKER_XREF(); try { CM_MAKER_CHECKER_XREF objDelMakernXCheckerRef = (from MXCRef in db.CM_MAKER_CHECKER_XREF where MXCRef.RECORD_ID == RecID select MXCRef).FirstOrDefault(); db.CM_MAKER_CHECKER_XREF.Remove(objDelMakernXCheckerRef); db.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }