コード例 #1
0
 public override void Save()
 {
     try
     {
         int Id = 0;
         foreach (var item in grdLister.Rows)
         {
             Id = item.Cells["Id"].Value.ToInt();
             if (Id > 0)
             {
                 objMaster.GetByPrimaryKey(Id);
                 objMaster.Edit();
                 objMaster.Current.PerMinJourneyCharges = item.Cells[COLS.PerMinJourneyCharges].Value.ToDecimal();
                 objMaster.CheckDataValidation          = false;
                 objMaster.Save();
                 objMaster.Clear();
             }
         }
     }
     catch (Exception ex)
     {
         if (objMaster.Errors.Count > 0)
         {
             ENUtils.ShowMessage(objMaster.ShowErrors());
         }
         else
         {
             ENUtils.ShowMessage(ex.Message);
         }
     }
 }
コード例 #2
0
        public void CopyCompanyFares(int CompanyId)
        {
            try
            {
                //  int VehicleTypeId = cVehicleTypeId;
                if (SaveFares == false)
                {
                    int FareId = 0;


                    var Query = General.GetObject <Fare>(c => c.CompanyId == CompanyId);
                    if (CompanyId == 0 && Vechileid > 0)
                    {
                        var Query2 = General.GetObject <Fare>(c => c.VehicleTypeId == Vechileid);
                        if (Query2 != null)
                        {
                            FareId = Query2.Id;
                        }
                    }
                    if (Query != null)
                    {
                        FareId = Query.Id;
                    }
                    var FareList = (from a in General.GetQueryable <Fare_ChargesDetail>(c => c.FareId == FareId)
                                    select new
                    {
                        Id = a.Id,
                        FareId = a.FareId,
                        OriginLocationTypeId = a.OriginLocationTypeId,
                        DestinationLocationTypeId = a.DestinationLocationTypeId,
                        OriginId = a.OriginId,
                        DestinationId = a.DestinationId,
                        FromAddress = a.FromAddress,
                        ToAddress = a.ToAddress,
                        Rate = a.Rate,
                        NightTimeRate = HasOffPeakRate ? a.NightTimeRate : 0,
                    }).ToList();
                    ChargesDetail.Clear();
                    foreach (var item in FareList)
                    {
                        decimal Rate = item.Rate.ToDecimal();
                        if (ApplyAdditionOrSubtractionOnFareRates)
                        {
                            decimal Amount       = 0.00m;
                            decimal PercentValue = numPercent.Value.ToDecimal();

                            if (rbtnAdd.IsChecked)
                            {
                                Amount = ((Rate * PercentValue) / 100);
                                Rate   = (Rate + Amount);
                            }
                            else
                            {
                                Amount = ((Rate * PercentValue) / 100);
                                Rate   = (Rate - Amount);
                            }
                        }
                        ChargesDetail.Add(new Fare_ChargesDetail {
                            Id = item.Id, FareId = item.FareId, OriginLocationTypeId = item.OriginLocationTypeId, DestinationLocationTypeId = item.DestinationLocationTypeId, OriginId = item.OriginId, DestinationId = item.DestinationId, FromAddress = item.FromAddress, ToAddress = item.ToAddress, Rate = Rate, NightTimeRate = item.NightTimeRate
                        });
                    }
                    var OtherChargesList = (from a in General.GetQueryable <Fare_OtherCharge>(c => c.FareId == FareId)
                                            select new
                    {
                        Id = a.Id,
                        FareId = a.FareId,
                        FromMile = a.FromMile,
                        ToMile = a.ToMile,
                        Rate = a.Rate,
                        FromStartTime = HasOffPeakRate ? a.FromStartTime : null,
                        TillStartTime = HasOffPeakRate ? a.TillStartTime : null,
                        FromEndTime = HasOffPeakRate ? a.FromEndTime : null,
                        TillEndTime = HasOffPeakRate ? a.TillEndTime : null,
                        PeakTimeRate = HasOffPeakRate ? a.PeakTimeRate : 0,
                        OffPeakTimeRate = HasOffPeakRate ? a.OffPeakTimeRate : 0,
                        NightTimeRate = HasOffPeakRate ? a.NightTimeRate : 0,
                    }).ToList();
                    OtherCharge.Clear();
                    foreach (var item in OtherChargesList)
                    {
                        OtherCharge.Add(new Fare_OtherCharge {
                            Id = item.Id, FareId = item.FareId, FromMile = item.FromMile, ToMile = item.ToMile, Rate = item.Rate, FromStartTime = item.FromStartTime, TillStartTime = item.TillStartTime, FromEndTime = item.TillEndTime, TillEndTime = item.TillEndTime, PeakTimeRate = item.PeakTimeRate, OffPeakTimeRate = item.OffPeakTimeRate, NightTimeRate = item.NightTimeRate
                        });
                    }

                    var PDAMeterList = (from a in General.GetQueryable <Fare_PDAMeter>(c => c.FareId == FareId)
                                        select new
                    {
                        Id = a.Id,
                        FareId = a.FareId,
                        FromMile = a.FromMile,
                        ToMile = a.ToMile,
                        Rate = a.Rate,
                        FromStartTime = HasOffPeakRate ? a.FromStartTime : null,
                        TillStartTime = HasOffPeakRate ? a.TillStartTime : null,
                        FromEndTime = HasOffPeakRate ? a.FromEndTime : null,
                        TillEndTime = HasOffPeakRate ? a.TillEndTime : null,
                        PeakTimeRate = HasOffPeakRate ? a.PeakTimeRate : 0,
                        OffPeakTimeRate = HasOffPeakRate ? a.OffPeakTimeRate : 0,
                        NightTimeRate = HasOffPeakRate ? a.NightTimeRate : 0,
                    }).ToList();
                    PDAMeter.Clear();
                    foreach (var item in PDAMeterList)
                    {
                        PDAMeter.Add(new Fare_PDAMeter {
                            Id = item.Id, FareId = item.FareId, FromMile = item.FromMile, ToMile = item.ToMile, Rate = item.Rate, FromStartTime = item.FromStartTime, TillStartTime = item.TillStartTime, FromEndTime = item.FromEndTime, TillEndTime = item.TillEndTime, PeakTimeRate = item.PeakTimeRate, OffPeakTimeRate = item.OffPeakTimeRate, NightTimeRate = item.NightTimeRate
                        });
                    }
                    var ZoneWisePricingList = (from a in General.GetQueryable <Fare_ZoneWisePricing>(c => c.FareId == FareId)
                                               select new
                    {
                        Id = a.Id,
                        FareId = a.FareId,
                        FromZoneId = a.FromZoneId,
                        ToZoneId = a.ToZoneId,
                        Price = a.Price,
                    }).ToList();
                    ZoneWisePricing.Clear();
                    foreach (var item in ZoneWisePricingList)
                    {
                        ZoneWisePricing.Add(new Fare_ZoneWisePricing {
                            Id = item.Id, FareId = item.FareId, FromZoneId = item.FromZoneId, ToZoneId = item.ToZoneId, Price = item.Price
                        });
                    }


                    var AirportAndStationList = (from a in General.GetQueryable <Gen_Company_AgentCommission>(c => c.FareId == FareId)
                                                 select new
                    {
                        Id = a.Id,
                        a.CompanyId,
                        FareId = a.FareId,
                        LocationId = a.LocationId,
                        LocationTypeId = a.LocationTypeId,
                        CommissionPercent = a.CommissionPercent,
                        CommissionAmount = a.CommissionAmount,
                        CommissionOnPercent = a.CommissionOnPercent,
                        DayWise = a.DayWise,
                        NightWise = a.NightWise,
                        VehicleTypeId = a.VehicleTypeId,

                        CompanyPrice = a.CompanyPrice,
                        DriverPrice = a.DriverPrice,
                        CustomerPrice = a.CustomerPrice
                    }).ToList();
                    CompanyAirportandStation.Clear();
                    foreach (var item in AirportAndStationList)
                    {
                        CompanyAirportandStation.Add(new Gen_Company_AgentCommission {
                            Id = item.Id, FareId = item.FareId, CompanyId = item.CompanyId, LocationId = item.LocationId, LocationTypeId = item.LocationTypeId, CommissionAmount = item.CommissionAmount, CommissionOnPercent = item.CommissionOnPercent, CommissionPercent = item.CommissionPercent, CompanyPrice = item.CompanyPrice, CustomerPrice = item.CustomerPrice, DayWise = item.DayWise, NightWise = item.NightWise, DriverPrice = item.DriverPrice, VehicleTypeId = item.VehicleTypeId
                        });
                    }
                }
                else
                {
                    var CompanyList = (from a in General.GetQueryable <Gen_Company>(null)
                                       select new
                    {
                        Id = a.Id,
                        CompanyName = a.CompanyName
                    }).ToList();


                    var queryy = CompanyList.Where(item => selectlist.Contains(item.Id));
                    foreach (var item in queryy)
                    {
                        if (objMaster.PrimaryKeyValue == null)
                        {
                            objMaster.New();
                        }
                        else
                        {
                            objMaster.Edit();
                        }
                        objMaster.Current.VehicleTypeId = Vechileid;
                        // objMaster.Current.VehicleTypeId = VehicleTypeId.ToInt();
                        objMaster.Current.CompanyId           = item.Id;
                        objMaster.Current.IsCompanyWise       = true;
                        objMaster.Current.AddOn               = DateTime.Now;
                        objMaster.Current.AddBy               = AppVars.LoginObj.LuserId.ToIntorNull();
                        objMaster.Current.StartRate           = numStartRate.Value;
                        objMaster.Current.StartRateValidMiles = numStartRateValidMiles.Value;


                        string[] skipProperties = { "Gen_Company",       "Gen_Location", "Gen_Location1", "Gen_LocationType",
                                                    "Gen_LocationType1", "Fare",         "Gen_Zone1",     "Gen_Zone",        "Fare_ZoneWisePricing1","Fare_ZoneWisePricing", "Fleet_VehicleType" };
                        IList <Fare_ChargesDetail> savedList  = objMaster.Current.Fare_ChargesDetails;
                        List <Fare_ChargesDetail>  ListDetail = (from a in ChargesDetail
                                                                 select new Fare_ChargesDetail
                        {
                            Id = a.Id,
                            FareId = objMaster.Current.Id,
                            OriginLocationTypeId = a.OriginLocationTypeId,
                            DestinationLocationTypeId = a.OriginLocationTypeId,
                            OriginId = a.OriginId,
                            DestinationId = a.DestinationId,
                            FromAddress = a.FromAddress,
                            ToAddress = a.ToAddress,
                            Rate = a.Rate,
                            NightTimeRate = a.NightTimeRate
                        }).ToList();

                        Utils.General.SyncChildCollection(ref savedList, ref ListDetail, "Id", skipProperties);

                        // OtherCharge

                        IList <Fare_OtherCharge> savedList2        = objMaster.Current.Fare_OtherCharges;
                        List <Fare_OtherCharge>  listofOtherDetail = (from a in OtherCharge
                                                                      select new Fare_OtherCharge
                        {
                            Id = a.Id,
                            FareId = a.FareId,
                            FromMile = a.FromMile,
                            ToMile = a.ToMile,
                            Rate = a.Rate,
                            FromStartTime = HasOffPeakRate ? a.FromStartTime : null,
                            TillStartTime = HasOffPeakRate ? a.TillStartTime : null,
                            FromEndTime = HasOffPeakRate ? a.FromEndTime : null,
                            TillEndTime = HasOffPeakRate ? a.TillEndTime : null,
                            PeakTimeRate = HasOffPeakRate ? a.PeakTimeRate : 0,
                            OffPeakTimeRate = HasOffPeakRate ? a.OffPeakTimeRate : 0,
                            NightTimeRate = HasOffPeakRate ? a.NightTimeRate : 0
                        }).ToList();


                        Utils.General.SyncChildCollection(ref savedList2, ref listofOtherDetail, "Id", skipProperties);

                        // PDA METER

                        IList <Fare_PDAMeter> savedList3           = objMaster.Current.Fare_PDAMeters;
                        List <Fare_PDAMeter>  listofpdaOtherDetail = (from a in PDAMeter
                                                                      select new Fare_PDAMeter
                        {
                            Id = a.Id,
                            FareId = a.FareId,
                            FromMile = a.FromMile,
                            ToMile = a.ToMile,
                            Rate = a.Rate,
                            FromStartTime = HasOffPeakRate ? a.FromStartTime : null,
                            TillStartTime = HasOffPeakRate ? a.TillStartTime : null,
                            FromEndTime = HasOffPeakRate ? a.FromEndTime : null,
                            TillEndTime = HasOffPeakRate ? a.TillEndTime : null,
                            PeakTimeRate = HasOffPeakRate ? a.PeakTimeRate : 0,
                            OffPeakTimeRate = HasOffPeakRate ? a.OffPeakTimeRate : 0,
                            NightTimeRate = HasOffPeakRate ? a.NightTimeRate : 0
                        }).ToList();


                        Utils.General.SyncChildCollection(ref savedList3, ref listofpdaOtherDetail, "Id", skipProperties);

                        IList <Fare_ZoneWisePricing> saveList4     = objMaster.Current.Fare_ZoneWisePricings;
                        List <Fare_ZoneWisePricing>  listofDetail4 = (from a in ZoneWisePricing
                                                                      select new Fare_ZoneWisePricing
                        {
                            Id = a.Id,
                            FareId = a.FareId,
                            FromZoneId = a.FromZoneId,
                            ToZoneId = a.ToZoneId,
                            Price = a.Price,
                        }).ToList();

                        Utils.General.SyncChildCollection(ref saveList4, ref listofDetail4, "Id", skipProperties);
                        //HP

                        IList <Gen_Company_AgentCommission> saveList5     = objMaster.Current.Gen_Company_AgentCommissions;
                        List <Gen_Company_AgentCommission>  listofDetail5 = (from a in CompanyAirportandStation
                                                                             select new Gen_Company_AgentCommission
                        {
                            Id = a.Id,
                            FareId = a.FareId,
                            LocationId = a.LocationId,
                            LocationTypeId = a.LocationTypeId,
                            CommissionPercent = a.CommissionPercent,
                            CommissionAmount = a.CommissionAmount,
                            CommissionOnPercent = a.CommissionOnPercent,
                            DayWise = a.DayWise,
                            NightWise = a.NightWise,
                            VehicleTypeId = a.VehicleTypeId,

                            CompanyPrice = a.CompanyPrice,
                            DriverPrice = a.DriverPrice,
                            CustomerPrice = a.CustomerPrice,
                            CompanyId = item.Id
                        }).ToList();

                        Utils.General.SyncChildCollection(ref saveList5, ref listofDetail5, "Id", skipProperties);
                        //

                        objMaster.Save();
                        objMaster.Clear();
                        objMaster = new FareBO();
                        FaresSaved(item.Id);
                    }
                }
            }
            catch (Exception ex)
            {
                if (objMaster.Errors.Count > 0)
                {
                    ENUtils.ShowMessage(objMaster.ShowErrors());
                }
                else
                {
                    ENUtils.ShowMessage(ex.Message);
                }
            }
        }
