public List <Address> insert(List <Address> data) { using (var con = new DeliverySaveContext()) { var addressNew = new List <Address>(); foreach (var item in data) { var address = con.Addresses.Where(x => x.id == item.id).FirstOrDefault(); if (address != null) { address.name = item.name; address.pid = item.pid; address.type = item.type; address.region = item.region; address.alias = item.alias; address.is_picked = item.is_picked; address.is_delivered = item.is_delivered; con.SaveChanges(); } else { addressNew.Add(item); } } con.Addresses.AddRange(addressNew); con.SaveChanges(); return(data); } }
public Address insert(Address data) { using (var con = new DeliverySaveContext()) { var address = con.Addresses.Where(x => x.id == data.id).FirstOrDefault(); if (address != null) { address.name = data.name; address.pid = data.pid; address.type = data.type; address.region = data.region; address.alias = data.alias; address.is_picked = data.is_picked; address.is_delivered = data.is_delivered; con.SaveChanges(); return(address); } else { con.Addresses.Add(data); con.SaveChanges(); return(data); } } }
public List <Address> getAll() { using (var con = new DeliverySaveContext()) { var address = con.Addresses.ToList(); return(address); } }
public List <Address> getAllWard(string districtID) { using (var con = new DeliverySaveContext()) { var wards = con.Addresses .Where(x => x.pid == districtID) .ToList(); return(wards); } }
public List <Address> getAllDistrict(string provinceID) { using (var con = new DeliverySaveContext()) { var districts = con.Addresses .Where(x => x.pid == provinceID) .ToList(); return(districts); } }
public List <Address> getAllProvince() { using (var con = new DeliverySaveContext()) { var provinces = con.Addresses. Where(x => x.pid == null) .ToList(); return(provinces); } }