public CrpNPCCorporation(MySql.Data.MySqlClient.MySqlConnection mysql_connection, System.Data.SqlClient.SqlConnection sqlserver_connection)
: base(mysql_connection, sqlserver_connection)
{
this._tableName = "crpNPCCorporations";
this._fields.Add("corporationID");
this._fields.Add("size");
this._fields.Add("extent");
this._fields.Add("solarSystemID");
this._fields.Add("investorID1");
this._fields.Add("investorShares1");
this._fields.Add("investorID2");
this._fields.Add("investorShares2");
this._fields.Add("investorID3");
this._fields.Add("investorShares3");
this._fields.Add("investorID4");
this._fields.Add("investorShares4");
this._fields.Add("friendID");
this._fields.Add("enemyID");
this._fields.Add("publicShares");
this._fields.Add("initialPrice");
this._fields.Add("minSecurity");
this._fields.Add("scattered");
this._fields.Add("fringe");
this._fields.Add("corridor");
this._fields.Add("hub");
this._fields.Add("border");
this._fields.Add("factionID");
this._fields.Add("sizeFactor");
this._fields.Add("stationCount");
this._fields.Add("stationSystemCount");
this._fields.Add("description");
this._fields.Add("iconID");
}
public static PartyData LoadCharacterParty(MySql database, string charID)
{
PartyData partyData = new PartyData();
string query = "SELECT parties.PartyID " +
"FROM parties " +
"WHERE parties.CharID = \'" + charID + "\';";
List<DataColumnCollection> rows = database.RetrieveRows(query);
if (rows != null) {
for (int i = 0; i < rows.Count; i++) {
partyData.PartyID = rows[i]["PartyID"].ValueString;
}
} else {
return null;
}
query = "SELECT parties.CharID " +
"FROM parties " +
"WHERE parties.PartyID = \'" + partyData.PartyID + "\';";
rows = database.RetrieveRows(query);
if (rows != null) {
for (int i = 0; i < rows.Count; i++) {
partyData.Members.Add(rows[i]["CharID"].ValueString);
}
}
return partyData;
}
public static void LoadShop(int shopNum, MySql database)
{
if (shops.Shops.ContainsKey(shopNum) == false)
shops.Shops.Add(shopNum, new Shop());
string query = "SELECT name, " +
"greeting, " +
"farewell " +
"FROM shop WHERE shop.num = \'" + shopNum + "\'";
DataColumnCollection row = database.RetrieveRow(query);
if (row != null)
{
shops[shopNum].Name = row["name"].ValueString;
shops[shopNum].JoinSay = row["greeting"].ValueString;
shops[shopNum].LeaveSay = row["farewell"].ValueString;
}
query = "SELECT trade_num, " +
"item, " +
"cost_num, " +
"cost_val " +
"FROM shop_trade WHERE shop_trade.num = \'" + shopNum + "\'";
foreach (DataColumnCollection columnCollection in database.RetrieveRowsEnumerable(query))
{
int tradeNum = columnCollection["trade_num"].ValueString.ToInt();
shops[shopNum].Items[tradeNum].GetItem = columnCollection["item"].ValueString.ToInt();
shops[shopNum].Items[tradeNum].GiveItem = columnCollection["cost_num"].ValueString.ToInt();
shops[shopNum].Items[tradeNum].GiveValue = columnCollection["cost_val"].ValueString.ToInt();
}
}
public void Deoploy(MySql.Data.MySqlClient.MySqlCommand cmd, StringBuilder sb, ref int paramCount)
{
if (upperBounds == null)
{
bool first = true;
foreach (DataColumn col in lowerBounds.Table.Columns)
{
sb.Append(first ? "" : " AND ");
sb.Append(" `" + col.ColumnName + "` = @param" + paramCount);
cmd.Parameters.AddWithValue("@param" + paramCount++, lowerBounds[col]);
first = false;
}
}
else
{
bool first = true;
foreach (DataColumn col in lowerBounds.Table.Columns)
{
sb.Append(first ? " `" : " AND `" + col.ColumnName + "` ");
if (col.DataType == typeof(int) || col.DataType == typeof(double))
{
sb.Append("BETWEEN @param" + paramCount + " AND @param" + paramCount + 1);
}
else
{
sb.Append(" <= @param" + paramCount + " AND `" + col.ColumnName + "` >= @param" + paramCount + 1);
}
cmd.Parameters.AddWithValue("@param" + paramCount++, lowerBounds[col]);
cmd.Parameters.AddWithValue("@param" + paramCount++, upperBounds[col]);
first = false;
}
}
}
public DgmEffect(MySql.Data.MySqlClient.MySqlConnection mysql_connection, System.Data.SqlClient.SqlConnection sqlserver_connection)
: base(mysql_connection, sqlserver_connection)
{
this._tableName = "dgmEffects";
this._fields.Add("effectID");
this._fields.Add("effectName");
this._fields.Add("effectCategory");
this._fields.Add("preExpression");
this._fields.Add("postExpression");
this._fields.Add("description");
this._fields.Add("guid");
this._fields.Add("iconID");
this._fields.Add("isOffensive");
this._fields.Add("isAssistance");
this._fields.Add("durationAttributeID");
this._fields.Add("trackingSpeedAttributeID");
this._fields.Add("dischargeAttributeID");
this._fields.Add("rangeAttributeID");
this._fields.Add("falloffAttributeID");
this._fields.Add("disallowAutoRepeat");
this._fields.Add("published");
this._fields.Add("displayName");
this._fields.Add("isWarpSafe");
this._fields.Add("rangeChance");
this._fields.Add("electronicChance");
this._fields.Add("propulsionChance");
this._fields.Add("distribution");
this._fields.Add("sfxName");
this._fields.Add("npcUsageChanceAttributeID");
this._fields.Add("npcActivationChanceAttributeID");
this._fields.Add("fittingUsageChanceAttributeID");
}
public MultiRowInsert(MySql database, string tableName, params string[] columnNames)
{
this.database = database;
this.tableName = tableName;
this.columnNames = columnNames;
UpdateParameters(tableName, columnNames);
}
public CrpNPCCorporationResearchField(MySql.Data.MySqlClient.MySqlConnection mysql_connection, System.Data.SqlClient.SqlConnection sqlserver_connection)
: base(mysql_connection, sqlserver_connection)
{
this._tableName = "crpNPCCorporationResearchFields";
this._fields.Add("skillID");
this._fields.Add("corporationID");
}
public static void AddMissionEnemyData(MySql database, int difficulty, int index, MissionEnemyData data)
{
database.AddRow("mission_enemy", new IDataColumn[] {
database.CreateColumn(false, "Rank", difficulty.ToString()),
database.CreateColumn(false, "EnemyIndex", index.ToString()),
database.CreateColumn(false, "NpcNum", data.NpcNum.ToString())
});
}
public static void CreateNewAccount(MySql database, string accountName, string encryptedPassword, string email)
{
database.AddRow("accounts", new IDataColumn[] {
database.CreateColumn(false, "AccountName", accountName),
database.CreateColumn(false, "Password", encryptedPassword),
database.CreateColumn(false, "Email", email)
});
}
public static void Testm(MySql.Data.MySqlClient.MySqlConnection connection)
{
DataContext db = new DataContext(connection);
Table<Artigo> Artigos = db.GetTable<Artigo>();
var q = (from a in Artigos select a).ToList();
}
public void addParam(MySql.Data.MySqlClient.MySqlDbType type, string name, dynamic value = null)
{
MySqlParameter param = new MySqlParameter(name, type);
param.Value = value;
if (type == MySql.Data.MySqlClient.MySqlDbType.String)
param.Size = -1;
cmd.Parameters.Add(param);
}
public CrpNPCCorporationTrade(MySql.Data.MySqlClient.MySqlConnection mysql_connection, System.Data.SqlClient.SqlConnection sqlserver_connection)
: base(mysql_connection, sqlserver_connection)
{
this._tableName = "crpNPCCorporationTrades";
this._fields.Add("corporationID");
this._fields.Add("typeID");
}
public static void AddGuildMember(MySql database, string guildName, string charID)
{
database.UpdateOrInsert("guild", new IDataColumn[] {
database.CreateColumn(false, "CharID", charID),
database.CreateColumn(false, "GuildName", guildName),
database.CreateColumn(false, "GuildAccess", "1")
});
}
public AgtAgentType(MySql.Data.MySqlClient.MySqlConnection mysql_connection, System.Data.SqlClient.SqlConnection sqlserver_connection)
: base(mysql_connection, sqlserver_connection)
{
this._tableName = "agtAgentTypes";
this._fields.Add("agentTypeID");
this._fields.Add("agentType");
}
public DgmTypeEffect(MySql.Data.MySqlClient.MySqlConnection mysql_connection, System.Data.SqlClient.SqlConnection sqlserver_connection)
: base(mysql_connection, sqlserver_connection)
{
this._tableName = "dgmTypeEffects";
this._fields.Add("typeID");
this._fields.Add("effectID");
this._fields.Add("isDefault");
}
public static void SaveHorseRaceStatistics(Network.GamePackets.HorseRaceStatistic stats, MySql.Data.MySqlClient.MySqlConnection conn)
{
var cmd = new MySqlCommand(MySqlCommandType.UPDATE).Update("HorseRace")
.Set("EntityName", stats.Name)
.Set("Rank", stats.Rank)
.Set("CurrentPts", stats.CurrentPts)
.Where("EntityID", stats.EntityID);
cmd.Execute(conn);
}
public CrtClass(MySql.Data.MySqlClient.MySqlConnection mysql_connection, System.Data.SqlClient.SqlConnection sqlserver_connection)
: base(mysql_connection, sqlserver_connection)
{
this._tableName = "crtClasses";
this._fields.Add("classID");
this._fields.Add("description");
this._fields.Add("className");
}
public DgmAttributeCategory(MySql.Data.MySqlClient.MySqlConnection mysql_connection, System.Data.SqlClient.SqlConnection sqlserver_connection)
: base(mysql_connection, sqlserver_connection)
{
this._tableName = "dgmAttributeCategories";
this._fields.Add("categoryID");
this._fields.Add("categoryName");
this._fields.Add("categoryDescription");
}
public EveIcon(MySql.Data.MySqlClient.MySqlConnection mysql_connection, System.Data.SqlClient.SqlConnection sqlserver_connection)
: base(mysql_connection, sqlserver_connection)
{
this._tableName = "eveIcons";
this._fields.Add("iconID");
this._fields.Add("iconFile");
this._fields.Add("description");
}
public static void AddMissionClientData(MySql database, int difficulty, int index, MissionClientData data)
{
database.AddRow("mission_client", new IDataColumn[] {
database.CreateColumn(false, "Rank", difficulty.ToString()),
database.CreateColumn(false, "ClientIndex", index.ToString()),
database.CreateColumn(false, "DexNum", data.DexNum.ToString()),
database.CreateColumn(false, "FormNum", data.FormNum.ToString())
});
}
public DgmTypeAttribute(MySql.Data.MySqlClient.MySqlConnection mysql_connection, System.Data.SqlClient.SqlConnection sqlserver_connection)
: base(mysql_connection, sqlserver_connection)
{
this._tableName = "dgmTypeAttributes";
this._fields.Add("typeID");
this._fields.Add("attributeID");
this._fields.Add("valueInt");
this._fields.Add("valueFloat");
}
public CrtRecommendation(MySql.Data.MySqlClient.MySqlConnection mysql_connection, System.Data.SqlClient.SqlConnection sqlserver_connection)
: base(mysql_connection, sqlserver_connection)
{
this._tableName = "crtRecommendations";
this._fields.Add("recommendationID");
this._fields.Add("shipTypeID");
this._fields.Add("certificateID");
this._fields.Add("recommendationLevel");
}
public static void AddMissionRewardData(MySql database, int difficulty, int index, MissionRewardData data)
{
database.AddRow("mission_reward", new IDataColumn[] {
database.CreateColumn(false, "Rank", difficulty.ToString()),
database.CreateColumn(false, "RewardIndex", index.ToString()),
database.CreateColumn(false, "ItemNum", data.ItemNum.ToString()),
database.CreateColumn(false, "ItemAmount", data.ItemAmount.ToString()),
database.CreateColumn(false, "ItemTag", data.ItemTag)
});
}
public CrpNPCDivision(MySql.Data.MySqlClient.MySqlConnection mysql_connection, System.Data.SqlClient.SqlConnection sqlserver_connection)
: base(mysql_connection, sqlserver_connection)
{
this._tableName = "crpNPCDivisions";
this._fields.Add("divisionID");
this._fields.Add("divisionName");
this._fields.Add("description");
this._fields.Add("leaderType");
}
public static string GetMapName(MySql database, string mapID)
{
string query = "SELECT map_data.Name FROM map_data WHERE map_data.MapID = \'" + mapID + "\'";
DataColumnCollection row = database.RetrieveRow(query);
if (row != null) {
return row[0].ValueString;
} else {
return null;
}
}
public static bool IsMapIDInUse(MySql database, string mapID)
{
string query = "SELECT MapID FROM map_general WHERE MapID = \'" + mapID + "\'";
DataColumnCollection row = database.RetrieveRow(query);
if (row != null) {
return row["MapID"].ValueString == mapID;
} else {
return false;
}
}
public EveUnit(MySql.Data.MySqlClient.MySqlConnection mysql_connection, System.Data.SqlClient.SqlConnection sqlserver_connection)
: base(mysql_connection, sqlserver_connection)
{
this._tableName = "eveUnits";
this._fields.Add("unitID");
this._fields.Add("unitName");
this._fields.Add("displayName");
this._fields.Add("description");
}
// form constructor
public FormEditMember(MySql.Data.MySqlClient.MySqlConnection connection)
{
InitializeComponent();
m_connection = connection;
BindFamilyMembers();
BindOrgRelations();
BindPayments();
BindWelfareAssistance();
}
public CrtRelationship(MySql.Data.MySqlClient.MySqlConnection mysql_connection, System.Data.SqlClient.SqlConnection sqlserver_connection)
: base(mysql_connection, sqlserver_connection)
{
this._tableName = "crtRelationships";
this._fields.Add("relationshipID");
this._fields.Add("parentID");
this._fields.Add("parentTypeID");
this._fields.Add("parentLevel");
this._fields.Add("childID");
}
public WarCombatZone(MySql.Data.MySqlClient.MySqlConnection mysql_connection, System.Data.SqlClient.SqlConnection sqlserver_connection)
: base(mysql_connection, sqlserver_connection)
{
this._tableName = "warCombatZones";
this._fields.Add("combatZoneID");
this._fields.Add("combatZoneName");
this._fields.Add("factionID");
this._fields.Add("centerSystemID");
this._fields.Add("description");
}
/// <summary>СОБЫТИЕ Сохраняем файл с рисунком в байтовый массив</summary>
protected override void PART_ButtonOpen_Click(object sender, RoutedEventArgs e)
{
Microsoft.Win32.OpenFileDialog _OpenFileDialog = new Microsoft.Win32.OpenFileDialog
{
FileName = "Рисунки",
DefaultExt = "*.jpg *.png *.ico",
Filter = "Рисунки (*.jpg *.png *.ico)|*.jpg"
};
if (_OpenFileDialog.ShowDialog() == true)
{
// Находим запись
DataRowView _Row = (DataRowView)PART_DataGrid.SelectedItem;
int _Cod = Convert.ToInt32(_Row["Cod"]); // код ответа
int _ID = Convert.ToInt32(_Row["ID"]); // код шаблона
int _Nomer = Convert.ToInt32(_Row["Nomer"]); // номер
string _NameImage = _OpenFileDialog.SafeFileName; // имя файла
string _Comment = Convert.ToString(_Row["Comment"]); // коментарий
_Row["NameImage"] = _NameImage;
byte[] _mPhoto = MET_GetPhoto(_OpenFileDialog.FileName);
_Row["Image"] = _mPhoto;
// ---- Update Если есть код ответа, значить строка старая и меняем ответ
if (_Row["Cod"].ToString() != "")
{
MySql.MET_QueryNoImage(MyQuery.s_ListImage_Update_1(_Cod, _ID, _Nomer, _NameImage, _Comment), "@Image", _mPhoto);
}
else
// ----- Insert Находим максимальный код
{
_Cod = MySql.MET_QueryInt(MyQuery.s_ListImage_Select_2(_ID, _Nomer)) + 1;
if (_Cod == 1)
{
_Cod = _ID * 1000 + _Nomer * 100 + 1; // если это первый ответ в шаблоне то начинаем с нужного номера
}
// ---- Добавляем ответ в базу
MySql.MET_QueryNoImage(MyQuery.s_ListImage_Insert_1(_Cod, _ID, _Nomer, _NameImage, _Comment), "@Image", _mPhoto);
// Добавляем данные в sqlDs
_Row["Cod"] = _Cod;
MyGlo.DataSet.Tables[PRO_TableName].Rows.Add(_Row);
}
}
}
public int Update(string email) //javított
{
MySql mySql = new MySql();
int applicantID = 0;
try
{
string command = "UPDATE `pmkcvtest`.`jeloltek` SET " +
"`nev` = '" + nev + "', " +
"`email` = '" + email + "', " +
"`telefon` = '" + telefon + "', " +
"`lakhely` = '" + lakhely + @"', " +
"`ertesult` = " + Utility.correction(id_ertesult.ToString()) + ", " +
"`szuldatum` = " + Utility.correction(szuldatum.ToString()) + ", " +
"`neme` = " + Utility.correction(id_neme.ToString()) + ", " +
"`tapasztalat_ev` = " + Utility.correction(tapasztalat_ev.ToString()) + ", " +
"`munkakor` = " + Utility.correction(id_munkakor.ToString()) + ", " +
"`munkakor2` = " + Utility.correction(id_munkakor2.ToString()) + ", " +
"`munkakor3` = " + Utility.correction(id_munkakor3.ToString()) + ", " +
"`vegz_terulet` = " + Utility.correction(id_vegz_terulet.ToString()) + ", " +
"`nyelvtudas` = " + Utility.correction(id_nyelvtudas.ToString()) + ", " +
"`nyelvtudas2` = " + Utility.correction(id_nyelvtudas2.ToString()) + ", " +
"`reg_date` = '" + Utility.correction(reg_date.ToString(), "") + "', " +
"`megjegyzes` = '" + Utility.correction(megjegyzes.ToString(), "") + "', " +
"`hirlevel` = " + Utility.correction(hirlevel.ToString()) + ", " +
"`statusz` = 1, " +
"`friss` = 1 " +
"WHERE `email` = '" + email + "' ;";
mySql.execute(command);
command = "SELECT jeloltek.id FROM jeloltek WHERE jeloltek.email = '" + email + "'";
applicantID = Convert.ToInt16(mySql.uniqueList(command, new string[] { "jeloltek" })[0]);
}
catch (Exception)
{
throw;
}
mySql.dbClose();
return(applicantID);
}
/// <summary>МЕТОД Добавление Изменение Назначений ЛС</summary>
private void MET_SaveNaznLS(DataRowView pRow)
{
PRI_Row = pRow;
int _Cod;
DateTime _DateN = MET_PoleDat("DateN");
int _Kurs = MET_PoleInt("Kurs");
int _Period = MET_PoleInt("Period");
string _NameLS = MET_PoleStr("NameLS");
int _Amt = MET_PoleInt("Amt");
string _Route = MET_PoleStr("Route");
string _Note = MET_PoleStr("Note");
int _FlagDrug = MET_PoleInt("FlagDrug");
int _FlagPac = MET_PoleInt("FlagPac");
int _UserVrach = MET_PoleInt("UserVrach");
int _DelUserVrach = MET_PoleInt("DelUserVrach");
DateTime _DelDate = MET_PoleDat("DelDate");
string _DelNote = MET_PoleStr("DelNote");
DateTime _xDateUp = DateTime.Today;
//---- Update Если есть код ответа, значить строка старая и меняем ответ
if (MET_PoleStr("Cod") != "-1")
{
_Cod = MET_PoleInt("Cod"); // код ответа
MySql.MET_QueryNo(MyQuery.lnzVrachLS_Update_1(_Cod, _DateN, _Kurs, _Period, _NameLS, _Amt, _Route, _Note,
_FlagDrug, _FlagPac, _UserVrach, _DelUserVrach, _DelDate, _DelNote, _xDateUp));
PUB_Node.PROP_Docum.PROP_Otchet.PROP_NewCreate = true;
return;
}
// ----- Insert Находим максимальный код
_Cod = MySql.MET_GetNextRef(30);
PRI_Row["Cod"] = _Cod;
decimal _KL = MyGlo.KL;
decimal _CodApstac = MyGlo.IND;
PRI_Row["CodApstac"] = _CodApstac;
DateTime _pDate = DateTime.Today;
// Добавляем ответ в базу
MySql.MET_QueryNo(MyQuery.lnzVrachLS_Insert_1(_Cod, _KL, _CodApstac, _DateN, _Kurs, _Period, _NameLS, _Amt, _Route, _Note,
_FlagDrug, _FlagPac, _UserVrach, _DelUserVrach, _DelDate, _DelNote, _pDate, _xDateUp));
PUB_Node.PROP_Docum.PROP_Otchet.PROP_NewCreate = true;
if (!PUB_Node.PROP_shaPresenceProtokol)
PUB_Node.PROP_shaPresenceProtokol = true;
}
/// <summary>
/// Removes a friend based on name. Return codes are as follows:
/// <list type="number">
/// <item>
/// 0 - Success
/// </item>
/// <item>
/// 1 - Friend not found
/// </item>
/// </list>
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public int RemoveFriend(MySql database, string name)
{
int error = 0;
int friendIndex = friends.IndexOf(name);
if (friendIndex > -1)
{
QuickRemove(friendIndex);
if (UpdateOnDemand && database != null)
{
database.DeleteRow("friends", "CharID = \'" + ownerCharID + "\' AND FriendName = \'" + name + "\'");
}
}
else
{
error = 1;
}
return(error);
}
public static List <string> LoadPartyIDList(MySql database)
{
List <string> idList = new List <string>();
string query = "SELECT parties.PartyID " +
"FROM parties;";
List <DataColumnCollection> rows = database.RetrieveRows(query);
if (rows != null)
{
for (int i = 0; i < rows.Count; i++)
{
if (!idList.Contains(rows[i]["PartyID"].ValueString))
{
idList.Add(rows[i]["PartyID"].ValueString);
}
}
}
return(idList);
}
public static List <ModelVegzettseg> getVegzettsegek(string command)
{
MySql mySql = new MySql();
List <ModelVegzettseg> list = new List <ModelVegzettseg>();
if (mySql.dbOpen() == true)
{
mySql.cmd = new MySqlCommand(command, mySql.conn);
mySql.sdr = mySql.cmd.ExecuteReader();
while (mySql.sdr.Read())
{
list.Add(new ModelVegzettseg
{
id = Convert.ToInt32(mySql.sdr["id"]),
megnevezes_vegzettseg = mySql.sdr["megnevezes_vegzettseg"].ToString(),
});
}
mySql.sdr.Close();
}
return(list);
}
public static Model selectByModelId(int modelId, MySql connection)
{
string selectStatement = "SELECT * FROM Model WHERE (modelId='" + modelId + "')";
SqlDataReader objectFromDatabase = connection.Select(selectStatement);
if (objectFromDatabase != null)
{
if (objectFromDatabase.HasRows)
{
objectFromDatabase.Read();
Model returnObject = new Model(Convert.ToInt32(objectFromDatabase["modelId"]),
Convert.ToInt32(objectFromDatabase["manufacturerId"]),
objectFromDatabase["description"].ToString());
objectFromDatabase.Close();
return(returnObject);
}
objectFromDatabase.Close();
return(null);
}
return(null);
}
/// <summary>
/// Get all lesson assosiated with a given appointment
/// </summary>
/// <param name="id">the id of the appointment</param>
/// <param name="lessonTable">Optional* the table to execute on</param>
/// <returns>list of assosiated lessons</returns>
public static List <Lesson> GetAllLessonsFromAppointmentID(int id, string lessonTable = LessonTable)
{
DataTable result = MySql.GetAllLessonsFromAppointmentID(id, lessonTable);
List <Lesson> lessonsAppointment = new List <Lesson>();
foreach (DataRow lesson in result.Rows)
{
lessonsAppointment.Add(new Lesson(
Convert.ToInt32(lesson[0]),
Convert.ToInt32(lesson[1]),
Convert.ToInt32(lesson[2]),
Convert.ToInt32(lesson[3]),
Convert.ToInt32(lesson[4]),
(DateTime)lesson[5],
(DateTime)lesson[6],
Convert.ToBoolean(lesson[7])));
}
return(lessonsAppointment);
}
public static List <ModelErtesulesek> getErtesulesek(string command)
{
MySql mySql = new MySql();
List <ModelErtesulesek> list = new List <ModelErtesulesek>();
if (mySql.dbOpen() == true)
{
mySql.cmd = new MySqlCommand(command, mySql.conn);
mySql.sdr = mySql.cmd.ExecuteReader();
while (mySql.sdr.Read())
{
list.Add(new ModelErtesulesek
{
id = Convert.ToInt32(mySql.sdr["id"]),
ertesules_megnevezes = mySql.sdr["ertesules_megnevezes"].ToString(),
});
}
mySql.sdr.Close();
}
return(list);
}
public static List <ModelNyelv> getNyelv(string query)
{
MySql mySql = new MySql();
List <ModelNyelv> items = new List <ModelNyelv>();
if (mySql.dbOpen() == true)
{
mySql.cmd = new MySqlCommand(query, mySql.conn);
mySql.sdr = mySql.cmd.ExecuteReader();
while (mySql.sdr.Read())
{
items.Add(new ModelNyelv
{
id = Convert.ToInt32(mySql.sdr["id"]),
nyelv = mySql.sdr["megnevezes_nyelv"].ToString(),
});
}
mySql.sdr.Close();
}
return(items);
}
private void UpdateUserList()
{
MySql sql = new MySql();
sql.OpenConnection();
DataTable users =
sql.GetDataSet(
"SELECT ReviewerID, FirstName, LastName, Email, IF(AdminAccess = 1, \'yes\', \'no\') as AdminAccess FROM feedbacksystem.reviewer where Archived = 0;");
UserDGV.DataSource = users;
for (int a = 0; a < UserDGV.ColumnCount - 2; a++)
{
UserDGV.Columns[a].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
}
UserDGV.Columns[UserDGV.ColumnCount - 2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
sql.CloseConnection();
}
/// <summary>МЕТОД Фильтруем данные для больших таблиц</summary>
protected override void MET_SqlFilter()
{
PRO_SqlWhere = $"\nwhere isnull(k.xDelete, 0) = 0 and p.pDate >= '{PRI_DatePicker_1.SelectedDate:yyyy-MM-dd}'";
// Фильтр по наличию выписки
if (PRI_CheckBox_1.IsChecked == true)
{
PRO_SqlWhere += " and iif(p3.pDate > p.pDate, p3.pDate, null) is null";
}
// ФИО пациента
if (PRO_TextFilter.Length > 0)
{
PRO_SqlWhere += $" and (k.FAM like '{PRO_TextFilter}%' or k.FAM like '{PRO_TextFilterTransliter}%')";
}
// Запрос
MySql.MET_DsAdapterFill(MET_SelectQuery(), PRO_TableName);
// Выделяем первую строку
if (PRO_DataView != null && PRO_DataView.Table.Rows.Count != -1)
{
PART_DataGrid.SelectedIndex = 0;
}
}
/// <summary>МЕТОД Создание фильтров для загрузки данных из SQL</summary>
protected override void MET_SqlFilter()
{
PRO_SqlWhere = "where isnull(a.xDelete, 0) = 0";
// Фильтр по дате
if (PRI_DatePicker_1.IsEnabled)
{
PRO_SqlWhere += $" and a.DN <= '{PRI_DatePicker_1.DisplayDate:MM.dd.yyyy}' and (a.DK is NULL or a.DK >= '{PRI_DatePicker_1.DisplayDate:MM.dd.yyyy}')";
}
// Фильтр по отделению
if (PRI_ComboBox_2.IsEnabled)
{
PRO_SqlWhere += $" and a.Otd = {PRI_ComboBox_2.SelectedValue}";
}
// ФИО пациента
if (PRO_TextFilter.Length > 0)
{
PRO_SqlWhere += $" and (k.FAM like '{PRO_TextFilter}%' or k.FAM like '{PRO_TextFilterTransliter}%')";
}
// Запрос
MySql.MET_DsAdapterFill(MET_SelectQuery(), PRO_TableName);
}
public static InstancedMap LoadInstancedMap(MySql database, string mapID)
{
InstancedMap map = new InstancedMap(mapID);
LoadMapDump(database, mapID, map);
string query = "SELECT map_instanced_data.MapBase FROM map_instanced_data WHERE map_instanced_data.MapID = \'" + database.VerifyValueString(mapID) + "\'";
DataColumnCollection row = database.RetrieveRow(query);
if (row != null)
{
int counter = 0;
map.MapBase = Convert.ToInt32(row[counter++].Value);
}
else
{
throw new Exception("Instanced map data not found");
}
return(map);
}
///<summary>МЕТОД Действие при сохранении</summary>
public override bool MET_Save()
{
// Если операции добавляли или сменили дату операции или меняем данные xInfo
if ((PRI_Insert | PROP_FormShablon.PUB_VirtualNodes.PROP_Data != PRI_Date | PROP_xInfo != PROP_Json?.ToString()) & PRI_FlagNew)
{
// Удаляем старые кода операций, если они не были синхронизированны
MySql.MET_QueryNo(MyQuery.Oper_Delete_1(PROP_FormShablon.PROP_Cod));
// Помечаем для удаления старые кода, которые были синхронизированы
MySql.MET_QueryNo(MyQuery.Oper_Update_1(PROP_FormShablon.PROP_Cod));
// Создаем строку тегов
PROP_xInfo = PROP_Json?.ToString();
// Добавляем новые кода операций
for (int i = 0; i < PRI_Count; i++)
{
MySql.MET_QueryNo(MyQuery.Oper_Insert_1(MySql.MET_GetNextRef(5), MyGlo.KL, MyGlo.IND, PROP_FormShablon.PUB_VirtualNodes.PROP_Data,
MyGlo.Otd, PRI_mCodOper[i], PROP_FormShablon.PROP_Cod, PROP_xInfo));
}
PRI_Insert = false;
}
return(true);
}
public static Map LoadStandardMap(MySql database, string mapID)
{
Map map = new Map(mapID);
LoadRawMap(database, mapID, map);
string query = "SELECT map_standard_data.Instanced FROM map_standard_data WHERE map_standard_data.MapID = \'" + database.VerifyValueString(mapID) + "\'";
DataColumnCollection row = database.RetrieveRow(query);
if (row != null)
{
int counter = 0;
map.Instanced = row[counter++].ValueString.ToBool();
}
else
{
throw new Exception("Standard map data not found");
}
return(map);
}
private void SaveTemplateBtn_Click(object sender, EventArgs e)
{
using (SaveBox save = new SaveBox())
{
var result = save.ShowDialog();
if (result == DialogResult.OK)
{
MySql sql = new MySql();
sql.OpenConnection();
if (sql.SaveTemplate(_currentFeed.Header, _currentFeed.Sections, save.Title, save.Desc))
{
MessageBox.Show("Template successfully saved");
}
sql.CloseConnection();
}
}
}
protected void btnCreateCust_Click(object sender, EventArgs e)
{
LabelInvalidEmailVerif.Visible = false;
LabelInvalidPasswordVerif.Visible = false;
if (textBoxPassword.Text.Trim().Length > 0 &&
textBoxPassword.Text.CompareTo(textBoxPasswordVerify.Text) == 0 &&
textBoxEmail.Text.Trim().Length > 0 &&
textBoxEmail.Text.CompareTo(textBoxEmailVerify.Text) == 0 &&
textBoxFirstname.Text.Trim().Length > 0 &&
textBoxLastname.Text.Trim().Length > 0 &&
textBoxSSN.Text.Trim().Length > 0 &&
textBoxStreet.Text.Trim().Length > 0 &&
textBoxCity.Text.Trim().Length > 0 &&
textBoxZIP.Text.Trim().Length > 0 &&
textBoxCountry.Text.Trim().Length > 0
)
{
Customer customer = new Customer(0, textBoxFirstname.Text, textBoxLastname.Text, textBoxSSN.Text, textBoxEmail.Text, textBoxPassword.Text);
int cid = MySql.CreateContact(customer);
Address address = new Address(0, textBoxStreet.Text, textBoxCity.Text, textBoxZIP.Text, textBoxCountry.Text);
int aid = MySql.CreateAddress(address);
int c2a = MySql.C2A(cid, aid);
}
else
{
if (textBoxEmail.Text.CompareTo(textBoxEmailVerify.Text) != 0)
{
LabelInvalidEmailVerif.Visible = true;
}
if (textBoxPassword.Text.CompareTo(textBoxPasswordVerify.Text) != 0)
{
LabelInvalidPasswordVerif.Visible = true;
}
}
}
/// <summary>СОБЫТИЕ Нажали на кнопку "Загрузки шаблона в SQL филиала"</summary>
protected virtual void PRI_ButtonFromToFilialSQL_1_Click(object sender, RoutedEventArgs e)
{
DataRowView _DataRowView = (DataRowView)PART_DataGrid.SelectedItem;
int _CodShablon = Convert.ToInt16(_DataRowView.Row["Cod"]);
string _TipDoc = PRI_ComboBox_1.SelectedValue.ToString();
eTipDocum _eTip = eTipDocum.Null;
switch (_TipDoc)
{
case "apaN":
_eTip = eTipDocum.Pol;
break;
case "ast":
_eTip = eTipDocum.Stac;
break;
case "par":
_eTip = eTipDocum.Paracl;
break;
case "kdl":
_eTip = eTipDocum.Kdl;
break;
}
var _TipProtokol = new MyTipProtokol(_eTip);
// Вопрос на загрузку
if (MessageBox.Show($"Вы точно хотите загрузить {_CodShablon} шаблон на филиал?", "Вот это вопрос", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
if (MySql.MET_QueryNo(MyQuery.MET_Shablon_InsertToFilial_1(_CodShablon, _TipProtokol.PROP_Prefix)))
{
MessageBox.Show($"Успех!", "Загружено в SQL", MessageBoxButton.OK, MessageBoxImage.Asterisk);
}
else
{
MessageBox.Show($"Что то пошло не так!", "Загружено в SQL", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
public static void ProccessSettings(ClientHandler.ioData io, ref CLIENT_STRUCT ClientObj)
{
string SessionToken = Utilities.BytesToString(io.reader.ReadBytes(0x10));
byte[] Resp = new byte[0x8];
EndianWriter Data = new EndianIO(Resp, EndianStyle.BigEndian).Writer;
bool ClientFound = MySql.GetClient(ref ClientObj, SessionToken);
if (ClientFound)
{
if (ClientObj.settings != null)
{
ClientSettings Settings = JsonConvert.DeserializeObject <ClientSettings>(ClientObj.settings);
ClientObj.settings = JsonConvert.SerializeObject(Settings);
}
else
{
ClientSettings Settings = JsonConvert.DeserializeObject <ClientSettings>(ClientObj.settings);
Settings.Enable_BlockXblDns = false;
Settings.Enable_DrawGuideInformation = true;
Settings.Enable_CustomNotification = true;
Settings.Enable_LEImage = true;
Settings.Enable_Gradient = true;
Settings.Enable_GradientBG = true;
Settings.Enable_GradientBtns = true;
Settings.Enable_ColorFade = true;
Settings.Enable_MachineIDSpoof = true;
Settings.Enable_AW_Bypass = true;
Settings.Enable_BO2_Bypass = true;
Settings.Enable_BO3_Bypass = true;
ClientObj.settings = JsonConvert.SerializeObject(Settings);
MySql.SaveClient(ClientObj, SessionToken);
}
}
else
{
io.writer.Write((int)PACKET_STATUS.ERROR);
}
}
public Presupuesto cargarPresupuesto(int id_egreso, string CUIT, string[] items, string[] cantidades, string[] precios)
{
using (var context = new MySql())
{
var egreso = context.egresos.First(e => e.id_egreso == id_egreso);
var proveedor = context.proveedores.First(p => p.CUIT == CUIT);
Presupuesto nuevo = new Presupuesto();
nuevo.egreso = egreso;
nuevo.proveedor = proveedor;
context.presupuestos.Add(nuevo);
context.SaveChanges();
MongoDB.getInstancia().agregarLogABitacora($"Se ha agregado un presupuesto de id:{nuevo.id_presupuesto} al egreso de id:{egreso.id_egreso}");
try
{
for (int i = 0; i < items.Length; i++)
{
var item = new Item();
item.descripcion = items[i];
item.cantidad = Int32.Parse(cantidades[i]);
item.valor = Int32.Parse(precios[i]);
item.presupuesto = nuevo;
item.prov = proveedor;
context.items.Add(item);
context.SaveChanges();
MongoDB.getInstancia().agregarLogABitacora($"Se ha agregado un item de id: {item.id_item} al presupuesto de id:{nuevo.id_egreso}");
}
nuevo.calcular_total();
context.SaveChanges();
}
catch (NullReferenceException) { }
return(nuevo);
}
}
public static void ProcessVerifyTkn(ClientHandler.ioData io, ref CLIENT_STRUCT ClientObj, ref TOKEN_STRUCT TokenObj)
{
string SessionToken = Utilities.BytesToString(io.reader.ReadBytes(0x10));
string Token = new string(io.reader.ReadChars(0xC));
string Ip = io.ipaddr.Address.ToString().Split(new char[] { ':' })[0];
byte[] Resp = new byte[0xC];
EndianWriter Data = new EndianIO(Resp, EndianStyle.BigEndian).Writer;
bool ClientFound = MySql.GetClient(ref ClientObj, SessionToken);
if (ClientFound)
{
Data.Write((int)PACKET_STATUS.SUCCESS);
if (MySql.isValid(ref TokenObj, Token) && !MySql.isBlackListed(Token))
{
if (!MySql.isUsed(Token))
{
Data.Write((int)TOKEN_STATUS.CANREDEEM);
}
else
{
Data.Write((int)TOKEN_STATUS.ALREADYREDEEMED);
}
}
else
{
Data.Write((int)TOKEN_STATUS.INVALIDTOKEN);
}
}
else
{
Data.Write((int)PACKET_STATUS.ERROR);
Data.Write((int)TOKEN_STATUS.ERROR);
}
Data.Write(TokenObj.Days);
io.writer.Write(Resp);
MySql.SaveClient(ClientObj, SessionToken);
}
/// <summary>
/// Does the read.
/// </summary>
/// <param name="id">The id.</param>
/// <param name="sql">The SQL.</param>
/// <returns>read WLTableMessagesDto</returns>
/// <exception cref="NoSingleRowReturnedException">when 0 or more than one row is returned</exception>
private static WLTableMessagesDto DoRead(long id, MySql sql)
{
SqlQuery query = new SqlQuery("PA_WLTableMessages_SEL", sql);
query.AddParam("@WLTableId", SqlDbType.BigInt, 0, id, ParameterDirection.Input);
WLTableMessagesDto dto;
SqlDataReader dr = query.ExecuteReader();
try
{
int rowsCalc;
if (dr.Read())
{
dto = MakeDtoByReader(dr);
rowsCalc = 1;
while (dr.Read())
{
rowsCalc++;
}
}
else
{
throw new NoSingleRowReturnedException(0, "PA_WLTableMessages_SEL", query.ToString());
}
if (rowsCalc != 1)
{
throw new NoSingleRowReturnedException(rowsCalc, "PA_WLTableMessages_SEL", query.ToString());
}
}
finally
{
dr.Close();
}
return(dto);
}
/// <summary>МЕТОД Отмена удаление протокола</summary>
public void MET_Restore()
{
// Восстановление для PDF
if (PROP_TipProtokol.PROP_TipDocum == eTipDocum.Kdl && PROP_NumShablon == 2000)
{
MET_RestorePdf();
return;
}
if (PROP_xDelete == 1)
{
PROP_xDelete = 0;
PROP_xDateUp = DateTime.Today;
PROP_xUserUp = MyGlo.User;
// Обновим логи
MET_ChangeLogs(MyGlo.User, "Изменён");
string _StrSql = MyQuery.MET_Protokol_Update_2(PROP_Cod, PROP_xDelete, PROP_xDateUp, PROP_xUserUp,
PROP_TipProtokol.PROP_Prefix, PROP_xLog);
// Обновим протокол в SQL
MySql.MET_QueryNo(_StrSql);
}
}
public override bool Delete()
{
if (teacher_id == null || teacher_id.Trim() == "")
{
error_string = "teacher_id不能为空";
return(false);
}
string sql = "delete from work_teach where teacher_id='@teacher_id'";
sql = sql.Replace("@teacher_id", teacher_id);
string re_str = MySql.ExecSql(sql);
if (re_str == "[{ }]")
{
return(true);
}
else
{
error_string = re_str;
return(false);
}
}
/// <summary>СОБЫТИЕ Нажали на кнопку Проверить старый ОКАТО</summary>
private void PART_ButtonOldOKATO_Click(object sender, RoutedEventArgs e)
{
oldOKATO = PART_TextBoxOldOKATO.Text;
if (oldOKATO == "")
{
PART_RichTextBox.AppendText("Введите в поле Старый номер ОКАТО\n");
return;
}
// Ищем старый ОКАТО
string _oldAdres = MySql.MET_QueryStr($"select isnull((select SOCR + '. ' + NAME + '; ' from Bazis.dbo.KLADR where OCATD = {oldOKATO} for xml path('')), 'не нашел')");
PART_RichTextBox.AppendText($"### Старый ОКАТО: {oldOKATO}\n");
PART_RichTextBox.AppendText($"Адреса: {_oldAdres}\n");
if (_oldAdres == "не нашел" || _oldAdres == "")
{
PART_ButtonNewOKATO.IsEnabled = false;
newOKATO = "";
return;
}
PART_ButtonNewOKATO.IsEnabled = true;
}
public override bool Delete()
{
if (speciality_id == null || speciality_id.Trim() == "")
{
error_string = "speciality_id不能为空";
return(false);
}
string sql = "delete from work_speciality where speciality_id='@speciality_id'";
sql = sql.Replace("@speciality_id", speciality_id);
string re_str = MySql.ExecSql(sql);
if (re_str == "[{ }]")
{
return(true);
}
else
{
error_string = re_str;
return(false);
}
}
/// <summary>
/// Saves the specified dto.
/// </summary>
/// <param name="dto">The dto.</param>
/// <param name="mySql">My SQL.</param>
private static void DoSave(WLTableMessagesDto dto, MySql mySql)
{
bool isNew = dto.IsNew;
string queryType = isNew ? "INS" : "UPD";
SqlQuery query = new SqlQuery("PA_WLTableMessages_" + queryType, mySql);
query.AddParam("@WLTableId", SqlDbType.BigInt, 0, dto.WLTableId, ParameterDirection.Input);
query.AddParam("@BeachButlerMessage", SqlDbType.NVarChar, 200, dto.BeachButlerMessage, ParameterDirection.Input);
query.AddParam("@TableGenieLeftButtonMessage", SqlDbType.NVarChar, 200, dto.TableGenieLeftButtonMessage, ParameterDirection.Input);
query.AddParam("@TableGenieMiddleButtonMessage", SqlDbType.NVarChar, 200, dto.TableGenieMiddleButtonMessage, ParameterDirection.Input);
query.AddParam("@TableGenieRightButtonMessage", SqlDbType.NVarChar, 200, dto.TableGenieRightButtonMessage, ParameterDirection.Input);
query.AddParam("@WLDictChangeStatusId", SqlDbType.Int, 4, dto.WLDictChangeStatusId, ParameterDirection.Input);
query.ExecuteStoreProc();
if (dto.IsNew)
{
dto.SetIsNew(false);
}
}
private void AddHeaderBtn_Click(object sender, EventArgs e)
{
using (SelectControl form = new SelectControl("Header"))
{
var result = form.ShowDialog();
if (result == DialogResult.OK)
{
MySql sql = new MySql();
sql.OpenConnection();
Header selectedHeader = sql.GetHeader(form._ids[0]);
selectedHeader.HeaderItems.Clear();
foreach (HeaderItem i in sql.GetHeaderItems(selectedHeader.HeaderId))
{
selectedHeader.addHeaderItem(i);
}
sql.CloseConnection();
HeaderPlacement place = new HeaderPlacement();
HeaderPanel.Controls.Clear();
foreach (HeaderItem item in selectedHeader.HeaderItems)
{
place.AddItem(item);
}
HeaderPanel.Controls.Add(place);
ChangeHeader.Enabled = true;
HorizontalLine.Visible = true;
TextLabel.Visible = true;
_currentTemplate.Header = selectedHeader;
}
}
}
/// <summary>СОБЫТИЕ Смена Корпуса</summary>
private void PART_RadioButtonKorpus_ItemsChanged(object sender, RoutedEventArgs e)
{
// Если выбираем чужой корпус
if (PART_RadioButtonKorpus.PROP_Text != MyGlo.Korpus.ToString())
{
// Проверяем доступ сервера друго корпуса по SQL функции Ping (зависит от установленных IP)
if (!MySql.MET_Ping())
{
// Сервер другого корпуса недоступен
PART_LabrlPingError.Content = "(сервер другого корпуса - не доступен)";
PART_RadioButtonKorpus.PROP_Text = MyGlo.Korpus.ToString();
return;
}
PART_LabrlPingError.Content = "";
}
// Загружаем Элементы
MET_LoadElement();
MyGlo.DataSet.Tables["rnDate"]?.Clear(); // чистим даты
MyGlo.DataSet.Tables["rnTime"]?.Clear(); // чистим время
// Показываем куда записан пациент
// MET_LoadTalon();
}
