Exemplo n.º 1
0
        //Method to update data in database from our app
        public bool Update(patientClass p)
        {
            //Create a default return type and set its default value to false
            bool isSucces = false;

            SqlConnection conn = new SqlConnection(myconnstrng);

            try
            {
                //Sql to update data in database
                string sql = $"UPDATE {table} SET Name=@Name, LastName = @LastName, Email=@Email, Phone=@Phone, Gender =@Gender, Age=@Age WHERE PatientID=@PatientID";

                //Creating Sql Command
                SqlCommand cmd = new SqlCommand(sql, conn);
                //Creating parameters to add value
                cmd.Parameters.AddWithValue("Name", p.Name);
                cmd.Parameters.AddWithValue("LastName", p.LastName);
                cmd.Parameters.AddWithValue("Email", p.Email);
                cmd.Parameters.AddWithValue("Phone", p.Phone);
                cmd.Parameters.AddWithValue("Gender", p.Gender);
                cmd.Parameters.AddWithValue("Age", p.Age);
                cmd.Parameters.AddWithValue("@PatientID", p.patientID);

                //Open DB connection
                conn.Open();

                int rows = cmd.ExecuteNonQuery();
                //if the query runs successfully then the value of rows will be greater than zero else its value will be zero
                if (rows > 0)
                {
                    isSucces = true;
                }
                else
                {
                    isSucces = false;
                }
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message);
            }
            finally
            {
                conn.Close();
            }

            return(isSucces);
        }
Exemplo n.º 2
0
        //Inserting data into
        public bool Insert(patientClass c)
        {
            //Creating a default return setting type and setting its value to false
            bool isSuccess = false;

            //1. Connect DB
            SqlConnection conn = new SqlConnection(myconnstrng);

            try
            {
                //2. Create a SQL Query to insert data into DB
                string sql = "INSERT INTO " + table + " (Name, LastName, Email, Phone, Gender, Age, FullName) VALUES (@Name, @LastName, @Email, @Phone, @Gender, @Age, @FullName)";
                //Creating SQL Command using sql and conn
                SqlCommand cmd = new SqlCommand(sql, conn);
                //Create Parameters to add data
                cmd.Parameters.AddWithValue("@Name", c.Name);
                cmd.Parameters.AddWithValue("@LastName", c.LastName);
                cmd.Parameters.AddWithValue("@Gender", c.Gender);
                cmd.Parameters.AddWithValue("@Phone", c.Phone);
                cmd.Parameters.AddWithValue("@Email", c.Email);
                cmd.Parameters.AddWithValue("@Age", c.Age);
                cmd.Parameters.AddWithValue("@FullName", c.Name + " " + c.LastName);

                //Connection Open here
                conn.Open();
                int rows = cmd.ExecuteNonQuery();

                //if the query runs successfully then the value of rows will be greater tan zero else its value will be 0
                if (rows > 0)
                {
                    isSuccess = true;
                }
                else
                {
                    isSuccess = false;
                }
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message);
            }
            finally
            {
                conn.Close();
            }
            return(isSuccess);
        }
Exemplo n.º 3
0
        //Method to Delete Data from database
        public bool Delete(patientClass p)
        {
            //Create a default return value and its value is false
            bool isSuccess = false;
            //Create Sql Connection
            SqlConnection conn = new SqlConnection(myconnstrng);

            try
            {
                //Sql to delete data
                string sql = $"DELETE FROM {table} WHERE patientID=@patientID";

                //Creating  SQL command
                SqlCommand cmd = new SqlCommand(sql, conn);
                cmd.Parameters.AddWithValue("patientID", p.patientID);
                //Open connection
                conn.Open();
                int rows = cmd.ExecuteNonQuery();
                //if the query run successfully then value of rows is greater than zero else its value is 0
                if (rows > 0)
                {
                    isSuccess = true;
                }
                else
                {
                    isSuccess = false;
                    //Delete failed
                    MessageBox.Show("No se ha podido eliminar al paciente");
                }
            }
            catch (Exception e)
            {
            }
            finally
            {
                //Close connection
                conn.Close();
            }
            return(isSuccess);
        }