public DataSet GetInvoiceByID(int trackingID)
{
StringBuilder sql;
SqlDataAdapter da;
DataSet invoicedata;
SqlConnection conn = dbConn.GetConnection();
invoicedata = new DataSet();
sql = new StringBuilder();
sql.AppendLine("SELECT * ");
sql.AppendLine("FROM Invoice WHERE trackingID=@trackingID");
try
{
da = new SqlDataAdapter(sql.ToString(), conn);
da.SelectCommand.Parameters.AddWithValue("trackingID", trackingID);
da.Fill(invoicedata);
}
catch (Exception ex)
{
errMsg = ex.Message;
}
finally
{
conn.Close();
}
return(invoicedata);
}
public DataSet GetPOListFiltered(string status)
{
StringBuilder sql;
SqlDataAdapter da;
DataSet ProgramData;
DalDbConn dbConn = new DalDbConn();
SqlConnection conn = dbConn.GetConnection();
ProgramData = new DataSet();
sql = new StringBuilder();
sql.AppendLine("SELECT *");
sql.AppendLine("FROM Delivery");
sql.AppendLine("WHERE deliveryStatus = @PS");
sql.AppendLine("ORDER BY trackingID DESC");
try
{
da = new SqlDataAdapter(sql.ToString(), conn);
da.SelectCommand.Parameters.AddWithValue("PS", status);
da.Fill(ProgramData);
}
catch (Exception ex)
{
string errMsg = ex.Message;
}
finally
{
conn.Close();
}
return(ProgramData);
}