private void btnSaveClient_Click(object sender, EventArgs e)
{
//Create a new role that the Variable will be added into
DataRow newClientRow = DM.dtClient.NewRow();
// if any of the text area is empty then do not write the data and return error message
if ((txtAddClientLastName.Text == "") || (txtAddClientFirstName.Text == "") || (txtAddClientStreetAddress.Text == "") ||
(txtAddClientSuburb.Text == "") || (txtAddClientCity.Text == "") || (cboAddClientCountryID.Text == "") ||
(cboAddClientCountryName.Text == "") || (txtAddClientEmail.Text == "") || (cboAddClientCreditStatus.Text == ""))
{
MessageBox.Show("You must type in all feilds", "Error");
}
else
{
newClientRow["LastName"] = txtAddClientLastName.Text;
newClientRow["FirstName"] = txtAddClientFirstName.Text;
newClientRow["StreetAddress"] = txtAddClientStreetAddress.Text;
newClientRow["Suburb"] = txtAddClientSuburb.Text;
newClientRow["City"] = txtAddClientCity.Text;
newClientRow["CountryID"] = cboAddClientCountryID.Text;
newClientRow["Email"] = txtAddClientEmail.Text;
newClientRow["CreditStatus"] = cboAddClientCreditStatus.Text;
//Add the new row to the table
DM.dtClient.Rows.Add(newClientRow);
currencyManager.EndCurrentEdit();
// Give the user the success message
MessageBox.Show("Client added successfully", "Success");
DM.UpdateClient();
}
}
// This button click method combines a Challenge ID and a Competitor ID together to create a new record in
// the Entry table, unless the competitor is already entered into that particular challenge.
private void btnAddEntry_Click(object sender, EventArgs e)
{
try
{
if (DM.dtChallenge.Rows[cmChallenge.Position]["Status"].ToString() == "Scheduled")
{
DataRow newEntry = DM.dtEntry.NewRow();
newEntry["ChallengeID"] = dgvChallenge["ChallengeID", cmChallenge.Position].Value;
newEntry["CompetitorID"] = dgvCompetitor["CompetitorID", cmCompetitor.Position].Value;
newEntry["Status"] = comChallengeEventStatus.Text;
DM.dsNZESL.Tables["Entry"].Rows.Add(newEntry);
currencyManager.EndCurrentEdit();
DM.UpdateEntry();
MessageBox.Show("Entry added successfully", "Success");
}
else
{
MessageBox.Show("Competitors can only be entered to scheduled challenges", "Error");
}
}
catch (ConstraintException)
{
MessageBox.Show("This competitor has already been entered in this challenge", "Error");
}
}
//save the update
private void btnSaveChanges_Click(object sender, EventArgs e)
{
DataRow updateVacancyRow = DM.dtVacancy.Rows[currencyManager.Position];
//stop the empty text to stop error
if ((txtpnlUpDescription.Text == "") || (txtpnlUpSalary.Text == ""))
{
MessageBox.Show("You must enter a value for each text fields ");
return;
}
else
{
//the salary should between 30000-200000
if ((Convert.ToInt32(txtpnlUpSalary.Text) < 30000) || (Convert.ToInt32(txtpnlUpSalary.Text)) > 200000)
{
MessageBox.Show("Salary should between 30000 and 200000");
return;
}
//update current row
else
{
updateVacancyRow["Description"] = txtpnlUpDescription.Text;
updateVacancyRow["Salary"] = Convert.ToInt32(txtpnlUpSalary.Text);
currencyManager.EndCurrentEdit();
DM.UpdateVacancy();
MessageBox.Show("Vacancy updated successfully", "Success");
}
}
}
public void EndAddNew2()
{
BindingContext bc = new BindingContext();
CancelAddNewList <int> list = new CancelAddNewList <int> ();
list.Add(4);
list.Add(6);
CurrencyManager cm = (CurrencyManager)bc [list];
Assert.AreEqual(false, list.EndNewCalled, "A1");
Assert.AreEqual(false, list.CancelNewCalled, "A2");
Assert.AreEqual(-1, list.LastIndex, "A3");
cm.EndCurrentEdit();
Assert.AreEqual(true, list.EndNewCalled, "B1");
Assert.AreEqual(false, list.CancelNewCalled, "B2");
Assert.AreEqual(0, list.LastIndex, "B3");
cm.Position = 1;
list.Reset();
cm.EndCurrentEdit();
Assert.AreEqual(true, list.EndNewCalled, "C1");
Assert.AreEqual(false, list.CancelNewCalled, "C2");
Assert.AreEqual(1, list.LastIndex, "C3");
}
private void btnSaveBook_Click(object sender, EventArgs e)
{
//Create a new role that the Variable will be added into
DataRow newBookrow = DM.dtBook.NewRow();
// if any of the text area is empty then do not write the data and return error message
if ((cboAddBookInfoID.Text == "") || (txtAddBookInfoCost.Text == "") || (txtAddBookInfoPrice.Text == "") ||
(dtpAddBookPublished.Text == "") || (cboAddBookVendorID.Text == ""))
{
MessageBox.Show("You must type in all feilds", "Error");
}
else
{
newBookrow["BookInfoID"] = cboAddBookInfoID.Text;
newBookrow["Cost"] = txtAddBookInfoCost.Text;
newBookrow["Price"] = txtAddBookInfoPrice.Text;
newBookrow["DatePublished"] = dtpAddBookPublished.Text;
newBookrow["VendorID"] = cboAddBookVendorID.Text;
//Add the new row to the table
DM.dtBook.Rows.Add(newBookrow);
currencyManager.EndCurrentEdit();
// Give the user the success message
MessageBox.Show("Book added successfully", "Success");
DM.UpdateBook();
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
//Create a new row that the variables will be added into
DataRow newServiceRow = DM.dtService.NewRow();
//If any of the text areas are empty then do not write data and return
if ((cboAddVehicleID.Text == "") || (cboAddServiceType.Text == "") ||
(txtAddHours.Text == "") || (dtpServiceDate.Text == ""))
{
MessageBox.Show("You must enter a value for each of the text fields.", "Error");
}
else
{
//newServiceRow["VehicleID"] = cboVehicleID.Text;
//newServiceRow["ServiceTypeID"] = cboServiceType.Text;
newServiceRow["Hours"] = txtAddHours.Text;
newServiceRow["ServiceDate"] = dtpServiceDate.Text;
//newServiceRow["Status"] = txtStatus.Text == "Pending";
//Add the new row to the Table
cmService.EndCurrentEdit();
DM.UpdateService();
//Give the user a success message
MessageBox.Show("Service updated successfully.", "Success");
}
return;
}
private void btnSaveClientOrder_Click(object sender, EventArgs e)
{
//Create a new role that the Variable will be added into
DataRow newClientOrderRow = DM.dtClientOrder.NewRow();
// if any of the text area is empty then do not write the data and return error message
if (dtpAddClientOrder.Text == "")
{
MessageBox.Show("You must enter a Order Date and Client ID", "Error");
}
else
{
newClientOrderRow["OrderDate"] = dtpAddClientOrder.Text;
newClientOrderRow["ClientID"] = cboAddClientID.Text;
newClientOrderRow["Status"] = "Current";
//Add the new row to the table
DM.dtClientOrder.Rows.Add(newClientOrderRow);
currencyManager.EndCurrentEdit();
DM.UpdateClientOrder();
// Give the user the success message
MessageBox.Show("Client Order Added Successfully");
}
}
private void btnSaveChanges_Click(object sender, EventArgs e)
{
DataRow updateBugRow = DM.dtBug.Rows[currencyManager.Position];
if ((txtUpdateComment.Text == ""))
{
MessageBox.Show("You must type in a comment.", "Error");
}
else
{
updateBugRow["Status"] = cboUpdateStatus.Text;
updateBugRow["ActualDate"] = dtpUpdateActualD.Text;
updateBugRow["EmployeeID"] = cboUpdateEmployeeID.Text;
updateBugRow["Comment"] = txtUpdateComment.Text;
updateBugRow["Assigned"] = "Assigned";
currencyManager.EndCurrentEdit();
DM.UpdateBug();
MessageBox.Show("Bug record updated successfully.", "Success");
pnlUpdateBug.Hide();
lstBug.Visible = true;
btnReturn.Enabled = true;
btnDeleteBug.Enabled = true;
btnNext.Enabled = true;
btnPrevious.Enabled = true;
btnAddBug.Enabled = true;
}
}
/// <summary>
/// add book to client order
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAddBook_Click(object sender, EventArgs e)
{
try
{
if (DM.dtClientOrder.Rows[cmClientOrder.Position]["Status"].ToString() == "Current")
{
string clientOrderID = DM.dtClientOrder.Rows[cmClientOrder.Position]["ClientOrderID"].ToString();
int aClientOrderID = Convert.ToInt32(clientOrderID);
string bookID = dgvUnorderedBooks["BookID", cmUnorderedBooks.Position].Value.ToString();
int aBookID = Convert.ToInt32(bookID);
cmBook.Position = DM.bookView.Find(aBookID);
DataRow newOrder = DM.dtBook.Rows[cmBook.Position];
newOrder["ClientOrderID"] = aClientOrderID;
cmBook.EndCurrentEdit();
DM.UpdateBook();
UpdateOrderedBooks();
UpdateUnorderedBooks();
MessageBox.Show("Book Added to Client Order Successfully!", "Success");
}
else
{
MessageBox.Show("Books can only be added to current orders!", "Error");
}
}
catch (ConstraintException)
{
MessageBox.Show("This book has already been added to this client order!", "Error");
}
}
private void button1_Click(object sender, EventArgs e)
{
cm.EndCurrentEdit();
commandbuilder = new SqlCommandBuilder(da);
da.Update(datatable);
MessageBox.Show("ADDED ", "Addtion");
label4.Text = (cm.Position + 1) + " / " + datatable.Rows.Count;
}
/// <summary>
/// update a client order
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSaveChanges_Click(object sender, EventArgs e)
{
DataRow updateClientOrderRow = DM.dtClientOrder.Rows[currencyManager.Position];
updateClientOrderRow["OrderDate"] = this.dtpUpdateOrderDate.Text;
currencyManager.EndCurrentEdit();
DM.UpdateClientOrder();
MessageBox.Show("Client Order Updated Successfully!", "Success");
}
//Update Book Info in the table
private void btnUpdSave_Click(object sender, EventArgs e)
{
DataRow updClientOrderRow = DM.dtClientOrder.Rows[currencyManager.Position];
updClientOrderRow["OrderDate"] = dtpUpdClientOrderDate.Text;
currencyManager.EndCurrentEdit();
MessageBox.Show("Client Order was updated successfully", "Success");
DM.UpdateClientOrder();
}
private void btnAdd_Click(object sender, EventArgs e)
{
// زر الاضافة
cm.EndCurrentEdit();
cmdb = new SqlCommandBuilder(adapter);
adapter.Update(Dt);
cm.Refresh();
MessageBox.Show("Add Successfully!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
//Function to save the modified Race record
private void btnSaveUpdateRace_Click(object sender, EventArgs e)
{
DataRow updateRaceRow = DM.dtRace.Rows[currencyManager.Position];
if (txtUpdateRaceName.Text == "")
{
MessageBox.Show("Race Name must not be empty!", "Error");
}
else if (txtUpdateRaceName.Text.Length > 30)
{
MessageBox.Show("Race Name must not exceed 30 characters!", "Error");
}
else if (txtUpdateRaceTime.Text == "")
{
MessageBox.Show("Race Time must not be empty!", "Error");
}
else if (npUpdateRaceCapacity.Text == "")
{
MessageBox.Show("Race Capacity must not be empty!", "Error");
}
else if (Convert.ToInt32(npUpdateRaceCapacity.Text) <= 1 || Convert.ToInt32(npUpdateRaceCapacity.Text) >= 40)
{
MessageBox.Show("Race Capacity must be between 2 and 39!", "Error");
}
else
{
try
{
//Add the modified record to the existing record
updateRaceRow["RaceName"] = txtUpdateRaceName.Text;
updateRaceRow["RaceTime"] = txtUpdateRaceTime.Text;
updateRaceRow["Capacity"] = npUpdateRaceCapacity.Text;
currencyManager.EndCurrentEdit();
DM.UpdateRace(); //Update database
MessageBox.Show("Race updated successfully.", "Success");
//Close Update Race Course Panel and Reset the buttons to its normal state
pnlUpdateRace.Hide();
lstRaces.Enabled = true;
lstRaces.Visible = true;
btnPrevious.Enabled = true;
btnNext.Enabled = true;
btnAddRace.Enabled = true;
btnDeleteRace.Enabled = true;
btnMarkRaceAsFinished.Enabled = true;
btnMarkRaceAsComplete.Enabled = true;
btnReturn.Enabled = true;
}
catch (Exception ex)
{
MessageBox.Show("Please use a time format for Race Time. Ex: 7:00 or 13:00", "Error");
}
}
}
// This is a button click method that validates and saves the new Event details, entered into the Add Event
// panel, into the database. If the data is invalid, it gives an error message. It then hides the Add Event
// panel, and shows the previously hidden text boxes, labels and the list box, and re-enables the buttons.
private void btnSaveMeeting_Click(object sender, EventArgs e)
{
DataRow newEventRow = DM.dtEvent.NewRow();
if ((txtAddEventName.Text == "") || (comAddEventArenaID.Text == "") || (comAddEventStatus.Text == "") ||
(datAddEventDate.Text == ""))
{
MessageBox.Show("Please fill in all fields", "Error");
}
else if (numAddEventCapacity.Value < 100)
{
MessageBox.Show("The minimum capacity for an event is 100 people.", "Error");
}
else
{
newEventRow["EventName"] = txtAddEventName.Text;
newEventRow["ArenaID"] = comAddEventArenaID.Text;
newEventRow["Status"] = comAddEventStatus.Text;
newEventRow["Capacity"] = numAddEventCapacity.Text;
newEventRow["EventDate"] = datAddEventDate.Text;
DM.dtEvent.Rows.Add(newEventRow);
DM.UpdateEvent();
currencyManager.EndCurrentEdit();
MessageBox.Show("Event added successfully", "Success");
lstEventName.Show();
lblEventID.Show();
lblEventName.Show();
lblEventArenaID.Show();
lblEventArenaName.Show();
lblEventStatus.Show();
lblEventCapacity.Show();
lblEventDate.Show();
txtEventID.Show();
txtEventName.Show();
txtEventArenaID.Show();
txtEventArenaName.Show();
txtEventStatus.Show();
txtEventCapacity.Show();
datEventDate.Show();
btnPrevious.Enabled = true;
btnNext.Enabled = true;
btnUpdateEvent.Enabled = true;
btnDeleteEvent.Enabled = true;
btnReturn.Enabled = true;
pnlAddEvent.Hide();
txtAddEventName.Text = "";
comAddEventArenaID.Text = "";
comAddEventStatus.Text = "";
}
}
// This is a button click method that validates and saves the new challenge details, entered into the Add
// Challenge panel, into the database. If the data is invalid, it gives an error message. It then hides the Add
// Challenge panel, and shows the previously hidden text boxes, labels and the list box, and re-enables the
// buttons. Finally, it removes the information from the Add Challenge panel's text fields so that if the user
// wishes to add another new challenge, they won't need to erase the previous data from the text fields.
private void btnSaveAddChallenge_Click(object sender, EventArgs e)
{
DataRow newChallengeRow = DM.dtChallenge.NewRow();
{
if ((txtAddChallengeName.Text == "") || (comAddEventID.Text == "") || (comAddEventName.Text == "") ||
(datAddStartTime.Text == "") || (comAddEventStatus.Text == "") || (numAddCapacity.Value == 0))
{
MessageBox.Show("Please fill in all fields", "Error");
}
else
{
newChallengeRow["ChallengeName"] = txtAddChallengeName.Text;
newChallengeRow["StartTime"] = datAddStartTime.Text;
newChallengeRow["EventID"] = comAddEventID.Text;
newChallengeRow["Status"] = comAddEventStatus.Text;
newChallengeRow["Capacity"] = Convert.ToInt32(numAddCapacity.Value);
DM.dtChallenge.Rows.Add(newChallengeRow);
DM.UpdateChallenge();
currencyManager.EndCurrentEdit();
MessageBox.Show("Challenge added successfully", "Success");
lstChallengeID.Show();
lblChallengeID.Show();
lblChallengeName.Show();
lblEventID.Show();
lblEventName.Show();
lblStartTime.Show();
lblStatus.Show();
lblCapacity.Show();
txtChallengeID.Show();
txtChallengeName.Show();
txtEventID.Show();
txtEventName.Show();
datStartTime.Show();
txtStatus.Show();
txtCapacity.Show();
btnPrevious.Enabled = true;
btnNext.Enabled = true;
btnUpdateChallenge.Enabled = true;
btnDeleteChallenge.Enabled = true;
btnChallengeFinished.Enabled = true;
btnChallengeComplete.Enabled = true;
btnReturn.Enabled = true;
pnlAddChallenge.Hide();
txtAddChallengeName.Text = "";
numAddCapacity.Value = 1;
}
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtCatName.Text))
{
cm.EndCurrentEdit(); // the new category is added to the source dt // if we comment that line the add will not be performed
BL.Category.AUDCategory(dt);
MessageBox.Show("The Product is Added Successfully", "Product", MessageBoxButtons.OK, MessageBoxIcon.Information);
btnNew.Enabled = true; btnAdd.Enabled = false; btnCancel.Enabled = false;
btnDel.Enabled = true; btnModify.Enabled = true;
}
else
{
MessageBox.Show("You Should enter valid values", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void btnSaveBookInfo_Click(object sender, EventArgs e)
{
//Create a new role that the Variable will be added into
DataRow newBookInforow = DM.dtBookInfo.NewRow();
newBookInforow["Title"] = txtAddBookTitle.Text;
newBookInforow["AuthorID"] = cboAddBookAuthorID.Text;
newBookInforow["Notes"] = txtAddAuthorNotes.Text;
DM.dtBookInfo.Rows.Add(newBookInforow);
currencyManager.EndCurrentEdit();
// Give the user the success message
MessageBox.Show("Book Info added successfully", "Success");
// Database is updated
DM.UpdateBookInfo();
}
// This is a button click method that validates and saves the new competitor details, entered into the Add
// Competitor panel, into the database. If the data is invalid, it gives an error message. It then hides the
// Add Competitor panel, and shows the previously hidden text boxes, labels and the list box, and re-enables the
// buttons. Finally, it removes the information from the Add Competitor panel's text fields so that if the user
// wishes to add another new competitor, they won't need to erase the previous data from the text fields.
private void btnSaveAddCompetitor_Click(object sender, EventArgs e)
{
DataRow newCompetitorRow = DM.dtCompetitor.NewRow();
if ((txtAddUserName.Text == "") || (txtAddFirstName.Text == "") || (txtAddLastName.Text == "") ||
(txtAddEmail.Text == ""))
{
MessageBox.Show("Please fill in all fields", "Error");
}
else
{
newCompetitorRow["UserName"] = txtAddUserName.Text;
newCompetitorRow["FirstName"] = txtAddFirstName.Text;
newCompetitorRow["LastName"] = txtAddLastName.Text;
newCompetitorRow["Gender"] = comAddGender.Text;
newCompetitorRow["DateOfBirth"] = datAddDateOfBirth.Text;
newCompetitorRow["EmailAddress"] = txtAddEmail.Text;
DM.dtCompetitor.Rows.Add(newCompetitorRow);
DM.UpdateCompetitor();
currencyManager.EndCurrentEdit();
MessageBox.Show("Competitor added successfully", "Success");
lstUserName.Show();
lblCompetitorID.Show();
lblUserName.Show();
lblFirstName.Show();
lblLastName.Show();
lblGender.Show();
lblDateOfBirth.Show();
lblEmail.Show();
txtCompetitorID.Show();
txtUserName.Show();
txtFirstName.Show();
txtLastName.Show();
txtGender.Show();
datDateOfBirth.Show();
txtEmail.Show();
btnPrevious.Enabled = true;
btnNext.Enabled = true;
btnUpdateCompetitor.Enabled = true;
btnDeleteCompetitor.Enabled = true;
btnReturn.Enabled = true;
pnlAddCompetitor.Hide();
txtAddUserName.Text = "";
txtAddFirstName.Text = "";
txtAddLastName.Text = "";
txtAddEmail.Text = "";
}
}
private void btnGuncelle_Click(object sender, EventArgs e)
{
CurrencyManager sonraki = (CurrencyManager)this.BindingContext[al.Tables["SATICI"]];
sonraki.EndCurrentEdit();
cb = new OleDbCommandBuilder(verial); // OleDbDataAdapter'i silme, güncelleme ve kayıt'a hazır hale getirmek için
verial.Update(al, "SATICI");
al.Clear();
verial.Fill(al.Tables[0]);
grdSatici.DataSource = al.Tables[0];
MessageBox.Show(" Güncelleme tamamlandı!", "İŞLEM TAMAM");
// Temizle
txtFirmaAdi.Clear();
txtYetkili.Clear();
txtAdres.Clear();
mskIsTel.Clear();
mskCepTel.Clear();
txtFirmaAdi.Enabled = false;
txtYetkili.Enabled = false;
txtAdres.Enabled = false;
mskIsTel.Enabled = false;
mskCepTel.Enabled = false;
}
/// <summary>
/// Raises the <see cref="E:System.Windows.Forms.ListView.AfterLabelEdit" /> event.
/// </summary>
/// <param name="e">A <see cref="T:System.Windows.Forms.LabelEditEventArgs" /> that contains the event data.</param>
#else
/// <summary>
/// Raises the <see cref="E:Gizmox.WebGUI.Forms.ListView.AfterLabelEdit"></see> event.
/// </summary>
/// <param name="e">A <see cref="T:Gizmox.WebGUI.Forms.LabelEditEventArgs"></see> that contains the event data.</param>
#endif
protected override void OnAfterLabelEdit(LabelEditEventArgs e)
{
if (e.Label == null)
{
// If you press ESC while editing.
e.CancelEdit = true;
return;
}
if (_listManager.List.Count > e.Item)
{
var row = _listManager.List[e.Item];
// In a ListView you are only able to edit the first Column.
var col = _listManager.GetItemProperties().Find(Columns[0].Text, false);
try
{
if (row != null && col != null)
{
col.SetValue(row, e.Label);
}
_listManager.EndCurrentEdit();
base.OnAfterLabelEdit(e);
}
catch (Exception ex)
{
// If you try to enter strings in number-columns, too long strings or something
// else wich is not allowed by the DataSource.
MessageBox.Show(Resources.EditFailed + ": " + ex.Message, Resources.EditFailed, MessageBoxButtons.OK, MessageBoxIcon.Error);
_listManager.CancelCurrentEdit();
e.CancelEdit = true;
}
}
}
/// <summary>
/// Check if fields are blank
/// If not blank, update candidate rows in the database
/// Catch error
/// </summary>
private void btnUpdateSaveChanges_Click(object sender, EventArgs e)
{
DataRow updateCandidateRow = DM.dtCandidate.Rows[currencyManager.Position];
if ((txtUpdateFirstName.Text == "") || (txtUpdateLastName.Text == "") || (txtUpdateStreetAddress.Text == "") || (txtUpdateSuburb.Text == "") || (txtUpdatePhoneNumber.Text == ""))
{
MessageBox.Show("You must ype in an candidate name, phone number, street address and suburb");
}
else
{
try
{
updateCandidateRow["LastName"] = txtUpdateLastName.Text;
updateCandidateRow["FirstName"] = txtUpdateFirstName.Text;
updateCandidateRow["StreetAddress"] = txtUpdateStreetAddress.Text;
updateCandidateRow["Suburb"] = txtUpdateSuburb.Text;
updateCandidateRow["PhoneNumber"] = txtUpdatePhoneNumber.Text;
currencyManager.EndCurrentEdit();
DM.UpdateCandidate();
MessageBox.Show("Candidate updated Successfully", "Success");
}
catch
{
MessageBox.Show("Please Enter The Proper type for each fields");
}
}
}
//Método que busca todos os clientes na API
public async void GetAllUsers()
{
using (var client = new HttpClient())
{
//Corrige erro de autenticação
ServicePointManager.SecurityProtocol = SecurityProtocolType.Ssl3 | SecurityProtocolType.Tls | SecurityProtocolType.Tls11 | SecurityProtocolType.Tls12;
//
using (var response = await client.GetAsync("https://localhost:5001/api/user/"))
{
if (response.IsSuccessStatusCode)
{
var UsersJsonString = await response.Content.ReadAsStringAsync();
gridFunc.DataSource = 0;
gridFunc.Columns.Clear();
gridFunc.Refresh();
gridFunc.DataSource = JsonConvert.DeserializeObject <ContaClientes[]>(UsersJsonString).ToList();
gridFunc.Update();
gridFunc.Refresh();
//Criao o botão delete
DataGridViewButtonColumn uninstallButtonColumn = new DataGridViewButtonColumn();
uninstallButtonColumn.UseColumnTextForButtonValue = true;
uninstallButtonColumn.HeaderText = "Delete";
uninstallButtonColumn.Name = "Delete";
uninstallButtonColumn.Text = "Delete";
gridFunc.Columns.Insert(6, uninstallButtonColumn);
// Oculta colunas desnecessárias do sistema
for (int i = 7; i < 60; i++)
{
gridFunc.Columns[i].Visible = false;
}
// Oculta usuários Clientes
foreach (DataGridViewRow row in gridFunc.Rows)
{
//permite ocultar linhas protegidas
CurrencyManager cm = (CurrencyManager)BindingContext[gridFunc.DataSource];
cm.EndCurrentEdit();
cm.ResumeBinding();
cm.SuspendBinding();
DataGridViewCheckBoxCell ck = (DataGridViewCheckBoxCell)row.Cells[5];
//Passa se o checkBox estiver selecionado;
if (Convert.ToBoolean(ck.Value) == false)
{
row.Visible = false;
}
}
}
else
{
MessageBox.Show("Não foi possível obter usuários : " + response.StatusCode);
}
}
}
}
private void updateKaiBtn_Click(object sender, EventArgs e)
{
var currentKaiRow = _dataModule.KaiTable.Rows[_kaiCurrencyManager.Position];
var currentEventRow = _dataModule.EventTable.Rows[_eventCurrencyManager.Position];
if (addPanelEventName.Text == "" || addFormKaiName.Text == "" || addPanelServingQuantity.Text == "" || addPanelPreparationTime.Text == "")
{
MessageBox.Show("You must enter a value for each of the text fields", "ERROR OCCURED");
return;
}
currentEventRow["EventName"] = addPanelEventName.Text;
_eventCurrencyManager.EndCurrentEdit();
_dataModule.UpdateEventTable();
currentKaiRow["EventId"] = currentEventRow["EventId"];
currentKaiRow["KaiName"] = addFormKaiName.Text;
currentKaiRow["ServeQuantity"] = Int32.Parse(addPanelServingQuantity.Text.ToString());
currentKaiRow["PreparationMinutes"] = Int32.Parse(addPanelPreparationTime.Text.ToString());
currentKaiRow["PreparationRequired"] = kaiAddCheckBox.Checked;
_kaiCurrencyManager.EndCurrentEdit();
_dataModule.UpdateKaiTable();
MessageBox.Show("Kai updated successfully", "Action succeed!");
addKaiCancelBtn_Click(sender, e);
}
private void panelUpdateWhanauBtn_Click(object sender, EventArgs e)
{
if (
string.IsNullOrEmpty(panelAddFirstName.Text) ||
string.IsNullOrEmpty(panelAddLastName.Text) ||
string.IsNullOrEmpty(panelAddEmail.Text) ||
string.IsNullOrEmpty(panelAddPhone.Text) ||
string.IsNullOrEmpty(panelAddAddress.Text))
{
MessageBox.Show("Please complete auto fields before save", "Idiot control !!!!!!!!!");
return;
}
bool isEmail = Regex.IsMatch(panelAddEmail.Text, @"\A(?:[a-z0-9!#$%&'*+/=?^_`{|}~-]+(?:\.[a-z0-9!#$%&'*+/=?^_`{|}~-]+)*@(?:[a-z0-9](?:[a-z0-9-]*[a-z0-9])?\.)+[a-z0-9](?:[a-z0-9-]*[a-z0-9])?)\Z", RegexOptions.IgnoreCase);
if (!isEmail)
{
MessageBox.Show("Email address is not valid", "Idiot control !!!!!!!!!");
return;
}
var whanauRecord = _dataModule.WhanauTable.Rows[_whanauCurrencyManager.Position];
whanauRecord["FirstName"] = panelAddFirstName.Text;
whanauRecord["LastName"] = panelAddLastName.Text;
whanauRecord["Email"] = panelAddEmail.Text;
whanauRecord["Phone"] = panelAddPhone.Text;
whanauRecord["Address"] = panelAddAddress.Text;
_whanauCurrencyManager.EndCurrentEdit();
_dataModule.UpdateWhanauTable();
MessageBox.Show("Whānau updated successfully", "Succeed");
panelCancel_Click(sender, e);
}
//Update Client in the table
private void btnUpdSave_Click(object sender, EventArgs e)
{
DataRow updClientRow = DM.dtClient.Rows[currencyManager.Position];
if (txtUpdLastName.Text == "")
{
MessageBox.Show("You must type in a Client's Last Name", "Error");
}
else if (txtUpdFirstName.Text == "")
{
MessageBox.Show("You must type in a Client's First Name", "Error");
}
else if (txtUpdStreetAddress.Text == "")
{
MessageBox.Show("You must type in a Client's Street Address", "Error");
}
else if (txtUpdSuburb.Text == "")
{
MessageBox.Show("You must type in a Client's Suburb Name", "Error");
}
else if (txtUpdCity.Text == "")
{
MessageBox.Show("You must type in a Client's City Name", "Error");
}
else if (isValidEmail(txtUpdEmail.Text) == false)
{
MessageBox.Show("You must type an Email in correct format", "Error");
}
else if (isLetterContains(txtUpdLastName.Text) == false)
{
MessageBox.Show("Client's Last Name can contain only letters", "Error");
}
else if (isLetterContains(txtUpdFirstName.Text) == false)
{
MessageBox.Show("Client's First Name can contain only letters", "Error");
}
else
{
updClientRow["City"] = txtUpdCity.Text;
updClientRow["Email"] = txtUpdEmail.Text;
updClientRow["FirstName"] = txtUpdFirstName.Text;
updClientRow["LastName"] = txtUpdLastName.Text;
updClientRow["StreetAddress"] = txtUpdStreetAddress.Text;
updClientRow["Suburb"] = txtUpdSuburb.Text;
updClientRow["CreditStatus"] = cboUpdCreditStatus.Text;
updClientRow["CountryID"] = cboUpdCountryID.Text;
currencyManager.EndCurrentEdit();
MessageBox.Show("Client was updated successfully", "Success");
DM.UpdateClient();
}
}
private void btnSaveChanges2_Click(object sender, EventArgs e)
{
DataRow updateMeetingRow = DM.dtMeeting.Rows[currencyManager.Position];
if ((txtMeetingName2.Text == "") || (numCapacity2.Value.ToString() == ""))
{
MessageBox.Show("You must enter a value for each of the text fields", "Error");
}
else if (int.Parse(numCapacity2.Value.ToString()) <= 1000 || int.Parse(numCapacity2.Value.ToString()) >= 20000)
{
MessageBox.Show("You must enter a value for capacity more than 1000 and less than 20000", "Error");
}
else
{
updateMeetingRow["MeetingName"] = txtMeetingName2.Text;
updateMeetingRow["Status"] = cmbStatus2.Text;
updateMeetingRow["Capacity"] = int.Parse(numCapacity2.Value.ToString());
updateMeetingRow["MeetingDate"] = dtpMeetingDate2.Value.ToString();
currencyManager.EndCurrentEdit();
DM.UpdateMeeting();
MessageBox.Show("Meeting updated successfully", "Success");
pnlUpdateMeeting.Visible = false;
lstMeeting.Visible = true;
btnPrevious.Enabled = true;
btnNext.Enabled = true;
btnAddMeeting.Enabled = true;
btnDeleteMeeting.Enabled = true;
btnReturn.Enabled = true;
}
}
private void carregaGrid()
{
dgvExclui.AutoGenerateColumns = false;
try
{
List <usuarioDTO> ListDto = new List <usuarioDTO>();
ListDto = new usuarioBLL().listaUsuario();
dgvExclui.DataSource = ListDto;
CurrencyManager cm = (CurrencyManager)BindingContext[dgvExclui.DataSource];
cm.EndCurrentEdit();
cm.ResumeBinding();
cm.SuspendBinding();
foreach (DataGridViewRow row in dgvExclui.Rows)
{
if (Convert.ToInt32(row.Cells["tipo"].Value) == 1)
{
row.Cells["teste"].Value = Convert.ToString("Professor");
}
else if (Convert.ToInt32(row.Cells["tipo"].Value) == 2)
{
row.Cells["teste"].Value = Convert.ToString("Técnico");
}
else
{
row.Visible = false;
}
}
}
catch (Exception erro)
{
throw erro;
}
}
private void btnSaveChanges_Click(object sender, EventArgs e)
{
DataRow updateTestRow = DM.dtTest.Rows[currencyManager.Position];
if ((txtUpdateComment.Text == ""))
{
MessageBox.Show("You must type in a comment.", "Error");
}
else
{
updateTestRow["Status"] = cboUpdateStatus.Text;
updateTestRow["DateEnd"] = dtpDEnd.Text;
updateTestRow["Comment"] = txtUpdateComment.Text;
currencyManager.EndCurrentEdit();
DM.UpdateTest();
MessageBox.Show("Test updated successfully.", "Success");
pnlUpdateTest.Hide();
lstTest.Visible = true;
btnReturn.Enabled = true;
btnDeleteTest.Enabled = true;
btnNext.Enabled = true;
btnPrevious.Enabled = true;
btnAddTest.Enabled = true;
}
}
private void btnUpdateVehicle_Click(object sender, EventArgs e)
{
DataRow updateVehicleRow = DM.dtVehicle.Rows[currencyManager.Position];
if ((txtAddPlateNumber.Text == "") || (txtAddMake.Text == "") ||
(txtAddModel.Text == ""))
{
MessageBox.Show("You must enter a value for each of the text fields.", "Error");
return;
}
else
{
//Update the text areas
updateVehicleRow["PlateNumber"] = txtAddPlateNumber.Text;
updateVehicleRow["Make"] = txtAddMake.Text;
updateVehicleRow["Model"] = txtAddModel.Text;
//updateVehicleRow["OwnerID"] = cboAddOwner.Text;
//Update the database
currencyManager.EndCurrentEdit();
DM.UpdateVehicle();
//Give the user a success message
MessageBox.Show("Vehicle updated successfully.", "Success");
}
return;
}
