public void SaveSODetail(IEnumerable <SalesOrderDetail> SO, SODBContext db)
{
try
{
foreach (SalesOrderDetail line in SO)
{
db.Entry(line.Item).State = EntityState.Unchanged;
db.SalesOrderDetails.Add(line);
}
}
catch (Exception ex)
{
throw ex;
}
}
public Customer GetCustomerByID(int ID)
{
Customer _results;
try
{
using (SODBContext db = new SODBContext())
{
_results = db.Customers.Find(ID);
}
}
catch (Exception ex)
{
throw ex;
}
return(_results);
}
public IEnumerable <Customer> GetAllCustomer()
{
IEnumerable <Customer> _results;
try
{
using (SODBContext db = new SODBContext())
{
_results = db.Customers.ToList();
}
}
catch (Exception ex)
{
throw ex;
}
return(_results);
}
public Item GetItemByID(int ID)
{
Item _results;
try
{
using (SODBContext db = new SODBContext())
{
_results = db.Items.Find(ID);
}
}
catch (Exception ex)
{
throw ex;
}
return(_results);
}
public IEnumerable <SalesPerson> GetAllSalesPerson()
{
IEnumerable <SalesPerson> _results;
try
{
using (SODBContext db = new SODBContext())
{
_results = db.SalesPersons.ToList();
}
}
catch (Exception ex)
{
throw ex;
}
return(_results);
}
public void SaveSOHeader(SalesOrderHeader SO)
{
try
{
using (SODBContext db = new SODBContext())
{
db.Entry(SO.SalesPerson).State = EntityState.Unchanged;
db.Entry(SO.Customer).State = EntityState.Unchanged;
db.Entry(SO.Customer.CustCity).State = EntityState.Unchanged;
//db.Entry(SO.SalesOrderDetails).State = EntityState.Unchanged;
db.SalesOrderHeaders.Add(SO);
//db.Entry(SO).State = EntityState.Added;
_SalesOrderDetail.SaveSODetail(SO.SalesOrderDetails, db);
//foreach (SalesOrderDetail line in SO.SalesOrderDetails)
//{
// //line.SalesOrderHeader = SO;
// //db.Entry(line.SalesOrderHeader).State = EntityState.Unchanged;
// db.Entry(line.Item).State = EntityState.Unchanged;
// //db.Entry(line.Item.UnitofMeasure).State = EntityState.Unchanged;
// //db.Entry(line.Item.ItemCategory).State = EntityState.Unchanged;
// //db.Entry(line).State = EntityState.Added;
// //db.Items.Attach(line.Item);
// //db.UnitofMeasures.Attach(line.Item.UnitofMeasure);
// //db.ItemCategories.Attach(line.Item.ItemCategory);
// db.SalesOrderDetails.Add(line);
//}
db.Entry(SO).State = EntityState.Added;
db.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public int GetSOHeaderDocNo()
{
SalesOrderHeader _results;
int _DocID;
try
{
using (SODBContext db = new SODBContext())
{
_results = db.SalesOrderHeaders.OrderByDescending(x => x.Id).Take(1).FirstOrDefault();
_DocID = (_results == null) ? 1 : _results.Id + 1;
}
}
catch (Exception ex)
{
throw ex;
}
return(_DocID);
}
public SalesPerson GetSalesPersonByName(string salespName)
{
SalesPerson _results;
try
{
using (SODBContext db = new SODBContext())
{
_results = db.SalesPersons
.Where(x => x.Name == salespName)
.FirstOrDefault();
}
}
catch (Exception ex)
{
throw ex;
}
return(_results);
}
public Item GetItemByName(string Name)
{
Item _results;
try
{
using (SODBContext db = new SODBContext())
{
_results = db.Items
//.Include("CustomerCity")
.Where(x => x.ItemDescription == Name)
.FirstOrDefault();
}
}
catch (Exception ex)
{
throw ex;
}
return(_results);
}
public Item GetItemByCode(string Code)
{
Item _results;
try
{
using (SODBContext db = new SODBContext())
{
_results = db.Items
.Include("UnitofMeasure")
.Include("ItemCategory")
.Where(x => x.ItemCode == Code)
.FirstOrDefault();
}
}
catch (Exception ex)
{
throw ex;
}
return(_results);
}
public Customer GetCustomerByName(string Name)
{
Customer _results;
try
{
using (SODBContext db = new SODBContext())
{
_results = db.Customers
.Include("CustCity")
.Where(x => x.CustName == Name)
.FirstOrDefault();
//_results = db.Customers.Where(x => x.CustName == Name).FirstOrDefault();
}
}
catch (Exception ex)
{
throw ex;
}
return(_results);
}
