private void button3_Click(object sender, EventArgs e)
{
var dtType = cmbDateType.SelectedItem as DateType;
string prvsYeardate = dtPicker.Value.AddYears(-1).ToString("yyyy-MM-dd");
DataTable dt = new DataTable();
string filterString = GetFilterstring().Replace(" OR (ServiceNameId=1 AND ServiceTypeId=1 AND Donordate <= '#" + prvsYeardate + "#')", "") + " AND Mobile is null";
if (cmbDateType.Enabled == true && dtType.Id != 3)
{
filterString = filterString + " OR (" + GetFilterForMonthlyAnnadanam() + " AND Mobile is null)";
}
var DonorList = oDonorRepository.GetAllasDataTable().Select(filterString);
if (DonorList.Count() != 0)
{
DataView view = new DataView(DonorList.CopyToDataTable());
dt = view.ToTable(false, "Address", "Surname", "NameOn", "DistrictName", "City", "Pin", "State", "Country", "ServiceTypeId", "MR_NO");
dt.Columns.Add("ServiceType");
foreach (DataRow dr in dt.Rows)
{
dr["ServiceType"] = lstServiceType[Convert.ToInt32(dr["ServiceTypeId"])].Name;
}
DonorReportDataSet drs = new DonorReportDataSet();
drs.Tables.Add(dt);
AddressForm oAddressForm = new AddressForm(dt);
oAddressForm.Show();
}
else
{
MessageBox.Show("Donors were not found for the selected filters");
}
}
private void button3_Click(object sender, EventArgs e)
{
var dtType = cmbDateType.SelectedItem as DateType;
string prvsYeardate = dtPicker.Value.AddYears(-1).ToString("yyyy-MM-dd");
DataTable dt = new DataTable();
string filterString = GetFilterstring().Replace(" OR (ServiceNameId=1 AND ServiceTypeId=1 AND Donordate <= '#" + prvsYeardate + "#')", "") + " AND Mobile is null";
var DonorList = oDonorRepository.GetAllasDataTable().Select(filterString);
if (DonorList.Count() != 0)
{
DataView view = new DataView(DonorList.CopyToDataTable());
dt = view.ToTable(false, "DoorNo", "Mandal", "Surname", "NameOn", "DistrictName", "City", "Pin", "State", "Country", "ServiceTypeId", "MR_NO");
dt.Columns.Add("ServiceType");
foreach (DataRow dr in dt.Rows)
{
dr["ServiceType"] = lstServiceType[Convert.ToInt32(dr["ServiceTypeId"])].Name;
}
DonorReportDataSet drs = new DonorReportDataSet();
drs.Tables.Add(dt);
AddressForm oAddressForm = new AddressForm(dt);
oAddressForm.Show();
}
else
MessageBox.Show("Donors were not found for the selected filters");
}
private void button1_Click(object sender, EventArgs e)
{
bool checkvalidate = validation();
if (checkvalidate == false && chkNonPerformSvc.Checked == false)
return;
var dtType = cmbDateType.SelectedItem as DateType;
DataTable dt = new DataTable();
var ServiceName = cmbServiceName.SelectedItem as ServiceName;
var ServiceTypes = cmbServiceType.SelectedItem as ServiceTypes;
//if (rdbServiceWseDonors.Checked && dtType.Id > 2 && ServiceTypes.Id == 2)
//{
// MessageBox.Show("Kindly pick English day or Telugu thidhi for Monthly Annadanam...");
// return;
//}
// performDate = string.Format(performDate, "yyyy-mm-dd");
string filterstring = string.Empty;
// if (rdbServiceWseDonors.Checked)
filterstring = GetFilterstring();
//else
//{
// if (dtType.Id == 3)
// filterstring = GetFilterstring();
//else
// filterstring = GetFilterstring() + " OR (" + GetFilterForMonthlyAnnadanam() + ")";
//}
var DonorList = oDonorRepository.GetAllasDataTable().Select(filterstring);
if (DonorList.Count() != 0)
{
//string performDate = DonorList[0]["PerformDate"].ToString();
DataView view = new DataView(DonorList.CopyToDataTable());
dt = view.ToTable(false, "Id", "NameOn", "Gothram", "MR_No");
DonorReportDataSet drs = new DonorReportDataSet();
drs.Tables.Add(dt);
DataTable DonorVals = new DataTable();
DonorVals.Columns.Add("ServiceType");
DonorVals.Columns.Add("ServiceName");
DonorVals.Columns.Add("PerformDate");
DataRow dr = DonorVals.NewRow();
if (rdbAlldonors.Checked)
{
dr["ServiceType"] = "All Donors";
dr["ServiceName"] = "All Donors";
}
else
{
dr["ServiceType"] = ServiceTypes.Name;
dr["ServiceName"] = (ServiceName == null) ? "" : ServiceName.Name;
}
if (!chkNonPerformSvc.Checked)
dr["PerformDate"] = performDate;
else
{
dr["ServiceType"] = "";
dr["ServiceName"] = "";
}
DonorVals.Rows.Add(dr);
DonorReportForm donorreportForm = new DonorReportForm(dt, DonorVals);
donorreportForm.Show();
}
else
MessageBox.Show("Donors were not found for the selected filters");
//report
// }
}
private void button1_Click(object sender, EventArgs e)
{
bool checkvalidate = validation();
if (checkvalidate == false && chkNonPerformSvc.Checked == false)
{
return;
}
var dtType = cmbDateType.SelectedItem as DateType;
DataTable dt = new DataTable();
var ServiceName = cmbServiceName.SelectedItem as ServiceName;
var ServiceTypes = cmbServiceType.SelectedItem as ServiceTypes;
if (rdbServiceWseDonors.Checked && dtType.Id > 2 && ServiceTypes.Id == 2)
{
MessageBox.Show("Kindly pick English day or Telugu thidhi for Monthly Annadanam...");
return;
}
// performDate = string.Format(performDate, "yyyy-mm-dd");
string filterstring = string.Empty;
if (rdbServiceWseDonors.Checked)
{
filterstring = GetFilterstring();
}
else
{
if (dtType.Id == 3)
{
filterstring = GetFilterstring();
}
else
{
filterstring = GetFilterstring() + " OR (" + GetFilterForMonthlyAnnadanam() + ")";
}
}
var DonorList = oDonorRepository.GetAllasDataTable().Select(filterstring);
if (DonorList.Count() != 0)
{
//string performDate = DonorList[0]["PerformDate"].ToString();
DataView view = new DataView(DonorList.CopyToDataTable());
dt = view.ToTable(false, "Id", "NameOn", "Gothram", "MR_No");
DonorReportDataSet drs = new DonorReportDataSet();
drs.Tables.Add(dt);
DataTable DonorVals = new DataTable();
DonorVals.Columns.Add("ServiceType");
DonorVals.Columns.Add("ServiceName");
DonorVals.Columns.Add("PerformDate");
DataRow dr = DonorVals.NewRow();
if (rdbAlldonors.Checked)
{
dr["ServiceType"] = "All Donors";
dr["ServiceName"] = "All Donors";
}
else
{
dr["ServiceType"] = ServiceTypes.Name;
dr["ServiceName"] = (ServiceName == null) ? "" : ServiceName.Name;
}
if (!chkNonPerformSvc.Checked)
{
dr["PerformDate"] = performDate;
}
else
{
dr["ServiceType"] = "";
dr["ServiceName"] = "";
}
DonorVals.Rows.Add(dr);
DonorReportForm donorreportForm = new DonorReportForm(dt, DonorVals);
donorreportForm.Show();
}
else
{
MessageBox.Show("Donors were not found for the selected filters");
}
//report
// }
}
