public DataTable getPackageDescription(BALSearch obj)
{
try
{
SqlConnection cn = new SqlConnection(strCon);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("[dbo].[sp_getsearchresults]", cn);
da.SelectCommand.Parameters.Clear();
da.SelectCommand.Parameters.AddWithValue("@action", obj.action);
da.SelectCommand.Parameters.AddWithValue("@packageId", obj.PackageId);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
cn.Open();
da.SelectCommand.ExecuteReader();
DataTable dtReturnData = new DataTable();
cn.Close();
da.Fill(dtReturnData);
if (dtReturnData != null)
{
return(dtReturnData);
}
else
{
return(null);
}
}
catch (Exception)
{
return(null);
}
}
public DataTable webserviceformahabaaahu(BALSearch obj)
{
try
{
SqlConnection cn = new SqlConnection(strCon);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("[dbo].[webserviceformahabaaahu]", cn);
da.SelectCommand.Parameters.Clear();
da.SelectCommand.CommandType = CommandType.StoredProcedure;
cn.Open();
da.SelectCommand.ExecuteReader();
DataTable dtReturnData = new DataTable();
cn.Close();
da.Fill(dtReturnData);
if (dtReturnData != null)
{
return(dtReturnData);
}
else
{
return(null);
}
}
catch (Exception)
{
return(null);
}
}
public DataTable getbyfilter1(BALSearch obj)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = new SqlConnection(strCon);
cmd.CommandText = "sp_getsearchresults";
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.Parameters.AddWithValue("@action", "getbyfilter");
cmd.Parameters.AddWithValue("@startdate", obj.StartDate);
cmd.Parameters.AddWithValue("@enddate", obj.EndDate);
cmd.Parameters.AddWithValue("@packageId", obj.PackageId);
DataTable dt = new DataTable();
if (cmd.Connection.State == ConnectionState.Open)
{
cmd.Connection.Close();
}
SqlDataAdapter da = new SqlDataAdapter(cmd);
if (cmd.Connection.State == ConnectionState.Open)
{
cmd.Connection.Close();
}
da.Fill(dt);
return(dt);
}
catch (SqlException ex)
{
return(null);
}
}
public DataTable GetSearchResultsPackages(BALSearch obj)
{
try
{
SqlConnection cn = new SqlConnection(strCon);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("[dbo].[sp_getsearchresults]", cn);
da.SelectCommand.Parameters.Clear();
da.SelectCommand.Parameters.AddWithValue("@action", obj.action);
da.SelectCommand.Parameters.AddWithValue("@startdate", obj.StartDate);
da.SelectCommand.Parameters.AddWithValue("@enddate", obj.EndDate);
da.SelectCommand.Parameters.AddWithValue("@countryId", obj.CountryId);
da.SelectCommand.Parameters.AddWithValue("@riverId", obj.RiverId);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
cn.Open();
da.SelectCommand.ExecuteReader();
DataTable dtReturnData = new DataTable();
cn.Close();
da.Fill(dtReturnData);
if (dtReturnData != null)
{
return(dtReturnData);
}
else
{
return(null);
}
}
catch (Exception)
{
return(null);
}
}
public DataTable PackagewiseavailbilityReport(BALSearch obj)
{
try
{
SqlConnection cn = new SqlConnection(strCon);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("[dbo].[sp_getsearchresults]", cn);
da.SelectCommand.Parameters.Clear();
da.SelectCommand.Parameters.AddWithValue("@action", obj.action);
da.SelectCommand.Parameters.AddWithValue("@packageId", obj.PackageId);
da.SelectCommand.Parameters.AddWithValue("@startdate", obj.StartDate);
da.SelectCommand.Parameters.AddWithValue("@enddate", obj.EndDate);
da.SelectCommand.Parameters.AddWithValue("@AgentId", obj.AgentId);
da.SelectCommand.Parameters.AddWithValue("@PackageType", obj.PackageType);
da.SelectCommand.Parameters.AddWithValue("@Openclose", obj.Openclose);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
cn.Open();
da.SelectCommand.ExecuteReader();
DataTable dtReturnData = new DataTable();
cn.Close();
da.Fill(dtReturnData);
if (dtReturnData != null)
{
return(dtReturnData);
}
else
{
return(null);
}
}
catch (Exception ex)
{
return(null);
}
}
