public JsonResult SaveProvince(ProvinceData information)
{
try
{
Provinces province = new Provinces();
string status = string.Empty;
if (information.Id == 0)
{
province = new Provinces()
{
Cases = information.Cases,
Deaths = information.Deaths,
ProvName = information.Name
};
db.Provinces.Add(province);
status = "added";
}
else
{
province = db.Provinces.FirstOrDefault(x => x.ProvinceId == information.Id);
province.Deaths = information.Deaths;
province.Cases = information.Cases;
status = "edited";
}
db.SaveChanges();
return(Json(new { error = false, message = "The Province was " + status + "success" }));
}
catch (Exception e)
{
return(Json(new { error = true, message = "Error to save Province" }));
}
}
public static Province ToModel(this ProvinceData node)
{
return(new Province()
{
Id = node.Id,
Name = node.Name,
Sort = node.Sort,
Remark = node.Remark
});
}
public Node(int x, int y, ProvinceData pd)
{
Connections = new List <Connection>();
X = x;
Y = y;
ProvinceData = pd;
IsCapRing = false;
IsAssignedTerrain = false;
IsWrapCorner = false;
}
//Place on Map
public Unit PlaceOnMap(Map map, ProvinceData province)
{
//Assign
this.province = province;
this.map = map;
//Coordinates from province center in 3D World
transform.position = province.center3D;
return(this);
}
protected override void Seed(DurandalAuthDbContext context)
{
var userManager = new UserManager <UserProfile>(new UserStore <UserProfile>(context));
var roleManager = new RoleManager <IdentityRole>(new RoleStore <IdentityRole>(context));
if (!roleManager.RoleExists("Administrator"))
{
roleManager.Create(new IdentityRole("Administrator"));
}
if (!roleManager.RoleExists("User"))
{
roleManager.Create(new IdentityRole("User"));
}
if (userManager.FindByName("admin") == null)
{
var user = new UserProfile {
UserName = "******", Email = "*****@*****.**", EmailConfirmed = true
};
var result = userManager.Create(user, "admin1234");
if (result.Succeeded)
{
userManager.AddToRole(user.Id, "Administrator");
}
}
var uow = new DurandalAuthDbContext();
var hasChanges = false;
//SetCategoryData(uow);
ProvinceData.SetProvinceData(uow, ref hasChanges);
GenderData.SetGenderData(uow, ref hasChanges);
// EthnicityData.SetEthnicityData(uow, ref hasChanges);
//LanguageData.SetLanguageData(uow, ref hasChanges);
EmploymentData.SetEmploymentStatus(uow, ref hasChanges);
/* PsiraGradeData.SetPsiraGradeData(uow, ref hasChanges);
* SecurityTrainingData.SetSecurityTrainingData(uow, ref hasChanges);*/
DecisionData.SetYesNoLookupData(uow, ref hasChanges);
//PsiraCategoryData.SetPsiraCategoryLookup(uow, ref hasChanges);
//CityData.SetCityNameData(uow, ref hasChanges);
AddressData.SetAddressData(uow, ref hasChanges);
//MaritalStatusData.SetMaritalStatusData(uow, ref hasChanges);
EntityTypeData.SetEntityData(uow, ref hasChanges);
TitleData.SetTitleData(uow, ref hasChanges);
if (hasChanges)
{
uow.SaveChanges();
}
}
public void UpdateProvinceData(ProvinceData provinceData)
{
this.ProvinceData = provinceData;
province = GameObject.FindGameObjectsWithTag("Province")
.Single(p => p.GetComponent <ProvinceController>().ProvinceData.Name.Equals(ProvinceData.Name))
.GetComponent <ProvinceController>();
UpdateBuildingsButtonState();
UpdateDeclareWarButtonState();
if (buildingSlotsPanel.activeSelf)
{
UpdateProvinceSlots();
}
}
private void search()
{
searDefine();
Dictionary <Color, int> result = new Dictionary <Color, int>();
if (kProvinceMap == null)
{
return;
}
var width = kProvinceMap.width;
var height = kProvinceMap.height;
LC_Helper.Loop(width, (i) =>
{
LC_Helper.Loop(height, (j) =>
{
var col = kProvinceMap.GetPixel(i, j);
var count = 0;
if (result.TryGetValue(col, out count))
{
result[col] = count + 1;
}
else
{
result.Add(col, 1);
}
});
});
kProvinceCount = result.Count;
kProvinceData = new ProvinceData[ConfigParam.MAXProvinceCount];
int flag = 0;
foreach (var colcount in result)
{
var col = colcount.Key;
kProvinceColorToIDMap.TryGetValue(col, out flag);
kProvinceData[flag] = new ProvinceData(flag, col);
}
kProvincePolitimap = new Texture2D(ConfigParam.BLOCKMAXWIDTH, ConfigParam.BLOCKMAXHEIGHT);
Graphics.ConvertTexture(kProvinceMap, kProvincePolitimap);
//DebugProvinceCol();
ChangeProvinceColor();
}
public ProvinceData CloneAs(int newId)
{
ProvinceData result = new ProvinceData();
result.id = newId;
result.name = name;
result.income = income;
result.manpower = manpower;
result.favor = favor;
result.raceId = raceId;
result.factionId = factionId;
result.trainable = trainable;
result.units = units;
result.training = training;
return(result);
}
public void OnEnable()
{
if (Player.curRegion == null)
{
return;
}
data = Player.curRegion.data;
image.sprite = SpriteHandler.GetBuilding(BuildIndex, (int)Player.curPlayer.fraction);
UpdateState();
Player.curPlayer.TreasureChange += UpdateState;
CurBuildAction = data.BuildingAction[BuildIndex];
if (CurBuildAction != null)
{
CurBuildAction.onAction += UpdateState;
}
}
public static ProvinceData ToViewData(this Province node, CategoryDictionary suffix = CategoryDictionary.None)
{
if (node == null)
{
return(null);
}
var model = new ProvinceData()
{
Id = node.Id,
Name = node.Name,
Sort = node.Sort,
Remark = node.Remark,
Buildings = (suffix & CategoryDictionary.Building) == CategoryDictionary.Building ? node.Buildings.Select(x => x.ToViewData()).ToList() : null,
Organizations = (suffix & CategoryDictionary.Organization) == CategoryDictionary.Organization ? node.Organizations.Select(x => x.ToViewData()).ToList() : null,
Cities = (suffix & CategoryDictionary.City) == CategoryDictionary.City ? node.Cities.Select(x => x.ToViewData()).ToList() : null,
};
return(model);
}
public ProvinceData getProvince(string Province_Code)
{
ProvinceData province_data = new ProvinceData();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From PROVINCE Where PROVINCE_CODE = '" + Province_Code + "'";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
province_data.Province_Code = rowData["PROVINCE_CODE"].ToString();
province_data.Province_ThaiName = rowData["PROVINCE_THAI"].ToString();
province_data.Province_EngName = rowData["PROVINCE_ENG"].ToString();
}
return(province_data);
}
public List <ProvinceData> getProvince()
{
List <ProvinceData> province_data = new List <ProvinceData>();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From PROVINCE Order By PROVINCE_THAI";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
ProvinceData province = new ProvinceData();
province.Province_Code = rowData["PROVINCE_CODE"].ToString();
province.Province_ThaiName = rowData["PROVINCE_THAI"].ToString();
province.Province_EngName = rowData["PROVINCE_ENG"].ToString();
province_data.Add(province);
}
return(province_data);
}
public static void Main()
{
var host = CreateHostBuilder();
using (var scope = host.Services.CreateScope())
{
var services = scope.ServiceProvider;
var context = services.GetRequiredService <WebAppDBContext>();
AccountData.Initialize(context);
AdminData.Initialize(context);
FunctionData.Initialize(context);
ProductData.Initialize(context);
ProductTypeData.Initialize(context);
SaleData.Initialize(context);
RegionData.Initialize(context);
ProvinceData.Initialize(context);
WardData.Initialize(context);
AuthorData.Initialize(context);
}
host.Run();
}
public RecruitAction(ProvinceData prov, BaseRegiment reg, float dt) : base(dt)
{
//type = TypeGameAction.RecruitGameAction;
regiment = reg;
onAction += () => prov.RecruitRegiment(this);
}
public static void toComponent(ProvinceData provinceData, Province province)
{
toComponent(provinceData.descriptorData, province.descriptor);
}
/// <summary>
/// Class constructor
/// </summary>
/// <param name="data">Province data loaded from a save</param>
/// <param name="dwellers">Race that populates the province</param>
/// <param name="owners">Faction that owns the province</param>
/// <param name="allUnitTypes">A hash of id => unit type that includes all unit types in the game</param>
public Province(ProvinceData data, Race dwellers, Faction owners, Dictionary <int, UnitType> allUnitTypes)
{
_data = data;
_dwellers = dwellers;
_owners = owners;
if (_data.raceId != dwellers.GetId())
{
Debug.Log("Bad race data for province " + _data.id + ": " + _data.raceId + " is changed to " + dwellers.GetId());
_data.raceId = dwellers.GetId();
}
if (_data.factionId != owners.GetId())
{
Debug.Log("Bad faction data for province " + _data.id + ": " + _data.factionId + " is changed to " + owners.GetId());
_data.factionId = owners.GetId();
}
_neighbors = new List <Province>();
_units = new List <Unit>();
for (int i = 0; i < data.units.Length; i++)
{
_units.Add(new Unit(data.units[i], allUnitTypes[data.units[i].id]));
}
_trainingOrders = new Dictionary <UnitType, UnitTrainingOrder>();
if (data.training != null && data.training.Length > 0)
{
for (int i = 0; i < data.training.Length; i++)
{
UnitTrainingOrderData order = data.training[i];
// order.id is unit type id just for conspiration
UnitType unitType = allUnitTypes[order.id];
_trainingOrders[unitType] = new UnitTrainingOrder(order, allUnitTypes);
}
}
_trainable = new List <UnitType>();
int minTrainingCost = 100500; // means "a lot"
// if the province doesn't have defined trainable unit types, use the list of racial units
if (_data.trainable == null || _data.trainable.Length == 0)
{
List <UnitType> racialUnits = _dwellers.GetRacialUnits();
for (int i = 0; i < racialUnits.Count; i++)
{
// heroes can't be trained
if (racialUnits[i].IsTrainable())
{
_trainable.Add(racialUnits[i]);
if (!racialUnits[i].IsHoly())
{
minTrainingCost = Math.Min(minTrainingCost, racialUnits[i].GetTrainingCost());
}
}
}
}
else
{
for (int i = 0; i < _data.trainable.Length; i++)
{
UnitType unitType = allUnitTypes[_data.trainable[i]];
if (unitType != null && unitType.IsTrainable())
{
_trainable.Add(unitType);
if (!unitType.IsHoly())
{
minTrainingCost = Math.Min(minTrainingCost, unitType.GetTrainingCost());
}
}
}
}
SelectCheapestToTrainUnits(minTrainingCost);
}
public void SetPlayerInfo(PlayerData n, ProvinceData pd)
{
Nation = n;
ProvinceData = pd;
}
public Node(int x, int y, ProvinceData pd, PlayerData n) : this(x, y, pd)
{
Nation = n;
}
private object GetProvinceData()
{
ProvinceData provinceData = new ProvinceData();
DataSet tmpData = new DataSet();
try
{
string Sql_GetProvinceInfo =
@"Select ProvinceID,ProvinceCode,ProvinceName,ProvinceType,'' InterfaceUrl, RegionProvince " +
"From [dbo].[Province]";
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = Sql_GetProvinceInfo;
// 获取数据
tmpData = DBUtility.FillData(cmd, DBUtility.BestToneCenterConStr);
// 数据转换
// DataSet --> SPData
int intTargetColumnCount = provinceData.Tables[ProvinceData.TableName].Columns.Count;
foreach (DataRow row in tmpData.Tables[0].Rows)
{
object[] newRow = new object[intTargetColumnCount];
for (int j = 0; j < intTargetColumnCount; j++)
{
newRow[j] = row[j];
}
provinceData.Tables[ProvinceData.TableName].Rows.Add(newRow);
}
}
catch (Exception Ex)
{
throw Ex;
}
return provinceData;
}
// PROVINCE_DATA <-> PROVINCE
public static ProvinceData fromComponent(Province province)
{
if (province == null) {
return null;
}
ProvinceData provinceData = new ProvinceData();
provinceData.descriptorData = fromComponent(province.descriptor);
return provinceData;
}
