예제 #1
0
        public static void bill_Water_Add(Guid id)
        {
            var Water_use = Context.Water_usage.Where(x => x.invoiceperiods_id == id).ToList();

            foreach (var i in Water_use)
            {
                var data = new bill_Water_usage
                {
                    Uid              = Guid.NewGuid(),
                    Water_usage_id   = i.Uid,
                    water_usagefirst = water_usagefirst(i.customer_services_id),
                    water_usageafter = i.water_Unit,
                    unit             = i.water_Unit - water_usagefirst(i.customer_services_id),
                    service_charge   = 5,
                    Minimum_rate     = Minimum_rate(i.water_Unit - water_usagefirst(i.customer_services_id)),
                    price            = ((i.water_Unit - water_usagefirst(i.customer_services_id)) * 7) + 5 + Minimum_rate(i.water_Unit - water_usagefirst(i.customer_services_id)),
                    status           = bill_Water_usage.Statusbill.Wait
                };
                Context.bill_Water_usage.Add(data);
                Context.SaveChanges();
            }
        }
예제 #2
0
        public static void bill_Water_Add(Guid id)
        {
            AssetDbContext Context   = new AssetDbContext();
            var            Water_use = Context.Water_usage.Where(x => x.invoiceperiods_id == id).ToList();

            foreach (var i in Water_use)
            {
                var data = new bill_Water_usage
                {
                    Uid              = Guid.NewGuid(),
                    Water_usage_id   = i.Uid,
                    water_usagefirst = 0,
                    water_usageafter = i.water_Unit,
                    unit             = 0 - i.water_Unit,
                    service_charge   = 15,
                    Minimum_rate     = 35,
                    price            = (0 - i.water_Unit) * 5,
                    status           = bill_Water_usage.Statusbill.Wait
                };
                Context.bill_Water_usage.Add(data);
                Context.SaveChanges();
            }
        }