/// <summary>
 /// Add parameters while fetch all master drop down list
 /// </summary>
 /// <param name="users"></param>
 /// <returns></returns>
 public IDbDataParameter[] AddParamsGetProductMaster(GetMasterNamesAndCodes master_details)
 {
     parameters.Clear();
     parameters.Add(dbManager.CreateParameter("@SearchText", 150, master_details.SearchText, DbType.String));
     parameters.Add(dbManager.CreateParameter("@MasterCode", 2, master_details.MasterCode, DbType.Int32));
     parameters.Add(dbManager.CreateParameter("@OperationType", 2, master_details.OperationType, DbType.Int16));
     return(parameters.ToArray());
 }
        /// <summary>
        /// To get the all master list..
        /// </summary>
        /// <param name="users"></param>
        /// <returns></returns>
        public DataTable GetProductMaster(GetMasterNamesAndCodes master_details)
        {
            var DbManager = new DBManager("DBConnection");

            return(DbManager.GetDataTable(_StoredProcedures.GetMasterNameAndCodes_SP, CommandType.StoredProcedure, _AdminMasterIRepository.AddParamsGetProductMaster(master_details)));
        }