public static void ServerStart(string str)
{
Console.WriteLine("Loading Data Access Objects.\n"
+ "-------------------------------------------");
DAOManager.Initialize(str);
Console.WriteLine("Loading Data Files.\n"
+ "-------------------------------------------");
Data.Data.LoadAll();
Data.Cache.LoadData();
StatsService.Init();
GeoService.Init();
MapService.Init();
QuestEngine.Init();
SkillEngine.Init();
ActionEngine.Init();
SkillsLearnService.Init();
AreaService.Init();
GuildService.Init();
InitMainLoop();
}
public IEnumerable <Food> biggerthanCal(int cal)
{
DAOManager dAOManager = new DAOManager();
List <Food> foods = new List <Food>();
foods = dAOManager.Foods();
// how do i add condition that checks if cal = 0 or smaller? i cannot add HttpResponse - because function returns IEnumerable
return(foods.Where(m => m.Calories > cal));
}
public void ShowAll<T>(string path) where T : BaseEntity
{
Console.Clear();
Console.WriteLine(path);
foreach (var item in DAOManager.GetInstance().Manager<T>().FindAll())
{
Console.WriteLine(item.ToString());
}
Console.ReadKey();
}
public override void UpdateMenu(string path)
{
while (true)
{
Console.Clear();
Console.WriteLine(path);
Port entity = null;
Console.WriteLine("1 - Редактировать по ID -->");
Console.WriteLine("2 - Редактировать № -->");
Console.WriteLine("3 - Выход -->");
var consoleCommand = ReadIntValueFromConsole();
if (consoleCommand == 1)
{
Console.WriteLine("Введите Id --> ");
var id = ReadIntValueFromConsole();
entity = DAO.GetInstance().Repository <Port>().Find(id);
if (entity == null)
{
Console.Write("Сущьность с Id = " + id + " не найденна!!!");
Console.ReadKey();
break;
}
}
else if (consoleCommand == 2)
{
Console.WriteLine("Введите номер записи --> ");
var pos = ReadIntValueFromConsole();
var list = DAOManager.GetInstance().Manager <Port>().FindAll();
if (pos >= list.Count())
{
Console.WriteLine("Вы ввели не корректный номер!!!");
Console.ReadKey(); break;
}
entity = list.ToList()[pos];
}
else if (consoleCommand == 3)
{
break;
}
if (entity == null)
{
break;
}
Console.WriteLine(entity.ToString());
Console.WriteLine();
Console.WriteLine("Введите название порта");
entity.Name = Console.ReadLine();
Console.WriteLine("Введите ID города");
entity.CityId = ReadIntValueFromConsole();
DAOManager.GetInstance().Manager <Port>().SaveChanges();
Console.WriteLine("Изменения внесены!!!");
Console.ReadKey();
}
}
public IEnumerable <Food> getbyFoodname([FromUri] string name)
{
DAOManager dAOManager = new DAOManager();
List <Food> foods = new List <Food>();
foods = dAOManager.Foods();
IEnumerable <Food> result = foods.Where(m => m.Name.ToUpper().Contains(name.ToUpper()));
return(result);
}
// POST api/messages
public HttpResponseMessage Post([FromBody] Food food)
{
DAOManager dAOManager = new DAOManager();
if (food == null)
{
return(Request.CreateResponse(HttpStatusCode.NoContent));
}
dAOManager.AddToDb(food);
return(Request.CreateResponse(HttpStatusCode.OK));
}
static void Main(string[] args)
{
//new InteractiveConsole().Menu("Меню");
//IManager<Captain> manager = new Manager<Captain>();
var listCity = DAOManager.GetInstance().Manager <City>().FindAll();
foreach (var item in listCity)
{
Console.WriteLine(item.ToString());
}
Console.ReadKey();
}
public void AddMenu<T>(string path) where T : BaseEntity
{
Console.Clear();
Console.WriteLine(path);
var constractor = typeof(T).GetConstructors().FirstOrDefault(m => m.GetParameters().Length > 0);
if (constractor == null) { return; }
var constractorAttributes = constractor.GetParameters().ToList();
var listParameters = new List<object> ();
foreach (var attribut in constractorAttributes)
{
if (attribut.ParameterType == typeof(string))
{
Console.WriteLine("Введите значение атрибута " + attribut.Name.ToUpper() + " -->");
listParameters.Add(Console.ReadLine());
}
else if (attribut.ParameterType == typeof(Int32))
{
Console.WriteLine("Введите значение атрибута " + attribut.Name.ToUpper() + "-->");
listParameters.Add(ReadIntValueFromConsole());
}
else if (attribut.ParameterType == typeof(DateTime))
{
Console.WriteLine("Введите значение атрибута " + attribut.Name.ToUpper() + "-->");
listParameters.Add(ReadDateTimeFromConsole());
}
else if (attribut.ParameterType == typeof(double))
{
Console.WriteLine("Введите значение атрибута " + attribut.Name.ToUpper() + "-->");
listParameters.Add(ReadDoubleFromConsole());
}
}
var assembly = Assembly.GetAssembly(typeof(T));
/*var o = assembly.CreateInstance(typeof(T).FullName, false,
BindingFlags.ExactBinding,
null, listParameters.ToArray(), null, null);*/
var o = Activator.CreateInstance(typeof (T), listParameters.ToArray());
var addItem = (T)o;
try
{
DAOManager.GetInstance().Manager<T>().Add(addItem);
//DAO.GetInstance().Repository<T>().Add(addItem);
Console.WriteLine("Изменения внесены!!!");
Console.ReadKey();
}
catch (Exception err)
{
Console.WriteLine("Возникла ошибка при добавлении записи ");
}
}
// GET api/messages
public HttpResponseMessage Get()
{
List <Food> foods = new List <Food>();
DAOManager dAOManager = new DAOManager();
foods = dAOManager.Foods();
if (foods.Count == 0)
{
return(Request.CreateResponse(HttpStatusCode.NoContent));
}
HttpResponseMessage msg = Request.CreateResponse(HttpStatusCode.OK, foods);
return(msg);
}
/// <summary>
/// 创建新的数据库访问集，并添加到数据库访问池中
/// </summary>
/// <param name="sSetName"></param>
/// <param name="sConStr"></param>
/// <returns></returns>
public DAOManager CreateDbAccessSet(string sSetName, string sConStr)
{
DAOManager ds = new DAOManager(sConStr);
try
{
m_lstDAOCache.Add(sSetName, m_lstDAO.Count);
}
catch (Exception ex)
{
LogHelper.GetInstance().Write("数据源：" + sSetName + "重复定义！");
}
m_lstDAO.Add(ds);
ds.SetName = sSetName;
return(ds);
}
// PUT api/messages/5
public HttpResponseMessage Put(int id, [FromBody] Food food)
{
DAOManager dAOManager = new DAOManager();
List <Food> foods = new List <Food>();
foods = dAOManager.Foods();
if (food == null)
{
return(Request.CreateResponse(HttpStatusCode.NoContent));
}
Food result = foods.FirstOrDefault(m => m.ID == id);
dAOManager.UpdateDB(food, id);
return(Request.CreateResponse(HttpStatusCode.OK));
}
// DELETE api/messages/5
public HttpResponseMessage Delete(int id)
{
DAOManager dAOManager = new DAOManager();
List <Food> foods = new List <Food>();
foods = dAOManager.Foods();
Food result = foods.FirstOrDefault(m => m.ID == id);
if (result == null)
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
dAOManager.RemoveFromDB(id);
return(Request.CreateResponse(HttpStatusCode.OK));
}
/// <summary>
/// 创建新的数据库访问集，并添加到数据库访问池中
/// </summary>
/// <param name="sSetName"></param>
/// <param name="sServer"></param>
/// <param name="sDatabase"></param>
/// <param name="sUser"></param>
/// <param name="sPassword"></param>
/// <param name="sDBType"></param>
/// <returns></returns>
public DAOManager CreateDbAccessSet(string sSetName, string sServer, string sDatabase, string sUser, string sPassword, string sDBType)
{
DAOManager ds = new DAOManager(sServer, sDatabase, sUser, sPassword, sDBType);
try
{
m_lstDAOCache.Add(sSetName, m_lstDAO.Count);
}
catch (Exception)
{
LogHelper.GetInstance().Write("数据源：" + sSetName + "重复定义！");
}
m_lstDAO.Add(ds);
ds.SetName = sSetName;
return(ds);
}
public IEnumerable <Food> getbyfilter(string name = "", int cal = 0)
{
DAOManager dAOManager = new DAOManager();
List <Food> foods = new List <Food>();
foods = dAOManager.Foods();
if (name == "" && cal != 0)
{
return(foods.Where(m => m.Calories > cal));
}
if (name != "" && cal == 0)
{
return(foods.Where(m => m.Name.ToUpper() == name.ToUpper()));
}
return(foods.Where(m => m.Calories > cal && m.Name.ToUpper().Contains(name.ToUpper())));
}
public HttpResponseMessage Get([FromUri] int id)
{
DAOManager dAOManager = new DAOManager();
List <Food> foods = new List <Food>();
foods = dAOManager.Foods();
Food result = foods.FirstOrDefault(m => m.ID == id);
if (result == null)
{
return(Request.CreateResponse(HttpStatusCode.NoContent));
}
HttpResponseMessage msg = Request.CreateResponse(HttpStatusCode.OK, result);
return(msg);
}
private void InitManager(List<string> pPermKeyList, bool pIsSuperUser)
{
try
{
// Check out the use of CreateObjectRef......
opsGridManager = new OpsGridManager(updMsgServer, updMsgUser, updMsgPwd, updateFromCacheTimerInterval,
msgFilter, inbMsgFilter, pPermKeyList, pIsSuperUser);
daoManager = new DAOManager();
opsGridManager.IncMessageCounter += new EventHandler(OnIncMessageCounter);
opsGridManager.ResetMessageCounter += new EventHandler(OnResetMessageCounter);
opsGridManager.BeginGridUpdates += new EventHandler(OnBeginGridUpdates);
opsGridManager.EndGridUpdates += new EventHandler(OnEndGridUpdates);
}
catch (Exception ex)
{
throw new Exception("An error occurred while creating and populating internal data storage." + Environment.NewLine +
"Error CNF-346 in " + PROJ_FILE_NAME + ".InitManager(): " + ex.Message);
}
}
public void DeleteMenu<T>(string path) where T :BaseEntity
{
while (true)
{
Console.Clear();
Console.WriteLine(path);
Console.WriteLine("Выбирите дейтвие: ");
Console.WriteLine("1 - Удалить по ID: ");
Console.WriteLine("2 - Удалить по номеру: ");
Console.WriteLine("3 - Выход");
var commandNumber = ReadIntValueFromConsole(1, 3);
if (commandNumber == 1)
{
Console.WriteLine("Введите ID: ");
var Id = ReadIntValueFromConsole();
var item = DAO.GetInstance().Repository<T>().Find(Id);
if (item != null)
{
DAOManager.GetInstance().Manager<T>().Remove(item);
//DAO.GetInstance().Repository<T>().Remove(item);
Console.WriteLine("Запись удаленна");
}
Console.WriteLine("Запись с ID = " + Id + "не найденна");
}
else if (commandNumber == 2)
{
Console.WriteLine("Введите номер записи в списке");
var number = ReadIntValueFromConsole();
var list = DAO.GetInstance().Repository<T>().FindAll();
if (number <= list.Count() - 1)
{
DAOManager.GetInstance().Manager<T>().Remove(list.ToList()[number]);
//DAO.GetInstance().Repository<T>().Remove(list.ToList()[number]);
Console.WriteLine("Запись удаленна");
}
Console.WriteLine("Вы ввели число, которое выходит за диаппазон существующих записей");
}
else if (commandNumber == 3)
{
break;
}
}
}
public Server()
{
try
{
Console.WriteLine("Starting Server...");
this.TcpServer = new TCPServer("*", Config.getServerPort(), Config.getServerMaxConnection());
Connection.SendAllThread.Start();
Levels.LoadLevels();
Console.WriteLine("Loading templates...");
Class_Template.LoadTemplates();
Console.WriteLine("Loaded " + Class_Template.ClassTemplates.Count + " templates");
Console.WriteLine("Loading Achievements...");
Achievements.LoadAchievementsFromFile();
Console.WriteLine("Loaded " + Achievements.achievementList.Count + " achievements");
Console.WriteLine("Loading OpCodes...");
OpCodes.Init();
Console.WriteLine("Loaded " + (OpCodes.ClientTypes.Count + OpCodes.ServerTypes.Count) + " OpCodes");
DAOManager.Initialise("SERVER=" + Config.getDatabaseHost() + ";DATABASE=" + Config.getDatabaseName() + ";UID=" + Config.getDatabaseUser() + ";PASSWORD="******";PORT=" + Config.getDatabasePort() + ";charset=utf8");
Console.WriteLine("Loading TCP...");
this.TcpServer.BeginListening();
Connection.sendThread.Start();
Console.WriteLine("Server Started !");
Server.serverOn = true;
}
catch (Exception exception)
{
Console.WriteLine("Can't start server : ", exception.Message);
return;
}
}
public void CleanUp()
{
daoManager = null;
managedDataSet = null;
opsGridManager.Dispose();
}
public override void UpdateMenu(string path)
{
while (true)
{
Console.Clear();
Console.WriteLine(path);
CargoType entity = null;
Console.WriteLine("1 - Редактировать по ID -->");
Console.WriteLine("2 - Редактировать № -->");
Console.WriteLine("3 - Выход -->");
var consoleCommand = ReadIntValueFromConsole();
if (consoleCommand == 1)
{
Console.WriteLine("Введите Id --> ");
var id = ReadIntValueFromConsole();
entity = DAO.GetInstance().Repository <CargoType>().Find(id);
if (entity == null)
{
Console.Write("Сущьность с Id = " + id + " не найденна!!!");
Console.ReadKey();
break;
}
}
else if (consoleCommand == 2)
{
Console.WriteLine("Введите номер записи --> ");
var pos = ReadIntValueFromConsole();
var list = DAOManager.GetInstance().Manager <CargoType>().FindAll();
if (pos >= list.Count())
{
Console.WriteLine("Вы ввели не корректный номер!!!");
Console.ReadKey(); break;
}
entity = list.ToList()[pos];
}
else if (consoleCommand == 3)
{
break;
}
if (entity == null)
{
break;
}
Console.WriteLine(entity.ToString());
Console.WriteLine();
Console.WriteLine("Введите название типа");
entity.TypeName = Console.ReadLine();
try
{
DAOManager.GetInstance().Manager <Captain>().SaveChanges();
//DAO.GetInstance().Repository<CargoType>().SaveChanges();
Console.WriteLine("Изменения внесены!!!");
}
catch (Exception err)
{
Console.WriteLine("Ошибка при сохранении изменений");
}
Console.ReadKey();
}
}
public override void UpdateMenu(string path)
{
while (true)
{
Console.Clear();
Console.WriteLine(path);
Trip entity = null;
Console.WriteLine("1 - Редактировать по ID -->");
Console.WriteLine("2 - Редактировать № -->");
Console.WriteLine("3 - Выход -->");
var consoleCommand = ReadIntValueFromConsole();
if (consoleCommand == 1)
{
Console.WriteLine("Введите Id --> ");
var id = ReadIntValueFromConsole();
entity = DAO.GetInstance().Repository <Trip>().Find(id);
if (entity == null)
{
Console.Write("Сущьность с Id = " + id + " не найденна!!!");
Console.ReadKey();
break;
}
}
else if (consoleCommand == 2)
{
Console.WriteLine("Введите номер записи --> ");
var pos = ReadIntValueFromConsole();
var list = DAOManager.GetInstance().Manager <Trip>().FindAll();
if (pos >= list.Count())
{
Console.WriteLine("Вы ввели не корректный номер!!!");
Console.ReadKey(); break;
}
entity = list.ToList()[pos];
}
else if (consoleCommand == 3)
{
break;
}
if (entity == null)
{
break;
}
Console.WriteLine(entity.ToString());
Console.WriteLine();
Console.WriteLine("Введите номер порта отправки");
entity.PortFromId = ReadIntValueFromConsole();
Console.WriteLine("Введите номер порта прибытия");
entity.PortToId = ReadIntValueFromConsole();
Console.WriteLine("Введите номер корабля");
entity.ShipId = ReadIntValueFromConsole();
Console.WriteLine("Введите дату отправки");
entity.StartDate = ReadDateTimeFromConsole();
Console.WriteLine("Введите дату прибытия");
entity.EndDate = ReadDateTimeFromConsole();
try
{
DAOManager.GetInstance().Manager <Trip>().SaveChanges();
Console.WriteLine("Изменения внесены!!!");
}
catch (Exception err)
{
Console.WriteLine("Ошибка при сохранении изменений");
}
Console.ReadKey();
}
}
public override void UpdateMenu(string path)
{
while (true)
{
Console.Clear();
Console.WriteLine(path);
Ship entity = null;
Console.WriteLine("1 - Редактировать по ID -->");
Console.WriteLine("2 - Редактировать № -->");
Console.WriteLine("3 - Выход -->");
var consoleCommand = ReadIntValueFromConsole();
if (consoleCommand == 1)
{
Console.WriteLine("Введите Id --> ");
var id = ReadIntValueFromConsole();
entity = DAO.GetInstance().Repository <Ship>().Find(id);
if (entity == null)
{
Console.Write("Сущьность с Id = " + id + " не найденна!!!");
Console.ReadKey();
break;
}
}
else if (consoleCommand == 2)
{
Console.WriteLine("Введите номер записи --> ");
var pos = ReadIntValueFromConsole();
var list = DAOManager.GetInstance().Manager <Ship>().FindAll();
if (pos >= list.Count())
{
Console.WriteLine("Вы ввели не корректный номер!!!");
Console.ReadKey(); break;
}
entity = list.ToList()[pos];
}
else if (consoleCommand == 3)
{
break;
}
if (entity == null)
{
break;
}
Console.WriteLine("Введите номер");
entity.Number = Console.ReadLine();
Console.WriteLine("Введите номер порта");
entity.PortId = ReadIntValueFromConsole();
Console.WriteLine("Введите номер капитана");
entity.CaptainId = ReadIntValueFromConsole();
Console.WriteLine("Введите грузоподемность");
entity.Capacity = ReadIntValueFromConsole();
Console.WriteLine("Введите максимальную дистанцию");
entity.MaxDistance = ReadIntValueFromConsole();
Console.WriteLine("Введите количество человек в команде");
entity.TeamCount = ReadIntValueFromConsole();
try
{
DAOManager.GetInstance().Manager <Ship>().SaveChanges();
Console.WriteLine("Изменения внесены!!!");
}
catch (Exception err)
{
Console.WriteLine("Ошибка при сохранении изменений");
}
Console.ReadKey();
}
}
