public void EditList()
{
using (var ctx = new SPWEntities())
{
foreach (var item in _lstItem)
{
if (item.Action == ActionEnum.Update)
{
var obj = ctx.STORE.Where(x => x.STORE_ID == item.STORE_ID).FirstOrDefault();
if (obj != null)
{
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.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 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 void Edit()
{
using (var ctx = new SPWEntities())
{
var obj = ctx.PRODUCT.Where(x => x.PRODUCT_ID == _item.PRODUCT_ID).FirstOrDefault();
obj.PRODUCT_CODE = _item.PRODUCT_CODE;
obj.PRODUCT_NAME = _item.PRODUCT_NAME;
obj.PRODUCT_SIZE = _item.PRODUCT_SIZE;
obj.PRODUCT_WEIGHT = _item.PRODUCT_WEIGHT;
obj.PRODUCT_PACKING_DESC = _item.PRODUCT_PACKING_DESC;
obj.PRODUCT_PACKING_PER_PDESC = _item.PRODUCT_PACKING_PER_PDESC;
obj.PRODUCT_PACKING_PER_UDESC = _item.PRODUCT_PACKING_PER_UDESC;
obj.PRODUCT_PACKING_QTY = _item.PRODUCT_PACKING_QTY;
obj.PRODUCT_TYPE_CODE = _item.PRODUCT_TYPE_CODE;
obj.PRODUCT_WEIGHT_DEFINE = _item.PRODUCT_WEIGHT_DEFINE;
if (_item.PRODUCT_IMAGE_PATH != null)
{
obj.PRODUCT_IMAGE_PATH = _item.PRODUCT_IMAGE_PATH;
}
obj.CATEGORY_ID = _item.CATEGORY_ID;
obj.UPDATE_DATE = _item.UPDATE_DATE;
obj.UPDATE_EMPLOYEE_ID = _item.UPDATE_EMPLOYEE_ID;
ctx.SaveChanges();
}
}
public ZONE Select(int ID)
{
using (var ctx = new SPWEntities())
{
var list = ctx.ZONE.Where(x => x.ZONE_ID == ID).FirstOrDefault();
return(list);
}
}
public List <ZONE> GetALL()
{
using (var ctx = new SPWEntities())
{
var list = ctx.ZONE.Where(x => x.SYE_DEL == true).ToList();
return(list);
}
}
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 <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 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 <CATEGORY> GetALL(CATEGORY item)
{
using (var ctx = new SPWEntities())
{
var list = ctx.CATEGORY.Where(x => x.CATEGORY_CODE.Contains(item.CATEGORY_CODE)).ToList();
return(list);
}
}
public USER SelectIncludeEmployee(int ID)
{
using (var ctx = new SPWEntities())
{
var list = ctx.USER.Include("EMPLOYEE").Where(x => x.USER_ID == ID).FirstOrDefault();
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 DEPARTMENT Select(int ID)
{
using (var ctx = new SPWEntities())
{
var list = ctx.DEPARTMENT.Where(x => x.DEPARTMENT_ID == ID).FirstOrDefault();
return(list);
}
}
public List <DEPARTMENT> GetALL(DEPARTMENT item)
{
using (var ctx = new SPWEntities())
{
var list = ctx.DEPARTMENT.Where(x => x.DEPARTMENT_CODE.Contains(item.DEPARTMENT_CODE)).ToList();
return(list);
}
}
public List <DEPARTMENT> GetALL()
{
using (var ctx = new SPWEntities())
{
var list = ctx.DEPARTMENT.Where(x => x.SYE_DEL == true).ToList();
return(list);
}
}
public List <ROAD> GetALL()
{
using (var ctx = new SPWEntities())
{
var list = ctx.ROAD.ToList();
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 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 USER SelectIncludeUserRole(int ID)
{
using (var ctx = new SPWEntities())
{
var list = ctx.USER.Include("ROLE").Where(x => x.USER_ID == ID).FirstOrDefault();
return(list);
}
}
public CATEGORY Select(int ID)
{
using (var ctx = new SPWEntities())
{
var list = ctx.CATEGORY.Where(x => x.CATEGORY_ID == ID).FirstOrDefault();
return(list);
}
}
public USER SelectInclude(string username, string password)
{
using (var ctx = new SPWEntities())
{
var list = ctx.USER.Include("EMPLOYEE").Include("ROLE").Where(x => x.USER_NAME == username && x.PASSWORD == password).FirstOrDefault();
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 <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 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 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 FUNCTION Select(int ID)
{
using (var ctx = new SPWEntities())
{
var list = ctx.FUNCTION.Where(x => x.FUNCTION_ID == ID).FirstOrDefault();
return(list);
}
}
public void Add()
{
using (var ctx = new SPWEntities())
{
ctx.DELIVERY_ORDER.Add(_item);
ctx.SaveChanges();
}
}
public List <ZONE> GetALL(ZONE item)
{
using (var ctx = new SPWEntities())
{
var list = ctx.ZONE.Where(x => x.ZONE_CODE.Contains(item.ZONE_CODE)).ToList();
return(list);
}
}
public List <ZONE_DETAIL> GetALLInclude(int ID)
{
using (var ctx = new SPWEntities())
{
var list = ctx.ZONE_DETAIL.Include("ZONE").ToList().Where(x => x.SYE_DEL == true && x.EMPLOYEE_ID == ID).ToList();
return(list);
}
}
public void Add()
{
using (var ctx = new SPWEntities())
{
ctx.ZONE.Add(_item);
ctx.SaveChanges();
}
}
public List <ORDER_DETAIL> GetALL()
{
using (var ctx = new SPWEntities())
{
var list = ctx.ORDER_DETAIL.Where(x => x.SYE_DEL == true).ToList();
return(list);
}
}
