public ActionResult Create(Ministers Minister)
{
if (Request.IsAuthenticated)
{
Minister.ActionType = "CREATE";
string InsertUser = User.Identity.GetUserName();
var r = MBL.AddNew(Minister, InsertUser);
if (!r)
{
ViewBag.Mensaje = "Ha ocurrido un error inesperado.";
return(View("~/Views/Shared/Error.cshtml"));
}
else
{
return(View(Minister));
}
}
else
{
return(this.RedirectToAction("Login", "Account"));
}
}
/// <summary>
/// データを遅延読み込み中かどうかを判定する
/// </summary>
/// <returns>データを遅延読み込み中ならばtrueを返す</returns>
private static bool IsLoadingData()
{
return(Leaders.IsLoading() ||
Ministers.IsLoading() ||
Teams.IsLoading() ||
Provinces.IsLoading() ||
Techs.IsLoading() ||
Units.IsLoading() ||
Maps.IsLoading());
}
//
// GET: /Ministers/Create
public ActionResult Create()
{
if (Request.IsAuthenticated)
{
Ministers Minister = new Ministers();
return(View(Minister));
}
else
{
return(this.RedirectToAction("Login", "Account"));
}
}
public bool AddNew(Ministers Minister, string InsertUser)
{
bool rpta = false;
try
{
using (var SqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["DB_MDA_CR_OA_Connection"].ToString()))
{
SqlCon.Open();
var SqlCmd = new SqlCommand("[ministry].[uspAddMinister]", SqlCon)
{
CommandType = CommandType.StoredProcedure
};
//Insert Parameters
SqlParameter ParName = new SqlParameter
{
ParameterName = "@MinisterName",
SqlDbType = SqlDbType.VarChar,
Size = 50,
Value = Minister.MinisterName
};
SqlCmd.Parameters.Add(ParName);
SqlParameter ParInsertUser = new SqlParameter
{
ParameterName = "@InsertUser",
SqlDbType = SqlDbType.VarChar,
Size = 50,
Value = InsertUser
};
SqlCmd.Parameters.Add(ParInsertUser);
//Exec Command
SqlCmd.ExecuteNonQuery();
rpta = true;
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
}
}
catch (Exception ex)
{
throw;
}
return(rpta);
}
public override void Deserialize(GenericReader reader)
{
base.Deserialize(reader);
int v = reader.ReadInt();
City = (City)reader.ReadInt();
if (CitySystem != null)
{
CitySystem.Minister = this;
}
Ministers.Add(this);
}
public List <Ministers> List(bool ActiveFlag)
{
List <Ministers> List = new List <Ministers>();
try
{
SqlCon.Open();
var SqlCmd = new SqlCommand("[config].[uspReadMinisters]", SqlCon)
{
CommandType = CommandType.StoredProcedure
};
if (ActiveFlag == true)
{
SqlParameter parStatus = new SqlParameter
{
ParameterName = "@pActiveFlag",
SqlDbType = SqlDbType.Bit,
Value = ActiveFlag
};
SqlCmd.Parameters.Add(parStatus);
}
using (var dr = SqlCmd.ExecuteReader())
{
while (dr.Read())
{
var detail = new Ministers
{
MinisterID = Convert.ToInt32(dr["MinisterID"]),
Title = dr["Title"].ToString(),
FullName = dr["FullName"].ToString(),
Photo = dr["Photo"].ToString(),
ActiveFlag = Convert.ToBoolean(dr["ActiveFlag"])
};
List.Add(detail);
}
}
}
catch (Exception ex)
{
throw ex;
}
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
return(List);
}
/// <summary>
/// 編集済みかどうかを取得する
/// </summary>
/// <returns>編集済みならばtrueを返す</returns>
public static bool IsDirty()
{
return(Misc.IsDirty() ||
Config.IsDirty() ||
Leaders.IsDirty() ||
Ministers.IsDirty() ||
Teams.IsDirty() ||
Provinces.IsDirty() ||
Techs.IsDirty() ||
Units.IsDirty() ||
CorpsNames.IsDirty() ||
UnitNames.IsDirty() ||
RandomLeaders.IsDirty() ||
Scenarios.IsDirty());
}
public void Save(IEnumerable <JudmentDocumentModel> data)
{
IDictionary <long, JudmentDocument> judmentDocsDict = new Dictionary <long, JudmentDocument>();
var judmentDocs = data.Select(x => x.ToJudmentDocument());
foreach (var document in judmentDocs)
{
judmentDocsDict.Add(document.ProcessNumber, document);
}
Ministers.Save(ref judmentDocsDict);
JudmentDocuments.Save(ref judmentDocsDict);
Parties.Save(ref judmentDocsDict);
Votes.Save(ref judmentDocsDict);
}
/// <summary>
/// データを保存する
/// </summary>
private static void SaveFiles()
{
if (!Misc.Save())
{
return;
}
if (!Config.Save())
{
return;
}
if (!Leaders.Save())
{
return;
}
if (!Ministers.Save())
{
return;
}
if (!Teams.Save())
{
return;
}
if (!Provinces.Save())
{
return;
}
if (!Techs.Save())
{
return;
}
if (!Units.Save())
{
return;
}
if (!CorpsNames.Save())
{
return;
}
if (!UnitNames.Save())
{
return;
}
if (!RandomLeaders.Save())
{
return;
}
Scenarios.Save();
}
private string GetIncomplete()
{
if (contact == null)
{
LoadContact(ContactId);
}
var sb = new StringBuilder();
Append(Ministry.Value == "0", sb, "no ministry");
Append(ContactType.Value == "0", sb, "no type");
Append(ContactReason.Value == "0", sb, "no reason");
Append(Ministers.Count() == 0, sb, "no contactors");
Append(MinisteredTo.Count() == 0, sb, "no contactees");
if (sb.Length > 0)
{
return(sb.ToString());
}
return("");
}
public TradeMinister(City city) : base(AIType.AI_Vendor, FightMode.None, 10, 1, .4, .2)
{
City = city;
SpeechHue = 0x3B2;
Female = Utility.RandomDouble() > 0.75;
Blessed = true;
Name = Female ? NameList.RandomName("female") : NameList.RandomName("male");
Title = "the minister of trade";
Body = Female ? 0x191 : 0x190;
HairItemID = Race.RandomHair(Female);
FacialHairItemID = Race.RandomFacialHair(Female);
HairHue = Race.RandomHairHue();
Hue = Race.RandomSkinHue();
SetStr(150);
SetInt(50);
SetDex(150);
EquipItem(new Cloak(1157));
EquipItem(new BodySash(1326));
ChainChest chest = new ChainChest
{
Hue = 1908
};
EquipItem(chest);
ThighBoots boots = new ThighBoots
{
Hue = 1908
};
EquipItem(boots);
EquipItem(new GoldRing());
Ministers.Add(this);
Frozen = true;
}
/// <summary>
/// コピー/移動先コンボボックスの選択項目変更時の処理
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void OnDestComboBoxSelectedIndexChanged(object sender, EventArgs e)
{
if (destComboBox.SelectedIndex < 0)
{
return;
}
if (!copyRadioButton.Checked && !moveRadioButton.Checked)
{
copyRadioButton.Checked = true;
}
// 開始ID数値アップダウンの数値が変更されていなければ変更する
if (!_idChanged)
{
idNumericUpDown.ValueChanged -= OnIdNumericUpDownValueChanged;
idNumericUpDown.Value = Ministers.GetNewId(Countries.Tags[destComboBox.SelectedIndex]);
idNumericUpDown.ValueChanged += OnIdNumericUpDownValueChanged;
}
}
/// <summary>
/// ファイルの再読み込みを要求する
/// </summary>
public static void RequestReload()
{
Misc.RequestReload();
Config.RequestReload();
Leaders.RequestReload();
Ministers.RequestReload();
Teams.RequestReload();
Techs.RequestReload();
Units.RequestReload();
Provinces.RequestReload();
CorpsNames.RequestReload();
UnitNames.RequestReload();
RandomLeaders.RequestReload();
Scenarios.RequestReload();
Maps.RequestReload();
SaveCanceled = false;
Log.Verbose("Request to reload");
}
public Ministers Details(int MiniterID)
{
var Detail = new Ministers();
try
{
SqlCon.Open();
var SqlCmd = new SqlCommand("[config].[uspReadMinisters]", SqlCon);
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlParameter pID = new SqlParameter
{
ParameterName = "@MinisterID",
SqlDbType = SqlDbType.Int,
Value = MiniterID
};
SqlCmd.Parameters.Add(pID);
using (var dr = SqlCmd.ExecuteReader())
{
dr.Read();
if (dr.HasRows)
{
Detail.MinisterID = Convert.ToInt32(dr["MinisterID"]);
Detail.FullName = dr["FullName"].ToString();
Detail.Title = dr["Title"].ToString();
Detail.Photo = dr["Photo"].ToString();
Detail.ActiveFlag = Convert.ToBoolean(dr["ActiveFlag"]);
}
}
}
catch (Exception ex)
{
throw ex;
}
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
return(Detail);
}
public HttpResponseMessage AddNew([FromBody] Ministers model)
{
var authHeader = this.Request.Headers.GetValues("Authorization").FirstOrDefault();
var token = authHeader.Substring("Bearer ".Length);
var handler = new JwtSecurityTokenHandler();
var jsonToken = handler.ReadToken(token);
var tokenS = handler.ReadToken(token) as JwtSecurityToken;
var UserName = tokenS.Claims.First(claim => claim.Type == "UserName").Value;
var r = MBL.AddNew(model, UserName);
if (!r)
{
return(this.Request.CreateResponse(HttpStatusCode.InternalServerError));
}
else
{
return(this.Request.CreateResponse(HttpStatusCode.OK, r));
}
}
public List <Ministers> List()
{
List <Ministers> List = new List <Ministers>();
try
{
using (var SqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["DB_MDA_CR_OA_Connection"].ToString()))
{
SqlCon.Open();
var SqlCmd = new SqlCommand("[ministry].[uspReadMinisters]", SqlCon)
{
CommandType = CommandType.StoredProcedure
};
using (var dr = SqlCmd.ExecuteReader())
{
while (dr.Read())
{
var minister = new Ministers
{
MinisterID = Convert.ToInt32(dr["MinisterID"]),
MinisterName = dr["MinisterName"].ToString()
};
List.Add(minister);
}
}
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
}
}
catch (Exception ex)
{
throw;
}
return(List);
}
/// <summary>
/// データを再読み込みする
/// </summary>
public static void Reload()
{
Log.Info("Reload");
// データを再読み込みする
Misc.Reload();
Config.Reload();
Leaders.Reload();
Ministers.Reload();
Teams.Reload();
Provinces.Reload();
Techs.Reload();
Units.Reload();
CorpsNames.Reload();
UnitNames.Reload();
RandomLeaders.Reload();
Scenarios.Reload();
// データ読み込み後の更新処理呼び出し
OnFileLoaded();
SaveCanceled = false;
}
public bool AddNew(Ministers minister, string insertuser)
{
return(MDAL.AddNew(minister, insertuser));
}
public bool AddNew(Ministers Detail, string InsertUser)
{
bool rpta;
try
{
SqlCon.Open();
var SqlCmd = new SqlCommand("[adm].[uspAddMinister]", SqlCon)
{
CommandType = CommandType.StoredProcedure
};
//Insert Parameters
SqlParameter Title = new SqlParameter
{
ParameterName = "@Title",
SqlDbType = SqlDbType.VarChar,
Size = 50,
Value = Detail.Title.Trim()
};
SqlCmd.Parameters.Add(Title);
SqlParameter pFullName = new SqlParameter
{
ParameterName = "@FullName",
SqlDbType = SqlDbType.VarChar,
Size = 100,
Value = Detail.FullName.Trim()
};
SqlCmd.Parameters.Add(pFullName);
SqlParameter pPhoto = new SqlParameter
{
ParameterName = "@Photo",
SqlDbType = SqlDbType.VarChar,
Size = 500,
Value = Detail.Photo
};
SqlCmd.Parameters.Add(pPhoto);
SqlParameter ParInsertUser = new SqlParameter
{
ParameterName = "@InsertUser",
SqlDbType = SqlDbType.VarChar,
Size = 50,
Value = InsertUser
};
SqlCmd.Parameters.Add(ParInsertUser);
//Exec Command
SqlCmd.ExecuteNonQuery();
rpta = true;
}
catch (Exception ex)
{
throw ex;
}
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
return(rpta);
}
public bool Update(Ministers Detail, string InsertUser)
{
return(MBL.Update(Detail, InsertUser));
}
public bool AddNew(Ministers Detail, string InsertUser)
{
return(MBL.AddNew(Detail, InsertUser));
}
/// <summary>
/// フォーム読み込み時の処理
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void OnFormLoad(object sender, EventArgs e)
{
Graphics g = Graphics.FromHwnd(Handle);
int margin = DeviceCaps.GetScaledWidth(2) + 1;
// 対象国コンボボックス
srcComboBox.BeginUpdate();
srcComboBox.Items.Clear();
int width = srcComboBox.Width;
foreach (string s in Countries.Tags
.Select(country => Countries.Strings[(int)country])
.Select(name => Config.ExistsKey(name)
? $"{name} {Config.GetText(name)}"
: name))
{
srcComboBox.Items.Add(s);
width = Math.Max(width,
(int)g.MeasureString(s, srcComboBox.Font).Width + SystemInformation.VerticalScrollBarWidth +
margin);
}
srcComboBox.DropDownWidth = width;
srcComboBox.EndUpdate();
if (srcComboBox.Items.Count > 0)
{
srcComboBox.SelectedIndex = Countries.Tags.ToList().IndexOf(_args.TargetCountries[0]);
}
srcComboBox.SelectedIndexChanged += OnSrcComboBoxSelectedIndexChanged;
// 閣僚地位
hosCheckBox.Text = Config.GetText(TextId.MinisterHeadOfState);
hogCheckBox.Text = Config.GetText(TextId.MinisterHeadOfGovernment);
mofCheckBox.Text = Config.GetText(TextId.MinisterForeignMinister);
moaCheckBox.Text = Config.GetText(TextId.MinisterArmamentMinister);
mosCheckBox.Text = Config.GetText(TextId.MinisterMinisterOfSecurity);
moiCheckBox.Text = Config.GetText(TextId.MinisterMinisterOfIntelligence);
cosCheckBox.Text = Config.GetText(TextId.MinisterChiefOfStaff);
coaCheckBox.Text = Config.GetText(TextId.MinisterChiefOfArmy);
conCheckBox.Text = Config.GetText(TextId.MinisterChiefOfNavy);
coafCheckBox.Text = Config.GetText(TextId.MinisterChiefOfAir);
// コピー/移動先コンボボックス
destComboBox.BeginUpdate();
destComboBox.Items.Clear();
width = destComboBox.Width;
foreach (string s in Countries.Tags
.Select(country => Countries.Strings[(int)country])
.Select(name => Config.ExistsKey(name)
? $"{name} {Config.GetText(name)}"
: name))
{
destComboBox.Items.Add(s);
width = Math.Max(width,
(int)g.MeasureString(s, destComboBox.Font).Width + SystemInformation.VerticalScrollBarWidth +
margin);
}
destComboBox.DropDownWidth = width;
destComboBox.EndUpdate();
if (destComboBox.Items.Count > 0)
{
destComboBox.SelectedIndex = Countries.Tags.ToList().IndexOf(_args.TargetCountries[0]);
}
destComboBox.SelectedIndexChanged += OnDestComboBoxSelectedIndexChanged;
// 開始ID
if (_args.TargetCountries.Count > 0)
{
idNumericUpDown.Value = Ministers.GetNewId(_args.TargetCountries[0]);
}
idNumericUpDown.ValueChanged += OnIdNumericUpDownValueChanged;
// 終了年
if (Game.Type != GameType.DarkestHour)
{
endYearCheckBox.Enabled = false;
endYearNumericUpDown.Enabled = false;
endYearNumericUpDown.ResetText();
}
// 引退年
if ((Game.Type != GameType.DarkestHour) || (Game.Version < 103))
{
retirementYearCheckBox.Enabled = false;
retirementYearNumericUpDown.Enabled = false;
retirementYearNumericUpDown.ResetText();
}
// イデオロギーコンボボックス
ideologyComboBox.BeginUpdate();
ideologyComboBox.Items.Clear();
width = ideologyComboBox.Width;
foreach (string s in Ministers.IdeologyNames.Where(id => id != TextId.Empty).Select(Config.GetText))
{
ideologyComboBox.Items.Add(s);
width = Math.Max(width, (int)g.MeasureString(s, ideologyComboBox.Font).Width + margin);
}
ideologyComboBox.DropDownWidth = width;
ideologyComboBox.EndUpdate();
if (ideologyComboBox.Items.Count > 0)
{
ideologyComboBox.SelectedIndex = 0;
}
ideologyComboBox.SelectedIndexChanged += OnIdeologyComboBoxSelectedIndexChanged;
// 忠誠度コンボボックス
loyaltyComboBox.BeginUpdate();
loyaltyComboBox.Items.Clear();
width = loyaltyComboBox.Width;
foreach (string s in Ministers.LoyaltyNames.Where(name => !string.IsNullOrEmpty(name)))
{
loyaltyComboBox.Items.Add(s);
width = Math.Max(width, (int)g.MeasureString(s, loyaltyComboBox.Font).Width + margin);
}
loyaltyComboBox.DropDownWidth = width;
loyaltyComboBox.EndUpdate();
if (loyaltyComboBox.Items.Count > 0)
{
loyaltyComboBox.SelectedIndex = 0;
}
loyaltyComboBox.SelectedIndexChanged += OnLoyaltyComboBoxSelectedIndexChanged;
}
