public void btnSearch_Click()
{
DateTime dtFrom = DateTime.Now;
DateTime dtTo = DateTime.Now;
if (dfFrom.IsEmpty)
dtFrom = new DateTime(2000, 12, 31);
else
dtFrom = dfFrom.SelectedDate;
if (dfTo.IsEmpty)
dtTo = DateTime.Now;
else
dtTo = dfTo.SelectedDate;
if (dtFrom > dtTo)
{
X.Msg.Alert("Error", "From Date must smaller than End Date").Show();
return;
}
//SuratkeluarQuery skQ = new SuratkeluarQuery();
SuratmasukQuery smQ = new SuratmasukQuery();
smQ.SelectAll();
if (dfFrom.SelectedDate == dfTo.SelectedDate)
{
smQ.Where(smQ.Tanggal == dfFrom.SelectedDate && smQ.Judul.Like("%" + txtJudul.Text.Trim() + "%")
&& smQ.Keterangan.Like("%" + txtKeterangan.Text.Trim() + "%") && smQ.Nomor.Like("%" + txtNomorSurat.Text.Trim() +
"%") && smQ.Dari.Like("%" + txtPenerima.Text.Trim() + "%"));
}
else
{
smQ.Where(smQ.Tanggal.Between(dfFrom.SelectedDate, dfTo.SelectedDate) && smQ.Judul.Like("%" + txtJudul.Text.Trim() + "%")
&& smQ.Keterangan.Like("%" + txtKeterangan.Text.Trim() + "%") && smQ.Nomor.Like("%" + txtNomorSurat.Text.Trim() +
"%") && smQ.Dari.Like("%" + txtPenerima.Text.Trim() + "%"));
}
DataTable dt = smQ.LoadDataTable();
this.storeInbox.DataSource = dt;
this.storeInbox.DataBind();
}
public DataTable GetInbox()
{
DataTable dt = new DataTable();
SuratmasukQuery smQ = new SuratmasukQuery();
smQ.SelectAll();
dt = smQ.LoadDataTable();
return dt;
}
