public void updateGridView()
{
//dgvBridelist.AutoGenerateColumns = false;
Bride b = new Bride();
dgvBridelist.DataSource = b.ListBride();
}
private void button1_Click(object sender, EventArgs e)
{
try
{
string query = "select * from bride WHERE brideID = brideID ";
if (textBox1.Text.Length > 0)
{
query += " AND name LIKE '%" + textBox1.Text + "%'";
}
if (textBox2.Text.Length > 0)
{
query += " AND surname LIKE '%" + textBox2.Text + "%'";
}
//if (text == "")
// return;
Bride b = new Bride();
dgvbridesearch.DataSource = b.SearchBride(query);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void GetData()
{
using (new WaitCursor())
{
ClearRecord();
Bride clsBride = new Bride();
clsBride.Bride_ID = System.Convert.ToInt32((Grid.SelectedCells[0].Column.GetCellContent(Grid.SelectedItem) as TextBlock).Text);
clsBride = BrideData.Select_Record(clsBride);
if ((clsBride != null))
{
try
{
nudBride_ID.Text = System.Convert.ToInt32(clsBride.Bride_ID).ToString();
tbBride_First_Name.Text = Convert.ToString(clsBride.Bride_First_Name);
tbBride_Middle_Int.Text = Convert.ToString(clsBride.Bride_Middle_Int);
tbBride_Last_Name.Text = Convert.ToString(clsBride.Bride_Last_Name);
}
catch
{
}
}
}
}
private void UpdateRecord()
{
using (new WaitCursor())
{
Bride oclsBride = new Bride();
Bride clsBride = new Bride();
oclsBride.Bride_ID = System.Convert.ToInt32((Grid.SelectedCells[0].Column.GetCellContent(Grid.SelectedItem) as TextBlock).Text);
oclsBride = BrideData.Select_Record(oclsBride);
if (VerifyData() == true)
{
SetData(clsBride);
Boolean bSucess = new Boolean();
bSucess = BrideData.Update(oclsBride, clsBride);
if (bSucess == true)
{
GoBack_To_Grid();
}
else
{
MessageBox.Show("Update failed.", "Error");
}
}
}
}
private void SetData(Bride clsBride)
{
using (new WaitCursor())
{
clsBride.Bride_First_Name = System.Convert.ToString(tbBride_First_Name.Text);
clsBride.Bride_Middle_Int = System.Convert.ToString(tbBride_Middle_Int.Text);
clsBride.Bride_Last_Name = System.Convert.ToString(tbBride_Last_Name.Text);
}
}
private void BrideList_Load(object sender, EventArgs e)
{
try
{
Bride b = new Bride();
dgvBridelist.DataSource = b.ListBride();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void BindGridView()
{
try
{
Bride b = new Bride();
dgvBridelist.DataSource = b.ListBride();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
Bride b = new Bride();
b.DeleteBride(int.Parse(dgvBridelist.SelectedRows[0].Cells["brideID"].Value.ToString()));
updateGridView();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public static bool Update(Bride oldBride,
Bride newBride)
{
SqlConnection connection = MarriageData.GetConnection();
string updateStatement
= "UPDATE "
+ " [Bride] "
+ "SET "
+ " [Bride_First_Name] = @NewBride_First_Name "
+ " ,[Bride_Middle_Int] = @NewBride_Middle_Int "
+ " ,[Bride_Last_Name] = @NewBride_Last_Name "
+ "WHERE "
+ " [Bride_ID] = @OldBride_ID "
+ " AND [Bride_First_Name] = @OldBride_First_Name "
+ " AND [Bride_Middle_Int] = @OldBride_Middle_Int "
+ " AND [Bride_Last_Name] = @OldBride_Last_Name "
+ "";
SqlCommand updateCommand = new SqlCommand(updateStatement, connection);
updateCommand.CommandType = CommandType.Text;
updateCommand.Parameters.AddWithValue("@NewBride_First_Name", newBride.Bride_First_Name);
updateCommand.Parameters.AddWithValue("@NewBride_Middle_Int", newBride.Bride_Middle_Int);
updateCommand.Parameters.AddWithValue("@NewBride_Last_Name", newBride.Bride_Last_Name);
updateCommand.Parameters.AddWithValue("@OldBride_ID", oldBride.Bride_ID);
updateCommand.Parameters.AddWithValue("@OldBride_First_Name", oldBride.Bride_First_Name);
updateCommand.Parameters.AddWithValue("@OldBride_Middle_Int", oldBride.Bride_Middle_Int);
updateCommand.Parameters.AddWithValue("@OldBride_Last_Name", oldBride.Bride_Last_Name);
try
{
connection.Open();
int count = updateCommand.ExecuteNonQuery();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException ex)
{
throw ex;
}
finally
{
connection.Close();
}
}
public static Bride Select_Record(Bride clsBridePara)
{
Bride clsBride = new Bride();
SqlConnection connection = MarriageData.GetConnection();
string selectStatement
= "SELECT "
+ " [Bride_ID] "
+ " ,[Bride_First_Name] "
+ " ,[Bride_Middle_Int] "
+ " ,[Bride_Last_Name] "
+ "FROM "
+ " [Bride] "
+ "WHERE "
+ " [Bride_ID] = @Bride_ID "
+ "";
SqlCommand selectCommand = new SqlCommand(selectStatement, connection);
selectCommand.CommandType = CommandType.Text;
selectCommand.Parameters.AddWithValue("@Bride_ID", clsBridePara.Bride_ID);
try
{
connection.Open();
SqlDataReader reader
= selectCommand.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
clsBride.Bride_ID = System.Convert.ToInt32(reader["Bride_ID"]);
clsBride.Bride_First_Name = System.Convert.ToString(reader["Bride_First_Name"]);
clsBride.Bride_Middle_Int = System.Convert.ToString(reader["Bride_Middle_Int"]);
clsBride.Bride_Last_Name = System.Convert.ToString(reader["Bride_Last_Name"]);
}
else
{
clsBride = null;
}
reader.Close();
}
catch (SqlException ex)
{
throw ex;
}
finally
{
connection.Close();
}
return(clsBride);
}
public static bool Add(Bride clsBride)
{
SqlConnection connection = MarriageData.GetConnection();
string insertStatement
= "INSERT "
+ " [Bride] "
+ " ( "
+ " [Bride_First_Name] "
+ " ,[Bride_Middle_Int] "
+ " ,[Bride_Last_Name] "
+ " ) "
+ "VALUES "
+ " ( "
+ " @Bride_First_Name "
+ " ,@Bride_Middle_Int "
+ " ,@Bride_Last_Name "
+ " ) "
+ "";
SqlCommand insertCommand = new SqlCommand(insertStatement, connection);
insertCommand.CommandType = CommandType.Text;
insertCommand.Parameters.AddWithValue("@Bride_First_Name", clsBride.Bride_First_Name);
insertCommand.Parameters.AddWithValue("@Bride_Middle_Int", clsBride.Bride_Middle_Int);
insertCommand.Parameters.AddWithValue("@Bride_Last_Name", clsBride.Bride_Last_Name);
try
{
connection.Open();
int count = insertCommand.ExecuteNonQuery();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException ex)
{
throw ex;
}
finally
{
connection.Close();
}
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
try
{
string text = textBox1.Text.Trim();
if (text == "")
{
dgvbridesearch.DataSource = null;
return;
}
Bride b = new Bride();
dgvbridesearch.DataSource = b.SearchBrideByName(text);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static bool Delete(Bride clsBride)
{
SqlConnection connection = MarriageData.GetConnection();
string deleteStatement
= "DELETE FROM "
+ " [Bride] "
+ "WHERE "
+ " [Bride_ID] = @OldBride_ID "
+ " AND [Bride_First_Name] = @OldBride_First_Name "
+ " AND [Bride_Middle_Int] = @OldBride_Middle_Int "
+ " AND [Bride_Last_Name] = @OldBride_Last_Name "
+ "";
SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection);
deleteCommand.CommandType = CommandType.Text;
deleteCommand.Parameters.AddWithValue("@OldBride_ID", clsBride.Bride_ID);
deleteCommand.Parameters.AddWithValue("@OldBride_First_Name", clsBride.Bride_First_Name);
deleteCommand.Parameters.AddWithValue("@OldBride_Middle_Int", clsBride.Bride_Middle_Int);
deleteCommand.Parameters.AddWithValue("@OldBride_Last_Name", clsBride.Bride_Last_Name);
try
{
connection.Open();
int count = deleteCommand.ExecuteNonQuery();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException ex)
{
throw ex;
}
finally
{
connection.Close();
}
}
private void InsertRecord()
{
using (new WaitCursor())
{
Bride clsBride = new Bride();
if (VerifyData() == true)
{
SetData(clsBride);
Boolean bSucess = new Boolean();
bSucess = BrideData.Add(clsBride);
if (bSucess == true)
{
GoBack_To_Grid();
}
else
{
MessageBox.Show("Insert failed.", "Error");
}
}
}
}
private void button1_Click(object sender, EventArgs e)
{
string username = txtbrideusername.Text;
string password = txtbridepass.Text;
if (username == "")
{
txtbrideusername.Text = "Please enter username";
return;
}
if (password == string.Empty)
{
txtbridepass.Text = "Please enter password";
return;
}
Bride b = new Bride();
int result = b.Login(username, password);
Groom g = new Groom();
int result2 = g.Login(username, password);
if (result == 1 || result2 == 1)
{
BrideGroomPage brideGroomPage = new BrideGroomPage();
brideGroomPage.Show();
this.Hide();
}
else
{
lblmesaj.Text = "Invalid username or password";
lblmesaj.ForeColor = Color.Red;
}
}
private void DeleteRecord()
{
using (new WaitCursor())
{
Bride clsBride = new Bride();
clsBride.Bride_ID = System.Convert.ToInt32((Grid.SelectedCells[0].Column.GetCellContent(Grid.SelectedItem) as TextBlock).Text);
if (MessageBox.Show("Are you sure? Delete this record?", "Delete", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
SetData(clsBride);
Boolean bSucess = new Boolean();
bSucess = BrideData.Delete(clsBride);
if (bSucess == true)
{
GoBack_To_Grid();
}
else
{
MessageBox.Show("Delete failed.", "Error");
}
}
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
string name = txtbridename.Text;
string surname = txtbridesurname.Text;
string phonenumber = txtbrideprohne.Text;
string email = txtbrideemail.Text;
string username = txtbrideusernae.Text;
string password = txtbridepasswo.Text;
string weddingdate = txtbrideweddingdate.Text;
string weddingvenue = txtbridevenue.Text;
string groomname = txtbridesgroom.Text;
if (name == string.Empty)
{
MessageBox.Show("Please enter name");
return;
}
if (surname == string.Empty)
{
MessageBox.Show("Please enter surname");
return;
}
if (phonenumber == string.Empty)
{
MessageBox.Show("Please enter phone number");
return;
}
if (email == string.Empty)
{
MessageBox.Show("Please enter email");
return;
}
if (username == string.Empty)
{
MessageBox.Show("Please enter username");
return;
}
if (password == string.Empty)
{
MessageBox.Show("Please enter password");
return;
}
if (weddingdate == string.Empty)
{
MessageBox.Show("Please enter wedding date");
return;
}
if (weddingvenue == string.Empty)
{
MessageBox.Show("Please enter wedding venue");
return;
}
if (groomname == string.Empty)
{
MessageBox.Show("Please enter groom name");
return;
}
Bride b = new Bride();
b.Name = name;
b.Surname = surname;
b.Phonenumber = phonenumber;
b.Email = email;
b.Username = username;
b.Password = password;
b.Weddingdate = weddingdate;
b.Weddingvenue = weddingvenue;
b.Groomname = groomname;
int result = b.AddBride(b);
if (result > 0)
{
label10.Text = "Bride Added";
Adminpage adminpage = new Adminpage();
adminpage.Show();
this.Hide();
}
else
{
label10.Text = "Bride not Added";
Adminpage adminpage = new Adminpage();
adminpage.Show();
this.Hide();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
