private void GrdFareIncreament_CommandCellClick(object sender, EventArgs e)
{
try
{
GridCommandCellElement gridCell = (GridCommandCellElement)sender;
if (gridCell.ColumnInfo.Name == "delete")
{
int id = gridCell.RowInfo.Cells["Id"].Value.ToInt();
if (id > 0)
{
using (TaxiDataContext db = new TaxiDataContext())
{
Fare_IncrementSetting objfare = db.Fare_IncrementSettings.FirstOrDefault(c => c.Id == id);
db.Fare_IncrementSettings.DeleteOnSubmit(objfare);
db.SubmitChanges();
gridCell.RowInfo.Delete();
}
}
}
}
catch
{
}
}
private bool SaveSettings()
{
bool rtn = false;
try
{
//if (dtpFromDate.Value == null)
//{
// ENUtils.ShowMessage("Required : From Date");
// return rtn;
//}
//if (dtpTillDate.Value == null)
//{
// ENUtils.ShowMessage("Required : Till Date");
// return rtn;
//}
//if (dtpFromDate.Value.ToDate() > dtpTillDate.Value.ToDate())
//{
// ENUtils.ShowMessage("Required : From Date must be less than Till Date");
// return rtn;
//}
//string criteriaBy = ddlIncrementType.Text.Trim().ToLower();
//if (optDateTimeWise.ToggleState == ToggleState.On)
// criteriaBy += "=1";
//else if (optDateWise.ToggleState == ToggleState.On)
// criteriaBy += "=2";
//else if (optTimeWise.ToggleState == ToggleState.On)
// criteriaBy += "=3";
using (TaxiDataContext db = new TaxiDataContext())
{
List <int> Ids = grdFareIncreament.Rows.Select(callnotification => Convert.ToInt32(callnotification.Cells["Id"].Value)).ToList();
for (int i = 0; i < grdFareIncreament.Rows.Count; i++)
{
int id = grdFareIncreament.Rows[i].Cells["Id"].Value.ToInt();
Fare_IncrementSetting objFare = null;
if (id.ToInt() > 0)
{
objFare = db.Fare_IncrementSettings.FirstOrDefault(c => c.Id == id);
}
else
{
objFare = new Fare_IncrementSetting();
}
objFare.FromDate = grdFareIncreament.Rows[i].Cells["FromDateTime"].Value.ToDateTime();
objFare.TillDate = grdFareIncreament.Rows[i].Cells["TillDateTime"].Value.ToDateTime();
objFare.IncrementRate = grdFareIncreament.Rows[i].Cells["IncreamentRate"].Value.ToDecimal();
objFare.EnableIncrement = chkEnableIncrement.Checked;
objFare.IncrementType = grdFareIncreament.Rows[i].Cells["IncreamentType"].Value.ToString().ToLower();
objFare.CriteriaBy = grdFareIncreament.Rows[i].Cells["CriteriaBy"].Value.ToInt();
if (objFare.Id == 0)
{
db.Fare_IncrementSettings.InsertOnSubmit(objFare);
}
db.SubmitChanges();
}
}
return(true);
}
//db.stp_SaveFareIncrementSettings(dtpFromDate.Value, dtpTillDate.Value, criteriaBy, numIncrementRate.Value.ToDecimal(), chkEnableIncrement.Checked);
catch (Exception ex)
{
ENUtils.ShowMessage(ex.Message);
}
return(rtn);
}