コード例 #3
0
        public void CopyCompanyFares(int SubCompanyId)
        {
            try
            {
                //  int VehicleTypeId = cVehicleTypeId;
                //if (SaveFares == false)
                {
                    int FareId = 0;


                    var Query = General.GetObject <Fare>(c => (c.SubCompanyId == SubCompanyId) && (c.VehicleTypeId == Vechileid));
                    //if (SubCompanyId == 0 && Vechileid > 0)
                    //{
                    //    var Query2 = General.GetObject<Fare>(c => c.VehicleTypeId == Vechileid);
                    //    if (Query2 != null)
                    //    {
                    //        FareId = Query2.Id;


                    //    }
                    //}
                    if (Query != null)
                    {
                        FareId = Query.Id;
                    }
                    if (optApplyAll.IsChecked || optOnlyFixedFares.IsChecked)
                    {
                        var FareList = (from a in General.GetQueryable <Fare_ChargesDetail>(c => c.FareId == FareId)
                                        select new
                        {
                            Id = a.Id,
                            FareId = a.FareId,
                            OriginLocationTypeId = a.OriginLocationTypeId,
                            DestinationLocationTypeId = a.DestinationLocationTypeId,
                            OriginId = a.OriginId,
                            DestinationId = a.DestinationId,
                            FromAddress = a.FromAddress,
                            ToAddress = a.ToAddress,
                            Rate = a.Rate,
                            a.CompanyRate,
                            NightTimeRate = HasOffPeakRate ? a.NightTimeRate : 0,
                        }).ToList();
                        ChargesDetail.Clear();
                        foreach (var item in FareList)
                        {
                            decimal Rate        = item.Rate.ToDecimal();
                            decimal CompanyRate = item.CompanyRate.ToDecimal();
                            if (numPercent.Value.ToDecimal() > 0)
                            {
                                decimal Amount       = 0.00m;
                                decimal PercentValue = numPercent.Value.ToDecimal();

                                if (rbtnAdd.IsChecked)
                                {
                                    Amount = ((Rate * PercentValue) / 100);
                                    Rate   = (Rate + Amount);
                                }
                                else
                                {
                                    Amount = ((Rate * PercentValue) / 100);
                                    Rate   = (Rate - Amount);
                                }

                                if (rbtnAdd.IsChecked)
                                {
                                    Amount      = ((CompanyRate * PercentValue) / 100);
                                    CompanyRate = (CompanyRate + Amount);
                                }
                                else
                                {
                                    Amount      = ((CompanyRate * PercentValue) / 100);
                                    CompanyRate = (CompanyRate - Amount);
                                }
                            }
                            ChargesDetail.Add(new Fare_ChargesDetail {
                                Id = item.Id, FareId = item.FareId, OriginLocationTypeId = item.OriginLocationTypeId, DestinationLocationTypeId = item.DestinationLocationTypeId, OriginId = item.OriginId, DestinationId = item.DestinationId, FromAddress = item.FromAddress, ToAddress = item.ToAddress, Rate = Rate, NightTimeRate = item.NightTimeRate, CompanyRate = CompanyRate
                            });
                        }
                    }
                    else
                    {
                        ChargesDetail.Clear();
                    }
                    if (optApplyAll.IsChecked || optOnlyMileage.IsChecked)
                    {
                        var OtherChargesList = (from a in General.GetQueryable <Fare_OtherCharge>(c => c.FareId == FareId)
                                                select new
                        {
                            Id = a.Id,
                            FareId = a.FareId,
                            FromMile = a.FromMile,
                            ToMile = a.ToMile,
                            Rate = a.Rate,
                            a.CompanyRate,
                            FromStartTime = HasOffPeakRate ? a.FromStartTime : null,
                            TillStartTime = HasOffPeakRate ? a.TillStartTime : null,
                            FromEndTime = HasOffPeakRate ? a.FromEndTime : null,
                            TillEndTime = HasOffPeakRate ? a.TillEndTime : null,
                            PeakTimeRate = HasOffPeakRate ? a.PeakTimeRate : 0,
                            OffPeakTimeRate = HasOffPeakRate ? a.OffPeakTimeRate : 0,
                            NightTimeRate = HasOffPeakRate ? a.NightTimeRate : 0,
                        }).ToList();
                        OtherCharge.Clear();
                        foreach (var item in OtherChargesList)
                        {
                            decimal Rate        = item.Rate.ToDecimal();
                            decimal CompanyRate = item.CompanyRate.ToDecimal();
                            if (numPercent.Value.ToDecimal() > 0)
                            {
                                decimal Amount       = 0.00m;
                                decimal PercentValue = numPercent.Value.ToDecimal();

                                if (rbtnAdd.IsChecked)
                                {
                                    Amount = ((Rate * PercentValue) / 100);
                                    Rate   = (Rate + Amount);
                                }
                                else
                                {
                                    Amount = ((Rate * PercentValue) / 100);
                                    Rate   = (Rate - Amount);
                                }

                                if (rbtnAdd.IsChecked)
                                {
                                    Amount      = ((CompanyRate * PercentValue) / 100);
                                    CompanyRate = (CompanyRate + Amount);
                                }
                                else
                                {
                                    Amount      = ((CompanyRate * PercentValue) / 100);
                                    CompanyRate = (CompanyRate - Amount);
                                }
                            }
                            OtherCharge.Add(new Fare_OtherCharge {
                                Id = item.Id, FareId = item.FareId, FromMile = item.FromMile, ToMile = item.ToMile, Rate = Rate, CompanyRate = CompanyRate, FromStartTime = item.FromStartTime, TillStartTime = item.TillStartTime, FromEndTime = item.TillEndTime, TillEndTime = item.TillEndTime, PeakTimeRate = item.PeakTimeRate, OffPeakTimeRate = item.OffPeakTimeRate, NightTimeRate = item.NightTimeRate
                            });
                        }
                    }
                    else
                    {
                        OtherCharge.Clear();
                    }
                    if (optApplyAll.IsChecked || optOnlyPlottoPlot.IsChecked)
                    {
                        var ZoneWisePricingList = (from a in General.GetQueryable <Fare_ZoneWisePricing>(c => c.FareId == FareId)
                                                   select new
                        {
                            Id = a.Id,
                            FareId = a.FareId,
                            FromZoneId = a.FromZoneId,
                            ToZoneId = a.ToZoneId,
                            Rate = a.Price,
                            a.CompanyRate
                        }).ToList();
                        ZoneWisePricing.Clear();
                        foreach (var item in ZoneWisePricingList)
                        {
                            decimal Rate        = item.Rate.ToDecimal();
                            decimal CompanyRate = item.CompanyRate.ToDecimal();
                            if (numPercent.Value.ToDecimal() > 0)
                            {
                                decimal Amount       = 0.00m;
                                decimal PercentValue = numPercent.Value.ToDecimal();

                                if (rbtnAdd.IsChecked)
                                {
                                    Amount = ((Rate * PercentValue) / 100);
                                    Rate   = (Rate + Amount);
                                }
                                else
                                {
                                    Amount = ((Rate * PercentValue) / 100);
                                    Rate   = (Rate - Amount);
                                }

                                if (rbtnAdd.IsChecked)
                                {
                                    Amount      = ((CompanyRate * PercentValue) / 100);
                                    CompanyRate = (CompanyRate + Amount);
                                }
                                else
                                {
                                    Amount      = ((CompanyRate * PercentValue) / 100);
                                    CompanyRate = (CompanyRate - Amount);
                                }
                            }
                            ZoneWisePricing.Add(new Fare_ZoneWisePricing {
                                Id = item.Id, FareId = item.FareId, FromZoneId = item.FromZoneId, ToZoneId = item.ToZoneId, Price = Rate, CompanyRate = CompanyRate
                            });
                        }
                    }
                    else
                    {
                        ZoneWisePricing.Clear();
                    }


                    var CompanyList = (from a in General.GetQueryable <Gen_SubCompany>(null)
                                       select new
                    {
                        Id = a.Id,
                        CompanyName = a.CompanyName
                    }).ToList();


                    var queryy = CompanyList.Where(item => selectlist.Contains(item.Id));
                    foreach (var item in queryy)
                    {
                        if (objMaster.PrimaryKeyValue == null)
                        {
                            objMaster.New();
                        }



                        objMaster.Current.VehicleTypeId = Vechileid;
                        objMaster.Current.SubCompanyId  = item.Id;

                        objMaster.Current.AddOn = DateTime.Now;
                        objMaster.Current.AddBy = AppVars.LoginObj.LuserId.ToIntorNull();



                        string[] skipProperties = { "Gen_Company",       "Gen_Location", "Gen_Location1", "Gen_LocationType",
                                                    "Gen_LocationType1", "Fare",         "Gen_Zone1",     "Gen_Zone",        "Fare_ZoneWisePricing1","Fare_ZoneWisePricing", "Fleet_VehicleType" };
                        if (optApplyAll.IsChecked || optOnlyFixedFares.IsChecked)
                        {
                            IList <Fare_ChargesDetail> savedList  = objMaster.Current.Fare_ChargesDetails;
                            List <Fare_ChargesDetail>  ListDetail = (from a in ChargesDetail
                                                                     select new Fare_ChargesDetail
                            {
                                Id = a.Id,
                                FareId = objMaster.Current.Id,
                                OriginLocationTypeId = a.OriginLocationTypeId,
                                DestinationLocationTypeId = a.OriginLocationTypeId,
                                OriginId = a.OriginId,
                                DestinationId = a.DestinationId,
                                FromAddress = a.FromAddress,
                                ToAddress = a.ToAddress,
                                Rate = a.Rate,
                                CompanyRate = a.CompanyRate,
                                NightTimeRate = a.NightTimeRate
                            }).ToList();

                            Utils.General.SyncChildCollection(ref savedList, ref ListDetail, "Id", skipProperties);
                        }
                        // OtherCharge
                        if (optApplyAll.IsChecked || optOnlyMileage.IsChecked)
                        {
                            IList <Fare_OtherCharge> savedList2        = objMaster.Current.Fare_OtherCharges;
                            List <Fare_OtherCharge>  listofOtherDetail = (from a in OtherCharge
                                                                          select new Fare_OtherCharge
                            {
                                Id = a.Id,
                                FareId = a.FareId,
                                FromMile = a.FromMile,
                                ToMile = a.ToMile,
                                Rate = a.Rate,
                                CompanyRate = a.CompanyRate,
                                FromStartTime = HasOffPeakRate ? a.FromStartTime : null,
                                TillStartTime = HasOffPeakRate ? a.TillStartTime : null,
                                FromEndTime = HasOffPeakRate ? a.FromEndTime : null,
                                TillEndTime = HasOffPeakRate ? a.TillEndTime : null,
                                PeakTimeRate = HasOffPeakRate ? a.PeakTimeRate : 0,
                                OffPeakTimeRate = HasOffPeakRate ? a.OffPeakTimeRate : 0,
                                NightTimeRate = HasOffPeakRate ? a.NightTimeRate : 0
                            }).ToList();


                            Utils.General.SyncChildCollection(ref savedList2, ref listofOtherDetail, "Id", skipProperties);
                        }
                        if (optApplyAll.IsChecked || optOnlyPlottoPlot.IsChecked)
                        {
                            IList <Fare_ZoneWisePricing> saveList4     = objMaster.Current.Fare_ZoneWisePricings;
                            List <Fare_ZoneWisePricing>  listofDetail4 = (from a in ZoneWisePricing
                                                                          select new Fare_ZoneWisePricing
                            {
                                Id = a.Id,
                                FareId = a.FareId,
                                FromZoneId = a.FromZoneId,
                                ToZoneId = a.ToZoneId,
                                Price = a.Price,
                                CompanyRate = a.CompanyRate,
                            }).ToList();

                            Utils.General.SyncChildCollection(ref saveList4, ref listofDetail4, "Id", skipProperties);
                        }
                        objMaster.Save();
                        objMaster.Clear();
                        objMaster = new FareBO();
                        FaresSaved(item.Id);
                    }
                }
            }
            catch (Exception ex)
            {
                if (objMaster.Errors.Count > 0)
                {
                    ENUtils.ShowMessage(objMaster.ShowErrors());
                }
                else
                {
                    ENUtils.ShowMessage(ex.Message);
                }
            }
        }
