protected void Page_Load(object sender, EventArgs e)
{
string mainconn = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
SqlConnection sqlconn = new SqlConnection(mainconn);
sqlconn.Open();
SqlCommand sqlcomm = new SqlCommand();
string sqlquery = "Select [UzimaInventory].[Id], [DrugName], [Status], [LocationName], [DateOrdered], [ExpirationDate] " +
"From[UzimaDrug], [UzimaInventory], [UzimaStatus], [UzimaLocations] " +
"Where[UzimaDrug].[Id] = [UzimaInventory].[DrugId] AND[UzimaStatus].[Id] = [UzimaInventory].[StatusId] AND [UzimaInventory].[CurrentLocationId] = [UzimaLocations].[Id] AND [StatusID] = 0";
sqlcomm.CommandText = sqlquery;
sqlcomm.Connection = sqlconn;
DataTable dt = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter(sqlcomm);
sda.Fill(dt);
InventoryGridview.DataSource = dt;
InventoryGridview.DataBind();
}
protected void DownloadInventory_Click(object sender, EventArgs e)
{
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=Inventory.pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
InventoryGridview.RenderControl(hw);
StringReader sr = new StringReader(sw.ToString());
Document pdfdoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f);
PdfWriter writer = PdfWriter.GetInstance(pdfdoc, Response.OutputStream);
pdfdoc.Open();
XMLWorkerHelper.GetInstance().ParseXHtml(writer, pdfdoc, sr);
pdfdoc.Close();
Response.Write(pdfdoc);
Response.End();
InventoryGridview.AllowPaging = true;
InventoryGridview.DataBind();
}
protected void InventoryGridview_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
InventoryGridview.PageIndex = e.NewPageIndex;
string mainconn = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
SqlConnection sqlconn = new SqlConnection(mainconn);
sqlconn.Open();
SqlCommand sqlcomm = new SqlCommand();
string sqlquery = "Select [DrugName], [Status], [LocationName], [DateOrdered], [ExpirationDate], [UzimaInventory].[Id]" +
"From[UzimaDrug], [UzimaInventory], [UzimaStatus], [UzimaLocations] " +
"Where[UzimaDrug].[Id] = [UzimaInventory].[DrugId] AND[UzimaStatus].[Id] = [UzimaInventory].[StatusId] AND[UzimaInventory].[CurrentLocationId] = [UzimaLocations].[Id] AND [StatusID] = 0";
sqlcomm.Parameters.AddWithValue("DrugName", InventorySearch.Text);
sqlcomm.CommandText = sqlquery;
sqlcomm.Connection = sqlconn;
DataTable dt = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter(sqlcomm);
sda.Fill(dt);
InventoryGridview.DataSource = dt;
InventoryGridview.DataBind();
}
private void BindInventoryGrid()
{
string sqlQuery;
if (Site1.UserLoginType == "Admin")
{
sqlQuery = "Select * from DonationInventory where ArticleSold IS NULL;";
}
else if (Site1.UserLoginType == null)
{
sqlQuery = "Select * from DonationInventory where ArticleSold IS NULL;";
}
else
{
sqlQuery = "Select * from DonationInventory where ArticleLocationID = '" + Site1.UserLoginLocation + "' and ArticleSold IS NULL;";
}
string constr = ConfigurationManager.ConnectionStrings["CARESconnection"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand(sqlQuery))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Connection = con;
sda.SelectCommand = cmd;
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
InventoryGridview.DataSource = dt;
InventoryGridview.DataBind();
}
}
}
}
}
