public bool SaveUserProhibitedCompanies(int UserID, ArrayList arrSelectedCompanies) { PIKCV.DAO.TransactionMgr Tran = PIKCV.DAO.TransactionMgr.ThreadTransactionMgr(); try { PIKCV.DAL.UserCVs ObjCV = new PIKCV.DAL.UserCVs(); PIKCV.DAL.UserProhibitedCompanies objUserProhibites = new PIKCV.DAL.UserProhibitedCompanies(); objUserProhibites.Where.UserID.Value = UserID; objUserProhibites.Query.Load(); Tran.BeginTransaction(); objUserProhibites.DeleteAll(); objUserProhibites.Save(); objUserProhibites = new PIKCV.DAL.UserProhibitedCompanies(); for (int i = 0; i < arrSelectedCompanies.Count; i++) { objUserProhibites.AddNew(); objUserProhibites.UserID = UserID; objUserProhibites.CompanyID = Convert.ToInt32(arrSelectedCompanies[i]); objUserProhibites.Save(); } ObjCV.Where.UserID.Value = UserID; ObjCV.Query.Load(); if (ObjCV.CvFocusCode < (int)PIKCV.COM.EnumDB.CVFocusCode.References) { ObjCV.CvFocusCode = (int)PIKCV.COM.EnumDB.CVFocusCode.References; } ObjCV.ModifyDate = DateTime.Now; ObjCV.Save(); Tran.CommitTransaction(); return(true); } catch (Exception) { Tran.RollbackTransaction(); PIKCV.DAO.TransactionMgr.ThreadTransactionMgrReset(); return(false); } }
public DataTable GetUserProhibitedCompanies(int UserID) { PIKCV.DAL.UserProhibitedCompanies obj = new PIKCV.DAL.UserProhibitedCompanies(); return(obj.GetUserProhibitedCompanies(UserID)); }