private List <CashAdvanceModel> getAllCashAdvanceByDate()
{
lstCashAdvance = new List <CashAdvanceModel>();
CashAdvanceModel cashAdvanceModel = new CashAdvanceModel();
queryString = "SELECT ID, therapistID, cash FROM dbspa.tblcashadvance WHERE " +
"(Date BETWEEN ? AND ?) AND isDeleted = 0";
parameters = new List <string>();
DateTime date = DateTime.Parse(datePickerFrom.Text);
parameters.Add(date.Year + "/" + date.Month + "/" + date.Day);
date = DateTime.Parse(datePickerTo.Text);
parameters.Add(date.Year + "/" + date.Month + "/" + date.Day);
MySqlDataReader reader = conDB.getSelectConnection(queryString, parameters);
while (reader.Read())
{
cashAdvanceModel.ID = reader["ID"].ToString();
cashAdvanceModel.TherapistID = reader["therapistID"].ToString();
cashAdvanceModel.Cash = reader["cash"].ToString();
lstCashAdvance.Add(cashAdvanceModel);
cashAdvanceModel = new CashAdvanceModel();
}
conDB.closeConnection();
return(lstCashAdvance);
}
private void btnDelete_Click(object sender, RoutedEventArgs e)
{
DialogResult dialogResult = System.Windows.Forms.MessageBox.Show("Are you sure you want to Delete record?", "Delete Record", MessageBoxButtons.YesNo);
if (dialogResult == System.Windows.Forms.DialogResult.Yes)
{
CashAdvanceModel t = dgvCashAdvance.SelectedItem as CashAdvanceModel;
if (t != null)
{
deleteCashAdvanceRecord(t.ID);
dgvCashAdvance.ItemsSource = loadDataGridDetails();
System.Windows.MessageBox.Show("RECORD DELETED SUCCESSFULLY!");
conDB.writeLogFile("DELETED CASH ADVANCE RECORD: ID: " + t.ID);
}
}
}
public ActionResult getCashAdvanceData(CashAdvanceModel data)
{
var context = new RRRoadwaysDBContext();
int vehicleNumber = Convert.ToInt32(data.VehicleNumber);
int pickpupPointId = Convert.ToInt32(data.PickupPointId);
List <CashAdvanceReport> griddata = new List <CashAdvanceReport>();
var cashAdnacceList = context.Advance
.Join(context.AdvanceDetails, a => a.Id, ad => ad.AdvanceId, (a, ad) => new { a, ad })
.Join(context.Vehicle, a => a.a.VehicleId, v => v.Id, (a, v) => new { a, v })
.Join(context.Station, d => d.a.ad.StationId, s => s.Id, (d, s) => new
{
Date = d.a.ad.AdvanceDate,
Vechicle = d.a.a.VehicleId,
VechicleNumber = d.v.VehicleNumber,
PickupPointId = d.a.ad.StationId,
PickupPointName = s.Name,
Description = d.a.ad.Description,
Amount = d.a.ad.Amount
}).Where(c => c.Date.Value.Date >= data.StartDate.Date)
.Where(c => c.Date.Value.Date <= data.EndDate.Date)
.Where(c => data.PickupPointId != "-1" ? c.PickupPointId == pickpupPointId : 1 == 1)
.Where(c => data.VehicleNumber != "-1" ? c.Vechicle == vehicleNumber : 1 == 1).ToList();
if (cashAdnacceList.Count > 0)
{
foreach (var item in cashAdnacceList)
{
CashAdvanceReport obj = new CashAdvanceReport()
{
SerialNo = griddata.Count + 1,
Date = item.Date.Value.Date,
VehicleNumber = item.VechicleNumber,
PickupPoint = item.PickupPointName,
Description = item.Description,
Amount = item.Amount,
};
griddata.Add(obj);
}
}
return(Json(new { data = griddata }, new Newtonsoft.Json.JsonSerializerSettings()));
}
public void SubmitReport(CashAdvanceModel model)
{
List <CashAdvanceModel> result = new List <CashAdvanceModel>();
DataTable getDataReport = new DataTable();
using (var rd = new ReportDocument())
{
rd.Load(Path.Combine(HttpContext.Current.Server.MapPath($"~/Reports/{REPORT_NAME}"), $"{REPORT_NAME}Report.rpt"));
//Parameter
result.Add(model);
//Convert Data To Report
getDataReport = ReportService.ConvertListToDatatable(result);
getDataReport.TableName = REPORT_NAME;
rd.SetDataSource(getDataReport);
//Encoding FileName
ReportService.ExportPdf(rd, REPORT_NAME);
}
GC.Collect();
}
private List <CashAdvanceModel> loadDataGridDetails()
{
List <CashAdvanceModel> lstCashAdvance = new List <CashAdvanceModel>();
CashAdvanceModel cashAdvance = new CashAdvanceModel();
queryString = "SELECT dbspa.tblcashadvance.ID, Date, therapistID, dbspa.tbltherapist.description, cash FROM " +
"(dbspa.tblcashadvance INNER JOIN dbspa.tbltherapist ON dbspa.tblcashadvance.therapistID = dbspa.tbltherapist.ID) " +
"WHERE dbspa.tblcashadvance.isDeleted = 0 ORDER BY dbspa.tblcashadvance.ID DESC";
MySqlDataReader reader = conDB.getSelectConnection(queryString, null);
while (reader.Read())
{
cashAdvance.ID = reader["ID"].ToString();
DateTime dte = DateTime.Parse(reader["Date"].ToString());
cashAdvance.Date = dte.ToShortDateString();
cashAdvance.Therapist = reader["description"].ToString();
cashAdvance.TherapistID = reader["therapistID"].ToString();
cashAdvance.Cash = reader["cash"].ToString();
lstCashAdvance.Add(cashAdvance);
cashAdvance = new CashAdvanceModel();
}
return(lstCashAdvance);
}
public void SubmitReport(CashAdvanceModel model)
{
_cashAdvance.SubmitReport(model);
}
