protected void btnSave_Click(object sender, EventArgs e)
{
int orcId = Convert.ToInt32(Request.QueryString["orc_id"]);
int forId = Convert.ToInt32(Request.QueryString["for_id"]);
bool success = false;
OrderDB orderbd = new OrderDB();
Order order = new Order();
RequestItemBD requestbd = new RequestItemBD();
RequestItem item = new RequestItem();
order.RegisterDate = DateTime.Now;
order.IdSupplier = forId;
order.IdBudget = orcId;
if (orderbd.Insert(order))
{
int lastOrderId = orderbd.SelectLastOrder();
for (int i = 0; i < gdvItems.Rows.Count; i++)
{
item.Desc = gdvItems.Rows[i].Cells[0].Text;
item.TypeOfItem = gdvItems.Rows[i].Cells[1].Text;
item.Qty = Convert.ToInt32(gdvItems.Rows[i].Cells[2].Text);
item.Price = Convert.ToDouble(gdvItems.Rows[i].Cells[3].Text);
item.PedId = lastOrderId;
if (requestbd.Insert(item))
{
success = true;
}
else
{
success = false;
}
}
}
else
{
success = false;
}
if (success)
{
Response.Redirect("ListOrders.aspx?orc_id=" + orcId + "&success=true");
}
else
{
lblMessage.Text = "Erro ao salvar o pedido.";
}
}
protected void LoadRequestItems(int pedId)
{
RequestItemBD requestItemBD = new RequestItemBD();
DataSet ds = requestItemBD.SelectItemsById(pedId);
int count = ds.Tables[0].Rows.Count;
if (count > 0)
{
gdvRequestItems.DataSource = ds.Tables[0].DefaultView;
gdvRequestItems.DataBind();
gdvRequestItems.HeaderRow.TableSection = TableRowSection.TableHeader;
//lblMessage.Visible = false;
}
//else
//{
// lblMessage.Visible = true;
//}
}
//função que abastece o gráfico com as informações do fornecedor e seus itens
public void LoadCharts()
{
RequestItemBD requestItemBD = new RequestItemBD();
RequestItem requestItem = new RequestItem();
DataSet ds = new DataSet();
ds = requestItemBD.TotalSuppliers();
int totSup = (Int32)(ds.Tables[0].Rows[0][0]);
int i = 0;
for (i = 1; i <= totSup; i++)
{
try
{
DataSet ds2 = new DataSet();
ds2 = requestItemBD.TotalWrongItems(i);
if (!(ds2.Tables[0].Rows[0][0] is DBNull))
{
requestItem.Wrong = Convert.ToInt32(ds2.Tables[0].Rows[0][0]);
DataSet ds3 = new DataSet();
ds3 = requestItemBD.TotalItems(i);
if (!(ds2.Tables[0].Rows[0][0] is DBNull))
{
requestItem.Qty = Convert.ToInt32(ds3.Tables[0].Rows[0][0]);
requestItem.Correct = requestItem.Qty - requestItem.Wrong;
DataSet ds4 = new DataSet();
ds4 = requestItemBD.SupplierName(i);
requestItem.SupName = Convert.ToString(ds4.Tables[0].Rows[0][0]);
dados = dados + "['" + requestItem.SupName + "', " + requestItem.Correct + "," + requestItem.Wrong + "],";
}
}
}catch (System.Exception ex)
{
throw;
}
}
}
