public static int AddUpdateCustomer(Customer ob)
{
int customerid = 0;
using (ABBEntities db = new ABBEntities())
{
if (ob.CustomerID>0)
{
Customer checkifexist = db.Customers.Where(u => u.CustomerID == ob.CustomerID).FirstOrDefault();
if (checkifexist != null)
{
checkifexist.CustomerID = ob.CustomerID;
checkifexist.CustomerFirstName = ob.CustomerFirstName;
checkifexist.CustomerLastName = ob.CustomerLastName;
checkifexist.PhoneNumber = ob.PhoneNumber;
checkifexist.Address = ob.Address;
checkifexist.City = ob.City;
checkifexist.St = ob.St;
checkifexist.Zip = ob.Zip;
checkifexist.Country = ob.Country;
}
}
else
{
db.Customers.Add(ob);
}
int saved = db.SaveChanges();
if(saved > 0)
{
customerid = ob.CustomerID;
}
}
return customerid;
}
public static int AddUpDateItem(Item ob)
{
int itemid = 0;
using (ABBEntities db = new ABBEntities())
{
if (ob.ItemId > 0)
{
Item ExistingItem = db.Items.Where(u => u.ItemId == ob.ItemId).FirstOrDefault();
if (ExistingItem != null)
{
ExistingItem.CategoryId = ob.CategoryId;
ExistingItem.ItemName = ob.ItemName;
ExistingItem.ItemId = ob.ItemId;
}
}
else
{
db.Items.Add(ob);
}
int saved = db.SaveChanges();
if (saved > 0)
{
itemid = ob.ItemId;
}
return itemid;
}
}
public static List<Customer> GetCustomers(int CustID)
{
List<Customer> _customers = null;
using (ABBEntities db = new ABBEntities())
{
_customers = (from u in db.Customers where ((CustID == null) | (u.CustomerID == CustID) | (CustID == 0)) select u).ToList();
}
return _customers;
}
public static List<Item> GetItem(int ItemID)
{
List<Item> _item = null;
using (ABBEntities db = new ABBEntities())
{
_item = (from u in db.Items where ((ItemID == null) | (u.ItemId == ItemID) | (ItemID == 0)) select u).ToList();
}
return _item;
}
