Beispiel #1
0
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                int    ID               = GenerateIDColumn.GetNewID("TripTbl");
                string Origin           = this.textBox1.Text.ToString();
                string Destination      = this.textBox2.Text.ToString();
                string RegisterDateTime = GetDateTime.GenerateDateTime();
                string Cost             = this.textBox3.Text.ToString();
                string Description      = this.richTextBox1.Text.ToString();

                string        connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["TaxiServiceDempAppWithSQLServer.Properties.Settings.TaxiServicesDBConnectionString"].ToString();
                SqlConnection cn = new SqlConnection(connectionString);
                cn.Open();

                string     query = "INSERT INTO TripTbl (ID, Origin, Destination, RegisterDateTime, Cost, Description) values (@ID, @Origin, @Destination, @RegisterDateTime, @Cost, @Description)";
                SqlCommand cmd   = new SqlCommand(query, cn);

                cmd.Parameters.Add("@ID", SqlDbType.Int);
                cmd.Parameters.Add("@Origin", SqlDbType.NVarChar);
                cmd.Parameters.Add("@Destination", SqlDbType.NVarChar);
                cmd.Parameters.Add("@RegisterDateTime", SqlDbType.NVarChar);
                cmd.Parameters.Add("@Cost", SqlDbType.NVarChar);
                cmd.Parameters.Add("@Description", SqlDbType.NVarChar);

                cmd.Parameters["@ID"].Value               = ID;
                cmd.Parameters["@Origin"].Value           = Origin;
                cmd.Parameters["@Destination"].Value      = Destination;
                cmd.Parameters["@RegisterDateTime"].Value = RegisterDateTime;
                cmd.Parameters["@Cost"].Value             = Cost;
                cmd.Parameters["@Description"].Value      = Description;

                cmd.ExecuteNonQuery();
                cn.Close();

                if (InsertTripsToDB(ID))
                {
                    MessageBox.Show("اطلاعات با موفقیت در سیستم ثبت شد!");
                    this.textBox1.Clear();
                    this.textBox2.Clear();
                    this.textBox3.Clear();
                    this.richTextBox1.Clear();
                }
                else
                {
                    throw new Exception();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("متاسفانه خطایی در روند ثبت اطلاعات رخ داده است !");
                MessageBox.Show(ex.Message);
            }
        }
Beispiel #2
0
        private bool InsertTripsToDB(int InputTripID)
        {
            try
            {
                int    ID     = GenerateIDColumn.GetNewID("TripsTbl");
                int    TripID = InputTripID;
                int    ReservationPersonID = int.Parse(this.comboBox3.SelectedValue.ToString());
                int    CustomerID          = int.Parse(this.comboBox1.SelectedValue.ToString());
                int    DriverID            = int.Parse(this.comboBox2.SelectedValue.ToString());
                string RegisterDateTime    = GetDateTime.GenerateDateTime();
                string Description         = "-";

                string        connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["TaxiServiceDempAppWithSQLServer.Properties.Settings.TaxiServicesDBConnectionString"].ToString();
                SqlConnection cn = new SqlConnection(connectionString);
                cn.Open();

                string     query = "INSERT INTO TripsTbl (ID, TripID, ReservationPersonID, CustomerID, DriverID, RegisterDateTime, Description) values (@ID, @TripID, @ReservationPersonID, @CustomerID, @DriverID, @RegisterDateTime, @Description)";
                SqlCommand cmd   = new SqlCommand(query, cn);

                cmd.Parameters.Add("@ID", SqlDbType.Int);
                cmd.Parameters.Add("@TripID", SqlDbType.Int);
                cmd.Parameters.Add("@ReservationPersonID", SqlDbType.Int);
                cmd.Parameters.Add("@CustomerID", SqlDbType.Int);
                cmd.Parameters.Add("@DriverID", SqlDbType.Int);
                cmd.Parameters.Add("@RegisterDateTime", SqlDbType.NVarChar);
                cmd.Parameters.Add("@Description", SqlDbType.NVarChar);

                cmd.Parameters["@ID"].Value     = ID;
                cmd.Parameters["@TripID"].Value = TripID;
                cmd.Parameters["@ReservationPersonID"].Value = ReservationPersonID;
                cmd.Parameters["@CustomerID"].Value          = CustomerID;
                cmd.Parameters["@DriverID"].Value            = DriverID;
                cmd.Parameters["@RegisterDateTime"].Value    = RegisterDateTime;
                cmd.Parameters["@Description"].Value         = Description;

                cmd.ExecuteNonQuery();
                cn.Close();

                return(true);
            }
            catch (Exception ex)
            {
                MessageBox.Show("متاسفانه خطایی در روند ثبت اطلاعات رخ داده است !");
                MessageBox.Show(ex.Message);
                return(false);
            }
        }