private void SaveChanges() { try { string addressQuery = string.Empty; string locationQuery = string.Empty; foreach (var item in grdAddresses.Rows.Where(c => c.Cells["Zone"].Value != null && c.Cells["Zone"].Value.ToInt() != c.Cells["OldZoneId"].Value.ToInt())) { addressQuery += "UPDATE GEN_ADDRESSES SET ZONEID=" + item.Cells["Zone"].Value.ToInt() + " where addressline1='" + item.Cells["FullAddress"].Value.ToStr() + "';" + Environment.NewLine; AppVars.listOfAddress.FirstOrDefault(c => c.AddressLine1 == item.Cells["FullAddress"].Value.ToStr() ).DefaultIfEmpty().ZoneId = item.Cells["Zone"].Value.ToInt(); } foreach (var item in grdLocations.Rows.Where(c => c.Cells["Zone"].Value != null && c.Cells["Zone"].Value.ToInt() != c.Cells["OldZoneId"].Value.ToInt())) { locationQuery += "UPDATE GEN_LOCATIONS SET ZONEID=" + item.Cells["Zone"].Value.ToInt() + " where LOCATIONNAME='" + item.Cells["Street"].Value.ToStr() + "' AND POSTCODE='" + item.Cells["PostCode"].Value.ToStr() + "';" + Environment.NewLine; } using (TaxiDataContext db = new TaxiDataContext()) { if (addressQuery.ToStr().Trim() != string.Empty) { db.stp_RunProcedure(addressQuery); } if (locationQuery.ToStr().Trim() != string.Empty) { db.stp_RunProcedure(locationQuery); } } if (addressQuery.ToStr().Length > 0 || locationQuery.ToStr().Length > 0) { RefreshRecords(); } } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }
private void SaveAndClose() { try { input_values = string.Join(",", grdAttributesList.Rows.Cast <DataGridViewRow>().Where(r => r.Cells[Col_BookingAttributesList.Default].Value.ToBool() == true).Select(c => c.Cells[Col_BookingAttributesList.ShortName].Value.ToStr()).ToArray <string>()); input_Ids = string.Join(",", grdAttributesList.Rows.Cast <DataGridViewRow>().Where(r => r.Cells[Col_BookingAttributesList.Default].Value.ToBool() == true).Select(c => c.Cells[Col_BookingAttributesList.Id].Value.ToStr()).ToArray <string>()); using (TaxiDataContext db = new TaxiDataContext()) { Customer objCust = db.Customers.FirstOrDefault(c => c.Id == this.CustomerId); if (objCust != null) { objCust.ExcludedDriverIds = input_Ids; db.SubmitChanges(); if (objCust.MobileNo.ToStr().Trim().Length > 0 && objCust.TelephoneNo.ToStr().Trim().Length == 0) { db.stp_RunProcedure("update booking set excludeddriverids='" + input_Ids + "' where customermobileno='" + objCust.MobileNo.ToStr().Trim() + "' and bookingstatusid=1"); } else if (objCust.MobileNo.ToStr().Trim().Length == 0 && objCust.TelephoneNo.ToStr().Trim().Length > 0) { db.stp_RunProcedure("update booking set excludeddriverids='" + input_Ids + "' where CustomerPhoneNo='" + objCust.TelephoneNo.ToStr().Trim() + "' and bookingstatusid=1"); } else if (objCust.MobileNo.ToStr().Trim().Length > 0 && objCust.TelephoneNo.ToStr().Trim().Length > 0) { db.stp_RunProcedure("update booking set excludeddriverids='" + input_Ids + "' where CustomerPhoneNo='" + objCust.TelephoneNo.ToStr().Trim() + "' and customermobileno='" + objCust.MobileNo.ToStr().Trim() + "' and bookingstatusid=1"); } } } this.Close(); } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }
void grdLister_CommandCellClick(object sender, EventArgs e) { try { GridCommandCellElement gridCell = (GridCommandCellElement)sender; if (gridCell.ColumnInfo.Name == "btnDelete") { GridViewRowInfo row = grdLister.CurrentRow; string AddressName = row.Cells[COLS.Address].Value.ToStr(); string AddressLine1 = row.Cells[COLS.AddressLine1].Value.ToStr(); long Id = row.Cells[COLS.Id].Value.ToLong(); var query = General.GetObject <Gen_RecentAddress>(c => (c.Id == Id) && (c.AddressLine1.Contains(AddressName))); if (query != null) { string[] result = query.AddressLine1.Split(new string[] { "</add>" }, StringSplitOptions.RemoveEmptyEntries); if (result.Count() > 1) { AddressLine1 = AddressLine1.Replace(AddressName, ""); AddressLine1 = AddressLine1.Replace("<add></add>", ""); using (TaxiDataContext db = new TaxiDataContext()) { if (!string.IsNullOrEmpty(AddressLine1)) { db.stp_RunProcedure("update Gen_RecentAddresses set AddressLine1='" + AddressLine1 + "' where Id=" + Id + ""); } else { db.stp_RunProcedure("delete from Gen_RecentAddresses where Id=" + Id + ""); } } } else { using (TaxiDataContext db = new TaxiDataContext()) { db.stp_RunProcedure("delete from Gen_RecentAddresses where Id=" + Id + ""); } } row.Delete(); // LoadRecentAddress(); //query.AddressLine1.Contains("").cou } } } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }
private void btnClearAddresses_Click(object sender, EventArgs e) { if (DialogResult.Yes == MessageBox.Show("are you sure you want to clear all recent addresses ?", "", MessageBoxButtons.YesNo)) { try { using (TaxiDataContext db = new TaxiDataContext()) { db.stp_RunProcedure("delete from Gen_RecentAddresses"); } LoadRecentAddress(); } catch { } } }
private void DeleteAddress() { try { string Error = string.Empty; int LocationTypeId = ddlLocationTypes2.SelectedValue.ToInt(); if (grdLocations.Rows.Where(c => c.Cells[COLSD.Delete].Value.ToBool() == true).Count() == 0)//|| grdDeleteLocations.Rows.Where(c => c.Cells[COLSD.Delete].Value.ToBool() == true).Count() == 0) { Error = "Please select address to delete"; } if (LocationTypeId == 0) { if (String.IsNullOrEmpty(Error)) { Error = "Required : Location Types"; } else { Error += Environment.NewLine + "Required : Location Types"; } } if (!string.IsNullOrEmpty(Error)) { ENUtils.ShowMessage(Error); return; } //var DeleteAddressList=grdLocations.Rows.Where(c=>c.Cells[COLSD.Delete].Value.ToBool()==true).Select(c) string DeleteIds = string.Join(",", (grdLocations.Rows.Where(c => (c.Cells[COLSD.Delete].Value.ToBool() == true) ) .Select(c => c.Cells[COLSD.Id].Value.ToString()).ToArray <string>())); string DeleteAddress = "delete from Gen_Locations where Id in(" + DeleteIds + ")"; using (TaxiDataContext db = new TaxiDataContext()) { db.stp_RunProcedure(DeleteAddress); } DisplayDeleteLocation(LocationTypeId); } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }
private void btnUpdate_Click(object sender, EventArgs e) { if (txtDetails.Text.Trim().Length == 0) { MessageBox.Show("Required : Information"); } else { try { using (TaxiDataContext db = new TaxiDataContext()) { db.stp_RunProcedure("update gen_company set CompanyInformation='" + txtDetails.Text.Trim() + "' where id=" + this._UniqueId); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } }
private void radButton1_Click_1(object sender, EventArgs e) { try { StringBuilder st = new StringBuilder(); if (grdFares.Rows.Where(c => c.Cells[COLS.CheckBox].Value.ToBool()).Count() == 0) { return; } if (DialogResult.Yes == RadMessageBox.Show("Are you sure you want to delete Selected Booking(s) ? ", "", MessageBoxButtons.YesNo, RadMessageIcon.Question)) { foreach (GridViewRowInfo row in grdFares.Rows.Where(c => c.Cells[COLS.CheckBox].Value.ToBool())) { st.Append("delete from Fare_CustomJourneys where Id =" + row.Cells[COLS.Id].Value.ToInt() + " "); } using (TaxiDataContext db = new TaxiDataContext()) { db.stp_RunProcedure(st.ToStr()); } SetDisplayRecords(); } } catch (Exception ex) { if (objeCustomBO.Errors.Count > 0) { ENUtils.ShowMessage(objeCustomBO.ShowErrors()); } else { ENUtils.ShowMessage(ex.Message); } } }
public override void Save() { try { int LocationTypeId = ddlLocations.SelectedValue.ToInt(); string ExcludeIds = string.Join(",", (grdPostCodes.Rows.Where(c => (c.Cells[COLS.Exclude].Value.ToBool() == true && (c.Cells[COLS.Id].Value.ToInt() > 0)) ) .Select(c => c.Cells[COLS.Id].Value.ToString()).ToArray <string>())); var Selectlist = (from a in grdPostCodes.Rows.Where(c => (c.Cells[COLS.Select].Value.ToBool() == true) && (c.Cells[COLS.Id].Value.ToInt() == 0)) select new { AddressName = a.Cells[COLS.AddressName].Value }).ToList(); string ExcludeList = string.Empty; //"delete from Gen_Locations where Id in("+ExcludeIds+");"; if (!string.IsNullOrEmpty(ExcludeIds)) { ExcludeList = "delete from Gen_Locations where Id in(" + ExcludeIds + ");"; } StringBuilder sb = new StringBuilder(); string PostCode = string.Empty; string ShortKey = string.Empty; string LocationName = string.Empty; sb.Append(ExcludeList); foreach (var item in Selectlist) { PostCode = General.GetPostCodeMatch(item.AddressName.ToStr()).Trim(); LocationName = item.AddressName.ToStr(); if (PostCode.Length > 0) { LocationName = LocationName.Replace(PostCode, "").ToStr().Trim(); } if (LocationName.Contains("'")) { LocationName = LocationName.Replace("'", "").Trim(); } ShortKey = objLocationType.Where(c => c.Id == LocationTypeId).FirstOrDefault().ShortCutKey.ToStr().ToLower(); ShortKey += " " + LocationName[0].ToStr().ToLower(); sb.Append("insert into Gen_Locations (LocationName,LocationTypeId,Address,PostCode,ShortCutKey) values('" + LocationName + "'," + LocationTypeId + ",'" + item.AddressName.ToStr().Replace("'", "").Trim() + "','" + PostCode + "','" + ShortKey + "');"); } using (TaxiDataContext db = new TaxiDataContext()) { db.stp_RunProcedure(sb.ToStr()); } } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }
private void UpdatePaymentCollection() { try { string Error = string.Empty; if (grdLister.Rows.Count() > 0 && grdLister.Rows.Count(c => c.Cells["IsPaid"].Value.ToBool() == true) == 0) { Error = "Please select record to update"; } if (!string.IsNullOrEmpty(Error)) { ENUtils.ShowMessage(Error); return; } if (grdLister.Rows.Count(c => c.Cells["IsPaid"].Value.ToBool() == true) > 0) { foreach (var item in grdLister.Rows.Where(c => c.Cells["IsPaid"].Value.ToBool() == true)) { long TranId = item.Cells["TransId"].Value.ToLong(); if (TranId > 0) { try { int IsPaid = item.Cells["IsPaid"].Value.ToBool() == true ? 1 : 0; // decimal adjustments = row.Cells[COLS.Adjustment].Value.ToDecimal(); string query = "update fleet_drivercommision set IsWeeklyPaid=" + IsPaid + " where Id=" + TranId; using (TaxiDataContext db = new TaxiDataContext()) { db.stp_RunProcedure(query); } UpdateDriverCommission(item.Cells["TotalRentCommission"].Value.ToDecimal()); //PopulateData(); DateTime?dtFrom = item.Cells["FromDate"].Value.ToDateorNull(); DateTime?dtTill = item.Cells["ToDate"].Value.ToDateorNull(); string DateRange = string.Format("{0:dd/MMMM/yyyy}", dtFrom) + " to " + string.Format("{0:dd/MMMM/yyyy}", dtTill); int DriverId = item.Cells["Id"].Value.ToInt(); int Id = 0; objDriverWeeklyRentHistory = new DriverWeeklyRentHistoryBO(); var MasterQuery = General.GetObject <Fleet_DriverWeeklyRentHistory>(c => (c.FromDate == dtFrom && c.TillDate == dtTill)); if (MasterQuery != null) { Id = MasterQuery.Id; objDriverWeeklyRentHistory.GetByPrimaryKey(Id); objDriverWeeklyRentHistory.Edit(); objDriverWeeklyRentHistory.Current.EditBy = AppVars.LoginObj.LuserId.ToInt(); objDriverWeeklyRentHistory.Current.EditLog = AppVars.LoginObj.UserName; objDriverWeeklyRentHistory.Current.EditOn = DateTime.Now; } else { objDriverWeeklyRentHistory.New(); objDriverWeeklyRentHistory.Current.AddBy = AppVars.LoginObj.LuserId.ToInt(); objDriverWeeklyRentHistory.Current.AddLog = AppVars.LoginObj.UserName; objDriverWeeklyRentHistory.Current.AddOn = DateTime.Now; } objDriverWeeklyRentHistory.Current.DateRange = DateRange; objDriverWeeklyRentHistory.Current.FromDate = dtFrom; objDriverWeeklyRentHistory.Current.TillDate = dtTill; objDriverWeeklyRentHistory.Current.CreatedOn = DateTime.Now; if (objDriverWeeklyRentHistory.Current.Fleet_DriverWeeklyRentHistory_Details.Count(c => c.DriverId == DriverId) == 0) { objDriverWeeklyRentHistory.Current.Fleet_DriverWeeklyRentHistory_Details.Add(new Fleet_DriverWeeklyRentHistory_Detail { TransId = objDriverWeeklyRentHistory.PrimaryKeyValue.ToInt(), AccountBookings = item.Cells["AccountBookings"].Value.ToDecimal(), Active = item.Cells["Active"].Value.ToStr(), DriverNo = item.Cells["DriverNo"].Value.ToStr(), DriverId = DriverId, RentComm = item.Cells["TotalRentCommission"].Value.ToDecimal(), IsPaid = item.Cells["IsPaid"].Value.ToBool(), OfficeToPay = item.Cells["OfficeToPay"].Value.ToDecimal(), PreviousBalance = item.Cells["PreviousBalance"].Value.ToDecimal(), DriverToPay = item.Cells["DriverToPay"].Value.ToDecimal() }); } else { Fleet_DriverWeeklyRentHistory_Detail objDriverWeeklyRentDetail = objDriverWeeklyRentDetail = objDriverWeeklyRentHistory.Current.Fleet_DriverWeeklyRentHistory_Details.FirstOrDefault(c => c.DriverId == DriverId); objDriverWeeklyRentDetail.TransId = objDriverWeeklyRentHistory.PrimaryKeyValue.ToInt(); objDriverWeeklyRentDetail.IsPaid = item.Cells["IsPaid"].Value.ToBool();; objDriverWeeklyRentDetail.AccountBookings = item.Cells["AccountBookings"].Value.ToDecimal(); objDriverWeeklyRentDetail.Active = item.Cells["Active"].Value.ToStr(); objDriverWeeklyRentDetail.DriverNo = item.Cells["DriverNo"].Value.ToStr(); objDriverWeeklyRentDetail.DriverId = DriverId; objDriverWeeklyRentDetail.RentComm = item.Cells["TotalRentCommission"].Value.ToDecimal(); objDriverWeeklyRentDetail.OfficeToPay = item.Cells["OfficeToPay"].Value.ToDecimal(); objDriverWeeklyRentDetail.PreviousBalance = item.Cells["PreviousBalance"].Value.ToDecimal(); objDriverWeeklyRentDetail.DriverToPay = item.Cells["DriverToPay"].Value.ToDecimal(); } objDriverWeeklyRentHistory.Save(); objDriverWeeklyRentHistory.Clear(); } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } } } } PopulateData(); } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }
void grdLister_CommandCellClick(object sender, EventArgs e) { GridCommandCellElement gridCell = (GridCommandCellElement)sender; if (gridCell.ColumnInfo.Name == "btnUpdate") { GridViewRowInfo row = gridCell.RowInfo; if (row is GridViewDataRowInfo) { long TranId = row.Cells["TransId"].Value.ToLong(); if (TranId > 0) { try { int IsPaid = row.Cells["IsPaid"].Value.ToBool() == true ? 1 : 0; // decimal adjustments = row.Cells[COLS.Adjustment].Value.ToDecimal(); string query = "update fleet_drivercommision set IsWeeklyPaid=" + IsPaid + " where Id=" + TranId; using (TaxiDataContext db = new TaxiDataContext()) { db.stp_RunProcedure(query); } UpdateDriverCommission(grdLister.CurrentRow.Cells["TotalRentCommission"].Value.ToDecimal()); PopulateData(); DateTime?dtFrom = grdLister.CurrentRow.Cells["FromDate"].Value.ToDateorNull(); DateTime?dtTill = grdLister.CurrentRow.Cells["ToDate"].Value.ToDateorNull(); string DateRange = string.Format("{0:dd/MMMM/yyyy}", dtFrom) + " to " + string.Format("{0:dd/MMMM/yyyy}", dtTill); int DriverId = grdLister.CurrentRow.Cells["Id"].Value.ToInt(); int Id = 0; objDriverWeeklyRentHistory = new DriverWeeklyRentHistoryBO(); var MasterQuery = General.GetObject <Fleet_DriverWeeklyRentHistory>(c => (c.FromDate == dtFrom && c.TillDate == dtTill)); if (MasterQuery != null) { Id = MasterQuery.Id; objDriverWeeklyRentHistory.GetByPrimaryKey(Id); objDriverWeeklyRentHistory.Edit(); objDriverWeeklyRentHistory.Current.EditBy = AppVars.LoginObj.LuserId.ToInt(); objDriverWeeklyRentHistory.Current.EditLog = AppVars.LoginObj.UserName; objDriverWeeklyRentHistory.Current.EditOn = DateTime.Now; } else { objDriverWeeklyRentHistory.New(); objDriverWeeklyRentHistory.Current.AddBy = AppVars.LoginObj.LuserId.ToInt(); objDriverWeeklyRentHistory.Current.AddLog = AppVars.LoginObj.UserName; objDriverWeeklyRentHistory.Current.AddOn = DateTime.Now; } objDriverWeeklyRentHistory.Current.DateRange = DateRange; objDriverWeeklyRentHistory.Current.FromDate = dtFrom; objDriverWeeklyRentHistory.Current.TillDate = dtTill; objDriverWeeklyRentHistory.Current.CreatedOn = DateTime.Now; if (objDriverWeeklyRentHistory.Current.Fleet_DriverWeeklyRentHistory_Details.Count(c => c.DriverId == DriverId) == 0) { objDriverWeeklyRentHistory.Current.Fleet_DriverWeeklyRentHistory_Details.Add(new Fleet_DriverWeeklyRentHistory_Detail { TransId = objDriverWeeklyRentHistory.PrimaryKeyValue.ToInt(), AccountBookings = grdLister.CurrentRow.Cells["AccountBookings"].Value.ToDecimal(), Active = grdLister.CurrentRow.Cells["Active"].Value.ToStr(), DriverNo = grdLister.CurrentRow.Cells["DriverNo"].Value.ToStr(), DriverId = DriverId, RentComm = grdLister.CurrentRow.Cells["TotalRentCommission"].Value.ToDecimal(), IsPaid = grdLister.CurrentRow.Cells["IsPaid"].Value.ToBool(), OfficeToPay = grdLister.CurrentRow.Cells["OfficeToPay"].Value.ToDecimal(), PreviousBalance = grdLister.CurrentRow.Cells["PreviousBalance"].Value.ToDecimal(), DriverToPay = grdLister.CurrentRow.Cells["DriverToPay"].Value.ToDecimal() }); } else { Fleet_DriverWeeklyRentHistory_Detail objDriverWeeklyRentDetail = objDriverWeeklyRentDetail = objDriverWeeklyRentHistory.Current.Fleet_DriverWeeklyRentHistory_Details.FirstOrDefault(c => c.DriverId == DriverId); //var query2 = General.GetObject<Fleet_DriverWeeklyRentHistory_Detail>(c => (c.TransId == objDriverWeeklyRentHistory.PrimaryKeyValue.ToInt() && c.DriverId == DriverId)); //if (query2 != null) //{ // int HistoryId = query2.Id; // using (TaxiDataContext db = new TaxiDataContext()) // { // Fleet_DriverWeeklyRentHistory_Detail objDriverWeeklyRentDetail = db.Fleet_DriverWeeklyRentHistory_Details.FirstOrDefault(c => c.Id == HistoryId); objDriverWeeklyRentDetail.TransId = objDriverWeeklyRentHistory.PrimaryKeyValue.ToInt(); objDriverWeeklyRentDetail.IsPaid = grdLister.CurrentRow.Cells["IsPaid"].Value.ToBool();; objDriverWeeklyRentDetail.AccountBookings = grdLister.CurrentRow.Cells["AccountBookings"].Value.ToDecimal(); objDriverWeeklyRentDetail.Active = grdLister.CurrentRow.Cells["Active"].Value.ToStr(); objDriverWeeklyRentDetail.DriverNo = grdLister.CurrentRow.Cells["DriverNo"].Value.ToStr(); objDriverWeeklyRentDetail.DriverId = DriverId; objDriverWeeklyRentDetail.RentComm = grdLister.CurrentRow.Cells["TotalRentCommission"].Value.ToDecimal(); objDriverWeeklyRentDetail.OfficeToPay = grdLister.CurrentRow.Cells["OfficeToPay"].Value.ToDecimal(); objDriverWeeklyRentDetail.PreviousBalance = grdLister.CurrentRow.Cells["PreviousBalance"].Value.ToDecimal(); objDriverWeeklyRentDetail.DriverToPay = grdLister.CurrentRow.Cells["DriverToPay"].Value.ToDecimal(); // db.SubmitChanges(); // } // } } objDriverWeeklyRentHistory.Save(); objDriverWeeklyRentHistory.Clear(); } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } } } } }
void grdLocations_CommandCellClick(object sender, EventArgs e) { try { GridCommandCellElement gridCell = (GridCommandCellElement)sender; string name = gridCell.ColumnInfo.Name.ToLower(); GridViewRowInfo row = gridCell.RowElement.RowInfo; string street = row.Cells["Street"].Value.ToStr().Trim(); string postCode = row.Cells["PostCode"].Value.ToStr().Trim(); int zoneId = row.Cells["Zone"].Value.ToInt(); if (zoneId == 0) { ENUtils.ShowMessage("Plot cannot be empty"); return; } if (string.IsNullOrEmpty(street)) { ENUtils.ShowMessage("Street cannot be empty"); return; } if (string.IsNullOrEmpty(postCode)) { ENUtils.ShowMessage("PostCode cannot be empty"); return; } string addressQuery = string.Empty; if (name == "delete") { if (DialogResult.Yes == RadMessageBox.Show("are you sure ?", "Delete", MessageBoxButtons.YesNo)) { addressQuery = "delete from Gen_locations where LOCATIONNAME='" + row.Cells["OldStreet"].Value.ToStr() + "' AND POSTCODE='" + row.Cells["OldPostCode"].Value.ToStr() + "';" + Environment.NewLine; row.Delete(); } else { return; } } else if (name == "edit") { street = street.Replace("'A", "A").ToStr().Trim().Replace("'B", "B").ToStr().Trim().Replace("'C", "C").Replace("'C", "C").ToStr().Trim() .Replace("'D", "D").ToStr().Trim().Replace("'E", "E").ToStr().Trim().Replace("'F", "F").ToStr().Trim().Replace("'G", "G").ToStr().Trim().Replace("'H", "H").ToStr().Trim() .Replace("'I", "I").ToStr().Trim().Replace("'J", "J").ToStr().Trim().Replace("'K", "K").ToStr().Trim().Replace("'L", "L").ToStr().Trim() .Replace("'M", "M").ToStr().Trim().Replace("'N", "N").ToStr().Trim().Replace("'O", "O").ToStr().Trim().Replace("'P", "P").ToStr().Trim() .Replace("'Q", "Q").ToStr().Trim().Replace("'R", "R").ToStr().Trim().Replace("'S", "S").ToStr().Trim().Replace("'T", "T").ToStr().Trim().Replace("'U", "U").ToStr().Trim() .Replace("'V", "V").ToStr().Trim().Replace("'W", "W").ToStr().Trim().Replace("'X", "X").ToStr().Trim().Replace("'Y", "Y").ToStr().Trim() .Replace("'Z", "Z").ToStr().Trim(); street = street.Replace("\r\n", "").ToStr().Trim(); street = street.Replace(",", "").ToStr().Trim(); string OLDStreet = row.Cells["OldStreet"].Value.ToStr(); OLDStreet = OLDStreet.Replace("'A", "''A").ToStr().Trim().Replace("'B", "''B").ToStr().Trim().Replace("'C", "''C") .Replace("'D", "''D").ToStr().Trim().Replace("'E", "''E").ToStr().Trim().Replace("'F", "''F").ToStr().Trim().Replace("'G", "''G").ToStr().Trim().Replace("'H", "''H").ToStr().Trim() .Replace("'I", "''I").ToStr().Trim().Replace("'J", "''J").ToStr().Trim().Replace("'K", "''K").ToStr().Trim().Replace("'L", "''L").ToStr().Trim() .Replace("'M", "''M").ToStr().Trim().Replace("'N", "''N").ToStr().Trim().Replace("'O", "''O").ToStr().Trim().Replace("'P", "''P").ToStr().Trim() .Replace("'Q", "''Q").ToStr().Trim().Replace("'R", "''R").ToStr().Trim().Replace("'S", "''S").ToStr().Trim().Replace("'T", "''T").ToStr().Trim().Replace("'U", "''U").ToStr().Trim() .Replace("'V", "''V").ToStr().Trim().Replace("'W", "''W").ToStr().Trim().Replace("'X", "''X").ToStr().Trim().Replace("'Y", "''Y").ToStr().Trim() .Replace("'Z", "''Z").ToStr().Trim(); addressQuery += "UPDATE GEN_LOCATIONS SET locationname='" + street + "',PostCode='" + postCode + "',ZoneId=" + zoneId + " where LOCATIONNAME='" + OLDStreet + "' AND POSTCODE='" + row.Cells["OldPostCode"].Value.ToStr() + "';" + Environment.NewLine; } // addressQuery = addressQuery.Replace("SET locationname=", "SET locationname='").ToStr().Trim(); using (TaxiDataContext db = new TaxiDataContext()) { if (addressQuery.ToStr().Trim() != string.Empty) { db.stp_RunProcedure(addressQuery); } } if (addressQuery.ToStr().Length > 0) { RefreshRecords(); } } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }
void grdAddresses_CommandCellClick(object sender, EventArgs e) { try { GridCommandCellElement gridCell = (GridCommandCellElement)sender; string name = gridCell.ColumnInfo.Name.ToLower(); GridViewRowInfo row = gridCell.RowElement.RowInfo; string fullAddress = row.Cells["FullAddress"].Value.ToStr().Trim().ToUpper(); string street = row.Cells["Street"].Value.ToStr().Trim().ToUpper(); string postCode = row.Cells["PostCode"].Value.ToStr().Trim().ToUpper(); int zoneId = row.Cells["Zone"].Value.ToInt(); if (zoneId == 0) { ENUtils.ShowMessage("Plot cannot be empty"); return; } if (string.IsNullOrEmpty(street)) { ENUtils.ShowMessage("Street cannot be empty"); return; } if (string.IsNullOrEmpty(postCode)) { ENUtils.ShowMessage("PostCode cannot be empty"); return; } string addressQuery = string.Empty; if (name == "delete") { if (DialogResult.Yes == RadMessageBox.Show("are you sure ?", "Delete", MessageBoxButtons.YesNo)) { addressQuery = "delete from GEN_ADDRESSES where addressline1='" + fullAddress + "';" + Environment.NewLine; row.Delete(); } else { return; } } else if (name == "edit") { street = street.Replace("'A", "A").ToStr().Trim().Replace("'B", "B").ToStr().Trim().Replace("'C", "C").Replace("'C", "C").ToStr().Trim() .Replace("'D", "D").ToStr().Trim().Replace("'E", "E").ToStr().Trim().Replace("'F", "F").ToStr().Trim().Replace("'G", "G").ToStr().Trim().Replace("'H", "H").ToStr().Trim() .Replace("'I", "I").ToStr().Trim().Replace("'J", "J").ToStr().Trim().Replace("'K", "K").ToStr().Trim().Replace("'L", "L").ToStr().Trim() .Replace("'M", "M").ToStr().Trim().Replace("'N", "N").ToStr().Trim().Replace("'O", "O").ToStr().Trim().Replace("'P", "P").ToStr().Trim() .Replace("'Q", "Q").ToStr().Trim().Replace("'R", "R").ToStr().Trim().Replace("'S", "S").ToStr().Trim().Replace("'T", "T").ToStr().Trim().Replace("'U", "U").ToStr().Trim() .Replace("'V", "V").ToStr().Trim().Replace("'W", "W").ToStr().Trim().Replace("'X", "X").ToStr().Trim().Replace("'Y", "Y").ToStr().Trim() .Replace("'Z", "Z").ToStr().Trim(); street = street.Replace("\r\n", "").ToStr().Trim(); street = street.Replace(",", "").ToStr().Trim(); string OLDaDDRESS = row.Cells["FullAddress"].Value.ToStr(); OLDaDDRESS = OLDaDDRESS.Replace("'A", "''A").ToStr().Trim().Replace("'B", "''B").ToStr().Trim().Replace("'C", "''C") .Replace("'D", "''D").ToStr().Trim().Replace("'E", "''E").ToStr().Trim().Replace("'F", "''F").ToStr().Trim().Replace("'G", "''G").ToStr().Trim().Replace("'H", "''H").ToStr().Trim() .Replace("'I", "''I").ToStr().Trim().Replace("'J", "''J").ToStr().Trim().Replace("'K", "''K").ToStr().Trim().Replace("'L", "''L").ToStr().Trim() .Replace("'M", "''M").ToStr().Trim().Replace("'N", "''N").ToStr().Trim().Replace("'O", "''O").ToStr().Trim().Replace("'P", "''P").ToStr().Trim() .Replace("'Q", "''Q").ToStr().Trim().Replace("'R", "''R").ToStr().Trim().Replace("'S", "''S").ToStr().Trim().Replace("'T", "''T").ToStr().Trim().Replace("'U", "''U").ToStr().Trim() .Replace("'V", "''V").ToStr().Trim().Replace("'W", "''W").ToStr().Trim().Replace("'X", "''X").ToStr().Trim().Replace("'Y", "''Y").ToStr().Trim() .Replace("'Z", "''Z").ToStr().Trim(); addressQuery = "update GEN_ADDRESSES SET addressline1='" + street + " " + postCode + "',PostalCode='" + postCode + "',ZoneId=" + zoneId + " where addressline1='" + OLDaDDRESS + "';" + Environment.NewLine; } using (TaxiDataContext db = new TaxiDataContext()) { if (addressQuery.ToStr().Trim() != string.Empty) { db.stp_RunProcedure(addressQuery); } } if (addressQuery.ToStr().Length > 0) { if (name == "delete") { AppVars.listOfAddress.RemoveAll(c => c.AddressLine1 == fullAddress); addresses.RemoveAll(c => c.AddressLine1 == fullAddress); } else if (name == "edit") { var obj = AppVars.listOfAddress.FirstOrDefault(c => c.AddressLine1 == fullAddress); if (obj != null) { obj.AddressLine1 = street + " " + postCode; obj.PostalCode = postCode; var obj1 = addresses.FirstOrDefault(c => c.AddressLine1 == fullAddress); if (obj1 != null) { obj1.AddressLine1 = street + " " + postCode; obj1.PostalCode = postCode; if (obj1.ZoneId != zoneId) { obj.ZoneId = zoneId; obj1.ZoneId = zoneId; row.Delete(); } } } } } } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }