public override void Save() { var rows = grdBookings.Rows.Where(c => c.Cells[COLS.ID].Value.ToStr() == "" || c.Cells[COLS.ID].Value.ToInt() == 0); foreach (GridViewRowInfo row in rows) { try { if (string.IsNullOrEmpty(row.Cells[COLS.PickupDateTime].Value.ToStr().Trim())) { continue; } objMaster = new BookingBO(); objMaster.New(); objMaster.Current.SubcompanyId = AppVars.objSubCompany.Id; objMaster.Current.BookingDate = DateTime.Now; objMaster.Current.BookingNo = row.Cells[COLS.BookingReference].Value.ToStr(); objMaster.Current.VehicleTypeId = row.Cells[COLS.VehicleType].Value.ToIntorNull(); objMaster.Current.FromLocTypeId = Enums.LOCATION_TYPES.ADDRESS; objMaster.Current.FromAddress = row.Cells[COLS.From].Value.ToStr(); objMaster.Current.ToLocTypeId = Enums.LOCATION_TYPES.ADDRESS; objMaster.Current.ToAddress = row.Cells[COLS.To].Value.ToStr(); objMaster.Current.JourneyTypeId = 1; objMaster.Current.FareRate = 0.00m; objMaster.Current.PickupDateTime = row.Cells[COLS.PickupDateTime].Value.ToDateTime(); string companyName = row.Cells[COLS.Account].Value.ToStr(); int? companyId = null; if (companyName.ToLower() == "cash") { } if (!string.IsNullOrEmpty(companyName)) { companyId = General.GetObject <Gen_Company>(c => c.CompanyName.ToLower() == companyName.ToLower()).DefaultIfEmpty().Id.ToIntorNull(); } if (companyId != null && companyId != 0) { objMaster.Current.CompanyId = companyId; objMaster.Current.IsCompanyWise = true; } objMaster.Current.CustomerName = row.Cells[COLS.Passenger].Value.ToStr().ToProperCase(); if (objMaster.Current.CustomerName.Length > 100) { objMaster.Current.CustomerName = objMaster.Current.CustomerName.Substring(0, 99); } string phoneNo = row.Cells[COLS.PhoneNo].Value.ToStr(); if (!string.IsNullOrEmpty(phoneNo)) { if (phoneNo.Contains("+44")) { phoneNo = phoneNo.Strip("+44").Trim(); } else if (phoneNo.Contains("0044")) { phoneNo = phoneNo.Strip("0044").Trim(); } if (phoneNo.Length > 0) { if (phoneNo[0] != '0') { phoneNo = phoneNo.Insert(0, "0"); } } } if (phoneNo.StartsWith("07")) { objMaster.Current.CustomerMobileNo = phoneNo; } else { objMaster.Current.CustomerPhoneNo = phoneNo; } if (companyId != null && companyId != 0) { if (companyName.ToLower().Trim() == "C/Card" || companyName.ToLower().Trim() == "Credit Card") { objMaster.Current.PaymentTypeId = Enums.PAYMENT_TYPES.CREDIT_CARD; } else { objMaster.Current.PaymentTypeId = Enums.PAYMENT_TYPES.BANK_ACCOUNT; } } else { objMaster.Current.PaymentTypeId = Enums.PAYMENT_TYPES.CASH; } objMaster.Current.BookingStatusId = Enums.BOOKINGSTATUS.WAITING; objMaster.Current.FromDoorNo = row.Cells[COLS.FlightNo].Value.ToStr(); objMaster.Current.Booking_ViaLocations.Add(new Booking_ViaLocation { ViaLocTypeId = Enums.LOCATION_TYPES.ADDRESS, ViaLocLabel = "Via", ViaLocTypeLabel = "Address", ViaLocTypeValue = "Address", ViaLocValue = row.Cells[COLS.Via].Value.ToStr() }); objMaster.Save(); row.Cells[COLS.ID].Value = objMaster.Current.Id; row.ErrorText = ""; } catch (Exception ex) { row.Cells[COLS.ID].Value = objMaster.Current.Id; row.ErrorText = objMaster.ShowErrors(); } } }
public override void Save() { var rows = grdBookings.Rows.Where(c => c.Cells[COLS.ID].Value.ToStr() == "" || c.Cells[COLS.ID].Value.ToInt() == 0); foreach (GridViewRowInfo row in rows) { try { objMaster = new BookingBO(); objMaster.New(); objMaster.Current.SubcompanyId = AppVars.objSubCompany.Id; objMaster.Current.BookingDate = DateTime.Now; objMaster.Current.BookingNo = row.Cells[COLS.BookingReference].Value.ToStr(); objMaster.Current.VehicleTypeId = row.Cells[COLS.VehicleType].Value.ToIntorNull(); objMaster.Current.FromLocTypeId = Enums.LOCATION_TYPES.ADDRESS; objMaster.Current.FromAddress = row.Cells[COLS.From].Value.ToStr(); objMaster.Current.ToLocTypeId = Enums.LOCATION_TYPES.ADDRESS; objMaster.Current.ToAddress = row.Cells[COLS.To].Value.ToStr(); objMaster.Current.JourneyTypeId = 1; objMaster.Current.FareRate = row.Cells[COLS.Fare].Value.ToDecimal(); objMaster.Current.PickupDateTime = row.Cells[COLS.PickupDateTime].Value.ToDateTime(); string companyName = row.Cells[COLS.Account].Value.ToStr(); int? companyId = null; if (!string.IsNullOrEmpty(companyName)) { companyId = General.GetObject <Gen_Company>(c => c.CompanyName.ToLower() == companyName.ToLower()).DefaultIfEmpty().Id.ToIntorNull(); } if (companyId != null) { objMaster.Current.CompanyId = companyId; objMaster.Current.IsCompanyWise = true; } objMaster.Current.CustomerName = row.Cells[COLS.Passenger].Value.ToStr().ToProperCase(); string phoneNo = row.Cells[COLS.PhoneNo].Value.ToStr(); if (!string.IsNullOrEmpty(phoneNo)) { if (phoneNo.Contains("+44")) { phoneNo = phoneNo.Strip("+44").Trim(); } else if (phoneNo.Contains("0044")) { phoneNo = phoneNo.Strip("0044").Trim(); } if (phoneNo.Length > 0) { if (phoneNo[0] != '0') { phoneNo = phoneNo.Insert(0, "0"); } } } if (phoneNo.StartsWith("07")) { objMaster.Current.CustomerMobileNo = phoneNo; } else { objMaster.Current.CustomerPhoneNo = phoneNo; } string payment = row.Cells[COLS.PaymentType].Value.ToStr(); int? paymentType = General.GetObject <Gen_PaymentType>(c => c.PaymentType.ToLower() == payment.ToLower()).DefaultIfEmpty().Id.ToIntorNull(); if (paymentType != 0) { objMaster.Current.PaymentTypeId = paymentType; } else { paymentType = General.GetObject <Gen_PaymentType>(c => c.PaymentType.ToLower() == "bank account").DefaultIfEmpty().Id.ToIntorNull(); objMaster.Current.PaymentTypeId = paymentType; } objMaster.Current.BookingStatusId = Enums.BOOKINGSTATUS.WAITING; objMaster.AddedBy = AppVars.LoginObj.UserName.ToStr(); objMaster.Save(); row.Cells[COLS.ID].Value = objMaster.Current.Id; row.ErrorText = ""; } catch (Exception ex) { row.Cells[COLS.ID].Value = objMaster.Current.Id; row.ErrorText = objMaster.ShowErrors(); } } }