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