private void btnget_Click(object sender, EventArgs e)
{
if (txtcode.Text.Length == 0)
{
return;
}
try { dt.Clear(); }
catch (Exception e1) { }
dataGridView1.Rows.Clear();
db DB = new db("");
dt = DB.getRow("SELECT * FROM tbl_data WHERE sID = " + txtcode.Text);
if (dt == null)
{
return;
}
foreach (DataRow dr in dt.Rows)
{
string price;
try
{
double db = Convert.ToDouble(dr["sPrice"].ToString());
price = db.ToString("N0") + " تومان";
}
catch (Exception e1) { price = dr["sPrice"].ToString() + " تومان"; }
try
{
dataGridView1.Rows.Add(dr["sType"].ToString(), dr["sBargain"].ToString(), dr["sOwnerName"].ToString(), dr["sMobile"].ToString(), dr["sPhone"].ToString(), dr["sDateFa"].ToString(), dr["sBuildingYear"].ToString() + " سال", dr["sFoundation"].ToString(), price);
}
catch (Exception e2) { }
}
}
private void btnfilter_Click(object sender, EventArgs e)
{
string query;
query = "SELECT * FROM tbl_data WHERE ";
if (ck1.Checked || ck2.Checked || ck3.Checked || ck4.Checked || ck5.Checked || ck6.Checked)
{
string in_where = " sType IN (";
var listOfStrings = new List <string>();
if (ck1.Checked)
{
listOfStrings.Add("'آپارتمان'");
}
if (ck2.Checked)
{
listOfStrings.Add("'کلنگی'");
}
if (ck3.Checked)
{
listOfStrings.Add("'مغازه'");
}
if (ck4.Checked)
{
listOfStrings.Add("'ویلا'");
}
if (ck5.Checked)
{
listOfStrings.Add("'پارکینگ'");
}
if (ck6.Checked)
{
listOfStrings.Add("'انباری'");
}
in_where += String.Join(",", listOfStrings.ToArray());
query += in_where + ") AND ";
}
if (ckt1.Checked || ckt2.Checked || ckt3.Checked)
{
string in_where = " sBargain IN (";
var listOfStrings2 = new List <string>();
if (ckt1.Checked)
{
listOfStrings2.Add("'فروشی'");
}
if (ckt2.Checked)
{
listOfStrings2.Add("'اجاره'");
}
if (ckt3.Checked)
{
listOfStrings2.Add("'رهن'");
}
in_where += String.Join(",", listOfStrings2.ToArray());
query += in_where + ") AND ";
}
if (txtpricefrom.Text.Length != 0 && txtpriceto.Text.Length != 0)
{
query += "sPrice BETWEEN '" + txtpricefrom.Text + "' AND '" + txtpriceto.Text + "' AND ";
}
if (txtkhab.SelectedIndex > -1)
{
query += "sKhab = '" + txtkhab.SelectedItem + "' AND ";
}
if (txtejarehfrom.Text.Length != 0 && txtejarehto.Text.Length != 0)
{
query += "sRent BETWEEN '" + txtejarehfrom.Text + "' AND '" + txtejarehto.Text + "' AND ";
}
if (txtrahnfrom.Text.Length != 0 && txtrahnto.Text.Length != 0)
{
query += "sMortgage BETWEEN '" + txtrahnfrom.Text + "' AND '" + txtrahnto.Text + "' AND ";
}
if (txtfoundationfrom.Text.Length != 0 && txtfoundationto.Text.Length != 0)
{
query += "sFoundation BETWEEN '" + txtfoundationfrom.Text + "' AND '" + txtfoundationto.Text + "' AND ";
}
if (txtnof.SelectedIndex != -1)
{
query += "sFloorPosition = '" + (txtnof.SelectedIndex + 1).ToString() + "' AND ";
}
if (txtnou.SelectedIndex != -1)
{
query += "sNumberOfUnit = '" + (txtnou.SelectedIndex + 1).ToString() + "' AND ";
}
if (txtyearbuilding.SelectedIndex != -1)
{
query += "sBuildingYear = '" + (txtyearbuilding.SelectedIndex + 1).ToString() + "' AND ";
}
if (ckasansor.Checked)
{
query += "sAsansor = 'True' AND ";
}
if (ckparking.Checked)
{
query += "sParking = 'True' AND ";
}
if (ckanbari.Checked)
{
query += "sAnbari = 'True' AND ";
}
if (ckvam.Checked)
{
query += "sVam = 'True' AND ";
}
query += " 1=1";
db DB = new db("");
dt.Clear();
dt = DB.getRow(query);
if (dt.Rows.Count == 0)
{
dataGridView1.Rows.Clear();
MessageBox.Show("هیچ موردی برای فیلتر تعین شده پیدا نشد", "توجه", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
dataGridView1.Rows.Clear();
foreach (DataRow dr in dt.Rows)
{
string price;
try
{
double db = Convert.ToDouble(dr["sPrice"].ToString());
price = db.ToString("N0") + " تومان";
}
catch (Exception e1) { price = dr["sPrice"].ToString() + " تومان"; }
dataGridView1.Rows.Add(dr["sType"].ToString(), dr["sBargain"].ToString(), dr["sOwnerName"].ToString(), dr["sMobile"].ToString(), dr["sPhone"].ToString(), dr["sDateFa"].ToString(), price);
}
dataGridView1.ClearSelection();
}
private void btninsert_Click(object sender, EventArgs e)
{
if (txtname.Text.Length == 0)
{
MessageBox.Show("لطفا نام مالک را وارد کنید", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (txtmobile.Text.Length == 0)
{
MessageBox.Show("لطفا موبایل مالک را وارد کنید", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (txtaddress.Text.Length == 0)
{
MessageBox.Show("لطفا آدرس ملک را وارد کنید", "خطا", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
string bargain;
bargain = "فروشی";
if (rbt1.Checked)
{
bargain = "فروشی";
}
else if (rbt2.Checked)
{
bargain = "اجاره";
}
else if (rbt3.Checked)
{
bargain = "رهن";
}
string stype;
if (rb1.Checked)
{
stype = "آپارتمان";
}
else if (rb2.Checked)
{
stype = "کلنگی";
}
else if (rb3.Checked)
{
stype = "مغازه";
}
else if (rb4.Checked)
{
stype = "ویلا";
}
else if (rb5.Checked)
{
stype = "پارکینگ";
}
else if (rb6.Checked)
{
stype = "انباری";
}
else
{
stype = "آپارتمان";
}
string date = DateTime.Today.Year + "-" + DateTime.Today.Month + "-" + DateTime.Today.Day;
string query;
query = String.Format("UPDATE tbl_data SET sType = '{0}',sOwnerName = '{1}',sMobile = '{2}',sPhone = '{3}',sAddress = '{4}',sNumberOfFloor = '{5}',sNumberOfUnit = '{6}',sBuildingYear = '{7}',sPrice = '{8}',sFloorPosition = '{9}',sArea = '{10}',sFoundation = '{11}',sKhab = '{12}',sKooler = '{13}',sGaz = '{14}',sTelephone = '{15}',sParking = '{16}',sAnbari = '{17}',sAsansor = '{18}',sTeras = '{19}',sNema = '{20}',sKaf = '{21}',sAshpazkhooneh = '{22}',sVam = '{23}',sDesc = '{24}',sBargain = '{25}',sRent = '{26}',sMortgage = '{27}' WHERE sID = '" + dr["sID"].ToString() + "'", stype, txtname.Text, txtmobile.Text, txtphone.Text, txtaddress.Text, txtnof.SelectedIndex + 1, txtnou.SelectedIndex + 1, txtyearbuilding.SelectedIndex + 1, txtprice.Text.Replace(",", ""), txtfloorposition.SelectedIndex + 1, txtarea.Text, txtfoundation.Text, txtkhab.SelectedIndex + 1, ckkooler.Checked, ckgaz.Checked, ckphone.Checked, ckparking.Checked, ckanbari.Checked, ckasansor.Checked, ckteras.Checked, txtnama.Text, txtkaf.Text, txtashpazkhooneh.Text, ckvam.Checked, txtdesc.Text, bargain, txtejareh.Text.Replace(",", ""), txtvadieh.Text.Replace(",", ""));
db DB = new db("");
DB.RunQuery(query);
MessageBox.Show("اطلاعات با موفقیت بروز شد", "توجه", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
