public DataSet GetEmployeeInstructionByDesignationId(int DesignationId, Common.JGConstant.EmployeeInstructionUsedFor UsedFor) { try { SqlDatabase database = MSSQLDataBase.Instance.GetDefaultDatabase(); { DbCommand command = database.GetStoredProcCommand("usp_GetEmpInstructionByDesignationId"); command.CommandType = CommandType.StoredProcedure; database.AddInParameter(command, "@DesignationId", DbType.Int32, DesignationId); database.AddInParameter(command, "@UsedFor", DbType.Int16, Convert.ToInt16(UsedFor)); DataSet dsEmpInstruction = database.ExecuteDataSet(command); return(dsEmpInstruction); } } catch (Exception ex) { return(null); } }
public DataSet GetEmployeeInstructionByDesignationId(int DesignationId, Common.JGConstant.EmployeeInstructionUsedFor UsedFor) { return(EmployeeInstructionDAL.Instance.GetEmployeeInstructionByDesignationId(DesignationId, UsedFor)); }