public Form1()
{
InitializeComponent();
connection = new PartsDBConnector("blitz.cs.niu.edu", 3306, "student", "student");
allParts = connection.GetAllParts();
partListBox.DataSource = allParts;
}
// GET: Order
public ActionResult Index()
{
var connection = new PartsDBConnector("blitz.cs.niu.edu", 3306, "student", "student");
var allParts = connection.GetAllParts();
foreach (Part p in allParts)
{
orders.Add(new OrderModel(0, p));
}
return(View(orders));
}
protected void Page_Load(object sender, EventArgs e)
{
var connection = new PartsDBConnector("blitz.cs.niu.edu", 3306, "student", "student");
orderRows = new List <OrderRow>();
allParts = connection.GetAllParts();
foreach (Part p in allParts)
{
orderRows.Add(new OrderRow(0, p));
}
GridView1.DataSource = orderRows;
GridView1.DataBind();
}
private void CheckAccpet_Click(object sender, EventArgs e)
{
int err = 0;
if (Int32.TryParse(ItemRecievedCode.Text, out err)) //checks for integer input
{
PartsDBConnector connection = new PartsDBConnector("blitz.cs.niu.edu", 3306, "student", "student");
Part signlePart = connection.GetPartByID(Int32.Parse(ItemRecievedCode.Text));
PartName.Text = signlePart.Name;
PartName.Visible = true;
}
else
{
PartName.Text = "Error, not valid part";
} //else show error
}
static void Main(string[] args)
{
PartsDBConnector connector = new PartsDBConnector("blitz.cs.niu.edu", 3306, "student", "student");
var parts = connector.GetAllParts();
foreach (var part in parts)
{
Console.WriteLine(part.ID);
Console.WriteLine(part.Name);
Console.WriteLine(part.Price);
Console.WriteLine("---------------");
}
Console.ReadLine();
var part1 = connector.GetPartByID(3);
Console.WriteLine(part1.ID);
Console.WriteLine(part1.Name);
Console.WriteLine(part1.Price);
Console.WriteLine("---------------");
Console.ReadLine();
}
