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