Ejemplo n.º 1
0
        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);
            }
        }
Ejemplo n.º 2
0
        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);
            }
        }
Ejemplo n.º 3
0
        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);
            }
        }
Ejemplo n.º 4
0
        public static string GetBiletSiralamaTipi()
        {
            string    alanAdi          = "BID";
            Hashtable hshBiletSiralama = DBProcess.SimpleQuery(
                "TERMINALLER",
                "WHERE TID = " + TerminalID,
                "",
                "SiralamaTipi" //BiletSiralama yoktu ben SiralamaTipi olarak deðiþtirdim (ek)
                );

            if (!hshBiletSiralama.ContainsKey("Error"))
            {
                DataTable dtBiletSiralama = (DataTable)hshBiletSiralama["DataTable"];
                if (dtBiletSiralama == null || dtBiletSiralama.Rows.Count < 0)
                {
                    return(alanAdi);
                }

                string tip = dtBiletSiralama.Rows[0][0].ToString();
                switch (tip)
                {
                case "1":
                    alanAdi = "BID";
                    break;

                case "2":
                    alanAdi = "BILET_NO";
                    break;
                }
                return(alanAdi);
            }
            else
            {
                return(alanAdi);
            }
        }