コード例 #4
0
        public override void Save()
        {
            try
            {
                if (objMaster.PrimaryKeyValue == null)
                {
                    objMaster.New();
                }
                else
                {
                    objMaster.Edit();
                }

                //  objMaster.Current.EffectiveDate = dtpEffectiveDate.Value.ToDateorNull();
                objMaster.Current.VehicleTypeId = ddlVehicleType.SelectedValue.ToIntorNull();
                objMaster.Current.IsCompanyWise = chkCompanyWise.Checked;
                objMaster.Current.CompanyId     = ddlCompany.SelectedValue.ToIntorNull();


                objMaster.Current.SubCompanyId = ddlSubCompanyId.SelectedValue.ToIntorNull();
                //   Fare_ChargesDetail c = new Fare_ChargesDetail();
                //NC 16/12/16
                decimal StartRate      = numStartRate.Value.ToDecimal();
                decimal ValidMiles     = numValidMiles.Value.ToDecimal();
                decimal FromStartRate  = numFromStartRate.Value.ToDecimal();
                decimal FromValidMiles = numFromValidMiles.Value.ToDecimal();
                decimal TillStartRate  = numTillStartRate.Value.ToDecimal();
                decimal TillValidMiles = numTillValidMiles.Value.ToDecimal();


                //DateTime dateValue = new DateTime(1900, 1, 1, 0, 0, 0);

                //DateTime? fromPeakTimeStartTime = string.Format("{0:dd/MM/yyyy HH:mm}", dateValue.ToDate() + dtpPeakTimeFromStartTime.Value.Value.TimeOfDay).ToDateTime();
                //DateTime? tillPeakTimeStartTime = string.Format("{0:dd/MM/yyyy HH:mm}", dateValue.ToDate() + dtpPeakTimeToStartTime.Value.Value.TimeOfDay).ToDateTime();
                //DateTime? fromOffPeakFromEndTime = string.Format("{0:dd/MM/yyyy HH:mm}", dateValue.ToDate() + dtpOffPeakFromEndTime.Value.Value.TimeOfDay).ToDateTime();
                //DateTime? tillOffPeakToEndTime = string.Format("{0:dd/MM/yyyy HH:mm}", dateValue.ToDate() + dtpOffPeakToEndTime.Value.Value.TimeOfDay).ToDateTime();


                DateTime dateValue = new DateTime(1900, 1, 1, 0, 0, 0);

                DateTime?fromPeakTimeStartTime  = null;
                DateTime?tillPeakTimeStartTime  = null;
                DateTime?fromOffPeakFromEndTime = null;
                DateTime?tillOffPeakToEndTime   = null;


                if (dtpPeakTimeFromStartTime.Value != null)
                {
                    fromPeakTimeStartTime = string.Format("{0:dd/MM/yyyy HH:mm}", dateValue.ToDate() + dtpPeakTimeFromStartTime.Value.Value.TimeOfDay).ToDateTime();
                }

                if (dtpPeakTimeToStartTime.Value != null)
                {
                    tillPeakTimeStartTime = string.Format("{0:dd/MM/yyyy HH:mm}", dateValue.ToDate() + dtpPeakTimeToStartTime.Value.Value.TimeOfDay).ToDateTime();
                }


                if (dtpOffPeakFromEndTime.Value != null)
                {
                    fromOffPeakFromEndTime = string.Format("{0:dd/MM/yyyy HH:mm}", dateValue.ToDate() + dtpOffPeakFromEndTime.Value.Value.TimeOfDay).ToDateTime();
                }

                if (dtpOffPeakToEndTime.Value != null)
                {
                    tillOffPeakToEndTime = string.Format("{0:dd/MM/yyyy HH:mm}", dateValue.ToDate() + dtpOffPeakToEndTime.Value.Value.TimeOfDay).ToDateTime();
                }

                if (radPanel8.Visible == false)
                {
                    fromPeakTimeStartTime  = null;
                    tillPeakTimeStartTime  = null;
                    fromOffPeakFromEndTime = null;
                    tillOffPeakToEndTime   = null;
                    FromStartRate          = 0;
                    FromValidMiles         = 0;
                    TillStartRate          = 0;
                    TillValidMiles         = 0;
                }
                else
                {
                    StartRate  = 0;
                    ValidMiles = 0;
                }


                objMaster.FromStartTime = fromPeakTimeStartTime != null?fromPeakTimeStartTime.Value.ToDateTimeorNull() : null;

                objMaster.FromEndTime = tillPeakTimeStartTime != null?tillPeakTimeStartTime.Value.ToDateTimeorNull() : null;

                objMaster.TillStartTime = fromOffPeakFromEndTime != null?fromOffPeakFromEndTime.Value.ToDateTimeorNull() : null;

                objMaster.TillEndTime = tillOffPeakToEndTime != null?tillOffPeakToEndTime.Value.ToDateTimeorNull() : null;

                objMaster.FromStartRate           = FromStartRate;
                objMaster.FromStartRateValidMiles = FromValidMiles;
                objMaster.TillStartRate           = TillStartRate;
                objMaster.TillStartRateValidMiles = TillValidMiles;
                objMaster.StartRate           = StartRate;
                objMaster.StartRateValidMiles = ValidMiles;
                //



                string[] skipProperties = { "Gen_Location",      "Gen_Location1", "Gen_LocationType",
                                            "Gen_LocationType1", "Fare",          "Gen_Zone1",       "Gen_Zone","Fare_ZoneWisePricing1", "Fare_ZoneWisePricing" };



                // PDA METER

                IList <Fare_PDAMeter> savedList3           = objMaster.Current.Fare_PDAMeters;
                List <Fare_PDAMeter>  listofpdaOtherDetail = (from r in grdPDAOtherCharges.Rows
                                                              select new Fare_PDAMeter
                {
                    Id = r.Cells[COLS_OTHERDETAILS.ID].Value.ToLong(),
                    FareId = r.Cells[COLS_OTHERDETAILS.FAREID].Value.ToInt(),
                    FromMile = r.Cells[COLS_OTHERDETAILS.FROMMILE].Value.ToDecimal(),
                    ToMile = r.Cells[COLS_OTHERDETAILS.TOMILE].Value.ToDecimal(),
                    Rate = r.Cells[COLS_OTHERDETAILS.FARE].Value.ToDecimal(),


                    FromStartTime = fromPeakTimeStartTime != null ? string.Format("{0:dd/MM/yyyy HH:mm}", dateValue.ToDate() + r.Cells[COLS_OTHERDETAILS.FROMSTARTTIME].Value.ToDateTimeorNull().Value.TimeOfDay).ToDateTime() : dateValue,
                    TillStartTime = tillPeakTimeStartTime != null? string.Format("{0:dd/MM/yyyy HH:mm}", dateValue.ToDate() + r.Cells[COLS_OTHERDETAILS.TILLSTARTTIME].Value.ToDateTimeorNull().Value.TimeOfDay).ToDateTime():dateValue,

                    FromEndTime = fromOffPeakFromEndTime != null? string.Format("{0:dd/MM/yyyy HH:mm}", dateValue.ToDate() + r.Cells[COLS_OTHERDETAILS.FROMENDTIME].Value.ToDateTimeorNull().Value.TimeOfDay).ToDateTime():dateValue,
                    TillEndTime = tillOffPeakToEndTime != null ? string.Format("{0:dd/MM/yyyy HH:mm}", dateValue.ToDate() + r.Cells[COLS_OTHERDETAILS.TILLENDTIME].Value.ToDateTimeorNull().Value.TimeOfDay).ToDateTime() : dateValue,
                    PeakTimeRate = HasOffPeakRate ? r.Cells[COLS_OTHERDETAILS.PEAKRATE].Value.ToDecimal() : 0,
                    OffPeakTimeRate = HasOffPeakRate ? r.Cells[COLS_OTHERDETAILS.OFFPEAKRATE].Value.ToDecimal() : 0,
                }).ToList();


                Utils.General.SyncChildCollection(ref savedList3, ref listofpdaOtherDetail, "Id", skipProperties);

                objMaster.UpdateStartRates = true;
                objMaster.Save();

                General.RefreshListWithoutSelected <frmFaresList>("frmFaresList1");
            }
            catch (Exception ex)
            {
                if (objMaster.Errors.Count > 0)
                {
                    ENUtils.ShowMessage(objMaster.ShowErrors());
                }
                else
                {
                    ENUtils.ShowMessage(ex.Message);
                }
            }
        }