private void btnDeleteHistory_Click(object sender, EventArgs e)
{
try
{
int RangeId = ddlDateRange.SelectedValue.ToInt();
if (RangeId == 0)
{
ENUtils.ShowMessage("Please select a DateRange History");
return;
}
using (TaxiDataContext db = new TaxiDataContext())
{
Fleet_DriverWeeklyRentHistory objHistory = db.GetTable <Fleet_DriverWeeklyRentHistory>().FirstOrDefault(c =>
(c.Id == RangeId));
if (objHistory != null)
{
db.Fleet_DriverWeeklyRentHistories.DeleteOnSubmit(objHistory);
db.SubmitChanges();
}
}
ComboFunctions.FillDriverWeeklyRentHistoryCombo(ddlDateRange);
//ComboFunctions.FillDriverCommissionCollectionHistoryCombo(ddlDateRange);
grdLister.Rows.Clear();
}
catch (Exception ex)
{
ENUtils.ShowMessage(ex.Message);
}
}
void grdLister_CommandCellClick(object sender, EventArgs e)
{
GridCommandCellElement gridCell = (GridCommandCellElement)sender;
if (gridCell.ColumnInfo.Name == "btnDelete")
{
GridViewRowInfo row = gridCell.RowInfo;
if (row is GridViewDataRowInfo)
{
long TranId = row.Cells["TransId"].Value.ToLong();
if (TranId > 0)
{
try
{
int Id = row.Cells["Id"].Value.ToInt();
int TransId = row.Cells["TransId"].Value.ToInt();
using (TaxiDataContext db = new TaxiDataContext())
{
if (db.GetTable <Fleet_DriverWeeklyRentHistory_Detail>().Count(c => c.TransId == TransId) == 1)
{
Fleet_DriverWeeklyRentHistory objHistory = db.GetTable <Fleet_DriverWeeklyRentHistory>().FirstOrDefault(c =>
(c.Id == TranId));
if (objHistory != null)
{
db.Fleet_DriverWeeklyRentHistories.DeleteOnSubmit(objHistory);
db.SubmitChanges();
}
}
else
{
Fleet_DriverWeeklyRentHistory_Detail objDetail = db.Fleet_DriverWeeklyRentHistory_Details.FirstOrDefault(c => c.Id == Id);
if (objDetail != null)
{
db.Fleet_DriverWeeklyRentHistory_Details.DeleteOnSubmit(objDetail);
db.SubmitChanges();
}
}
}
PopulateData();
}
catch (Exception ex)
{
ENUtils.ShowMessage(ex.Message);
}
}
}
}
}
private void DeletePaymentHistory()
{
try
{
string Error = string.Empty;
if (grdLister.Rows.Count() > 0 && grdLister.Rows.Count(c => c.Cells["Check"].Value.ToBool() == true) == 0)
{
Error = "Please select record to delete";
}
if (!string.IsNullOrEmpty(Error))
{
ENUtils.ShowMessage(Error);
return;
}
int Id = 0;
int TransId = 0;
long TranId = 0;
if (grdLister.Rows.Count(c => c.Cells["Check"].Value.ToBool() == true) > 0)
{
if (DialogResult.Yes == RadMessageBox.Show("Are you sure you want to delete this Record ?", "", MessageBoxButtons.YesNo, RadMessageIcon.Question))
{
foreach (var item in grdLister.Rows.Where(c => c.Cells["Check"].Value.ToBool() == true))
{
//long TranId = row.Cells["TranId"].Value.ToLong();
Id = item.Cells["Id"].Value.ToInt();
TransId = item.Cells["TransId"].Value.ToInt();
TranId = item.Cells["TransId"].Value.ToLong();
if (TranId > 0)
{
try
{
//int Id = row.Cells["Id"].Value.ToInt();
//int TransId = row.Cells["TranId"].Value.ToInt();
using (TaxiDataContext db = new TaxiDataContext())
{
if (db.GetTable <Fleet_DriverWeeklyRentHistory_Detail>().Count(c => c.TransId == TransId) == 1)
{
Fleet_DriverWeeklyRentHistory objHistory = db.GetTable <Fleet_DriverWeeklyRentHistory>().FirstOrDefault(c => (c.Id == TranId));
if (objHistory != null)
{
db.Fleet_DriverWeeklyRentHistories.DeleteOnSubmit(objHistory);
db.SubmitChanges();
}
}
else
{
Fleet_DriverWeeklyRentHistory_Detail objDetail = db.Fleet_DriverWeeklyRentHistory_Details.FirstOrDefault(c => c.Id == Id);
if (objDetail != null)
{
db.Fleet_DriverWeeklyRentHistory_Details.DeleteOnSubmit(objDetail);
db.SubmitChanges();
}
}
}
}
catch (Exception ex)
{
ENUtils.ShowMessage(ex.Message);
}
}
}
PopulateData();
}
}
}
catch (Exception ex)
{
ENUtils.ShowMessage(ex.Message);
}
}