public void Edit()
{
using (var ctx = new SPWEntities())
{
var obj = ctx.STORE.Where(x => x.STORE_ID == _item.STORE_ID).FirstOrDefault();
obj.STORE_CODE = _item.STORE_CODE;
obj.STORE_NAME = _item.STORE_NAME;
obj.PROVINCE_ID = _item.PROVINCE_ID;
obj.SECTOR_ID = _item.SECTOR_ID;
obj.ROAD_ID = _item.ROAD_ID;
obj.ZONE_ID = _item.ZONE_ID;
obj.STORE_ADDR1 = _item.STORE_ADDR1;
obj.STORE_CODE = _item.STORE_CODE;
obj.STORE_DISTRICT = _item.STORE_DISTRICT;
obj.STORE_FAX = _item.STORE_FAX;
obj.STORE_MOBILE = _item.STORE_MOBILE;
obj.STORE_NAME = _item.STORE_NAME;
obj.STORE_POSTCODE = _item.STORE_POSTCODE;
obj.STORE_STREET = _item.STORE_STREET;
obj.STORE_SUBDISTRICT = _item.STORE_SUBDISTRICT;
obj.STORE_TEL1 = _item.STORE_TEL1;
obj.STORE_TEL2 = _item.STORE_TEL2;
obj.UPDATE_DATE = _item.UPDATE_DATE;
obj.UPDATE_EMPLOYEE_ID = _item.UPDATE_EMPLOYEE_ID;
ctx.SaveChanges();
}
}
public List<FUNCTION> GetALL(string name)
{
using (var ctx = new SPWEntities())
{
var list = ctx.FUNCTION.Where(x => x.FUNCTION_NAME.Contains(name)).ToList();
return list;
}
}
public List<ORDER> GetALLIncludeByStore(int ID)
{
using (var ctx = new SPWEntities())
{
var list = ctx.ORDER.Include("ORDER_DETAIL").Where(x => x.SYE_DEL == true && x.STORE_ID == ID).ToList();
return list;
}
}
public void Add()
{
using (var ctx = new SPWEntities())
{
ctx.ZONE_DETAIL.Add(_item);
ctx.SaveChanges();
}
}
public void Add()
{
using (var ctx = new SPWEntities())
{
ctx.DELIVERY_ORDER_DETAIL.Add(_item);
ctx.SaveChanges();
}
}
public COLOR_TYPE Select(int ID)
{
using (var ctx = new SPWEntities())
{
var list = ctx.COLOR_TYPE.Where(x => x.COLOR_TYPE_ID == ID).FirstOrDefault();
return list;
}
}
public List<COLOR_TYPE> GetALL()
{
using (var ctx = new SPWEntities())
{
var list = ctx.COLOR_TYPE.Where(x => x.SYE_DEL == true).ToList();
return list;
}
}
public List<FUNCTION> GetALLInclude()
{
using (var ctx = new SPWEntities())
{
var list = ctx.FUNCTION.Include("SUB_FUNCTION").Where(x => x.SYE_DEL == true).ToList();
return list;
}
}
public List<ORDER_DETAIL> GetALL()
{
using (var ctx = new SPWEntities())
{
var list = ctx.ORDER_DETAIL.Where(x => x.SYE_DEL == true).ToList();
return list;
}
}
public List<PRODUCT_DETAIL> Select(int ID)
{
using (var ctx = new SPWEntities())
{
var list = ctx.PRODUCT_DETAIL.Include("ZONE").Where(x => x.PRODUCT_ID == ID).ToList();
return list;
}
}
public ROLE_FUNCTION Select(int ID)
{
using (var ctx = new SPWEntities())
{
var list = ctx.ROLE_FUNCTION.Where(x => x.ROLE_FUNCTION_ID == ID).FirstOrDefault();
return list;
}
}
public List<ROLE_FUNCTION> GetALLIncludeFunction(int roleId)
{
using (var ctx = new SPWEntities())
{
var list = ctx.ROLE_FUNCTION.Include("FUNCTION").Where(x => x.ROLE_ID == roleId && x.SYE_DEL == true).ToList();
return list;
}
}
public DELIVERY_ORDER Select(int ID)
{
using (var ctx = new SPWEntities())
{
var list = ctx.DELIVERY_ORDER.Include("DELIVERY_ORDER_DETAIL").Where(x => x.DELORDER_ID == ID).FirstOrDefault();
return list;
}
}
public List<PRODUCT_COLOR> GetALLInclude(int productID)
{
using (var ctx = new SPWEntities())
{
var list = ctx.PRODUCT_COLOR.Include("COLOR").Where(x => x.SYE_DEL == true && x.PRODUCT_ID == productID).OrderBy(x => x.COLOR.COLOR_TYPE_ID).ToList();
return list;
}
}
public List<PRODUCT_DETAIL> GetALL(int productID)
{
using (var ctx = new SPWEntities())
{
var list = ctx.PRODUCT_DETAIL.Where(x => x.SYE_DEL == true && x.PRODUCT_ID == productID).OrderBy(x => x.ZONE_ID).ToList();
return list;
}
}
public List<PRODUCT_DETAIL> GetALLInclude()
{
using (var ctx = new SPWEntities())
{
var list = ctx.PRODUCT_DETAIL.Include("PRODUCT").Where(x => x.SYE_DEL == true).ToList();
return list;
}
}
public List<USER> GetALL(string name)
{
using (var ctx = new SPWEntities())
{
var list = ctx.USER.Where(x => x.USER_NAME.Contains(name)).ToList();
return list;
}
}
public List<USER> GetALLInclude()
{
using (var ctx = new SPWEntities())
{
var list = ctx.USER.Include("EMPLOYEE").Where(x => x.SYE_DEL == true).ToList();
return list;
}
}
public void Add()
{
using (var ctx = new SPWEntities())
{
ctx.USER.Add(_item);
ctx.SaveChanges();
}
}
public List<USER> GetALL()
{
using (var ctx = new SPWEntities())
{
var list = ctx.USER.Where(x => x.SYE_DEL == true).ToList();
return list;
}
}
public List<DELIVERY_ORDER> GetALLInclude()
{
using (var ctx = new SPWEntities())
{
var list = ctx.DELIVERY_ORDER.Include("DELIVERY_ORDER_DETAIL").Where(x => x.SYE_DEL == true).ToList();
return list;
}
}
public VEHICLE Select(int ID)
{
using (var ctx = new SPWEntities())
{
var list = ctx.VEHICLE.Where(x => x.VEHICLE_ID == ID).FirstOrDefault();
return list;
}
}
public List<ROLE_FUNCTION> GetALL()
{
using (var ctx = new SPWEntities())
{
var list = ctx.ROLE_FUNCTION.Where(x => x.SYE_DEL == true).ToList();
return list;
}
}
public ORDER_DETAIL Select(int ID)
{
using (var ctx = new SPWEntities())
{
var list = ctx.ORDER_DETAIL.Where(x => x.ORDER_DETAIL_ID == ID).FirstOrDefault();
return list;
}
}
public List<ORDER_DETAIL> GetALLIncludeByOrder(int ID)
{
using (var ctx = new SPWEntities())
{
var list = ctx.ORDER_DETAIL.Include("PRODUCT").Where(x => x.SYE_DEL == true && x.ORDER_ID == ID).ToList();
return list;
}
}
public List<ROAD> GetALL()
{
using (var ctx = new SPWEntities())
{
var list = ctx.ROAD.ToList();
return list;
}
}
public void Delete(int ID)
{
using (var ctx = new SPWEntities())
{
var obj = ctx.ROLE_FUNCTION.Where(x => x.ROLE_FUNCTION_ID == ID).FirstOrDefault();
ctx.ROLE_FUNCTION.Remove(obj);
ctx.SaveChanges();
}
}
public List<VEHICLE> GetALL(string subname, string name)
{
using (var ctx = new SPWEntities())
{
var list = ctx.VEHICLE.Where(x => x.VEHICLE_CODE.Contains(subname)
&& x.VEHICLE_REGNO.Contains(name)).ToList();
return list;
}
}
//public List<COLOR> GetALLInclude()
//{
// using (var ctx = new SPWEntities())
// {
// var list = ctx.COLOR.Include("COLOR_TYPE").Where(x => x.SYE_DEL == true).ToList();
// return list;
// }
//}
public List<COLOR> GetALL(string subname, string name)
{
using (var ctx = new SPWEntities())
{
var list = ctx.COLOR.Where(x => x.COLOR_SUBNAME.Contains(subname)
&& x.COLOR_NAME.Contains(name)).ToList();
return list;
}
}
public void Edit()
{
using (var ctx = new SPWEntities())
{
var obj = ctx.DELIVERY_ORDER.Where(x => x.DELORDER_ID == _item.DELORDER_ID).FirstOrDefault();
obj.DELORDER_CODE = _item.DELORDER_CODE;
obj.UPDATE_DATE = _item.UPDATE_DATE;
obj.UPDATE_EMPLOYEE_ID = _item.UPDATE_EMPLOYEE_ID;
ctx.SaveChanges();
}
}
