private void Update_Click(object sender, RoutedEventArgs e) { if (!String.IsNullOrEmpty(CatagoryIdTxt.Text) && !String.IsNullOrEmpty(CatagoryNameTxt.Text)) { SqlConnection sqlConFill = new SqlConnection(conn); SqlCommand cmdFill = new SqlCommand(); cmdFill.CommandText = "UPDATE catagory_list SET Cat_Id=@CatagoryId,Cat_Name=@CatagoryName WHERE Cat_Id=@CatagoryId"; cmdFill.Parameters.AddWithValue("@CatagoryId", CatagoryIdTxt.Text); cmdFill.Parameters.AddWithValue("@CatagoryName", CatagoryNameTxt.Text); cmdFill.Connection = sqlConFill; sqlConFill.Open(); cmdFill.ExecuteNonQuery(); sqlConFill.Close(); Catagory win2 = new Catagory(); win2.Show(); this.Close(); } else { MessageBox.Show("Catagory Id or Name Cann't be Empty"); } }
private void Create_Click(object sender, RoutedEventArgs e) { if (!String.IsNullOrEmpty(CatagoryNameTxt.Text)) { int sr = 0; SqlConnection sqlConFill = new SqlConnection(conn); SqlCommand cmdFill = new SqlCommand(); cmdFill.CommandText = "SELECT MAX(Cat_Id) FROM catagory_list"; cmdFill.Connection = sqlConFill; sqlConFill.Open(); SqlDataReader rd1 = cmdFill.ExecuteReader(); if (rd1.HasRows) { rd1.Read(); var outputParam = rd1[0]; if (!(outputParam is DBNull)) { sr = Convert.ToInt32(rd1[0]); } else { sr = 0; } rd1.Close(); } sqlConFill.Close(); sr = sr + 1; cmdFill.CommandText = "SELECT Cat_Id FROM catagory_list WHERE Cat_Name=@Name"; cmdFill.Parameters.AddWithValue("@Name", CatagoryNameTxt.Text); cmdFill.Connection = sqlConFill; sqlConFill.Open(); SqlDataReader rd = cmdFill.ExecuteReader(); String cat = ""; if (rd.HasRows) { rd.Read(); cat = cat + rd[0].ToString(); rd.Close(); sqlConFill.Close(); MessageBox.Show("Food Catagory Already Exist at Id " + cat); } else { sqlConFill.Close(); sqlConFill = new SqlConnection(conn); cmdFill = new SqlCommand(); cmdFill.CommandText = "INSERT INTO catagory_list(Cat_Id,Cat_Name) VALUES (@CatagoryId,@CatagoryName)"; cmdFill.Parameters.AddWithValue("@CatagoryId", sr.ToString()); cmdFill.Parameters.AddWithValue("@CatagoryName", CatagoryNameTxt.Text); cmdFill.Connection = sqlConFill; sqlConFill.Open(); cmdFill.ExecuteNonQuery(); sqlConFill.Close(); Catagory win2 = new Catagory(); win2.Show(); this.Close(); } } else { MessageBox.Show("Catagory Name Cann't be Empty"); } }
private void Delete_Click(object sender, RoutedEventArgs e) { if (!String.IsNullOrEmpty(CatagoryIdTxt.Text) && !String.IsNullOrEmpty(CatagoryNameTxt.Text)) { SqlConnection sqlConFill = new SqlConnection(conn); SqlCommand cmdFill = new SqlCommand(); cmdFill.CommandText = "DELETE FROM catagory_list WHERE Cat_Id=@CatagoryId"; cmdFill.Parameters.AddWithValue("@CatagoryId", CatagoryIdTxt.Text); cmdFill.Connection = sqlConFill; sqlConFill.Open(); cmdFill.ExecuteNonQuery(); sqlConFill.Close(); SqlConnection sqlConFilld = new SqlConnection(conn); SqlCommand cmdFilld = new SqlCommand(); cmdFilld.CommandText = "DELETE FROM Foods WHERE Catagory_Id=@dCatagoryIde"; cmdFilld.Parameters.AddWithValue("@dCatagoryIde", CatagoryIdTxt.Text); cmdFilld.Connection = sqlConFilld; sqlConFilld.Open(); cmdFilld.ExecuteNonQuery(); sqlConFilld.Close(); cmdFill.CommandText = "UPDATE catagory_list SET Cat_Id=Cat_Id-1 WHERE Cat_Id>@CatagoryId2"; cmdFill.Parameters.AddWithValue("@CatagoryId2", CatagoryIdTxt.Text); cmdFill.Connection = sqlConFill; sqlConFill.Open(); cmdFill.ExecuteNonQuery(); sqlConFill.Close(); SqlConnection sqlConFilluf = new SqlConnection(conn); SqlCommand cmdFilluf = new SqlCommand(); cmdFilluf.CommandText = "UPDATE Foods SET Catagory_Id=Catagory_Id-1 WHERE Catagory_Id>@CatagoryIduf"; cmdFilluf.Parameters.AddWithValue("@CatagoryIduf", CatagoryIdTxt.Text); cmdFilluf.Connection = sqlConFilluf; sqlConFilluf.Open(); cmdFilluf.ExecuteNonQuery(); sqlConFilluf.Close(); Catagory win2 = new Catagory(); win2.Show(); this.Close(); } else { MessageBox.Show("Catagory Id or Name Cann't be Empty"); } }
private void Catagory_Click(object sender, RoutedEventArgs e) { Catagory win2 = new Catagory(); win2.Show(); this.Close(); }