protected void rgProdType_UpdateCommand(object sender, GridCommandEventArgs e)
{
using (var context = new cathlabEntities())
{
int ID = int.Parse(e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["ID"].ToString());
ProductType pt = context.ProductTypes.Find(ID);
pt.Type = (e.Item.FindControl("tbType") as RadTextBox).Text;
context.SaveChanges();
}
}
protected void btnInsertProduct_Click(object sender, EventArgs e)
{
using (var context = new cathlabEntities())
{
Product prod = new Product();
prod.PartNumber = txtPartNum.Text;
prod.LotNumber = (txtLotNumber.Text != null) ? int.Parse(txtLotNumber.Text) : -1;
prod.ExpirationDate = rdpExpiration.SelectedDate;
prod.LocationID = int.Parse(lbxLoc.SelectedValue);
context.Products.Add(prod);
context.SaveChanges();
}
}
protected void rgPartNumbers_UpdateCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "Update")
{
using (var context = new cathlabEntities())
{
int PNum = int.Parse(e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["PartNum"].ToString());
PartNumber pn = context.PartNumbers.Find(PNum);
pn.NameSize = (e.Item.FindControl("tbNameSize") as RadTextBox).Text;
pn.Cost = int.Parse((e.Item.FindControl("tbCost") as RadTextBox).Text);
pn.Par = int.Parse((e.Item.FindControl("tbPar") as RadTextBox).Text);
context.SaveChanges();
}
}
}
protected void rgManufacturers_DeleteCommand(object sender, GridCommandEventArgs e)
{
GridDataItem item = (GridDataItem)e.Item;
int ID = (int)item.GetDataKeyValue("ID");
using (var context = new cathlabEntities())
{
Manufacturer m = context.Manufacturers.Find(ID);
try
{
context.Manufacturers.Remove(m);
context.SaveChanges();
}
catch (DbUpdateException)
{
rnLabel.Text = "ERROR! Can't delete manufacturer. Products in database rely on this entry.";
RadNotification.Show();
}
}
}
protected void rgPartNumbers_DeleteCommand(object sender, GridCommandEventArgs e)
{
GridDataItem item = (GridDataItem)e.Item;
string PartNum = item.GetDataKeyValue("PartNum").ToString();
using (var context = new cathlabEntities())
{
PartNumber pn = context.PartNumbers.Find(PartNum);
try
{
context.PartNumbers.Remove(pn);
context.SaveChanges();
}
catch (DbUpdateException)
{
rnLabel.Text = "ERROR! Cannot delete, there are products<br/> in the database of that part number.";
RadNotification.Show();
}
}
}
protected void rgProdType_DeleteCommand(object sender, GridCommandEventArgs e)
{
GridDataItem item = (GridDataItem)e.Item;
int ID = (int)item.GetDataKeyValue("ID");
using (var context = new cathlabEntities())
{
ProductType pt = context.ProductTypes.Find(ID);
var temp = (from prod in context.Products
where prod.PartNumber1.ProductTypeID == pt.ID
select prod).FirstOrDefault();
if (temp == null)
{
context.ProductTypes.Remove(pt);
context.SaveChanges();
rgProdType.Rebind();
}
else
{
rnLabel.Text = "ERROR! Can't delete product type. Products in database rely on this entry.";
RadNotification.Show();
}
//try
//{
// context.ProductTypes.Remove(pt);
// context.SaveChanges();
//}
//catch (Exception)
//{
// rnLabel.Text = "ERROR! Can't delete product type. Products in database rely on this entry.";
// RadNotification.Show();
//}
}
}
