Cancel() public method

Attempts to cancel the execution of a NpgsqlCommand.
This Method isn't implemented yet.
public Cancel ( ) : void
return void
Beispiel #1
0
        /*
        function name AddStudents_Click
        inputs: query
        outputs: add student studying lesson and cancel student studying lesson
        errors:
        */
        private void AddStudents_Click(object sender, EventArgs e)
        {
            string str = "Uid=postgres; Password=123; server=localhost; port=5432; Database=classmanagement;";
            NpgsqlConnection conn = new NpgsqlConnection(str);
            conn.Open();

            foreach (DataGridViewRow dr in dataGridView1.Rows)
            {
                int n = dr.Index;
                if (dr.Cells[0].Value != null)
                {

                    String insert = "";

                    String select1 = "SELECT studentname FROM attendance WHERE studentname='" + dataGridView1.Rows[n].Cells[1].Value + "'AND subjectname='" + comboBox1.Text + "'";
                    NpgsqlCommand select_command1 = new NpgsqlCommand(select1, conn);
                    NpgsqlDataReader read = select_command1.ExecuteReader();
                    if (read.Read())
                    {
                        MessageBox.Show("Error message", "error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }
                    else
                    {
                        insert = "INSERT into attendance VALUES('" + dataGridView1.Rows[n].Cells[2].Value + "','" + dataGridView1.Rows[n].Cells[3].Value + "','" + comboBox1.Text + "')";
                        NpgsqlCommand command = new NpgsqlCommand(insert, conn);
                        command.ExecuteNonQuery();
                        command.Cancel();
                        String select = "SELECT name,start_time,start_minute,finish_time,finish_minute FROM subject WHERE name='" + comboBox1.Text + "'";
                        NpgsqlCommand select_command = new NpgsqlCommand(select, conn);
                        NpgsqlDataReader reader1 = select_command.ExecuteReader();
                        NpgsqlCommand baba = new NpgsqlCommand();
                        if (reader1.Read())
                        {
                            int num1 = Convert.ToInt32(reader1[1]);
                            int num2 = Convert.ToInt32(reader1[2]);
                            int num3 = Convert.ToInt32(reader1[3]);
                            int num4 = Convert.ToInt32(reader1[4]);
                            String ins = "INSERT into startfinish VALUES('" + comboBox1.Text.ToString() + "','" + dataGridView1.Rows[n].Cells[2].Value + "','" + dataGridView1.Rows[n].Cells[3].Value + "','" + num1 + "','" + num2 + "','" + num3 + "','" + num4 + "')";
                            baba = new NpgsqlCommand(ins, conn);

                        }
                        reader1.Close();
                        baba.ExecuteNonQuery();

                        insert = "INSERT into homework VALUES('" + dataGridView1.Rows[n].Cells[2].Value + "','" + dataGridView1.Rows[n].Cells[3].Value + "','" + comboBox1.Text.ToString() + "')";
                        NpgsqlCommand comm = new NpgsqlCommand(insert, conn);
                        comm.ExecuteNonQuery();

                        insert = "INSERT into grade VALUES('" + comboBox1.Text.ToString() + "','" + dataGridView1.Rows[n].Cells[2].Value + "','" + dataGridView1.Rows[n].Cells[3].Value + "')";
                        NpgsqlCommand comm1 = new NpgsqlCommand(insert, conn);
                        comm1.ExecuteNonQuery();

                        //MessageBox.Show("success.");
                    }
                    read.Close();
                }
                else
                {
                    String delete = "DELETE FROM attendance WHERE studentname='" + dataGridView1.Rows[n].Cells[2].Value + "' AND subjectname='"+comboBox1.Text+"'";
                    NpgsqlCommand comm = new NpgsqlCommand(delete, conn);
                    comm.ExecuteNonQuery();

                    delete = "DELETE FROM startfinish WHERE student_name='" + dataGridView1.Rows[n].Cells[2].Value + "' AND lesson_name='"+comboBox1.Text+"'";
                    NpgsqlCommand comm1 = new NpgsqlCommand(delete, conn);
                    comm1.ExecuteNonQuery();

                    delete = "DELETE FROM homework WHERE studentname='" + dataGridView1.Rows[n].Cells[2].Value + "' AND subjectname='" + comboBox1.Text + "'";
                    NpgsqlCommand comm2 = new NpgsqlCommand(delete, conn);
                    comm2.ExecuteNonQuery();

                    delete = "DELETE FROM grade WHERE student_name='" + dataGridView1.Rows[n].Cells[2].Value + "' AND lesson='" + comboBox1.Text + "'";
                    NpgsqlCommand comm3 = new NpgsqlCommand(delete, conn);
                    comm3.ExecuteNonQuery();
                }

            }
            conn.Close();
        }
Beispiel #2
0
 public void CancelCrossCommand()
 {
     using (var cmd1 = CreateSleepCommand(Conn, 2))
     using (var cmd2 = new NpgsqlCommand("SELECT 1", Conn)) {
         var cancelTask = Task.Factory.StartNew(() =>
         {
             Thread.Sleep(300);
             cmd2.Cancel();
         });
         Assert.That(() => cmd1.ExecuteNonQuery(), Throws.Nothing);
         cancelTask.Wait();
     }
 }
Beispiel #3
0
 public void Cancel()
 {
     using (var cmd = new NpgsqlCommand("SELECT pg_sleep(5)", Conn))
     {
         Task.Factory.StartNew(() =>
         {
             Thread.Sleep(300);
             cmd.Cancel();
         });
         Assert.That(() => cmd.ExecuteNonQuery(),
             Throws.TypeOf<NpgsqlException>()
             .With.Property("Code").EqualTo("57014")
         );
     }
 }
        //public override MembershipUserCollection GetAllUsers(int pageIndex, int pageSize, out int totalRecords)
        public MembershipUserCollection GetAllUsers(string providerName, string applicationname, int pageIndex, int pageSize)
        {
            MembershipUserCollection users = new MembershipUserCollection();
            using (NpgsqlConnection conn = new NpgsqlConnection(GetConnectionString()))
            {
                string query = string.Format(
                    QRY_GET_ALL_USER_BY_APPLICATION,
                    applicationname);
                using (NpgsqlCommand cmd = new NpgsqlCommand(query, conn))
                {
                    NpgsqlDataReader reader = null;
                    try
                    {
                        conn.Open();
                        reader = cmd.ExecuteReader();
                        int counter = 0;
                        int startIndex = pageSize * pageIndex;
                        int endIndex = startIndex + pageSize - 1;
                        while (reader.Read())
                        {
                            if (counter >= startIndex)
                            {
                                MembershipUser u = GetUserFromReader(providerName, reader);
                                users.Add(u);
                            }

                            if (counter >= endIndex)
                                cmd.Cancel();
                            ++counter;
                        }
                    }
                    catch (NpgsqlException ex)
                    {
                        Logger.Instance.Write (TrackProtect.Logging.LogLevel.Error, ex, "GetAllUsers<NpgsqlException>");
                    }
                    finally
                    {
                        if (reader != null)
                            reader.Close();
                        conn.Close();
                    }
                }
            }
            return users;
        }
        public MembershipUserCollection FindUsersByName(string providerName, string usernameToMatch, string applicationname, int pageIndex, int pageSize, out int totalRecords)
        {
            MembershipUserCollection users = new MembershipUserCollection();
            using (NpgsqlConnection conn = new NpgsqlConnection(GetConnectionString()))
            {
                string query = string.Format(
                    QRY_SELECT_USER_COUNT_BY_NAME,
                    usernameToMatch,
                    applicationname);
                using (NpgsqlCommand cmd = new NpgsqlCommand(QRY_SELECT_USER_COUNT_BY_NAME, conn))
                {
                    NpgsqlDataReader reader = null;

                    try
                    {
                        conn.Open();
                        totalRecords = (int)cmd.ExecuteScalar();

                        if (totalRecords <= 0) { return users; }

                        query = string.Format(
                            QRY_GET_USER_BY_NAME_AND_APPLICATION_ORDERED,
                            usernameToMatch,
                            applicationname);
                        cmd.CommandText = query;

                        reader = cmd.ExecuteReader();

                        int counter = 0;
                        int startIndex = pageSize * pageIndex;
                        int endIndex = startIndex + pageSize - 1;

                        while (reader.Read())
                        {
                            if (counter >= startIndex)
                            {
                                MembershipUser u = GetUserFromReader(providerName, reader);
                                users.Add(u);
                            }

                            if (counter >= endIndex) { cmd.Cancel(); }

                            counter++;
                        }
                    }
                    catch (NpgsqlException e)
                    {
                        if (WriteExceptionsToEventLog)
                        {
                            WriteToEventLog(e, "FindUsersByName");

                            throw new ProviderException(EXCEPTION_MESSAGE);
                        }
                        else
                        {
                            throw e;
                        }
                    }
                    finally
                    {
                        if (reader != null) { reader.Close(); }

                        conn.Close();
                    }
                }
            }

            return users;
        }
        private void timer_Tick(object sender, System.Timers.ElapsedEventArgs e)
        {
            timer.Enabled = false;
            CustomBase.Rec rec = new CustomBase.Rec();
            L.Log(LogType.FILE, Log.LogLevel.INFORM, "Service Started");
            string readQuery = null;
            PostGreConnection pgc = new PostGreConnection();
            NpgsqlDataReader readReader = null;
            NpgsqlCommand command = null;

            try
            {
                if (!reg_flag)
                {
                    if (!Read_Registry())
                    {
                        L.Log(LogType.FILE, Log.LogLevel.ERROR, "Error on Reading the Registry ");
                        return;
                    }
                    else
                        if (!Initialize_Logger())
                        {
                            L.Log(LogType.FILE, Log.LogLevel.ERROR, "Error on Intialize Logger on McaffeeEpo Recorder functions may not be running");
                            return;
                        }
                    reg_flag = true;
                }

                if (fromend)
                {
                    if (!Set_LastPosition())
                        L.Log(LogType.FILE, Log.LogLevel.INFORM, "Error on setting last position see eventlog for more details");
                    fromend = false;
                }

                readQuery = "Select kayit_tarih,kayit_saat,kullanici_ip,kullanici_name,table_name,prev_data,current_data,url,kodu from loglar where kodu > " + last_position.ToString() + " ORDER BY kodu";

                //readQuery = "Select * from loglar";
                L.Log(LogType.FILE, Log.LogLevel.DEBUG, " Query for EventLogTable is " + readQuery);

                pgc.OpenPostGreConnection(remote_host, user, password, mcdb_name);

                command = new NpgsqlCommand();

                readReader = pgc.ExecutePostGreQuery(readQuery, ref command);

                //if (readReader.Read() != false)
                //{
                //    L.Log(LogType.FILE, Log.LogLevel.INFORM, "timer_Tick() ----> Query Which Was Executed Bring Data");
                //}

                int i = 0;
                while (readReader.Read())
                {
                    rec.LogName = "NetCadPostGre Recorder";

                    string date = "";
                    string time = "";
                    string date_time = "";

                    date = readReader[0].ToString();
                    time = readReader[1].ToString();

                    string saat = time.Split(' ')[0].Trim();
                    string zamanDilimi = time.Split(' ')[1].Trim();

                    if (zamanDilimi == "AM")
                        time = saat + ":00";
                    else
                        time = (Convert.ToInt32(saat.Split(':')[0]) + 12).ToString() + ":" + saat.Split(':')[1] + ":00";

                    date = date.Split('/')[1] + "/" + date.Split('/')[0] + "/" + date.Split('/')[2];
                    date_time = date + " " + time;

                    try
                    {
                        rec.Datetime = Convert.ToDateTime(date_time).AddMinutes(zone).ToString("yyyy/MM/dd HH:mm:ss.fff");
                    }
                    catch (Exception ex)
                    {
                        rec.Datetime = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss.fff");
                        L.Log(LogType.FILE, Log.LogLevel.ERROR, "In timer_Tick()-->> An Error Occured While Parsing kayit_tarih and kayit_saat " + ex.Message);
                    }

                    //L.Log(LogType.FILE, Log.LogLevel.INFORM, "rec.Datetime is : " +rec.Datetime);

                    string kullaniciIP = "";
                    kullaniciIP = readReader[2].ToString();
                    try
                    {
                        rec.CustomStr1 = System.Net.IPAddress.Parse(kullaniciIP).ToString();
                    }
                    catch (Exception ex)
                    {
                        L.Log(LogType.FILE, Log.LogLevel.ERROR, "In timer_Tick()-->> An Error Occured While Parsing kullanici_ip " + ex.Message);
                        rec.CustomStr1 = kullaniciIP;
                        L.Log(LogType.FILE, Log.LogLevel.ERROR, "In timer_Tick()-->> kullnici_ip olduðu gibi atandý. " + kullaniciIP);
                    }

                    // L.Log(LogType.FILE, Log.LogLevel.INFORM, "rec.CustomStr1 is (kullanici_ip) : " +rec.CustomStr1);

                    string kullaniciAdý = "";
                    kullaniciAdý = readReader[3].ToString();

                    try
                    {
                        rec.UserName = kullaniciAdý;
                    }
                    catch (Exception ex)
                    {
                        L.Log(LogType.FILE, Log.LogLevel.ERROR, "In timer_Tick()-->> An Error Occured While Parsing kullanici_name " + ex.Message);
                    }
                    //L.Log(LogType.FILE, Log.LogLevel.INFORM, "rec.UserName is (kullanici_name) : " + rec.UserName);

                    string tableName = "";
                    tableName = readReader[4].ToString();

                    try
                    {
                        L.Log(LogType.FILE, Log.LogLevel.INFORM, "CustomStr7 Is : " + tableName);
                        rec.CustomStr7 = tableName;
                    }
                    catch (Exception ex)
                    {
                        L.Log(LogType.FILE, Log.LogLevel.ERROR, "In timer_Tick()-->> An Error Occured While Parsing table_name " + ex.Message);
                    }
                    //L.Log(LogType.FILE, Log.LogLevel.INFORM, "rec.CustomStr7 (table_name) is : " + rec.CustomStr7);

                    string url = "";
                    url = readReader[7].ToString();
                    try
                    {
                        rec.CustomStr6 = url;
                    }
                    catch (Exception ex)
                    {
                        L.Log(LogType.FILE, Log.LogLevel.ERROR, "In timer_Tick()-->> An Error Occured While Parsing url " + ex.Message);
                    }
                    //L.Log(LogType.FILE, Log.LogLevel.INFORM, "rec.CustomStr6 (url) is : " + rec.CustomStr6);

                    string tempCurrentData = "";
                    tempCurrentData = readReader[6].ToString();
                    //L.Log(LogType.FILE, Log.LogLevel.INFORM, " (current_data) is : " + tempCurrentData);
                    try
                    {
                        string[] permanentCurrentData = new string[4];
                        for (int f = 0; f < permanentCurrentData.Length; f++)
                        {
                            permanentCurrentData[f] = "";
                        }

                        if (tempCurrentData != "")
                        {
                            permanentCurrentData = parseCurrentData(tempCurrentData);
                        }

                        if (permanentCurrentData[0].Length > 900)
                        {
                            rec.CustomStr9 = permanentCurrentData[0].Substring(0,850);
                            rec.CustomStr10 = permanentCurrentData[0].Substring(851, 850);
                        }
                        else
                        {
                            rec.CustomStr9 = permanentCurrentData[0];
                        }

                        rec.CustomStr4 = permanentCurrentData[1];
                        rec.CustomStr5 = permanentCurrentData[2];
                        rec.CustomStr8 = permanentCurrentData[3];

                        L.Log(LogType.FILE, Log.LogLevel.INFORM, "rec.CustomStr4 Is : " + rec.CustomStr4);
                        L.Log(LogType.FILE, Log.LogLevel.INFORM, "rec.CustomStr5 Is : " + rec.CustomStr5);

                    }
                    catch (Exception ex)
                    {
                        L.Log(LogType.FILE, Log.LogLevel.ERROR, "In timer_Tick()-->> An Error Occured While Parsing current_data " + ex.Message);
                    }

                    string tempPrevData = "";
                    tempPrevData = readReader[5].ToString();
                    //L.Log(LogType.FILE, Log.LogLevel.INFORM, " (tempPrevData) is : " + tempPrevData);
                    string permanentPrevData = "";
                    if (tempPrevData != "")
                    {
                        permanentPrevData = parsePrevData(tempPrevData);
                    }

                    rec.CustomStr2 = permanentPrevData;

                    long recordID = Convert.ToInt64(readReader[8].ToString());

                    L.Log(LogType.FILE, Log.LogLevel.DEBUG, "Start sending Data");

                    if (usingRegistry)
                    {
                        CustomServiceBase s = base.GetInstanceService("Security Manager Sender");
                        s.SetData(rec);
                    }
                    else
                    {
                        CustomServiceBase s = base.GetInstanceService("Security Manager Remote Recorder");
                        s.SetData(Dal, virtualhost, rec);
                    }

                    L.Log(LogType.FILE, Log.LogLevel.DEBUG, "Finish Sending Data");

                    last_position = recordID;
                    last_recdate = rec.Datetime;
                    L.Log(LogType.FILE, Log.LogLevel.DEBUG, "Record Number is " + last_position.ToString());
                    i++;
                    if (i > max_record_send)
                    {
                        command.Cancel();
                        L.Log(LogType.FILE, Log.LogLevel.DEBUG, "max_record_send < " + i.ToString() + " and command canceled");
                        return;
                    }
                    lastDb = mcdb_name;
                    if (usingRegistry)
                        SetNetCadPostGre_Registry(last_position.ToString());
                    else
                    {
                        CustomServiceBase s = base.GetInstanceService("Security Manager Remote Recorder");
                        s.SetReg(Id, last_position.ToString(), "", lastDb, "", last_recdate);
                    }
                }
                L.Log(LogType.FILE, Log.LogLevel.DEBUG, "Finish getting the data");
            }
            catch (Exception er)
            {
                L.Log(LogType.FILE, Log.LogLevel.ERROR, er.ToString());
            }
            finally
            {
                timer.Enabled = true;
                L.Log(LogType.FILE, Log.LogLevel.INFORM, "Service Stopped");

                if (command != null)
                {
                    command.Dispose();
                }
                pgc.ClosePostGreConnection();
            }
        }
Beispiel #7
0
        public void DoWork()
        {
            using (NpgsqlConnection conn = new NpgsqlConnection(GlobalUtils.TopSecret.PostgresCS))
            using (NpgsqlCommand command = new NpgsqlCommand())
            {
                try
                {
                    conn.Open();
                    //conn.StatisticsEnabled = true;
                    command.Connection = conn;
                }
                catch (Exception e)
                {
                    Console.Error.WriteLine(e.Message);
                    return;
                }
                try
                {
                    using (NpgsqlTransaction sqlTran = conn.BeginTransaction())
                    {
                        command.Transaction = sqlTran;
                        NpgsqlDataReader reader;

                        List<string> commands = GetCommands(com);
                        foreach (string c in commands)
                        {
                            command.CommandText = c;
                            using (reader = command.ExecuteReader())
                            {
                                ShowResultSet(reader);
                                while (reader.NextResult())
                                    ShowResultSet(reader);
                            }
                        }
                        //var stats = conn.RetrieveStatistics();
                        //using (TextWriter tw = new StreamWriter(path + ".stats"))
                        //{
                        //    tw.WriteLine("Execution time: {0} sec, rows selected: {1}, rows affected: {2}",
                        //                    Math.Round((double)(long)stats["ExecutionTime"] / 1000, 2),
                        //                    stats["SelectRows"],
                        //                    stats["IduRows"]);
                        //}
                    }
                }
                catch (Exception e)
                {
                    Console.Error.WriteLine(e.Message);
                    if (command != null)
                        command.Cancel();
                }
            }
        }