private void IsTransferOrFiktifTicket(int _TicketID, out bool _IsTransfer, out bool _IsFiktif)
{
_IsTransfer = false;
_IsFiktif = false;
Hashtable hshTicketInf = DBProcess.SimpleQuery("KUYRUK", "WHERE BID = " + _TicketID,
"", "TRANSFER, OZEL_MUSTERI");
DataTable dtTciketInf = null;
if (hshTicketInf.ContainsKey("Error"))
{
return;
}
else
{
dtTciketInf = (DataTable)hshTicketInf["DataTable"];
if (dtTciketInf.Rows.Count > 0)
{
_IsFiktif = bool.Parse(dtTciketInf.Rows[0]["OZEL_MUSTERI"].ToString());
_IsTransfer = bool.Parse(dtTciketInf.Rows[0]["TRANSFER"].ToString());
}
}
}
public bool Login(string p_UserName, string p_Pass)
{
Username = p_UserName;
Pass = p_Pass;
DataTable dtUserInf = (DataTable)DBProcess.SimpleQuery(
"PERSONELLER",
"WHERE KULLANICI_ADI='" + Username + "' AND SIFRE='" + Pass + "'",
"",
"PID, TID, AD, SOYAD"
)["DataTable"];
if (dtUserInf.Rows.Count > 0)
{
this.PersonelID = int.Parse(dtUserInf.Rows[0]["PID"].ToString());
this.Ad = dtUserInf.Rows[0]["AD"].ToString();
this.Soyad = dtUserInf.Rows[0]["SOYAD"].ToString();
this.TerminalID = int.Parse(dtUserInf.Rows[0]["TID"].ToString());
return(true);
}
else
{
return(false);
}
}
private static bool CheckLeapTicket()
{
bool durum = false;
try
{
DataTable dtQueue = (DataTable)DBProcess.SimpleQuery(
"KUYRUK INNER JOIN BILETLER ON KUYRUK.BID = BILETLER.BID",
"Where BILETLER.SIS_TAR < '" + DateTime.Now.ToString("yyyy.MM.dd") + "'",
"",
"KUYRUK.BID, BILETLER.SIS_TAR")["DataTable"];
if (dtQueue != null && dtQueue.Rows.Count > 0)
{
foreach (DataRow item in dtQueue.Rows)
{
DBProcess.DeleteData("KUYRUK", "Where BID = " + item[0]);
}
durum = true;
}
}
catch (Exception hata)
{
durum = false;
Console.WriteLine("CheckLeapTicket. Hata:" + hata.Message);
OlayGunluk.Olay("CheckLeapTicket. Hata:" + hata.Message);
}
return(durum);
}
public static bool GetOtoCagriAktif()
{
Hashtable hshOtoCagri = DBProcess.SimpleQuery(
"TERMINALLER",
"WHERE TID = " + TerminalID,
"",
"OTO_CAGRI"
);
if (!hshOtoCagri.ContainsKey("Error"))
{
DataTable dtOtoCagri = (DataTable)hshOtoCagri["DataTable"];
if (dtOtoCagri != null && dtOtoCagri.Rows.Count > 0)
{
return(bool.Parse(dtOtoCagri.Rows[0][0].ToString()));
}
else
{
return(false);
}
}
else
{
return(false);
}
}
public static bool GetDoubleClickCagriAktif()
{
Hashtable hshDoubleClick = DBProcess.SimpleQuery(
"TERMINALLER",
"WHERE TID = " + TerminalID,
"",
"DoubleClick"
);
if (!hshDoubleClick.ContainsKey("Error"))
{
DataTable dtDoubleClick = (DataTable)hshDoubleClick["DataTable"];
if (dtDoubleClick != null && dtDoubleClick.Rows.Count > 0)
{
return(bool.Parse(dtDoubleClick.Rows[0][0].ToString()));
}
else
{
return(false);
}
}
else
{
return(false);
}
}
internal DataTable FillChatHistory(DBProcess setting)
{
Stopwatch sw = new Stopwatch();
sw.Start();
this.log.LogWrite("Query : " + setting.DataFromSource, Log.LogType.Information);
try
{
OdbcConnection con = new OdbcConnection(setting.SourceConString);
OdbcDataAdapter da = new OdbcDataAdapter(setting.DataFromSource, con);
da.SelectCommand.CommandTimeout = 240;
da.SelectCommand.Parameters.AddWithValue("TRANSCRIPT", setting.UniqueValue);
DataTable dt = new DataTable();
da.Fill(dt);
this.log.LogWrite("Data Count : " + dt.Rows.Count, Log.LogType.Information);
sw.Stop();
this.log.LogWrite("Time Elapsed : " + sw.ElapsedMilliseconds, Log.LogType.Information);
return(dt);
}
catch (Exception ex)
{
this.log.LogWrite("Error at getting data. Error : " + ex.ToString(), Log.LogType.Error);
return(null);
}
}
public Hashtable New()
{
Hashtable hshNewTicket = new Hashtable();
hshNewTicket.Add("TID", TerminalID);
hshNewTicket.Add("GRPID", GrupID);
hshNewTicket.Add("BILET_NO", BiletNo);
hshNewTicket.Add("SIS_TAR", AlinmaTarihi);
hshNewTicket.Add("TRANSFER", Transfer);
hshNewTicket.Add("BTNID", ButonID);
hshNewTicket.Add("OZEL_MUSTERI", Fiktif);
Hashtable hshInsertState = DBProcess.InsertData("BILETLER", hshNewTicket);
if (!hshInsertState.ContainsKey("Error"))
{
string _BiletID = hshInsertState["Identity"].ToString(); hshInsertState.Clear(); hshInsertState = NewQueue(_BiletID);
if (hshInsertState.ContainsKey("Error"))
{
this.NewQueue(_BiletID);
}
}
return(hshInsertState);
}
public int GetCalledTicketCount()
{
int rv_CalledTicketCount = 0;
Hashtable hshCalledTicketResult;
DataTable dtCalledTicketCount;
string vs_WhereSQL = string.Empty;
vs_WhereSQL = string.Format(
"Where (TERMINAL_GRUP.TID = {0}) AND (BILETLER.SIS_TAR BETWEEN CONCAT(TIMESTAMPADD(dd, 0, TIMESTAMPDIFF(dd, 0, NOW())) , '00:00') AND CONCAT(TIMESTAMPADD(dd, 0, TIMESTAMPDIFF(dd, 0, NOW())) , '23:59'))",
// "Where (TERMINAL_GRUP.TID = {0}) AND (BILETLER.SIS_TAR BETWEEN DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE())) + '00:00' AND DATEADD(dd, 0, DATEDIFF(dd, 0, GETDATE())) + '23:59')",
this.TID);
hshCalledTicketResult = DBProcess.SimpleQuery(
"TERMINAL_GRUP RIGHT OUTER JOIN BILETLER ON TERMINAL_GRUP.TID = BILETLER.TID",
vs_WhereSQL,
"",
"COUNT(BILETLER.BID) AS [CalledTicketCount]"
);
if (!hshCalledTicketResult.ContainsKey("Error"))
{
dtCalledTicketCount = (DataTable)hshCalledTicketResult["DataTable"];
rv_CalledTicketCount = Convert.ToInt32(dtCalledTicketCount.Rows[0]["CalledTicketCount"]);
}
return(rv_CalledTicketCount);
}
public static int GetOtoCagriSuresi()
{
Hashtable hshOtoCagri = DBProcess.SimpleQuery(
"TERMINALLER",
"WHERE TID = " + TerminalID,
"",
"OTO_SURE"
);
if (!hshOtoCagri.ContainsKey("Error"))
{
DataTable dtOtoSure = (DataTable)hshOtoCagri["DataTable"];
if (dtOtoSure == null || dtOtoSure.Rows.Count < 0)
{
return(0);
}
DateTime dtTimeOtoSure = DateTime.Parse(dtOtoSure.Rows[0][0].ToString());
TimeSpan tsOtoCagriSuresi = new TimeSpan(dtTimeOtoSure.Hour, dtTimeOtoSure.Minute, dtTimeOtoSure.Second);
return(Convert.ToInt32(tsOtoCagriSuresi.TotalMilliseconds));
}
else
{
return(0);
}
}
public Hashtable UpdateOnlyBMAdres(string Where, int BMAdres)
{
Hashtable hshTableUpdate = new Hashtable();
hshTableUpdate.Add("BM_ADRES", BMAdres);
return(DBProcess.UpdateData("BUTONLAR", "WHERE " + Where, hshTableUpdate));
}
public int GetNextTicketNumber()
{
int NextTicketNumber = 0;
string strWhereSQL = string.Format("Where GRPID={0} AND (SIS_TAR BETWEEN '{1}' AND '{2}')",
newBilet.GrupID,
BiletTarih.ToString("MM.dd.yyyy 00:00:00"),
BiletTarih.ToString("MM.dd.yyyy 23:59:59")
);
DataTable dtTicketNumber = (DataTable)DBProcess.SimpleQuery("BILETLER",
strWhereSQL,
"ORDER BY BID DESC",
"TOP (1) BILET_NO")["DataTable"];
if (dtTicketNumber != null)
{
if (dtTicketNumber.Rows.Count > 0)
{
NextTicketNumber = int.Parse(dtTicketNumber.Rows[0][0].ToString()) + 1;
}
else
{
NextTicketNumber = grup.BaslangicNo;
}
}
else
{
NextTicketNumber = 0;
}
return(NextTicketNumber);
}
public void Delete(string Where, int TerminalId) //ikinci parametre örnek týp merkezi için eklendi
{
Hashtable hshDelete = DBProcess.DeleteData("KUYRUK", "Where " + Where);
Hashtable cl = new Hashtable();
cl["I_yf3"] = TerminalId;
//Hashtable hshDelete = DBProcess.UpdateData("KUYRUK", "Where " + Where, cl); //örnek týp merkezi
//deleteTryingCount++;
//if (hshDelete.ContainsKey("Error"))
//{
// if (deleteTryingCount <= 5)
// {
// Delete(Where, TerminalId);
// }
// else
// {
// hshDelete.Clear();
// hshDelete.Add("GRPID", 0);
// Update("BID" + BiletID, hshDelete);
// }
//}
}
public void ToIncreaseOrResetTransferRatio(int TermID, int GrpID)
{
string strWhereSQL = string.Format("Where TID={0} AND GRPID={1}", TermID, GrpID);
int transferCagriOran = 0, transferCagrilan = 0;
Hashtable hshIncrease;
DataTable dtCallRatio = (DataTable)DBProcess.SimpleQuery(
"TERMINAL_GRUP",
strWhereSQL,
"",
"TRANSFER_ORAN, TRANSFER_CAGRILAN"
)["DataTable"];
transferCagriOran = int.Parse(dtCallRatio.Rows[0]["TRANSFER_ORAN"].ToString());
transferCagrilan = int.Parse(dtCallRatio.Rows[0]["TRANSFER_CAGRILAN"].ToString());
hshIncrease = new Hashtable();
if (transferCagriOran > transferCagrilan + 1)
{
hshIncrease.Add("TRANSFER_CAGRILAN", transferCagrilan + 1);
}
else
{
hshIncrease.Add("TRANSFER_CAGRILAN", 0);
}
DBProcess.UpdateData("TERMINAL_GRUP", "Where TID=" + TermID + " AND GRPID=" + GrpID, hshIncrease);
}
public int GetNextTicketNumber(bool sureliMi)
{
//süreli mi true ise, verilemeyen biletlerden ilki gelmeli.
int NextTicketNumber = 0;
string strWhereSQL =
string.Format(
"Where GRPID={0} AND (SIS_TAR BETWEEN '{1}' AND '{2}') AND (OZEL_MUSTERI='False') AND (TRANSFER='False') ",
this.GrupID,
BiletTarih.ToString("yyyy.MM.dd 00:00:00"),
BiletTarih.ToString("yyyy.MM.dd 23:59:59")
);
DataTable dtTicketNumber = (DataTable)DBProcess.SimpleQuery("BILETLER",
strWhereSQL,
"ORDER BY BID DESC limit 1",
"BILET_NO")["DataTable"];
if (dtTicketNumber != null)
{
if (dtTicketNumber.Rows.Count > 0)
{
NextTicketNumber = int.Parse(dtTicketNumber.Rows[0][0].ToString()) + 1;
}
else
{
NextTicketNumber = grup.BaslangicNo;
}
}
else
{
NextTicketNumber = 0;
}
return(NextTicketNumber);
}
private bool TerminalHasThisGroup(string _grpID, out bool _IsAssistGroup)
{
string strWhereSQL = string.Format("WHERE TID = {0} AND GRPID = {1}", SanalTerminal.TerminalID, _grpID);
Hashtable hshGroups = DBProcess.SimpleQuery("TERMINAL_GRUP", strWhereSQL, "", "YARDIM_GRUBU");
DataTable dtGroupInf = null;
_IsAssistGroup = false;
if (hshGroups.ContainsKey("Error"))
{
return(false);
}
else
{
dtGroupInf = (DataTable)hshGroups["DataTable"];
if (dtGroupInf.Rows.Count > 0)
{
_IsAssistGroup = bool.Parse(dtGroupInf.Rows[0][0].ToString());
return(true);
}
else
{
return(false);
}
}
}
public DataTable Get()
{
DataTable dtGetData = (DataTable)DBProcess.SimpleQuery("KIOSK_AYAR",
"",
"", "*")["DataTable"];
return(dtGetData);
}
public void SetTicketStateToDone(int _BiletID)
{
Hashtable hshTicketDone = new Hashtable();
hshTicketDone.Add("ISLEM_BIT_TAR", this.IslemBitisSaati);
DBProcess.UpdateData("BILETLER", "Where BID=" + _BiletID, hshTicketDone);
}
public void UpdateLoginState(bool IsLogin)
{
Hashtable hshUpdateStates = new Hashtable();
hshUpdateStates.Add("OTURUM_DURUM", IsLogin);
DBProcess.UpdateData("PERSONELLER", "WHERE PID = " + this.PersonelID, hshUpdateStates);
}
public void SetLastCallingGroup(int TermID, int GrpID, bool TicketType)
{
Hashtable hshUpdate = new Hashtable();
hshUpdate.Add("SON_CAGRILAN_GRUP", GrpID);
hshUpdate.Add("SON_CAGRILAN_TUR", TicketType);
DBProcess.UpdateData("TERMINALLER", "Where TID=" + TermID, hshUpdate);
}
public DataTable Get(string Where, string Columns)
{
DataTable dtGroups = (DataTable)DBProcess.SimpleQuery("GRUPLAR",
"Where " + Where + " AND SIL='False'",
"ORDER BY GRPID DESC",
Columns)["DataTable"];
return(dtGroups);
}
public DataTable Get(string Columns)
{
DataTable dtGet = (DataTable)DBProcess.SimpleQuery("SISTEM_CONFIG",
"",
"",
Columns)["DataTable"];
return(dtGet);
}
public DataTable Get(string Where, string Columns)
{
DataTable dtGetData = (DataTable)DBProcess.SimpleQuery("BUTONLAR",
"Where " + Where,
"", Columns)["DataTable"];
return(dtGetData);
}
public void ResetCallAndTransferRatio(int _TermID)
{
Hashtable hshReset = new Hashtable();
hshReset.Add("CAGRILAN", 0);
hshReset.Add("TRANSFER_CAGRILAN", 0);
DBProcess.UpdateData("TERMINAL_GRUP", "Where TID=" + _TermID, hshReset);
}
public DataTable Get(string Where)
{
DataTable dtGet = (DataTable)DBProcess.SimpleQuery("BILET_AYAR",
"Where " + Where,
"ORDER BY KID DESC",
"*")["DataTable"];
return(dtGet);
}
public static DataTable LoadToControl()
{
DataTable dtData = (DataTable)DBProcess.SimpleQuery("GRUPLAR",
"Where SIL='False'",
"ORDER BY GRPID DESC",
"GRPID, GRUP_ISMI")["DataTable"];
return(dtData);
}
public DataTable Get(string Where, string Columns)
{
DataTable dtGet = (DataTable)DBProcess.SimpleQuery("BILETLER",
"Where " + Where,
"ORDER BY BID DESC",
Columns)["DataTable"];
return(dtGet);
}
public DataTable Get(string Where, string Columns, string OrderBy)
{
DataTable dtGroups = (DataTable)DBProcess.SimpleQuery("GRUPLAR",
"Where " + Where + " AND SIL='False'",
OrderBy,
Columns)["DataTable"];
return(dtGroups);
}
private void cmdChangeSQLPort_Click(object sender, EventArgs e)
{
try
{
UInt16 newPort;
UInt16 oldPort;
if (UInt16.TryParse(txtSQLConnectionPort.Text, out newPort))
{
Boolean isOccupied = DBProcess.IsListenerOnPort(newPort) || DBProcess.IsConnectionOnPort(newPort);
if (!isOccupied)
{
oldPort = Program.IniFile.GetValue <UInt16>("DB_Server", "Port", "3306");
if (MessageBox.Show(this, "Change db-port from " + oldPort + " to " + newPort + " ?", "Aborted", MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation) == DialogResult.OK)
{
// switch off the general log for the database
STA.Settings.INIFile dbIniFile;
if (Debugger.IsAttached)
{
dbIniFile = new STA.Settings.INIFile(Path.Combine(Program.IniFile.GetValue("DB_Server", "WorkingDirectory", @"..\..\..\RNDatabase\Database"), "Elite.ini"), false, true, true);
}
else
{
dbIniFile = new STA.Settings.INIFile(Program.GetDataPath(@"Database\Elite.ini"), false, true, true);
}
Program.IniFile.SetValue("DB_Server", "Port", newPort.ToString());
dbIniFile.SetValue("mysqld", "port", newPort.ToString());
MessageBox.Show(this, "Port changed, restart required.", "Changed configuration", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
txtSQLConnectionPort.Text = Program.IniFile.GetValue <UInt16>("DB_Server", "Port", "3306").ToString();
}
}
else
{
MessageBox.Show(this, "Selected port is already occupied", "Aborted", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtSQLConnectionPort.Text = Program.IniFile.GetValue <UInt16>("DB_Server", "Port", "3306").ToString();
}
}
else
{
MessageBox.Show(this, "Couldn't parse value as <UInt16>", "Aborted", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
txtSQLConnectionPort.Text = Program.IniFile.GetValue <UInt16>("DB_Server", "Port", "3306").ToString();
}
}
catch (Exception ex)
{
CErr.processError(ex, "Error while changing the tcp-port of the sql-server");
}
}
public bool IsActive(int _BtnID, int _KioskID)
{
DataTable dtIsAktif = (DataTable)DBProcess.SimpleQuery(
"BUTONLAR",
" WHERE BM_ADRES = " + _KioskID + " AND BTNID = " + _BtnID,
"",
"AKTIF")["DataTable"];
return(bool.Parse(dtIsAktif.Rows[0][0].ToString()));
}
public Hashtable New()
{
Hashtable hshNewCoffeBreak = new Hashtable();
hshNewCoffeBreak.Add("PID", PersonelID);
hshNewCoffeBreak.Add("BAS_TARIH", MolaBaslangic);
hshNewCoffeBreak.Add("MOLADA", true);
return(DBProcess.InsertData("MOLALAR", hshNewCoffeBreak));
}
