private void button1_Click(object sender, EventArgs e)
{
try
{
string query = "select * from groom WHERE groomID = groomID ";
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;
Groom g = new Groom();
dgvgroomsearch.DataSource = g.SearchGroom(query);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void UpdateRecord()
{
using (new WaitCursor())
{
Groom oclsGroom = new Groom();
Groom clsGroom = new Groom();
oclsGroom.Groom_ID = System.Convert.ToInt32((Grid.SelectedCells[0].Column.GetCellContent(Grid.SelectedItem) as TextBlock).Text);
oclsGroom = GroomData.Select_Record(oclsGroom);
if (VerifyData() == true)
{
SetData(clsGroom);
Boolean bSucess = new Boolean();
bSucess = GroomData.Update(oclsGroom, clsGroom);
if (bSucess == true)
{
GoBack_To_Grid();
}
else
{
MessageBox.Show("Update failed.", "Error");
}
}
}
}
public static bool InsertGroom()
{
HttpResponseMessage response = new HttpResponseMessage();
var httpRequest = HttpContext.Current.Request;
string temp = "~/UploadFile/";
List <Entities.ImageEntity> l = new List <Entities.ImageEntity>();
if (httpRequest.Files.Count == 1)
{
var postedFile = httpRequest.Files[0];
if (string.Equals(postedFile.ContentType, "image/jpg", StringComparison.OrdinalIgnoreCase) ||
string.Equals(postedFile.ContentType, "image/jpeg", StringComparison.OrdinalIgnoreCase) ||
string.Equals(postedFile.ContentType, "image/pjpeg", StringComparison.OrdinalIgnoreCase) ||
string.Equals(postedFile.ContentType, "image/gif", StringComparison.OrdinalIgnoreCase) ||
string.Equals(postedFile.ContentType, "image/x-png", StringComparison.OrdinalIgnoreCase) ||
string.Equals(postedFile.ContentType, "image/png", StringComparison.OrdinalIgnoreCase))
{
var filePath = HttpContext.Current.Server.MapPath(temp + postedFile.FileName);
postedFile.SaveAs(filePath);
Groom groom = new Groom();
groom.url = "http://localhost:50637/UploadFile/" + postedFile.FileName;
groom.token = getFaceToken(postedFile.InputStream);
groom.name = postedFile.FileName;
DB.Grooms.Add(groom);
DB.SaveChanges();
return(true);
}
}
return(false);
//return response;
}
private void GetData()
{
using (new WaitCursor())
{
ClearRecord();
Groom clsGroom = new Groom();
clsGroom.Groom_ID = System.Convert.ToInt32((Grid.SelectedCells[0].Column.GetCellContent(Grid.SelectedItem) as TextBlock).Text);
clsGroom = GroomData.Select_Record(clsGroom);
if ((clsGroom != null))
{
try
{
nudGroom_ID.Text = System.Convert.ToInt32(clsGroom.Groom_ID).ToString();
tbGroom_First_Name.Text = Convert.ToString(clsGroom.Groom_First_Name);
tbGroom_Middle_Int.Text = Convert.ToString(clsGroom.Groom_Middle_Int);
tbGroom_Last_Name.Text = Convert.ToString(clsGroom.Groom_Last_Name);
}
catch
{
}
}
}
}
void UpdateScreen()
{
SdlHardware.ClearScreen();
Groom.DrawOnHiddenScreen();
Mcharacter.DrawOnHiddenScreen();
SdlHardware.ShowHiddenScreen();
}
private void SetData(Groom clsGroom)
{
using (new WaitCursor())
{
clsGroom.Groom_First_Name = System.Convert.ToString(tbGroom_First_Name.Text);
clsGroom.Groom_Middle_Int = System.Convert.ToString(tbGroom_Middle_Int.Text);
clsGroom.Groom_Last_Name = System.Convert.ToString(tbGroom_Last_Name.Text);
}
}
public static Entities.GroomEntity GroomEntity(Groom groom)
{
return(new Entities.GroomEntity()
{
id = groom.id,
name = groom.name,
token = groom.token,
url = groom.url
});
}
private void button1_Click(object sender, EventArgs e)
{
try
{
Groom g = new Groom();
dgvgroomlist.DataSource = g.ListGroom();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public static bool Update(Groom oldGroom,
Groom newGroom)
{
SqlConnection connection = MarriageData.GetConnection();
string updateStatement
= "UPDATE "
+ " [Groom] "
+ "SET "
+ " [Groom_First_Name] = @NewGroom_First_Name "
+ " ,[Groom_Middle_Int] = @NewGroom_Middle_Int "
+ " ,[Groom_Last_Name] = @NewGroom_Last_Name "
+ "WHERE "
+ " [Groom_ID] = @OldGroom_ID "
+ " AND [Groom_First_Name] = @OldGroom_First_Name "
+ " AND [Groom_Middle_Int] = @OldGroom_Middle_Int "
+ " AND [Groom_Last_Name] = @OldGroom_Last_Name "
+ "";
SqlCommand updateCommand = new SqlCommand(updateStatement, connection);
updateCommand.CommandType = CommandType.Text;
updateCommand.Parameters.AddWithValue("@NewGroom_First_Name", newGroom.Groom_First_Name);
updateCommand.Parameters.AddWithValue("@NewGroom_Middle_Int", newGroom.Groom_Middle_Int);
updateCommand.Parameters.AddWithValue("@NewGroom_Last_Name", newGroom.Groom_Last_Name);
updateCommand.Parameters.AddWithValue("@OldGroom_ID", oldGroom.Groom_ID);
updateCommand.Parameters.AddWithValue("@OldGroom_First_Name", oldGroom.Groom_First_Name);
updateCommand.Parameters.AddWithValue("@OldGroom_Middle_Int", oldGroom.Groom_Middle_Int);
updateCommand.Parameters.AddWithValue("@OldGroom_Last_Name", oldGroom.Groom_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 Groom Select_Record(Groom clsGroomPara)
{
Groom clsGroom = new Groom();
SqlConnection connection = MarriageData.GetConnection();
string selectStatement
= "SELECT "
+ " [Groom_ID] "
+ " ,[Groom_First_Name] "
+ " ,[Groom_Middle_Int] "
+ " ,[Groom_Last_Name] "
+ "FROM "
+ " [Groom] "
+ "WHERE "
+ " [Groom_ID] = @Groom_ID "
+ "";
SqlCommand selectCommand = new SqlCommand(selectStatement, connection);
selectCommand.CommandType = CommandType.Text;
selectCommand.Parameters.AddWithValue("@Groom_ID", clsGroomPara.Groom_ID);
try
{
connection.Open();
SqlDataReader reader
= selectCommand.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
clsGroom.Groom_ID = System.Convert.ToInt32(reader["Groom_ID"]);
clsGroom.Groom_First_Name = System.Convert.ToString(reader["Groom_First_Name"]);
clsGroom.Groom_Middle_Int = System.Convert.ToString(reader["Groom_Middle_Int"]);
clsGroom.Groom_Last_Name = System.Convert.ToString(reader["Groom_Last_Name"]);
}
else
{
clsGroom = null;
}
reader.Close();
}
catch (SqlException ex)
{
throw ex;
}
finally
{
connection.Close();
}
return(clsGroom);
}
public static bool Add(Groom clsGroom)
{
SqlConnection connection = MarriageData.GetConnection();
string insertStatement
= "INSERT "
+ " [Groom] "
+ " ( "
+ " [Groom_First_Name] "
+ " ,[Groom_Middle_Int] "
+ " ,[Groom_Last_Name] "
+ " ) "
+ "VALUES "
+ " ( "
+ " @Groom_First_Name "
+ " ,@Groom_Middle_Int "
+ " ,@Groom_Last_Name "
+ " ) "
+ "";
SqlCommand insertCommand = new SqlCommand(insertStatement, connection);
insertCommand.CommandType = CommandType.Text;
insertCommand.Parameters.AddWithValue("@Groom_First_Name", clsGroom.Groom_First_Name);
insertCommand.Parameters.AddWithValue("@Groom_Middle_Int", clsGroom.Groom_Middle_Int);
insertCommand.Parameters.AddWithValue("@Groom_Last_Name", clsGroom.Groom_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 == "")
{
dgvgroomsearch.DataSource = null;
return;
}
Groom g = new Groom();
dgvgroomsearch.DataSource = g.SearchGroomByName(text);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static bool Delete(Groom clsGroom)
{
SqlConnection connection = MarriageData.GetConnection();
string deleteStatement
= "DELETE FROM "
+ " [Groom] "
+ "WHERE "
+ " [Groom_ID] = @OldGroom_ID "
+ " AND [Groom_First_Name] = @OldGroom_First_Name "
+ " AND [Groom_Middle_Int] = @OldGroom_Middle_Int "
+ " AND [Groom_Last_Name] = @OldGroom_Last_Name "
+ "";
SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection);
deleteCommand.CommandType = CommandType.Text;
deleteCommand.Parameters.AddWithValue("@OldGroom_ID", clsGroom.Groom_ID);
deleteCommand.Parameters.AddWithValue("@OldGroom_First_Name", clsGroom.Groom_First_Name);
deleteCommand.Parameters.AddWithValue("@OldGroom_Middle_Int", clsGroom.Groom_Middle_Int);
deleteCommand.Parameters.AddWithValue("@OldGroom_Last_Name", clsGroom.Groom_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())
{
Groom clsGroom = new Groom();
if (VerifyData() == true)
{
SetData(clsGroom);
Boolean bSucess = new Boolean();
bSucess = GroomData.Add(clsGroom);
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())
{
Groom clsGroom = new Groom();
clsGroom.Groom_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(clsGroom);
Boolean bSucess = new Boolean();
bSucess = GroomData.Delete(clsGroom);
if (bSucess == true)
{
GoBack_To_Grid();
}
else
{
MessageBox.Show("Delete failed.", "Error");
}
}
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
string name = txtgroomname.Text;
string surname = txtgroomsurname.Text;
string phonenumber = txtgroomphone.Text;
string email = txtgroomemail.Text;
string username = txtgroomusername.Text;
string password = txtgroomasswo.Text;
string weddingdate = txtgroomdate.Text;
string weddingvenue = txtgroomvenue.Text;
string bridename = txtgroomsbride.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 (bridename == string.Empty)
{
MessageBox.Show("Please enter groom name");
return;
}
Groom g = new Groom();
g.Name = name;
g.Surname = surname;
g.Phonenumber = phonenumber;
g.Email = email;
g.Username = username;
g.Password = password;
g.Weddingdate = weddingdate;
g.Weddingvenue = weddingvenue;
g.Bridename = bridename;
int result = g.AddGroom(g);
if (result > 0)
{
label10.Text = "Groom Added";
Adminpage adminpage = new Adminpage();
adminpage.Show();
this.Hide();
}
else
{
label10.Text = "Groom not Added";
Adminpage adminpage = new Adminpage();
adminpage.Show();
this.Hide();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
void CheckInput()
{
if (SdlHardware.KeyPressed(SdlHardware.KEY_D) && Mcharacter.GetX()
>= Groom.MaxRight)
{
Groom.ActualCol++;
Groom.UpdateScreenMap(Groom.ActualCol, Groom.ActualRow);
Mcharacter.MoveTo(0, Mcharacter.GetY());
Steps--;
}
else if (SdlHardware.KeyPressed(SdlHardware.KEY_D))
{
if (Groom.CanMoveTo(Mcharacter.GetX() + Mcharacter.GetSpeedX(),
Mcharacter.GetY(),
Mcharacter.GetX() + Mcharacter.GetWidth() +
Mcharacter.GetSpeedX(),
Mcharacter.GetY() + Mcharacter.GetHeight()))
{
Mcharacter.MoveRight();
Steps--;
}
else
{
Mcharacter.NextFrame();
}
Mcharacter.ChangeDirection(Sprite.RIGHT);
}
else if (SdlHardware.KeyPressed(SdlHardware.KEY_A) &&
Mcharacter.GetX() <= 0)
{
Groom.ActualCol--;
Groom.UpdateScreenMap(Groom.ActualCol, Groom.ActualRow);
Mcharacter.MoveTo(Groom.MaxRight, Mcharacter.GetY());
Steps--;
}
else if (SdlHardware.KeyPressed(SdlHardware.KEY_A))
{
if (Groom.CanMoveTo(Mcharacter.GetX() - Mcharacter.GetSpeedX(),
Mcharacter.GetY(),
Mcharacter.GetX() + Mcharacter.GetWidth() -
Mcharacter.GetSpeedX(),
Mcharacter.GetY() + Mcharacter.GetHeight()))
{
Mcharacter.MoveLeft();
Steps--;
}
else
{
Mcharacter.NextFrame();
}
Mcharacter.ChangeDirection(Sprite.LEFT);
}
else if (SdlHardware.KeyPressed(SdlHardware.KEY_W) &&
Mcharacter.GetY() <= Groom.GetTopMargin())
{
Groom.ActualRow--;
Groom.UpdateScreenMap(Groom.ActualCol, Groom.ActualRow);
Mcharacter.MoveTo(Mcharacter.GetX(), Groom.MaxDown);
Steps--;
}
else if (SdlHardware.KeyPressed(SdlHardware.KEY_W))
{
if (Groom.CanMoveTo(Mcharacter.GetX(),
Mcharacter.GetY() - Mcharacter.GetSpeedY(),
Mcharacter.GetX() + Mcharacter.GetWidth(),
Mcharacter.GetY() + Mcharacter.GetHeight() -
Mcharacter.GetSpeedY()))
{
Mcharacter.MoveUp();
Steps--;
}
else
{
Mcharacter.NextFrame();
}
Mcharacter.ChangeDirection(Sprite.UP);
}
else if (SdlHardware.KeyPressed(SdlHardware.KEY_S) &&
Mcharacter.GetY() >= Groom.MaxDown)
{
Groom.ActualRow++;
Groom.UpdateScreenMap(Groom.ActualCol, Groom.ActualRow);
Mcharacter.MoveTo(Mcharacter.GetX(), Groom.GetTopMargin());
Steps--;
}
else if (SdlHardware.KeyPressed(SdlHardware.KEY_S))
{
if (Groom.CanMoveTo(Mcharacter.GetX(),
Mcharacter.GetY() + Mcharacter.GetSpeedY(),
Mcharacter.GetX() + Mcharacter.GetWidth(),
Mcharacter.GetY() + Mcharacter.GetHeight() +
Mcharacter.GetSpeedY()))
{
Mcharacter.MoveDown();
Steps--;
}
else
{
Mcharacter.NextFrame();
}
Mcharacter.ChangeDirection(Sprite.DOWN);
}
else if (SdlHardware.KeyPressed(SdlHardware.KEY_RETURN))
{
SdlHardware.Pause(100);
foreach (Chest c in Groom.chests)
{
if (c.canInteractue(Mcharacter))
{
c.Interactue(Mcharacter);
}
}
}
if (SdlHardware.KeyPressed(SdlHardware.KEY_I))
{
if (gm.Run(Groom, Mcharacter) == 5)
{
finished = true;
}
}
}
public static WebResult <bool> InsertGroom()
{
try
{
HttpResponseMessage response = new HttpResponseMessage();
var httpRequest = HttpContext.Current.Request;
List <Entities.ImageEntity> images = new List <Entities.ImageEntity>();
if (httpRequest.Files.Count == 1)
{
var postedFile = httpRequest.Files[0];
if (string.Equals(postedFile.ContentType, "image/jpg", StringComparison.OrdinalIgnoreCase) ||
string.Equals(postedFile.ContentType, "image/jpeg", StringComparison.OrdinalIgnoreCase) ||
string.Equals(postedFile.ContentType, "image/pjpeg", StringComparison.OrdinalIgnoreCase) ||
string.Equals(postedFile.ContentType, "image/gif", StringComparison.OrdinalIgnoreCase) ||
string.Equals(postedFile.ContentType, "image/x-png", StringComparison.OrdinalIgnoreCase) ||
string.Equals(postedFile.ContentType, "image/png", StringComparison.OrdinalIgnoreCase))
{
string urlStorage = InitImages.SendToStorage(postedFile.FileName, postedFile.InputStream);
if (urlStorage == "")
{
return new WebResult <bool>()
{
Status = false,
Message = "failed to load image",
Value = false
}
}
;
Groom groom = new Groom();
groom.url = urlStorage;
string token = getFaceToken(urlStorage);
if (token == "")
{
return new WebResult <bool>()
{
Status = false,
Message = "failed",
Value = false
}
}
;
groom.token = token;
groom.name = postedFile.FileName;
DB.Grooms.Add(groom);
if (DB.SaveChanges() > 0)
{
return new WebResult <bool>()
{
Status = true,
Message = "Ok",
Value = true
}
}
;
}
}
return(new WebResult <bool>()
{
Status = false,
Message = "That's not an image",
Value = false
});
}
catch (Exception e)
{
return(new WebResult <bool>()
{
Status = false,
Message = e.Message,
Value = false
});
}
}
