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