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