public static void DeleteProfileAddress(int id) { using (var db = new Data.DrinkzAppBDDataContext()) { var dbAddress = db.Addresses.Where(c => c.FK_PROFILE == id).FirstOrDefault(); db.Addresses.DeleteOnSubmit(dbAddress); db.SubmitChanges(); } }
public static void UpdateAddress(Dto.Address address) { using (var db = new Data.DrinkzAppBDDataContext()) { var dbAddress = db.Addresses.Where(c=> c.FK_PROFILE == address.FK_PROFILE).FirstOrDefault(); dbAddress.STATE = address.STATE; dbAddress.ZIP_CODE = address.ZIP_CODE; dbAddress.STREET = address.STREET; db.SubmitChanges(); } }
public static void UpdateProfile(Dto.Profile Profile) { using (var db = new Data.DrinkzAppBDDataContext()) { var dbProfile = db.Profiles.Where(c => c.PK_PROFILE == Profile.PK_PROFILE).FirstOrDefault(); dbProfile.OS_ID = Profile.OS_ID; dbProfile.NAME = Profile.NAME; dbProfile.URL_IMAGE = Profile.URL_IMAGE; dbProfile.DEVICE_ID = Profile.DEVICE_ID; dbProfile.FACEBOOK_ID = Profile.FACEBOOK_ID; db.SubmitChanges(); } }
public static Dto.Address GetAddressById(int Id) { using (var db = new Data.DrinkzAppBDDataContext()) { return db.Addresses.Where(c => c.FK_PROFILE == Id).Select(c => new Dto.Address { FK_PROFILE = c.FK_PROFILE, PK_ADDRESS = c.PK_ADDRESS, STATE = c.STATE, STREET = c.STREET, ZIP_CODE = c.ZIP_CODE }).FirstOrDefault(); } }
public static Dto.Profile GetProfileById(int id) { using (var db = new Data.DrinkzAppBDDataContext()) { return db.Profiles.Where(c => c.PK_PROFILE == id).Select(c => new Dto.Profile { DEVICE_ID = c.DEVICE_ID, FACEBOOK_ID = c.DEVICE_ID, NAME = c.NAME, URL_IMAGE = c.URL_IMAGE, OS_ID = c.OS_ID, PK_PROFILE = c.PK_PROFILE }).FirstOrDefault(); } }
public static void CreateNewAddress(Dto.Address address) { using (var db = new Data.DrinkzAppBDDataContext()) { var dbAddress = new Data.Address() { FK_PROFILE = address.FK_PROFILE, STATE = address.STATE, STREET = address.STREET, ZIP_CODE = address.ZIP_CODE, }; db.Addresses.InsertOnSubmit(dbAddress); db.SubmitChanges(); } }