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 }); } }