예제 #1
0
        public EditIncomingModel(Incoming incoming)
        {
            EditedIncoming = incoming;
            ApplicationDbContext db = new ApplicationDbContext();

            Banks         = new SelectList(db.Banks, "Id", "BankName", EditedIncoming.BankId);
            Companies     = new SelectList(db.Counterparties, "Id", "Name", EditedIncoming.CounterpartyId);
            Categories    = new SelectList(db.IncomingCategorys, "Id", "IncomingCategoryName", EditedIncoming.IncomingCategoryId);
            Types         = new SelectList(db.IncomingTypes, "Id", "TypeName", incoming.IncomingTypeId);
            WayOfPayments = new SelectList(db.WayOfPayments, "Id", "WayOfPaymentName", EditedIncoming.WayOfPaymentId);

            if (EditedIncoming.BankId != null)
            {
                SelectedBankId = db.Banks.Where(b => b.Id == incoming.Bank.Id).First().Id;
            }
            SelectedIncomingCategory = db.IncomingCategorys.Where(ic => ic.Id == incoming.IncomingCategory.Id).First().Id;
            SelectedIncomingType     = db.IncomingTypes.Where(it => it.Id == incoming.IncomingType.Id).First().Id;
            SelectedWayOfPayment     = db.WayOfPayments.Where(w => w.Id == incoming.WayOfPayment.Id).First().Id;
        }
예제 #2
0
파일: DbInit.cs 프로젝트: vinil2001/finance
        public static void Init()
        {
            ApplicationDbContext Db = new ApplicationDbContext();

            Bank newBank = new Bank()
            {
                Id = 0, BankName = "PrivatBank"
            };
            Bank newBank2 = new Bank()
            {
                Id = 1, BankName = "UkrSibBank"
            };

            Db.Banks.Add(newBank);
            Db.Banks.Add(newBank2);

            OwnershipType newOwnershipType = new OwnershipType()
            {
                Id = 0, OwnershipTypeName = "TOV"
            };
            OwnershipType newOwnershipType2 = new OwnershipType()
            {
                Id = 1, OwnershipTypeName = "PP"
            };

            Db.OwnershipTypes.Add(newOwnershipType);
            Db.OwnershipTypes.Add(newOwnershipType2);

            Counterparty newCounterparty = new Counterparty()
            {
                Name = "MetalHolding", OwneshipType = newOwnershipType
            };
            Counterparty newCounterparty2 = new Counterparty()
            {
                Name = "Парті", OwneshipType = newOwnershipType
            };

            Db.Counterparties.Add(newCounterparty);
            Db.Counterparties.Add(newCounterparty2);

            IncomingCategory newIncomingCategory = new IncomingCategory()
            {
                Id = 0, IncomingCategoryName = "Производство"
            };
            IncomingCategory newIncomingCategory2 = new IncomingCategory()
            {
                Id = 1, IncomingCategoryName = "Торговля"
            };

            Db.IncomingCategorys.Add(newIncomingCategory);
            Db.IncomingCategorys.Add(newIncomingCategory2);

            IncomingType newIncomingType = new IncomingType()
            {
                Id = 0, TypeName = "Технологическое"
            };
            IncomingType newIncomingType2 = new IncomingType()
            {
                Id = 1, TypeName = "ВЭД"
            };

            Db.IncomingTypes.Add(newIncomingType);
            Db.IncomingTypes.Add(newIncomingType2);

            WayOfPayment newWayOfPayment = new WayOfPayment()
            {
                Id = 0, WayOfPaymentName = "Bank"
            };
            WayOfPayment newWayOfPayment2 = new WayOfPayment()
            {
                Id = 1, WayOfPaymentName = "Cash"
            };

            Db.WayOfPayments.Add(newWayOfPayment);
            Db.WayOfPayments.Add(newWayOfPayment2);


            Incoming newIncoming = new Incoming()
            {
                Id               = 0,
                Bank             = newBank,
                Counterparty     = newCounterparty,
                IncomingData     = DateTime.Now,
                IncomingCategory = newIncomingCategory,
                IncomingSum      = 23456,
                IncomingType     = newIncomingType,
                InvoiceData      = DateTime.Now,
                InvoiceNumber    = 989898,
                Name             = " ",
                WayOfPayment     = newWayOfPayment
            };

            Db.Incomings.Add(newIncoming);
            Db.SaveChanges();
        }