public static List <rptArrivalToDepositeBLL> GetReportData(Guid WarehouseId, DateTime from)
{
string strSql = "spArrivalToDepositeRPT";
List <rptArrivalToDepositeBLL> list = null;
SqlParameter[] arPar = new SqlParameter[2];
SqlDataReader reader;
arPar[0] = new SqlParameter("@warehouseId", SqlDbType.UniqueIdentifier);
arPar[0].Value = WarehouseId;
arPar[1] = new SqlParameter("@ArrivalDate", SqlDbType.DateTime);
arPar[1].Value = from;
SqlConnection conn = Connection.getConnection();
if (conn == null || conn.State != ConnectionState.Open)
{
throw new Exception("Invalid database connection.");
}
reader = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, strSql, arPar);
if (reader.HasRows)
{
list = new List <rptArrivalToDepositeBLL>();
while (reader.Read())
{
rptArrivalToDepositeBLL obj = new rptArrivalToDepositeBLL();
obj.VoucherNo = reader["VoucherNo"].ToString();
if (reader["VoucherNo"] != DBNull.Value)
{
obj.ClientId = new Guid(reader["ClientId"].ToString());
}
obj.PlateNo = reader["PlateNumber"].ToString();
obj.TrailerPlateNo = reader["TrailerPlateNumber"].ToString();
if (reader["TotalNumberOfBags"] != DBNull.Value)
{
obj.NoBags = int.Parse(reader["TotalNumberOfBags"].ToString());
}
if (reader["ArrivalDate"] != DBNull.Value)
{
obj.ArrivalDate = DateTime.Parse(reader["ArrivalDate"].ToString());
}
if (reader["DateDeposited"] != DBNull.Value)
{
obj.unloadedDate = DateTime.Parse(reader["DateDeposited"].ToString());
}
if (reader["WarehouseId"] != DBNull.Value)
{
obj.WarehouseId = new Guid(reader["WarehouseId"].ToString());
}
list.Add(obj);
}
conn.Close();
return(list);
}
else
{
conn.Close();
return(null);
}
return(list);
}
private void getData(DateTime from)
{
List <rptArrivalToDepositeBLL> lst = null;
rptArrivalToDepositeBLL o = new rptArrivalToDepositeBLL();
lst = o.GetReportData(UserBLL.GetCurrentWarehouse(), from);
if (lst != null)
{
if (lst.Count > 0)
{
str.Append("<table align='center' border='1' bordercolor='#000000' width='99%' class='reporttable1' cellspacing='0' cellpadding='0' style='font-size:10;'>");
str.Append("<tr style='color:#000000; font-weight:bold>' ");
str.Append("<td>S.No");
str.Append("</td>");
str.Append("<td>voucher.No");
str.Append("</td>");
str.Append("<td>Company Name");
str.Append("</td>");
str.Append("<td>Plate No.");
str.Append("</td>");
str.Append("<td>Trailer Plate No.");
str.Append("</td>");
str.Append("<td>No. Bags");
str.Append("</td>");
str.Append("<td>Date of Arrival");
str.Append("</td>");
str.Append("<td>Date of Deposit");
str.Append("</td>");
str.Append("</tr>");
int sno = 0;
foreach (rptArrivalToDepositeBLL i in lst)
{
sno++;
str.Append("<tr>");
str.Append("<td>");
str.Append(sno.ToString());
str.Append("</td>");
str.Append("<td>");
str.Append(i.VoucherNo.ToString());
str.Append("</td>");
str.Append("<td>");
str.Append(i.ClientName.ToString());
str.Append("</td>");
str.Append("<td>");
str.Append(i.PlateNo.ToString());
str.Append("</td>");
str.Append("<td>");
str.Append(i.TrailerPlateNo.ToString());
str.Append("</td>");
str.Append("<td>");
str.Append(i.NoBags.ToString());
str.Append("</td>");
str.Append("<td>");
str.Append(i.ArrivalDate.ToShortDateString());
str.Append("</td>");
str.Append("<td>");
str.Append(i.unloadedDate.ToShortDateString());
str.Append("</td>");
str.Append("</tr>");
}
str.Append("</table>".ToString());
}
}
}