Beispiel #1
0
        public void UpdateSalesman(SalesmanDTO salesmanDTO)
        {
            sqlConnection.Open();

            string sqlQuery = "Update Salesman SET SalesmanID='" + salesmanDTO.SalesmanID + "' where SalesmanID='" + salesmanDTO.SalesmanID + "'";

            sqlCommand = new SqlCommand(sqlQuery, sqlConnection);
            sqlCommand.ExecuteNonQuery();

            string sqlQuery1 = "Update Salesman SET SalesmanName='" + salesmanDTO.SalesmanNAME + "' where SalesmanID='" + salesmanDTO.SalesmanID + "'";

            sqlCommand1 = new SqlCommand(sqlQuery1, sqlConnection);
            sqlCommand1.ExecuteNonQuery();

            string sqlQuery2 = "Update Salesman SET Password='******' where SalesmanID='" + salesmanDTO.SalesmanID + "'";

            sqlCommand2 = new SqlCommand(sqlQuery2, sqlConnection);
            sqlCommand2.ExecuteNonQuery();


            string sqlQuery3 = "Update Salesman SET Address='" + salesmanDTO.SalesmanADDRESS + "' where SalesmanID='" + salesmanDTO.SalesmanID + "'";

            sqlCommand3 = new SqlCommand(sqlQuery3, sqlConnection);
            sqlCommand3.ExecuteNonQuery();

            sqlConnection.Close();
        }
Beispiel #2
0
        public void CreateSalesman(SalesmanDTO salesmanDTO)
        {
            try
            {
                sqlConnection.Open();
                string sqlQuery = " insert into Salesman values('" + salesmanDTO.SalesmanID +
                                  "','" + salesmanDTO.SalesmanNAME +
                                  "','" + salesmanDTO.SalesmanPASSWORD +
                                  "','" + salesmanDTO.SalesmanADDRESS +
                                  "')";

                sqlCommand = new SqlCommand(sqlQuery, sqlConnection);
                sqlCommand.ExecuteNonQuery();

                sqlConnection.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Invalid Input!", "alert", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }