public DataSet FilterMessagePhoneCall(int empId, string fromDate, string toDate) { FilterPhoneCallBO objFilterPhoneCallBO = new FilterPhoneCallBO(); objFilterPhoneCallBO.empId = empId; objFilterPhoneCallBO.fromDate = fromDate; objFilterPhoneCallBO.toDate = toDate; FilterMessagePhoneCallDL objFilterMessagePhoneCallDL = new FilterMessagePhoneCallDL(); return objFilterMessagePhoneCallDL.FilterMessagePhoneCall(objFilterPhoneCallBO); }
public DataSet FilterGeneralInquiryPhoneCall(int empId, string fromDate, string toDate) { FilterPhoneCallBO objFilterPhoneCallBO = new FilterPhoneCallBO(); objFilterPhoneCallBO.empId = empId; objFilterPhoneCallBO.fromDate = fromDate; objFilterPhoneCallBO.toDate = toDate; FilterGeneralInquiryPhoneCallDL objFilterGeneralInquiryPhoneCallDL = new FilterGeneralInquiryPhoneCallDL(); return(objFilterGeneralInquiryPhoneCallDL.FilterGeneralInquiryPhoneCall(objFilterPhoneCallBO)); }
public DataSet FilterForwardPhoneCall(FilterPhoneCallBO objFilterPhoneCallBO) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); SqlCommand cmd = new SqlCommand("spFilterForwardPhoneCall", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@empId", objFilterPhoneCallBO.empId); cmd.Parameters.Add("@fromDate", objFilterPhoneCallBO.fromDate); cmd.Parameters.Add("@toDate", objFilterPhoneCallBO.toDate); DataSet ds = new DataSet(); SqlDataAdapter adapter = new SqlDataAdapter(cmd); conn.Open(); adapter.Fill(ds); conn.Close(); return ds; }
public DataSet FilterEmergencyPhoneCall(FilterPhoneCallBO objFilterPhoneCallBO) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); SqlCommand cmd = new SqlCommand("spFilterEmergencyPhoneCall", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@empId", objFilterPhoneCallBO.empId); cmd.Parameters.Add("@fromDate", objFilterPhoneCallBO.fromDate); cmd.Parameters.Add("@toDate", objFilterPhoneCallBO.toDate); DataSet ds = new DataSet(); SqlDataAdapter adapter = new SqlDataAdapter(cmd); conn.Open(); adapter.Fill(ds); conn.Close(); return(ds); }