private void btnCreate_Click(object sender, EventArgs e)
{
if (txtPhone.MaskedTextProvider.MaskCompleted)
{
if (clsGlobal.mode == "add")
{
try
{
string img = System.IO.Path.GetFileName(imgpath);
this.employeesTableAdapter.Insert(txtName.Text, txtPhone.Text, txtEmail.Text, cmbGender.Text, txtAddress.Text, img, txtPassword.Text, cmbPosition.Text, txtComment.Text);
RemaxDatabaseDataSet data = new RemaxDatabaseDataSet();
RemaxDatabaseDataSetTableAdapters.EmployeesTableAdapter empadapt = new RemaxDatabaseDataSetTableAdapters.EmployeesTableAdapter();
empadapt.Fill(data.Employees);
int id = -1;
foreach (DataRow ab in data.Employees)
{
if (ab["Phone"].ToString() == txtPhone.Text)
{
id = Convert.ToInt32(ab["refEmployee"].ToString());
}
}
if (listSkills.Items.Count > 0)
{
foreach (ListViewItem itn in listSkills.Items)
{
this.employeeSkillsTableAdapter.Insert(id, Convert.ToInt32(itn.SubItems[0].Text));
}
}
frm1.employeesTableAdapter.Fill(frm1.remaxDatabaseDataSet.Employees);
this.Close();
}
catch (System.Data.OleDb.OleDbException exc)
{
string errorMessages = "";
for (int i = 0; i < exc.Errors.Count; i++)
{
errorMessages += "Index #" + i + "\n" +
"Message: " + exc.Errors[i].Message + "\n" +
"NativeError: " + exc.Errors[i].NativeError + "\n" +
"Source: " + exc.Errors[i].Source + "\n" +
"SQLState: " + exc.Errors[i].SQLState + "\n";
}
MetroMessageBox.Show(this, "Error while inserting the new agent:\n" + errorMessages, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else if (clsGlobal.mode == "edit")
{
try
{
string img = System.IO.Path.GetFileName(imgpath);
this.employeesTableAdapter.Update(txtName.Text, txtPhone.Text, txtEmail.Text, cmbGender.Text, txtAddress.Text, img, txtPassword.Text, cmbPosition.Text, txtComment.Text, refnumber);
RemaxDatabaseDataSet data = new RemaxDatabaseDataSet();
RemaxDatabaseDataSetTableAdapters.EmployeesTableAdapter empadapt = new RemaxDatabaseDataSetTableAdapters.EmployeesTableAdapter();
empadapt.Fill(data.Employees);
int id = -1;
foreach (DataRow ab in data.Employees)
{
if (ab["Phone"].ToString() == txtPhone.Text)
{
id = Convert.ToInt32(ab["refEmployee"].ToString());
}
}
if (listSkills.Items.Count > 0)
{
foreach (DataRow ab in remaxDatabaseDataSet.EmployeeSkills.Rows)
{
if (ab.Field <Int32>("refEmployee") == id)
{
this.employeeSkillsTableAdapter.Delete(ab.Field <Int32>("refEmployee"), ab.Field <Int32>("refSkill"));
}
}
employeeSkillsTableAdapter.Fill(remaxDatabaseDataSet.EmployeeSkills);
foreach (ListViewItem itn in listSkills.Items)
{
this.employeeSkillsTableAdapter.Insert(id, Convert.ToInt32(itn.SubItems[0].Text));
}
}
frm1.employeesTableAdapter.Fill(frm1.remaxDatabaseDataSet.Employees);
this.Close();
}
catch (System.Data.OleDb.OleDbException exc)
{
string errorMessages = "";
for (int i = 0; i < exc.Errors.Count; i++)
{
errorMessages += "Index #" + i + "\n" +
"Message: " + exc.Errors[i].Message + "\n" +
"NativeError: " + exc.Errors[i].NativeError + "\n" +
"Source: " + exc.Errors[i].Source + "\n" +
"SQLState: " + exc.Errors[i].SQLState + "\n";
}
MetroMessageBox.Show(this, "Error while inserting the new agent:\n" + errorMessages, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
MetroMessageBox.Show(this, "Check the phone formating! ", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnCreate_Click(object sender, EventArgs e)
{
if (clsGlobal.mode == "add")
{
try
{
int id = 0;
this.housesTableAdapter.Insert(Convert.ToInt32(cmbEmployee.SelectedValue.ToString()),
Convert.ToInt32(cmbListing.SelectedValue.ToString()),
Convert.ToInt32(cmbType.SelectedValue.ToString()),
Convert.ToInt32(cmbClient.SelectedValue.ToString()),
cmbBathroom.Text,
cmbTotalRoom.Text,
txtLivingArea.Text,
cmbParkingSpot.Text,
cmbDate.Text,
txtAddress.Text,
cmbBedroom.Text,
txtComment.Text,
txtPrice.Text);
if (listPic.Items.Count > 0)
{
foreach (ListViewItem itn in listPic.Items)
{
this.picturesTableAdapter.Insert(itn.SubItems[0].Text, itn.SubItems[1].Text);
}
}
RemaxDatabaseDataSet dvx = new RemaxDatabaseDataSet();
RemaxDatabaseDataSetTableAdapters.HousesTableAdapter emp = new RemaxDatabaseDataSetTableAdapters.HousesTableAdapter();
emp.Fill(dvx.Houses);
int xd = -1;
foreach (DataRow ab in dvx.Houses)
{
if (ab["Address"].ToString() == txtAddress.Text)
{
xd = Convert.ToInt32(ab["refHouse"].ToString());
}
}
RemaxDatabaseDataSet data = new RemaxDatabaseDataSet();
RemaxDatabaseDataSetTableAdapters.PicturesTableAdapter empadapt = new RemaxDatabaseDataSetTableAdapters.PicturesTableAdapter();
empadapt.Fill(data.Pictures);
foreach (DataRow ab in data.Pictures)
{
foreach (ListViewItem itn in listPic.Items)
{
if (itn.SubItems[0].Text == ab["PicturePath"].ToString() &&
itn.SubItems[1].Text == ab["PictureComment"].ToString())
{
id = Convert.ToInt32(ab["refPicture"].ToString());
this.housesPicturesTableAdapter.Insert(xd, id);
}
}
}
if (listSkills.Items.Count > 0)
{
foreach (ListViewItem itn in listSkills.Items)
{
this.housesFeaturesTableAdapter.Insert(xd, Convert.ToInt32(itn.SubItems[0].Text));
}
}
frm1.housesTableAdapter1.Fill(frm1.remaxDatabaseDataSet1.Houses);
frm1.select();
this.Close();
}
catch (System.Data.OleDb.OleDbException exc)
{
string errorMessages = "";
for (int i = 0; i < exc.Errors.Count; i++)
{
errorMessages += "Index #" + i + "\n" +
"Message: " + exc.Errors[i].Message + "\n" +
"NativeError: " + exc.Errors[i].NativeError + "\n" +
"Source: " + exc.Errors[i].Source + "\n" +
"SQLState: " + exc.Errors[i].SQLState + "\n";
}
MetroMessageBox.Show(this, "Error while inserting the new agent:\n" + errorMessages, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else if (clsGlobal.mode == "edit")
{
try
{
int id = 0;
this.housesTableAdapter.Update(Convert.ToInt32(cmbEmployee.SelectedValue.ToString()),
Convert.ToInt32(cmbListing.SelectedValue.ToString()),
Convert.ToInt32(cmbType.SelectedValue.ToString()),
Convert.ToInt32(cmbClient.SelectedValue.ToString()),
cmbBathroom.Text,
cmbTotalRoom.Text,
txtLivingArea.Text,
cmbParkingSpot.Text,
cmbDate.Text,
txtAddress.Text,
cmbBedroom.Text,
txtComment.Text,
txtPrice.Text,
refHouse,
refEmployee,
refListing,
refType,
refClient);
foreach (DataRow ab in remaxDatabaseDataSet.HousesPictures.Rows)
{
if (ab.Field <Int32>("refHouse") == refHouse)
{
this.housesPicturesTableAdapter.Delete(refHouse, ab.Field <Int32>("refPicture"));
this.picturesTableAdapter.Delete(ab.Field <Int32>("refPicture"));
}
}
if (listPic.Items.Count > 0)
{
foreach (ListViewItem itn in listPic.Items)
{
this.picturesTableAdapter.Insert(itn.SubItems[0].Text, itn.SubItems[1].Text);
}
}
picturesTableAdapter.Fill(remaxDatabaseDataSet.Pictures);
RemaxDatabaseDataSet data = new RemaxDatabaseDataSet();
RemaxDatabaseDataSetTableAdapters.PicturesTableAdapter empadapt = new RemaxDatabaseDataSetTableAdapters.PicturesTableAdapter();
empadapt.Fill(data.Pictures);
foreach (DataRow ab in data.Pictures)
{
foreach (ListViewItem itn in listPic.Items)
{
if (itn.SubItems[0].Text == ab["PicturePath"].ToString() &&
itn.SubItems[1].Text == ab["PictureComment"].ToString())
{
id = Convert.ToInt32(ab["refPicture"].ToString());
this.housesPicturesTableAdapter.Insert(refHouse, id);
}
}
}
housesPicturesTableAdapter.Fill(remaxDatabaseDataSet.HousesPictures);
frm1.housesTableAdapter1.Fill(frm1.remaxDatabaseDataSet1.Houses);
if (listSkills.Items.Count > 0)
{
foreach (DataRow ab in remaxDatabaseDataSet.HousesFeatures.Rows)
{
if (ab.Field <Int32>("refHouse") == refHouse)
{
this.housesFeaturesTableAdapter.Delete(refHouse, ab.Field <Int32>("refFeature"));
}
}
housesFeaturesTableAdapter.Fill(remaxDatabaseDataSet.HousesFeatures);
foreach (ListViewItem itn in listSkills.Items)
{
this.housesFeaturesTableAdapter.Insert(refHouse, Convert.ToInt32(itn.SubItems[0].Text));
}
}
housesPicturesTableAdapter.Fill(remaxDatabaseDataSet.HousesPictures);
frm1.housesTableAdapter1.Fill(frm1.remaxDatabaseDataSet1.Houses);
frm1.select();
this.Close();
}
catch (System.Data.OleDb.OleDbException exc)
{
string errorMessages = "";
for (int i = 0; i < exc.Errors.Count; i++)
{
errorMessages += "Index #" + i + "\n" +
"Message: " + exc.Errors[i].Message + "\n" +
"NativeError: " + exc.Errors[i].NativeError + "\n" +
"Source: " + exc.Errors[i].Source + "\n" +
"SQLState: " + exc.Errors[i].SQLState + "\n";
}
MetroMessageBox.Show(this, "Error while inserting the new agent:\n" + errorMessages, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
