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