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