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(); } }