private bool Save()
{
bool result = false;
using (var ctx = new EF6.RT2020Entities())
{
var city = ctx.City.Find(this.CityId);
if (city == null)
{
city = new EF6.City();
city.CityId = new Guid();
ctx.City.Add(city);
city.CityCode = txtCityCode.Text;
}
city.CityName = txtCityName.Text;
city.CityName_Chs = txtCityNameAlt1.Text;
city.CityName_Cht = txtCityNameAlt2.Text;
city.ProvinceId = new Guid(cboProvince.SelectedValue.ToString());
ctx.SaveChanges();
result = true;
}
return(result);;
}
private static string GetFormatedText(EF6.City target, string[] textField, string textFormatString)
{
for (int i = 0; i < textField.Length; i++)
{
PropertyInfo pi = target.GetType().GetProperty(textField[i]);
textFormatString = textFormatString.Replace("{" + i.ToString() + "}", pi != null ? pi.GetValue(target, null).ToString() : string.Empty);
}
return(textFormatString);
}
/// <summary>
/// Get a EF6.City object from the database using the given CityId
/// </summary>
/// <param name="cityId">The primary key value</param>
/// <returns>A EF6.City object</returns>
public static EF6.City Get(Guid cityId)
{
EF6.City result = null;
using (var ctx = new EF6.RT2020Entities())
{
result = ctx.City.Where(x => x.CityId == cityId).AsNoTracking().FirstOrDefault();
}
return(result);
}
/// <summary>
/// Get a EF6.City object from the database using the given QueryString
/// </summary>
/// <param name="cityId">The primary key value</param>
/// <returns>A EF6.City object</returns>
public static EF6.City Get(string whereClause)
{
EF6.City result = null;
using (var ctx = new EF6.RT2020Entities())
{
result = ctx.City
.SqlQuery(string.Format("Select * from City Where {0}", whereClause))
.AsNoTracking()
.FirstOrDefault();
}
return(result);
}
/// <summary>
/// 寫啲 default values 入：
/// dbo.Province = Region; dbo.City = District
/// </summary>
/// <returns></returns>
public static bool WriteDefaultValues()
{
bool result = false;
using (var ctx = new EF6.RT2020Entities())
{
ctx.Configuration.LazyLoadingEnabled = false;
using (var scope = ctx.Database.BeginTransaction())
{
try
{
#region dbo.Country
var country = ctx.Country.Where(x => x.CountryCode == "HK").FirstOrDefault();
if (country == null)
{
country = new EF6.Country();
country.CountryId = Guid.NewGuid();
ctx.Country.Add(country);
}
country.CountryCode = HongKong.Id;
country.CountryName = HongKong.Name;
country.CountryName_Chs = HongKong.NameAlt1;
country.CountryName_Cht = HongKong.NameAlt2;
ctx.SaveChanges();
#endregion
#region dbo.Province
foreach (var item in Region)
{
var code = String.Format("{0}.{1}", country.CountryCode, item.Id);
var province = ctx.Province.Where(x => x.ProvinceCode == code).FirstOrDefault();
if (province == null)
{
province = new EF6.Province()
{
ProvinceId = Guid.NewGuid(),
ProvinceCode = String.Format("{0}.{1}", country.CountryCode, item.Id)
};
ctx.Province.Add(province);
}
province.ProvinceName = item.Name;
province.ProvinceName_Chs = item.NameAlt1;
province.ProvinceName_Cht = item.NameAlt2;
province.CountryId = country.CountryId;
}
ctx.SaveChanges();
#endregion
#region cbo.City
foreach (var item in District)
{
var parent = String.Format("{0}.{1}", country.CountryCode, item.Parent);
var province = ctx.Province.Where(x => x.ProvinceCode == parent).FirstOrDefault();
if (province != null)
{
var code = String.Format("{0}.{1}", province.ProvinceCode, item.Id);
var city = ctx.City.Where(x => x.CityCode == code).FirstOrDefault();
if (city == null)
{
city = new EF6.City()
{
CityId = Guid.NewGuid(),
CityCode = String.Format("{0}.{1}", province.ProvinceCode, item.Id),
};
ctx.City.Add(city);
}
city.CityName = item.Name;
city.CityName_Chs = item.NameAlt1;
city.CityName_Cht = item.NameAlt2;
city.ProvinceId = province.ProvinceId;
}
}
ctx.SaveChanges();
#endregion
scope.Commit();
result = true;
}
catch
{
scope.Rollback();
}
}
}
return(result);
}
