protected void autopopulate()
{
string part = tbPartNum.Text;
using (var context = new cathlabEntities())
{
var temp = (from pnum in context.PartNumbers
where pnum.PartNum == part
select new { pnum.Manufacturer.Name, pnum.NameSize, pnum.ProductType.Type }).SingleOrDefault();
if (temp != null)
{
pnlNewProduct.Visible = true;
loadELocations();
tbEManufacturer.Text = temp.Name;
tbENameSize.Text = temp.NameSize;
tbEProdType.Text = temp.Type;
}
else
{
pnlNewPartNumber.Visible = true;
pnlNewProduct.Visible = false;
loadManufacturers();
loadProductTypes();
}
}
}
protected void btnPNSubmit_Click(object sender, EventArgs e)
{
if (lbxManufacturer.SelectedItem == null || lbxProdType.SelectedItem == null || tbNNameSize.Text == string.Empty)
{
lblMissing.Visible = true;
}
else
{
using (var context = new cathlabEntities())
{
int cost, par;
int.TryParse(tbNCost.Text, out cost);
int.TryParse(tbNPar.Text, out par);
PartNumber pn = new PartNumber();
pn.PartNum = pnum;
pn.NameSize = tbNNameSize.Text;
pn.ManufacturerID = int.Parse(lbxManufacturer.SelectedValue); //
pn.ProductTypeID = int.Parse(lbxProdType.SelectedValue); //
pn.Cost = cost;
pn.Par = par;
context.PartNumbers.Add(pn);
context.SaveChanges();
pnlNewPartNumber.Visible = true;
pnlNewPartNumber.Visible = false;
lblMissing.Visible = false;
autopopulate();
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
using (var context = new cathlabEntities())
{
ProductType pt = new ProductType();
pt.Type = tbType.Text;
context.ProductTypes.Add(pt);
context.SaveChanges();
}
}
protected void loadELocations()
{
using (var context = new cathlabEntities())
{
List <Location> temp = (from loc in context.Locations select loc).ToList();
lbxELocation.DataValueField = "ID";
lbxELocation.DataTextField = "LocationName";
lbxELocation.DataSource = temp;
lbxELocation.DataBind();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
using (var context = new cathlabEntities())
{
Manufacturer man = new Manufacturer();
man.Name = tbManufacturerName.Text;
man.Email = tbxEmail.Text;
man.PhoneNumber = tbxPhoneNumber.Text;
man.Address = tbxAddress.Text;
context.Manufacturers.Add(man);
context.SaveChanges();
}
}
protected void loadProductTypes()
{
using (var context = new cathlabEntities())
{
List <ProductType> temp = (from prodtype in context.ProductTypes select prodtype).ToList();
ProductType a = new ProductType();
a.ID = 0; a.Type = "New Type";
temp.Insert(0, a);
lbxProdType.DataValueField = "ID";
lbxProdType.DataTextField = "Type";
lbxProdType.DataSource = temp;
lbxProdType.DataBind();
}
}
protected void loadManufacturers()
{
using (var context = new cathlabEntities())
{
List <Manufacturer> temp = (from man in context.Manufacturers select man).ToList();
Manufacturer a = new Manufacturer();
a.ID = 0; a.Name = "New Manufacturer";
temp.Insert(0, a);
lbxManufacturer.DataValueField = "ID";
lbxManufacturer.DataTextField = "Name";
lbxManufacturer.DataSource = temp;
lbxManufacturer.DataBind();
}
}
protected void btnPTSubmit_Click(object sender, EventArgs e)
{
using (var context = new cathlabEntities())
{
// Check for existing Prod Type?
string ptType = tbNProdType.Text;
ProductType pt = new ProductType();
pt.Type = tbNProdType.Text;
context.ProductTypes.Add(pt);
context.SaveChanges();
int ptID = (int)(from prodType in context.ProductTypes where prodType.Type == ptType select prodType.ID).First();
loadProductTypes();
pnlNewPartNumber.Visible = true;
pnlNewProdType.Visible = false;
loadProductTypes();
lbxProdType.SelectedValue = ptID.ToString();
}
}
protected void btnManSubmit_Click(object sender, EventArgs e)
{
using (var context = new cathlabEntities())
{
string manName = tbManufacturerName.Text;
Manufacturer man = new Manufacturer();
man.Name = tbManufacturerName.Text;
man.Email = tbxEmail.Text;
man.PhoneNumber = tbxPhoneNumber.Text;
man.Address = tbxAddress.Text;
context.Manufacturers.Add(man);
context.SaveChanges();
int mmm = (int)(from mann in context.Manufacturers where mann.Name == manName select mann.ID).First();
loadManufacturers();
pnlNewPartNumber.Visible = true;
pnlNewManufacturer.Visible = false;
lbxManufacturer.SelectedValue = mmm.ToString();
}
}
protected void btnInsertProduct_Click(object sender, EventArgs e)
{
using (var context = new cathlabEntities())
{
int lotNum, locID;
int.TryParse(lbxELocation.SelectedValue, out locID);
int.TryParse(tbLotNumber.Text, out lotNum);
Product p = new Product();
p.PartNumber = pnum;
//p.SerialNumber = ;
p.ExpirationDate = rdpExpiration.SelectedDate.Value.Date;
p.LocationID = locID;
p.LotNumber = lotNum;
p.StatusID = 4;
context.Products.Add(p);
context.SaveChanges();
pnlScan.Visible = true;
pnlNewProduct.Visible = false;
lblStatus.Visible = true;
lblStatus.Text = string.Format("Product '{0}' has been successfully entered.", pnum);
tbPartNum.Text = string.Empty;
}
}
