private String model1() // when user fill rahn_low rahn_high ejare_low ejare_high
{
String sql = "";
TextRange _text = new TextRange(comments.Document.ContentStart, comments.Document.ContentEnd);
String cmt = _text.Text;
cmt = cmt.Remove(cmt.Length - 2);
if (WndConfig.getConfig().rahn_complete&& ejare_Low.Text.Trim().Length == 0 && ejare_High.Text.Trim().Length == 0 && (rahn_Low.Text.Trim().Length != 0 || rahn_High.Text.Trim().Length != 0)) // rahn e complete
{
sql = "EXEC SearchManzelSRahnComplete N'" + address_Txt.Text + "',N'" + metraj_Low.Text + "',N'" +
metraj_High.Text + "',N'" + zirbanaa_Low.Text + "',N'" +
zirbanaa_High.Text + "',N'" + tabaghaat_Low.Text + "',N'" +
tabaghaat_High.Text + "',N'" + vahed_Low.Text + "',N'" +
vahed_High.Text + "',N'" + owner.Text + "',N'" + MyPriceTextBox.getStringFromMasked(rahn_Low.Text) + "',N'" +
MyPriceTextBox.getStringFromMasked(rahn_High.Text) + "',N'" + cmt + "'";
}
else
{
sql = "EXEC SearchManzelSSimple N'" + address_Txt.Text + "',N'" + metraj_Low.Text + "',N'" +
metraj_High.Text + "',N'" + zirbanaa_Low.Text + "',N'" +
zirbanaa_High.Text + "',N'" + tabaghaat_Low.Text + "',N'" +
tabaghaat_High.Text + "',N'" + vahed_Low.Text + "',N'" +
vahed_High.Text + "',N'" + owner.Text + "',N'" + MyPriceTextBox.getStringFromMasked(rahn_Low.Text) + "',N'" +
MyPriceTextBox.getStringFromMasked(rahn_High.Text) + "',N'" + MyPriceTextBox.getStringFromMasked(ejare_Low.Text) +
"',N'" + MyPriceTextBox.getStringFromMasked(ejare_High.Text) + "',N'" + cmt + "'";
}
return(sql);
}
public HouseF()
{
InitializeComponent();
initLabels();
DataTable dt = new DataTable("MajmooeF");
DataColumn[] dc = new DataColumn[]
{
new DataColumn("طبقه"),
new DataColumn("نوع ملک"),
new DataColumn("متراژ مفید"),
new DataColumn("خوابها"),
new DataColumn("آشپزخانه"),
new DataColumn("کفپوش")
};
dt.Columns.AddRange(dc);
gridView.DataSource = dt;
textBox1.Focus();
price = new DispatcherTimer();
price.Tick += new EventHandler(price_Tick);
price.Interval = TimeSpan.FromSeconds(1);
price.Start();
WndConfig.setConfiguration(this);
}
public SearchWithID()
{
InitializeComponent();
ID_txt.Focus();
WndConfig.setConfig4SimpleSearch(this);
}
public ApartmanMaskooniF()
{
InitializeComponent();
textBox1.Focus();
price = new DispatcherTimer();
price.Tick += new EventHandler(price_Tick);
price.Interval = TimeSpan.FromSeconds(1);
WndConfig.setConfiguration(this);
}
public HouseS(String id)
{
InitializeComponent();
textBox1.Focus();
setDataGridView(id);
price = new DispatcherTimer();
price.Tick += new EventHandler(price_Tick);
price.Interval = TimeSpan.FromSeconds(1);
WndConfig.setConfiguration(this);
}
public MaghazeF()
{
InitializeComponent();
initLabels();
textBox1.Focus();
price = new DispatcherTimer();
price.Tick += new EventHandler(price_Tick);
price.Interval = TimeSpan.FromSeconds(1);
price.Start();
WndConfig.setConfiguration(this);
}
public MaghazeF()
{
InitializeComponent();
Calendar cal = new Calendar(DateTime.Today.ToShortDateString(), Calendar.Solar_Date);
date_Lbl.Content = cal.calcOtherModeNumeric();
address_Txt.Focus();
price = new DispatcherTimer();
price.Tick += new EventHandler(price_Tick);
price.Interval = TimeSpan.FromSeconds(1);
price.Start();
WndConfig.setConfig4SimpleSearch(this);
}
public MaghazeS()
{
InitializeComponent();
PersianDate pd = new PersianDate(DateTime.Today);
date_Lbl.Content = pd.ToShortDateString();
address_Txt.Focus();
price = new DispatcherTimer();
price.Tick += new EventHandler(price_Tick);
price.Interval = TimeSpan.FromSeconds(1);
price.Start();
WndConfig.setConfig4SimpleSearch(this);
}
