private void SaveCourse_MouseLeftButtonUp_1(object sender, MouseButtonEventArgs e) { if (CourseNametxt.Tag == null) { if (CourseNametxt.Text == "") { MessageBox.Show("Course Name Required"); CourseNametxt.Focus(); } else if (Pricetxt.Text == "") { MessageBox.Show("Price Required"); Pricetxt.Focus(); } else if (decimal.Parse(Pricetxt.Text) < 100 || decimal.Parse(Pricetxt.Text) > 5000) { MessageBox.Show("Price must be between 100 and 5000"); Pricetxt.Focus(); Pricetxt.SelectAll(); } else if (PeriodTxt.Text == "") { MessageBox.Show("Period Name Required"); PeriodTxt.Focus(); } else if (CategoriesList.SelectedIndex == -1) { MessageBox.Show("Select Category"); CategoriesList.Focus(); } else { SqlParameter[] p = new SqlParameter[5]; p[0] = new SqlParameter("@Title", SqlDbType.NVarChar, 50); p[0].Value = CourseNametxt.Text; p[1] = new SqlParameter("@Price", SqlDbType.Float); p[1].Value = float.Parse(Pricetxt.Text); p[2] = new SqlParameter("@Period", SqlDbType.NVarChar, 50); p[2].Value = PeriodTxt.Text; p[3] = new SqlParameter("@CategoryID", SqlDbType.Int); p[3].Value = int.Parse(CategoriesList.SelectedValue.ToString()); p[4] = new SqlParameter("@Description", SqlDbType.NVarChar, 50); p[4].Value = Descriptiontxt.Text; DataAccess.InsUpDel("InsertCourse", p); MessageBox.Show("Added"); CourseNametxt.Text = string.Empty; Pricetxt.Text = ""; PeriodTxt.Text = ""; CategoriesList.SelectedIndex = -1; Descriptiontxt.Text = ""; CourseNametxt.Focus(); } } else { SqlParameter[] p = new SqlParameter[6]; p[0] = new SqlParameter("@CourseID", SqlDbType.Int); p[0].Value = int.Parse(CourseNametxt.Tag.ToString()); p[1] = new SqlParameter("@Title", SqlDbType.NVarChar, 50); p[1].Value = CourseNametxt.Text; p[2] = new SqlParameter("@Price", SqlDbType.Float); p[2].Value = float.Parse(Pricetxt.Text); p[3] = new SqlParameter("@Period", SqlDbType.NVarChar, 50); p[3].Value = PeriodTxt.Text; p[4] = new SqlParameter("@CategoryID", SqlDbType.Int); p[4].Value = int.Parse(CategoriesList.SelectedValue.ToString()); p[5] = new SqlParameter("@Description", SqlDbType.NVarChar, 50); p[5].Value = Descriptiontxt.Text; DataAccess.InsUpDel("EditCourse", p); MessageBox.Show("Edited"); } }