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