// Add your own data access methods here. If you wish to // expose your public method to a WCF service, marked them with // the attribute [NCPublish], and another T4 template will generate your service contract /// <summary> /// This function will insert new partner spread details in PartnerCommission table /// </summary> /// <returns></returns> public void AddNewPartnerSpread(PartnerCommission partComm) { try { using (var unitOfWork = new EFUnitOfWork()) { var partCommRepo = new PartnerCommissionRepository(new EFRepository <PartnerCommission>(), unitOfWork); partCommRepo.Add(partComm); partCommRepo.Save(); } } catch (Exception ex) { CommonErrorLogger.CommonErrorLog(ex, System.Reflection.MethodBase.GetCurrentMethod().Name); throw; } }
/// <summary> /// This method returns all fee structures of a particular IB user /// </summary> /// <param name="userID">userID</param> /// <returns></returns> public List <PartnerCommission> GetAllFeeStructureForUser(int userID) { try { using (var unitOfWork = new EFUnitOfWork()) { var partCommRepo = new PartnerCommissionRepository(new EFRepository <PartnerCommission>(), unitOfWork); ObjectSet <PartnerCommission> partCommObjSet = ((CurrentDeskClientsEntities)partCommRepo.Repository.UnitOfWork.Context).PartnerCommissions; //Return list of fee structure of user return(partCommObjSet.Where(part => part.FK_UserID == userID).ToList()); } } catch (Exception ex) { CommonErrorLogger.CommonErrorLog(ex, System.Reflection.MethodBase.GetCurrentMethod().Name); throw; } }
/// <summary> /// This method disables currently active fee and makes selected fee active /// </summary> /// <param name="userID">userID</param> /// <param name="feeID">feeID</param> /// <returns></returns> public bool MakeFeeStructureDefault(int userID, int feeID) { try { using (var unitOfWork = new EFUnitOfWork()) { var partCommRepo = new PartnerCommissionRepository(new EFRepository <PartnerCommission>(), unitOfWork); ObjectSet <PartnerCommission> partCommObjSet = ((CurrentDeskClientsEntities)partCommRepo.Repository.UnitOfWork.Context).PartnerCommissions; //Get currently active fee var activeFee = partCommObjSet.Where(part => part.FK_UserID == userID && part.IsDefault == true).FirstOrDefault(); if (activeFee != null) { activeFee.IsDefault = false; //Get selected fee to be made active var selectedFee = partCommObjSet.Where(part => part.PK_PartnerCommID == feeID).FirstOrDefault(); if (selectedFee != null) { selectedFee.IsDefault = true; partCommRepo.Save(); return(true); } } return(false); } } catch (Exception ex) { CommonErrorLogger.CommonErrorLog(ex, System.Reflection.MethodBase.GetCurrentMethod().Name); return(false); } }