/// <summary>
/// This is forms constructor.
/// In this constructor the combobox for user types(CmbUsersTypes) is
/// filling from the user types table(users_types).
/// </summary>
public DeleteUsersTypes()
{
InitializeComponent();
CmbUsersTypes.DataSource = DCom.GetData("SELECT * FROM users_types");
CmbUsersTypes.DisplayMember = "Type";
CmbUsersTypes.ValueMember = "Type";
}
/// <summary>
/// Finally when the client made the changes that he wants the program checks if all the fields
/// all fields are fill. If all fields are fill then the program exec the apropriate querry for the
/// update of the rating, else show a error message.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtnSelect_Click(object sender, EventArgs e)
{
LblRatingValue.Show();
LblComment.Show();
LblUsername.Show();
TbxComment.Show();
TbxRatingValue.Show();
CmbUsername.Show();
BtnEdit.Show();
LblSelect.Hide();
CmbSelect.Hide();
BtnSelect.Hide();
SelectedData = DCom.GetData(String.Format(SqlExec, CmbSelect.SelectedValue));
TbxRatingValue.Text = SelectedData.Rows[0]["Rating_Value"].ToString();
TbxComment.Text = SelectedData.Rows[0]["Comment"].ToString();
CmbUsername.DataSource = DCom.GetData("SELECT * FROM users");
CmbUsername.DisplayMember = "Username";
CmbUsername.ValueMember = "Username";
}
/// <summary>
/// When the client select the user that wants to edit the not necessarily labels, tetxboxes and comboboxes are hiding
/// from the form and then the neccesarily labels, tetxboxes and comboboxes are pop up. Then fills all the fields with
/// the data of the selected user.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtnSelect_Click(object sender, EventArgs e)
{
Guidelbl.Hide();
CmbUser.Hide();
BtnSelect.Hide();
label1.Show();
label2.Show();
label3.Show();
label4.Show();
label5.Show();
label6.Show();
TbxFirstName.Show();
TbxLastName.Show();
TbxUsername.Show();
TbxTelephone.Show();
TbxEmail.Show();
CmbTypes.Show();
BtnEdit.Show();
SelectedData = DCom.GetData(String.Format(SqlExec, CmbUser.SelectedValue));
TbxFirstName.Text = (string)SelectedData.Rows[0]["First_Name"];
TbxLastName.Text = (string)SelectedData.Rows[0]["Last_Name"];
TbxUsername.Text = (string)SelectedData.Rows[0]["Username"];
TbxEmail.Text = (string)SelectedData.Rows[0]["Email"];
TbxTelephone.Text = (string)SelectedData.Rows[0]["Telephone"];
DataTable GetUserType = DCom.GetData(String.Format("SELECT users_types.Type FROM users, users_types WHERE users.Username='******' and users.Type=users_types.Type", CmbUser.SelectedValue));
CmbTypes.DataSource = DCom.GetData("SELECT * FROM users_types");
CmbTypes.DisplayMember = "Type";
CmbTypes.ValueMember = "Type";
CmbTypes.Text = (string)GetUserType.Rows[0]["Type"];
}
/// <summary>
/// In forms constractor the Combobox for User Types(CmbTypes) fills up from the table users_types
/// that contains all the types. The diplay member is the name of the type(Row Type)
/// and the value member is the same.
/// </summary>
public AddLocation()
{
InitializeComponent();
CmbMunicipality.DataSource = DCom.GetData("SELECT Municipality_Name FROM municipality");
CmbMunicipality.DisplayMember = "Municipality_Name";
CmbMunicipality.ValueMember = "Municipality_Name";
}
/// <summary>
/// In the constructor the from is created.
/// Then the combobox of the form is fill with the ID
/// of the work hours
/// </summary>
public DeleteWorkHours()
{
InitializeComponent();
CmbWorkHours.DataSource = DCom.GetData("SELECT * FROM work_hours");
CmbWorkHours.DisplayMember = "ID";
CmbWorkHours.ValueMember = "ID";
}
/// <summary>
/// In forms constractor the Combobox for Usernames(CmbUsername) fills up from the table users
/// that contains all the users. The diplay member is the usenrame of the user(Row Username)
/// and the value member is the same.
/// </summary>
public AddLogin()
{
InitializeComponent();
CmbUsername.DataSource = DCom.GetData("SELECT users.Username FROM users WHERE users.Username NOT IN (SELECT login.Username FROM login)");
CmbUsername.DisplayMember = "Username";
CmbUsername.ValueMember = "Username";
}
/// <summary>
/// In forms constractor the Combobox for User Types(CmbMunicipality) fills up from the table users_types
/// that contains all the types. The diplay member is the name of the type(Row Type)
/// and the value member is the same.
/// </summary>
public AddMunicipality()
{
InitializeComponent();
CmbMunicipality.DataSource = DCom.GetData("SELECT * FROM province");
CmbMunicipality.DisplayMember = "Name";
CmbMunicipality.ValueMember = "Name";
}
/// <summary>
/// When the client select the rating that wants to edit the not necessarily labels, tetxboxes and comboboxes are hiding
/// from the form and then the neccesarily labels, tetxboxes and comboboxes are pop up. Then fills all the fields with
/// the data of the selected rating.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtnSelect_Click(object sender, EventArgs e)
{
LblBusiness.Show();
LblDate.Show();
LblPerson.Show();
LblUsername.Show();
CmbBusiness.Show();
CmbUsername.Show();
BtnEdit.Show();
TbxPerson.Show();
DtpDate.Show();
LblSelect.Hide();
CmbSelect.Hide();
BtnSelect.Hide();
SelectedData = DCom.GetData(String.Format(SqlExec, CmbSelect.SelectedValue));
TbxPerson.Text = SelectedData.Rows[0]["Persons"].ToString();
CmbBusiness.DataSource = DCom.GetData("SELECT businesses.ID, CONCAT(businesses.Business_Name, ', ', location.Address_Name, ', ', location.Municipality) AS NAME FROM businesses, location WHERE businesses.Location_ID = location.ID");
CmbBusiness.DisplayMember = "NAME";
CmbBusiness.ValueMember = "ID";
CmbUsername.DataSource = DCom.GetData("SELECT * FROM users");
CmbUsername.DisplayMember = "Username";
CmbUsername.ValueMember = "Username";
CmbUsername.Text = SelectedData.Rows[0]["User"].ToString();
CmbBusiness.Text = SelectedData.Rows[0]["BusinessID"].ToString();
}
/// In forms constractor the Combobox for Days(CmbDays) fills up from the table days
/// that contains all the days. The diplay member is the name of the day(Row Name)
/// and the value member is the same.
public AddWorkHours()
{
InitializeComponent();
CmbDays.DataSource = DCom.GetData("SELECT * FROM days");
CmbDays.DisplayMember = "Name";
CmbDays.ValueMember = "Name";
}
/// <summary>
/// In the constructor the from is created.
/// Then the combobox of the form is fill with the Usernames
/// and NAMES of users.
/// </summary>
public DeleteLocation()
{
InitializeComponent();
CmbLocation.DataSource = DCom.GetData("SELECT Username,CONCAT(Last_name,' ' , First_Name) AS NAME FROM users");
CmbLocation.DisplayMember = "Location";
CmbLocation.ValueMember = "Location";
}
/// <summary>
/// This state is when the client press the button to add a record.
/// Before it goes to add the record it checks if all the fields are completed.
/// Then add the record in database.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Addbtn_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(TbxBusinessName.Text) || string.IsNullOrWhiteSpace(TbxCategory.Text) || string.IsNullOrWhiteSpace(TbxDescription.Text) ||
string.IsNullOrWhiteSpace(TbxPrice.Text) || string.IsNullOrWhiteSpace(TbxWebsite.Text) || string.IsNullOrWhiteSpace(CmbLocation.Text) ||
string.IsNullOrWhiteSpace(CmbTypes.Text) || string.IsNullOrWhiteSpace(CmbUser.Text) || string.IsNullOrWhiteSpace(CmbWorkHours.Text))
{
MessageBox.Show("PLEASE ADD ALL THE DATA", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (ChbReservation.Checked)
{
DCom.Exec(String.Format(SqlExec, TbxBusinessName.Text, CmbTypes.SelectedValue, TbxCategory.Text, CmbLocation.SelectedValue, TbxTelephone.Text,
TbxWebsite.Text, TbxDescription.Text, CmbWorkHours.SelectedValue, CmbUser.SelectedValue, TbxRating.Text, TbxPrice.Text, '1'));
MessageBox.Show("ADD COMPLETE");
Close();
}
else
{
DCom.Exec(String.Format(SqlExec, TbxBusinessName.Text, CmbTypes.SelectedValue, TbxCategory.Text, CmbLocation.SelectedValue, TbxTelephone.Text,
TbxWebsite.Text, TbxDescription.Text, CmbWorkHours.SelectedValue, CmbUser.SelectedValue, TbxRating.Text, TbxPrice.Text, '0'));
MessageBox.Show("ADD COMPLETE");
Close();
}
}
}
/// <summary>
/// In the constructor the from is created.
/// Then the combobox of the form is filled with the days
/// </summary>
public DeleteDays()
{
InitializeComponent();
CmbDay.DataSource = DCom.GetData("SELECT * FROM days");
CmbDay.DisplayMember = "Name";
CmbDay.ValueMember = "Name";
}
private void BtnSelect_Click(object sender, EventArgs e)
{
LblBusinessDescription.Show();
LblBusinessName.Show();
LblCategory.Show();
LblPrice.Show();
LblRating.Show();
LblTelephone.Show();
LblUser.Show();
LblWebsite.Show();
LblWorkHours.Show();
LblBusinessType.Show();
LblLocation.Show();
TbxBusinessName.Show();
TbxCategory.Show();
TbxDescription.Show();
TbxPrice.Show();
TbxRating.Show();
TbxTelephone.Show();
TbxWebsite.Show();
CmbLocation.Show();
CmbTypes.Show();
CmbUser.Show();
CmbWorkHours.Show();
ChbReservation.Show();
BtnEdit.Show();
LblSelect.Hide();
CmbBusinesses.Hide();
BtnSelect.Hide();
SelectedData = DCom.GetData(String.Format(SqlExec, CmbBusinesses.SelectedValue));
TbxBusinessName.Text = (string)SelectedData.Rows[0]["Business_Name"];
TbxCategory.Text = (string)SelectedData.Rows[0]["Category"];
TbxDescription.Text = (string)SelectedData.Rows[0]["Description"];
TbxPrice.Text = SelectedData.Rows[0]["Price_Range"].ToString();
TbxRating.Text = (string)SelectedData.Rows[0]["Rating"].ToString();
TbxTelephone.Text = (string)SelectedData.Rows[0]["Telephone"];
TbxWebsite.Text = (string)SelectedData.Rows[0]["Website"];
CmbLocation.DataSource = DCom.GetData("SELECT ID,CONCAT(Address_Name, ', ', Address_Number) AS NAME FROM location");
CmbLocation.DisplayMember = "NAME";
CmbLocation.ValueMember = "ID";
CmbTypes.DataSource = DCom.GetData("SELECT * FROM businesses_types");
CmbTypes.DisplayMember = "Type";
CmbTypes.ValueMember = "Type";
CmbUser.DataSource = DCom.GetData("SELECT * FROM users");
CmbUser.DisplayMember = "Username";
CmbUser.ValueMember = "Username";
CmbWorkHours.DataSource = DCom.GetData("SELECT * FROM work_hours");
CmbWorkHours.DisplayMember = "ID";
CmbWorkHours.ValueMember = "ID";
}
/// <summary>
/// When the client select the user that wants to edit the not necessarily labels, tetxboxes and comboboxes are hiding
/// from the form and then the neccesarily labels, tetxboxes and comboboxes are pop up. Then fills all the fields with
/// the data of the selected user.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtnSelect_Click(object sender, EventArgs e)
{
label2.Show();
label3.Show();
label4.Show();
label5.Show();
label6.Show();
label7.Show();
TbxAddressNumber.Show();
TbxAdressName.Show();
TbxLat.Show();
TbxLong.Show();
TbxPostalCode.Show();
CmbMunicipality.Show();
BtnEdit.Show();
label1.Hide();
CmbLocation.Hide();
BtnSelect.Hide();
SelectedData = DCom.GetData(String.Format(SqlExec, CmbLocation.SelectedValue));
TbxAdressName.Text = SelectedData.Rows[0]["Address_Name"].ToString();
TbxAddressNumber.Text = SelectedData.Rows[0]["Address_Number"].ToString();
TbxLat.Text = SelectedData.Rows[0]["Lat"].ToString();
TbxLong.Text = SelectedData.Rows[0]["Long"].ToString();
TbxPostalCode.Text = SelectedData.Rows[0]["Postal_Code"].ToString();
CmbMunicipality.DataSource = DCom.GetData("SELECT * FROM municipality");
CmbMunicipality.DisplayMember = "Municipality_Name";
CmbMunicipality.ValueMember = "Municipality_Name";
CmbMunicipality.Text = SelectedData.Rows[0]["Municipality"].ToString();
}
/// <summary>
/// In the constructor the from is created.
/// Then the combobox of the form is fill with the Usernames
/// and NAMES of users.
/// </summary>
public DeleteMunicipality()
{
InitializeComponent();
CmbMunicipality.DataSource = DCom.GetData("SELECT * FROM municipality");
CmbMunicipality.DisplayMember = "NAME";
CmbMunicipality.ValueMember = "Municipality_Name";
}
/// <summary>
/// In the constructor the from is created.
/// Then the combobox of the form is fill with the Usernames
/// and NAMES of users.
/// </summary>
public DeleteUser()
{
InitializeComponent();
CmbUsers.DataSource = DCom.GetData("SELECT Username,CONCAT(Last_name,' ' , First_Name) AS NAME FROM users");
CmbUsers.DisplayMember = "NAME";
CmbUsers.ValueMember = "Username";
}
/// <summary>
/// In the constructor the from is created.
/// Then the combobox of the form is fill with the Usernames
/// of the table login.
/// </summary>
public DeleteLogin()
{
InitializeComponent();
CmbUsername.DataSource = DCom.GetData("SELECT * FROM login");
CmbUsername.DisplayMember = "Username";
CmbUsername.ValueMember = "Username";
}
/// <summary>
/// In forms constractor the Combobox for Username(CmbUsername) fills up from the table users
/// that contains all the users. The diplay member is the name of the Username(Row Username)
/// and the value member is the same.
/// </summary>
public AddRatingsForm()
{
InitializeComponent();
CmbUsername.DataSource = DCom.GetData("SELECT Username FROM users");
CmbUsername.DisplayMember = "Username";
CmbUsername.ValueMember = "Username";
}
/// <summary>
/// In the constructor the from is created.
/// Then the combobox of the form is fill with the province names of thre provinces.
/// </summary>
public DeleteProvince()
{
InitializeComponent();
CmbUsers.DataSource = DCom.GetData("SELECT * FROM province");
CmbUsers.DisplayMember = "Province_Name";
CmbUsers.ValueMember = "Province_Name";
}
public DeleteBusinessForm()
{
InitializeComponent();
CmbBusiness.DataSource = DCom.GetData("SELECT businesses.ID, CONCAT(businesses.Business_Name, ', ', location.Address_Name, ', ', location.Municipality) AS NAME FROM businesses, location WHERE businesses.Location_ID = location.ID");
CmbBusiness.DisplayMember = "NAME";
CmbBusiness.ValueMember = "ID";
}
/// <summary>
/// This is forms constructor.
/// In this constructor the combobox for user types(CmbBusinessesTypes) is
/// filling from the user types table(businesses_types).
/// </summary>
public DeleteBusinessesTypes()
{
InitializeComponent();
CmbBusinessesTypes.DataSource = DCom.GetData("SELECT * FROM businesses_types");
CmbBusinessesTypes.DisplayMember = "Type";
CmbBusinessesTypes.ValueMember = "Type";
}
/// <summary>
/// In the constructor the from is created.
/// Then the combobox of the form is fill with the ID and NAME
/// from reservation.
/// </summary>
public DeleteReservationForm()
{
InitializeComponent();
CmbReservations.DataSource = DCom.GetData("SELECT ID, CONCAT(ID, ', ', User, ', ', BusinessID) AS NAME FROM reservation");
CmbReservations.DisplayMember = "NAME";
CmbReservations.ValueMember = "ID";
}
/// <summary>
/// In the constructor the from is created.
/// Then the combobox of the form is fill with the Usernames
/// </summary>
public DeleteRatingsForm()
{
InitializeComponent();
CmbRatings.DataSource = DCom.GetData("SELECT *, CONCAT(Username, ', ', Rating_Value) AS NAME FROM ratings");
CmbRatings.DisplayMember = "NAME";
CmbRatings.ValueMember = "ID";
}
/// <summary>
/// In forms constructor the not necessarily labels, tetxboxes and comboboxes are hiding
/// from the form. Then the combobox for users(CmbDays) is filling with the usernames and NAMES
/// from table users.
/// </summary>
public EditDays()
{
InitializeComponent();
label2.Hide();
TbxDays.Hide();
CmbDays.DataSource = DCom.GetData("SELECT * FROM days");
CmbDays.DisplayMember = "Name";
CmbDays.ValueMember = "Name";
}
/// <summary>
/// In forms constructor the not necessarily labels and tetxboxes are hiding
/// from the form. Then the combobox for businesses types(CmbBusinessesTypes) is filling
/// from the businesses types(businesses_types) table.
/// /// </summary>
public EditBusinessesTypes()
{
InitializeComponent();
BtnEdit.Hide();
LblGuide1.Hide();
TbxEditiBusinessesTypes.Hide();
CmbBusinessesTypes.DataSource = DCom.GetData("SELECT * FROM businesses_types");
CmbBusinessesTypes.DisplayMember = "Type";
CmbBusinessesTypes.ValueMember = "Type";
}
/// <summary>
/// In forms constructor the not necessarily labels, tetxboxes and comboboxes are hiding
/// from the form. Then the combobox for province(comboBoxptovince) is filling with the data from table province.
/// </summary>
public EditProvince()
{
InitializeComponent();
TbxProvinceName.Hide();
labelpro.Hide();
BtnEdit.Hide();
comboBoxptovince.DataSource = DCom.GetData("SELECT * FROM province");
comboBoxptovince.DisplayMember = "Province_Name";
comboBoxptovince.ValueMember = "Province_Name";
}
/// <summary>
/// In forms constructor the not necessarily labels and tetxboxes are hiding
/// from the form. Then the combobox for login(CmbUsername) is filling
/// from the user types(users_types) table.
/// /// </summary>
public EditMunicipality()
{
InitializeComponent();
guidelbl.Hide();
label2.Hide();
TbxName.Hide();
CmbProvince.Hide();
CmbMunicipality_Name.DataSource = DCom.GetData("SELECT * FROM municipality WHERE Municipality_Name = '{0}'");
CmbMunicipality_Name.DisplayMember = "NAME";
CmbMunicipality_Name.ValueMember = "NAME";
}
private void BtnSelect_Click(object sender, EventArgs e)
{
TbxDays.Show();
BtnEdit.Show();
label2.Show();
label3.Hide();
CmbDays.Hide();
BtnSelect.Hide();
SelectedData = DCom.GetData(String.Format(SqlExec, CmbDays.SelectedValue));
TbxDays.Text = (string)SelectedData.Rows[0]["Name"];
}
/// <summary>
/// When the client select the user type that wants to edit the not necessarily labels and comboboxes are hiding
/// from the form and then the neccesarily labels and tetxboxes are pop up. Then fills all the fields with
/// the data of the selected user type.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BtnSelect_Click(object sender, EventArgs e)
{
BtnEdit.Show();
LblGuide1.Show();
TbxEditiBusinessesTypes.Show();
BtnSelect.Hide();
CmbBusinessesTypes.Hide();
LblGuide.Hide();
SelectedData = DCom.GetData(String.Format(SqlExec, CmbBusinessesTypes.SelectedValue));
TbxEditiBusinessesTypes.Text = (string)SelectedData.Rows[0]["Type"];
}
/// <summary>
/// When the client select the privince that wants to edit the not necessarily labels, tetxboxes and comboboxes are hiding
/// from the form and then the neccesarily labels, tetxboxes and comboboxes are pop up. Then fills all the fields with
/// the data of the selected province.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnselect_Click(object sender, EventArgs e)
{
label2.Hide();
comboBoxptovince.Hide();
TbxProvinceName.Hide();
btnselect.Hide();
labelpro.Show();
TbxProvinceName.Show();
BtnEdit.Show();
SelectedData = DCom.GetData(String.Format(SqlExec, comboBoxptovince.SelectedValue));
TbxProvinceName.Text = (string)SelectedData.Rows[0]["Province_Name"];
}
