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); }