public static void insertKanmusuLevel(MemberTable <Ship> ships)
{
if (0 != ships.Count)
{
insertLevel(ships);
}
}
public static void insertKanmusuLevel(MemberTable <Fleet> fleets)
{
if (0 != fleets.Count)
{
insertLevel(fleets);
}
}
void DeleteMemberById()
{
if (CheckIfMemberExists())
{
try {
SqlConnection con = new SqlConnection(strcon);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("Delete From dbo.member_master_tbl Where member_id='"
+ TextBox_MemberId.Text.Trim() + "'", con);
cmd.ExecuteNonQuery();
con.Close();
Response.Write("<script>alert('Member Deleted Successfully');</script>");
ClearForm();
MemberTable.DataBind();
} catch (Exception ex) {
Response.Write("<script>alert('" + ex.Message + "');</script>");
}
}
else
{
Response.Write("<script>alert('Invalid Member Id');</script>");
}
}
void UpdateMemberStatusById(string status)
{
if (CheckIfMemberExists())
{
try {
SqlConnection con = new SqlConnection(strcon);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("Update dbo.member_master_tbl Set account_status='"
+ status + "' Where member_id='" + TextBox_MemberId.Text.Trim() + "'", con);
cmd.ExecuteNonQuery();
con.Close();
MemberTable.DataBind();
Response.Write("<script>alert('Member Status Updated');</script>");
} catch (Exception ex) {
Response.Write("<script>alert('" + ex.Message + "');</script>");
}
}
else
{
Response.Write("<script>alert('Invalid Member Id');</script>");
}
}
public MemberSymbol GetMember(string name)
{
MemberSymbol result;
MemberTable.TryGetValue(name, out result);
return(result);
}
public ActionResult ListMember()
{
try
{
MemberTable membertable = new MemberTable(db);
IEnumerable <LibMember> membermodel = membertable.GetMembers();
string searchValue = Request.Form[ProjectConstants.SearchValue];
//IF it is a clear action, empty the search textbox
if (Request.Form[ProjectConstants.Action] != null && Request.Form[ProjectConstants.Action] == ProjectConstants.Clear)
{
searchValue = null;
}
//Check for filter
if (searchValue != null)
{
ViewBag.SearchValue = searchValue;
membermodel = membermodel.Where(member => member.Firstname.Contains(searchValue));
}
return(View(membermodel));
}
catch (Exception)
{
throw;
}
}
public static void insertLevel(MemberTable <Ship> ships)
{
using (LevelLogDBContext context = new LevelLogDBContext())
{
Models.LevelLog levelLog;
foreach (Ship ship in ships.Values)
{
if (ship.IsLocked)
{
levelLog = context.LevelLogs.Find(ship.Id, DateTime.Now.Date);
//.SqlQuery<Models.LevelLog>("SELECT * FROM LevelLog WHERE Id = {0} AND InsertDate = {1}",
//ship.Id, DateTime.Now.ToString("yyyy/MM/dd")).FirstAsync().Result;
if (null == levelLog)
{
levelLog = new Models.LevelLog();
levelLog.Id = ship.Id;
levelLog.ShipId = ship.Info.Id;
levelLog.InsertDate = DateTime.Now.Date;
levelLog.Level = ship.Level;
context.LevelLogs.Add(levelLog);
}
else
{
levelLog.Level = ship.Level;
levelLog.ShipId = ship.Info.Id;
}
}
}
context.SaveChanges();
}
}
public string InsertMember(string Member)
{
/// call the crud
/// sample_eventtrigger is the field calling this method
/// needs to be removed from the jschema before submitting
JToken jmember = JToken.Parse(Member);
foreach (var ea in jmember.Children())
{
if (((JProperty)ea).Name == "sample_eventtrigger")
{
ea.Remove();
Console.WriteLine("call the crud: " + jmember);
var member = new MemberTable
{
MemberID = 0, /// snowflake id
Attributes = jmember.ToString(Formatting.None), // cast to string
InsertUser = 304, /// example with the system -
/// if the user needs to be dynamic it can be added to the jsoncollection
/// as payload and then parsed in the method.
InsertDate = DateTime.Now
};
/// call the crud method to insert new member
break;
}
}
return(null);
}
//DateTime dateoutput;
public Boolean ValidateMember(LibMember member)
{
MemberTable membertable = new MemberTable(new MySQLDatabase());
IEnumerable <LibMember> Listofmembers = membertable.GetMembers();
// for validating email members
foreach (var singlemember in Listofmembers)
{
if (singlemember.Email == member.Email)
{
return(false);
}
}
// for validating the first name
if (member.Firstname.Any(char.IsDigit) || member.Firstname.Any(char.IsSymbol) || string.IsNullOrEmpty(member.Firstname))
{
return(false);
}
// to check whether the Last name
if (member.Lastname.Any(char.IsDigit) || member.Lastname.Any(char.IsSymbol) || string.IsNullOrEmpty(member.Lastname))
{
return(false);
}
// to validate the email address
var emailaddress = new System.Net.Mail.MailAddress(member.Email);
if (!emailaddress.Equals(member.Email) && String.IsNullOrEmpty(member.Email))
{
return(false);
}
// to validate Phone address
if (member.Phone == null)
{
return(false);
}
if (String.IsNullOrEmpty(member.Address))
{
return(false);
}
//parsing Date format and validating
if (!DateTime.TryParse(member.Dob, out DateTime dateoutput))
{
return(false);
}
return(true);
}
public void SetFleets(MemberTable<Fleet> fleets)
{
if (fleets == null) return;
this.shipIds = new HashSet<int>(fleets
.Where(x => x.Value.Expedition.IsInExecution)
.SelectMany(x => x.Value.GetShips().Select(s => s.Id)));
}
public ActionResult Edit(string id)
{
// Get the Specific Book by Id
MemberTable memberTable = new MemberTable(db);
LibMember EditMember = memberTable.GetMemberById(id);
return(View(EditMember));
}
public void MemberTable_Add_ArgumentChecking()
{
var mt = new MemberTable();
Assert.ThrowsException <ArgumentNullException>(() => mt.Add(default(LambdaExpression)));
Assert.ThrowsException <ArgumentNullException>(() => mt.Add(default(MemberTable)));
Assert.ThrowsException <ArgumentNullException>(() => mt.Add(default(MemberInfo)));
}
internal void Update(kcsapi_slotitem[] source)
{
this.SlotItems = new MemberTable <SlotItem>(source.Select(x => new SlotItem(x)));
foreach (var ship in this.homeport.Organization.Ships.Values)
{
ship.UpdateSlots();
}
}
public ActionResult DeleteMember(string id)
{
// Get the Specific Book by Id
MemberTable membertable = new MemberTable(db);
var deleteCount = membertable.DeleteById(id);
return(RedirectToActionPermanent(ProjectConstants.ListMember));
}
public static void insertLevel(MemberTable <Fleet> fleets)
{
{
foreach (Fleet fleet in fleets.Values)
{
insertLevel(fleet);
}
}
}
public ActionResult EditMember(LibMember member)
{
// Get the Specific Book by Id
MemberTable memberTable = new MemberTable(db);
memberTable.Update(member);
return(RedirectToActionPermanent(ProjectConstants.ListMember));
}
internal Repairyard(Homeport parent, KanColleProxy proxy)
{
this.homeport = parent;
this.Docks = new MemberTable<RepairingDock>();
proxy.api_get_member_ndock.TryParse<kcsapi_ndock[]>().Subscribe(x => this.Update(x.Data));
proxy.api_req_nyukyo_start.TryParse().Subscribe(this.Start);
proxy.api_req_nyukyo_speedchange.TryParse().Subscribe(this.ChangeSpeed);
}
public void GetMemberbyId_Null()
{
Mock <IDatabase> mock = new Mock <IDatabase>();
MemberTable membertable = new MemberTable(mock.Object);
List <Dictionary <string, string> > result = new List <Dictionary <string, string> >();
mock.Setup(x => x.Query(It.IsAny <string>(), It.IsAny <Dictionary <string, object> >())).Returns(result);
Assert.AreEqual(null, membertable.GetMemberById("1"));
}
public void MemberTable_Add_ConstructorInfo_ArgumentChecking()
{
var mt = new MemberTable();
Assert.ThrowsException <ArgumentNullException>(() => mt.Add(default(ConstructorInfo)));
var ctor = typeof(StaticCtor).GetConstructor(BindingFlags.Static | BindingFlags.NonPublic, null, Type.EmptyTypes, null);
Assert.ThrowsException <ArgumentException>(() => mt.Add(ctor));
}
public void MemberTable_Add_Expression_FieldInfo_Instance()
{
var mt = new MemberTable();
var field = typeof(Stuff).GetField(nameof(Stuff.InstanceField));
mt.Add((Stuff s) => s.InstanceField);
AssertHasMember(mt, field);
}
public void MemberTable_Add_Expression_FieldInfo_Static()
{
var mt = new MemberTable();
var field = typeof(Stuff).GetField(nameof(Stuff.StaticField));
mt.Add(() => Stuff.StaticField);
AssertHasMember(mt, field);
}
public void MemberTable_Add_PropertyInfo_ArgumentChecking()
{
var mt = new MemberTable();
Assert.ThrowsException <ArgumentNullException>(() => mt.Add(default(PropertyInfo)));
var property = typeof(Stuff).GetProperty(nameof(Stuff.InstancePropertySetOnly));
Assert.ThrowsException <ArgumentException>(() => mt.Add(property));
}
public void MemberTable_Add_Expression_Unary()
{
var mt = new MemberTable();
var method = typeof(decimal).GetMethod("op_UnaryNegation", new[] { typeof(decimal) });
mt.Add((decimal a) => - a);
AssertHasMember(mt, method);
}
public ActionResult Edit([Bind(Include = "MemberID,Name,Address,LoanHistory")] MemberTable memberTable)
{
if (ModelState.IsValid)
{
db.Entry(memberTable).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(memberTable));
}
public void MemberTable_Add_Expression_PropertyInfo_Static()
{
var mt = new MemberTable();
var property = typeof(Stuff).GetProperty(nameof(Stuff.StaticProperty));
mt.Add(() => Stuff.StaticProperty);
AssertHasMember(mt, property);
}
public void MemberTable_Add_Expression_PropertyInfo_Instance()
{
var mt = new MemberTable();
var property = typeof(Stuff).GetProperty(nameof(Stuff.InstanceProperty));
mt.Add((Stuff s) => s.InstanceProperty);
AssertHasMember(mt, property);
}
public void MemberTable_Add_Expression_Binary()
{
var mt = new MemberTable();
var method = typeof(decimal).GetMethod("op_Addition", new[] { typeof(decimal), typeof(decimal) });
mt.Add((decimal a, decimal b) => a + b);
AssertHasMember(mt, method);
}
public void DeletebyId()
{
Mock <IDatabase> mock = new Mock <IDatabase>();
mock.Setup(x => x.Execute(It.IsAny <string>(), It.IsAny <Dictionary <string, object> >())).Returns(1);
MemberTable membertable = new MemberTable(mock.Object);
int result = membertable.DeleteById("25");
Assert.AreEqual(1, result);
}
public IActionResult TableAdd(MemberTable user)
{
var userAdd = new MemberTablenya()
{
Id = user.Id, Username = user.Username, Password = user.Password, Email = user.Email, Full_name = user.Full_name
};
Tables.Add(userAdd);
return(Ok(userAdd));
}
public void SetFleets(MemberTable <Fleet> fleets)
{
if (fleets == null)
{
return;
}
this.shipIds = new HashSet <int>(fleets
.Where(x => x.Value.Expedition.IsInExecution)
.SelectMany(x => x.Value.Ships.Select(s => s.Id)));
}
public ActionResult Create([Bind(Include = "MemberID,Name,Address,LoanHistory")] MemberTable memberTable)
{
if (ModelState.IsValid)
{
db.MemberTable.Add(memberTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(memberTable));
}
internal void Update(kcsapi_ndock[] source)
{
if (this.Docks.Count == source.Length)
{
foreach (var raw in source) this.Docks[raw.api_id]?.Update(raw);
}
else
{
foreach (var dock in this.Docks) dock.Value?.Dispose();
this.Docks = new MemberTable<RepairingDock>(source.Select(x => new RepairingDock(this.homeport, x)));
}
}
public ActionResult DeleteConfirmed(int id)
{
var book = db.BookTable.FirstOrDefault(s => s.MemberID == id);
book.MemberID = null;
book.OnLoan = 0;
MemberTable memberTable = db.MemberTable.Find(id);
db.MemberTable.Remove(memberTable);
db.SaveChanges();
return(RedirectToAction("Index"));
}
internal void Update(kcsapi_kdock[] source)
{
if (this.Docks.Count == source.Length)
{
foreach (var raw in source) this.Docks[raw.api_id]?.Update(raw);
}
else
{
foreach (var dock in this.Docks) dock.Value.SafeDispose();
this.Docks = new MemberTable<BuildingDock>(source.Select(x => new BuildingDock(x)));
}
}
internal Itemyard(KanColleProxy proxy)
{
this.SlotItems = new MemberTable<SlotItem>();
this.UseItems = new MemberTable<UseItem>();
proxy.api_get_member_slot_item.TryParse<kcsapi_slotitem[]>().Subscribe(x => this.Update(x.Data));
proxy.api_req_kousyou_createitem.TryParse<kcsapi_createitem>().Subscribe(x => this.CreateItem(x.Data));
proxy.api_req_kousyou_destroyitem2.TryParse<kcsapi_destroyitem2>().Subscribe(this.DestroyItem);
proxy.api_req_sortie_battleresult.TryParse<kcsapi_battleresult>().Subscribe(x => this.DropShip(x.Data));
proxy.api_get_member_useitem.TryParse<kcsapi_useitem[]>().Subscribe(x => this.Update(x.Data));
}
private void Update(kcsapi_kdock[] source)
{
if (this.Docks.Count == source.Length)
{
foreach (var raw in source)
{
var target = this.Docks[raw.api_id];
if (target != null) target.Update(raw);
}
}
else
{
this.Docks = new MemberTable<BuildingDock>(source.Select(x => new BuildingDock(x)));
}
}
internal void Update(kcsapi_ndock[] source)
{
if (this.Docks.Count == source.Length)
{
foreach (var raw in source)
{
var target = this.Docks[raw.api_id];
if (target != null) target.Update(raw);
}
}
else
{
this.Docks.ForEach(x => x.Value.Dispose());
this.Docks = new MemberTable<RepairingDock>(source.Select(x => new RepairingDock(homeport, x)));
}
}
internal Itemyard(Homeport parent, KanColleProxy proxy)
{
this.homeport = parent;
this.SlotItems = new MemberTable<SlotItem>();
this.UseItems = new MemberTable<UseItem>();
proxy.api_get_member_slot_item.TryParse<kcsapi_slotitem[]>().Subscribe(x => this.Update(x.Data));
proxy.api_req_kousyou_createitem.TryParse<kcsapi_createitem>().Subscribe(x => this.CreateItem(x.Data));
proxy.api_req_kousyou_destroyitem2.TryParse<kcsapi_destroyitem2>().Subscribe(this.DestroyItem);
// 出撃中の装備数調整は諦め！
proxy.api_get_member_useitem.TryParse<kcsapi_useitem[]>().Subscribe(x => this.Update(x.Data));
proxy.api_req_kousyou_remodel_slot.TryParse<kcsapi_remodel_slot>().Subscribe(x =>
{
this.RemoveFromRemodel(x.Data);
this.RemodelSlotItem(x.Data);
});
}
private void Update(kcsapi_ndock[] source)
{
if (this.Docks.Count == source.Length)
{
foreach (var raw in source)
{
var target = this.Docks[raw.api_id];
if (target != null) target.Update(raw);
}
}
else
{
this.Docks.ForEach(x => x.Value.Dispose());
this.Docks = new MemberTable<RepairingDock>(source.Select(x => new RepairingDock(homeport, x)));
}
// 艦娘を入渠させたとき、ship2 -> ndock の順でデータが来るため、
// ndock の後で改めて各艦隊のステータスを更新してやらないと入渠ステータスに変更できない
this.homeport.Fleets.ForEach(x => x.Value.UpdateStatus());
}
/// <summary>
/// 指定した <see cref="kcsapi_ship2"/> 型の配列を使用して、<see cref="Ships"/> プロパティ値を更新します。
/// </summary>
internal void Update(kcsapi_ship2[] source)
{
if (source.Length <= 1)
{
foreach (var ship in source)
{
var target = this.Ships[ship.api_id];
if (target == null) continue;
target.Update(ship);
var fleet = this.GetFleet(target.Id);
if (fleet != null) fleet.State.Calculate();
}
}
else
{
this.Ships = new MemberTable<Ship>(source.Select(x => new Ship(this.homeport, x)));
if (KanColleClient.Current.IsInSortie)
{
foreach (var id in this.evacuatedShipsIds) this.Ships[id].Situation |= ShipSituation.Evacuation;
foreach (var id in this.towShipIds) this.Ships[id].Situation |= ShipSituation.Tow;
}
}
}
/// <summary>
/// 指定した <see cref="kcsapi_ship2"/> 型の配列を使用して、<see cref="Ships"/> プロパティ値を更新します。
/// </summary>
internal void Update(kcsapi_ship2[] source)
{
if (source.Length <= 1)
{
foreach (var ship in source)
{
var target = this.Ships[ship.api_id];
if (target == null) continue;
target.Update(ship);
var fleet = this.GetFleet(target.Id);
if (fleet != null) fleet.Calculate();
}
}
else
{
this.Ships = new MemberTable<Ship>(source.Select(x => new Ship(this.homeport, x)));
}
}
internal void Update(kcsapi_useitem[] source)
{
this.UseItems = new MemberTable<UseItem>(source.Select(x => new UseItem(x)));
}
