public async Task <ActionResult> DeleteConfirmed(int id)
        {
            OpenDay openDay = await db.OpenDays.FindAsync(id);

            db.OpenDays.Remove(openDay);
            await db.SaveChangesAsync();

            return(RedirectToAction("Index"));
        }
        public async Task <ActionResult> Edit([Bind(Include = "OpenDayId,OpenDate,CompanyId,UserName")] OpenDay openDay)
        {
            if (ModelState.IsValid)
            {
                db.Entry(openDay).State = EntityState.Modified;
                await db.SaveChangesAsync();

                return(RedirectToAction("Index"));
            }
            ViewBag.CompanyId = new SelectList(db.Companies, "CompanyId", "Name", openDay.CompanyId);
            return(View(openDay));
        }
        public ActionResult Create(OpenDay view)
        {
            var response = MovementsHelper.NewCollectionTmp(view, User.Identity.Name);

            if (ModelState.IsValid)
            {
                //db.OpenDays.Add(openDay);
                //await db.SaveChangesAsync();
                return(RedirectToAction("Index"));
            }

            ViewBag.CompanyId = new SelectList(db.Companies, "CompanyId", "Name", view.CompanyId);
            return(View(view));
        }
        // GET: OpenDays/Details/5
        public async Task <ActionResult> Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            OpenDay openDay = await db.OpenDays.FindAsync(id);

            if (openDay == null)
            {
                return(HttpNotFound());
            }
            return(View(openDay));
        }
        // GET: OpenDays/Edit/5
        public async Task <ActionResult> Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            OpenDay openDay = await db.OpenDays.FindAsync(id);

            if (openDay == null)
            {
                return(HttpNotFound());
            }
            ViewBag.CompanyId = new SelectList(db.Companies, "CompanyId", "Name", openDay.CompanyId);
            return(View(openDay));
        }
        // GET: OpenDays/Create
        public ActionResult Create()
        {
            var user = db.Users.Where(u => u.UserName == User.Identity.Name).FirstOrDefault();

            ViewBag.CompanyId = new SelectList(CombosHelper.GetCompanies(), "CompanyId", "Name", user.CompanyId);

            var view = new OpenDay
            {
                CompanyId = user.CompanyId,
                OpenDate  = DateTime.Today,
                UserName  = user.UserName,
                OnOff     = true,
            };

            return(View(view));
        }
Exemple #7
0
        public static Response NewCollectionTmp(OpenDay view, string userName)
        {
            using (var transacction = db.Database.BeginTransaction())
            {
                try
                {
                    var user           = db.Users.Where(u => u.UserName == userName).FirstOrDefault();
                    var mainWareHouses = db.MainWarehouses.Where(w => w.CompanyId == user.CompanyId).ToList();
                    var wareHouses     = db.Warehouses.Where(w => w.CompanyId == view.CompanyId).ToList();

                    var disbursedLoans = db.DisbursedLoans.Where(wH => wH.CompanyId == view.CompanyId).Where(cA => cA.StateId == 2).ToList();

                    //var lastOpenDay = db.OpenDays.Where(od => od.CompanyId == view.CompanyId).Where(of => of.OnOff == true).FirstOrDefault();
                    //lastOpenDay.OnOff = false;
                    //db.Entry(lastOpenDay).State = EntityState.Modified;

                    var openDay = new OpenDay
                    {
                        OpenDate  = DateTime.Today,
                        CompanyId = user.CompanyId,
                        UserName  = user.UserName,
                        OnOff     = true,
                    };
                    db.OpenDays.Add(openDay);
                    db.SaveChanges();

                    foreach (MainWarehouse mainWarehouse in mainWareHouses)
                    {
                        var mainInventory = new MainInventory
                        {
                            MainWarehouseId       = mainWarehouse.MainWarehouseId,
                            CompanyId             = view.CompanyId,
                            Date                  = openDay.OpenDate,
                            Collection            = 0,
                            Pettycash             = 0,
                            Administrativeexpense = 0,
                            Subtotal              = 0,
                            Renewedcredit         = 0,
                            Total                 = 0,
                            WareHouseInitialLoan  = 0,
                            WareHouseTotalLoan    = 0,
                            WareHouseTotalBalance = 0,
                        };
                        db.MainInventories.Add(mainInventory);
                    }

                    foreach (Warehouse warehouse in wareHouses)
                    {
                        var inventory = new Inventory
                        {
                            WarehouseId           = warehouse.WarehouseId,
                            CompanyId             = view.CompanyId,
                            Date                  = openDay.OpenDate,
                            Collection            = 0,
                            Pettycash             = 0,
                            Administrativeexpense = 0,
                            Subtotal              = 0,
                            Renewedcredit         = 0,
                            Total                 = 0,
                            InitialLoan           = 0,
                            TotalLoan             = 0,
                            TotalBalance          = 0,
                        };
                        db.Inventories.Add(inventory);
                    }

                    foreach (DisbursedLoan detailDL in disbursedLoans)
                    {
                        var collectionTmp = new CollectionTmp
                        {
                            CompanyId       = detailDL.CompanyId,
                            WarehouseId     = detailDL.WarehouseId,
                            DisbursedLoanId = detailDL.DisbursedLoanId,
                            UserName        = userName,
                            LoanState       = detailDL.LoanState,
                            CollectionDate  = openDay.OpenDate,
                            Payment         = 0,
                            CurrentBalance  = detailDL.Balance,
                        };
                        db.CollectionTmps.Add(collectionTmp);
                    }

                    db.SaveChanges();

                    transacction.Commit();
                    return(new Response {
                        Succeeded = true,
                    });
                }
                catch (Exception ex)
                {
                    transacction.Rollback();
                    return(new Response
                    {
                        Message = ex.Message,
                        Succeeded = false,
                    });
                }
            }
        }
 public OpenDayCombo(string pDisp, string pValue, OpenDay pOd)
 {
     _disp = pDisp;
     _value = pValue;
     _OD = pOd;
 }