public static List <GRNSentBLL> getCountApprovedGRNSentbyDate(DateTime datesent)
{
List <GRNSentBLL> list = null;
string strSql = "spSentGRN";
SqlDataReader reader;
SqlParameter[] arPar = new SqlParameter[1];
arPar[0] = new SqlParameter("@Approveddate", SqlDbType.DateTime);
arPar[0].Value = datesent;
SqlConnection conn = null;
try
{
conn = Connection.getConnection();
reader = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure, strSql, arPar);
if (reader.HasRows)
{
list = new List <GRNSentBLL>();
while (reader.Read())
{
GRNSentBLL obj = new GRNSentBLL();
if (reader["NoofGRN"] != DBNull.Value)
{
obj.count = int.Parse(reader["NoofGRN"].ToString());
}
else
{
throw new Exception("Invalid Count");
}
if (reader["WarehouseId"] != DBNull.Value)
{
obj.warehouseId = new Guid(reader["WarehouseId"].ToString());
}
else
{
throw new Exception("Invalid Warehouse Id");
}
list.Add(obj);
}
return(list);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn != null)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
}
return(null);
return(list);
}
private void ShowGRNSent()
{
int TotalCount = 0;
DateTime dateSent = DateTime.Parse(this.txtArrivalDate.Text);
GRNSentBLL obj = new GRNSentBLL();
List <GRNSentBLL> list = obj.getCount(dateSent, out TotalCount);
gvDetail.DataSource = list;
gvDetail.DataBind();
this.lblTotal.Text = TotalCount.ToString();
}
