コード例 #1
0
        public async Task <IActionResult> Edit(int id, [Bind("CashInBankId,CIBDate,OpenningBalance,ClosingBalance,CashIn,CashOut")] CashInBank cashInBank)
        {
            if (id != cashInBank.CashInBankId)
            {
                return(NotFound());
            }

            if (ModelState.IsValid)
            {
                try
                {
                    _context.Update(cashInBank);
                    await _context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!CashInBankExists(cashInBank.CashInBankId))
                    {
                        return(NotFound());
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction(nameof(Index)));
            }
            return(PartialView(cashInBank));
        }
コード例 #2
0
        public async Task <ActionResult <CashInBank> > PostCashInBank(CashInBank cashInBank)
        {
            _context.CashInBanks.Add(cashInBank);
            await _context.SaveChangesAsync();

            return(CreatedAtAction("GetCashInBank", new { id = cashInBank.CashInBankId }, cashInBank));
        }
コード例 #3
0
        public async Task <IActionResult> PutCashInBank(int id, CashInBank cashInBank)
        {
            if (id != cashInBank.CashInBankId)
            {
                return(BadRequest());
            }

            _context.Entry(cashInBank).State = EntityState.Modified;

            try
            {
                await _context.SaveChangesAsync();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!CashInBankExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(NoContent());
        }
コード例 #4
0
        public static AccountsInfo GetAccoutingRecord(AprajitaRetailsContext db)
        {
            AccountsInfo info = new AccountsInfo();
            CashInHand   cih  = db.CashInHands.Where(c => (c.CIHDate) == (DateTime.Today)).FirstOrDefault();

            if (cih != null)
            {
                info.CashInHand  = cih.InHand; info.CashIn = cih.CashIn; info.CashOut = cih.CashOut;
                info.OpenningBal = cih.OpenningBalance;
            }

            CashInBank cib = db.CashInBanks.Where(c => (c.CIBDate) == (DateTime.Today)).FirstOrDefault();

            if (cib != null)
            {
                info.CashToBank = cib.CashIn; info.CashFromBank = cib.CashOut;
                info.CashInBank = cib.InHand;
            }

            var CashExp = db.PettyCashExpenses.Where(c => (c.ExpDate) == (DateTime.Today));
            var CashPay = db.CashPayments.Where(c => (c.PaymentDate) == (DateTime.Today));

            if (CashExp != null)
            {
                info.TotalCashPayments = (decimal?)CashExp.Sum(c => (decimal?)c.Amount) ?? 0;
            }
            if (CashPay != null)
            {
                info.TotalCashPayments += (decimal?)CashPay.Sum(c => (decimal?)c.Amount) ?? 0;
            }
            return(info);
        }
コード例 #5
0
        public ActionResult DeleteConfirmed(int id)
        {
            CashInBank cashInBank = db.CashInBanks.Find(id);

            db.CashInBanks.Remove(cashInBank);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
コード例 #6
0
 public ActionResult Edit([Bind(Include = "CashInBankId,CIBDate,OpenningBalance,ClosingBalance,CashIn,CashOut")] CashInBank cashInBank)
 {
     if (ModelState.IsValid)
     {
         db.Entry(cashInBank).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(cashInBank));
 }
コード例 #7
0
        public ActionResult Create([Bind(Include = "CashInBankId,CIBDate,OpenningBalance,ClosingBalance,CashIn,CashOut")] CashInBank cashInBank)
        {
            if (ModelState.IsValid)
            {
                db.CashInBanks.Add(cashInBank);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(cashInBank));
        }
コード例 #8
0
        //StoreBased Action
        public void ProcessBankOpenningBalance(eStoreDbContext db, DateTime date, int StoreId, bool saveit = false)
        {
            CashInBank today;

            today = db.CashInBanks.Where(c => c.CIBDate.Date == date.Date && c.StoreId == StoreId).FirstOrDefault();

            DateTime   yDate     = date.AddDays(-1);
            CashInBank yesterday = db.CashInBanks.Where(c => c.CIBDate.Date == yDate.Date && c.StoreId == StoreId).FirstOrDefault();

            bool isNew = false;

            if (today == null)
            {
                today = new CashInBank()
                {
                    CashIn = 0, CashOut = 0, CIBDate = date, ClosingBalance = 0, OpenningBalance = 0, StoreId = StoreId
                };
                isNew = true;
            }

            if (yesterday == null)
            {
                yesterday = new CashInBank()
                {
                    CashIn = 0, CashOut = 0, CIBDate = yDate, ClosingBalance = 0, OpenningBalance = 0, StoreId = StoreId
                };
                today.OpenningBalance = 0;
                today.ClosingBalance  = today.OpenningBalance + today.CashIn - today.CashOut;
                db.CashInBanks.Add(yesterday);
            }
            else
            {
                yesterday.ClosingBalance = yesterday.OpenningBalance + yesterday.CashIn - yesterday.CashOut;

                today.OpenningBalance = yesterday.ClosingBalance;
                today.ClosingBalance  = today.OpenningBalance + today.CashIn - today.CashOut;

                db.Entry(yesterday).State = EntityState.Modified;
            }

            if (isNew)
            {
                db.CashInBanks.Add(today);
            }
            else
            {
                db.Entry(today).State = EntityState.Modified;
            }

            if (saveit)
            {
                db.SaveChanges();
            }
        }
コード例 #9
0
        public async Task <IActionResult> Create([Bind("CashInBankId,CIBDate,OpenningBalance,ClosingBalance,CashIn,CashOut")] CashInBank cashInBank)
        {
            if (ModelState.IsValid)
            {
                _context.Add(cashInBank);
                await _context.SaveChangesAsync();

                return(RedirectToAction(nameof(Index)));
            }
            return(PartialView(cashInBank));
        }
コード例 #10
0
        public async Task <IActionResult> Create([Bind("CashInBankId,CIBDate,OpenningBalance,ClosingBalance,CashIn,CashOut,StoreId")] CashInBank cashInBank)
        {
            if (ModelState.IsValid)
            {
                _context.Add(cashInBank);
                await _context.SaveChangesAsync();

                return(RedirectToAction(nameof(Index)));
            }
            ViewData["StoreId"] = new SelectList(_context.Stores, "StoreId", "StoreId", cashInBank.StoreId);
            return(View(cashInBank));
        }
コード例 #11
0
        public static void UpDateCashOutBank(AprajitaRetailsContext db, DateTime dateTime, decimal Amount, bool saveit = false)
        {
            CashInBank cashIn = db.CashInBanks.Where(d => d.CIBDate == dateTime).FirstOrDefault();

            if (cashIn != null)
            {
                cashIn.CashOut += Amount;
                db.SaveChanges();
            }
            else
            {
                CreateCashInBank(db, dateTime, 0, Amount, saveit);
            }
        }
コード例 #12
0
        // GET: CashInBanks/Delete/5
        public ActionResult Delete(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            CashInBank cashInBank = db.CashInBanks.Find(id);

            if (cashInBank == null)
            {
                return(HttpNotFound());
            }
            return(View(cashInBank));
        }
コード例 #13
0
        public static void UpdateCashInBank(eStoreDbContext db, DateTime dateTime, decimal Amount, bool saveit = false)
        {
            //throw new NotImplementedException();
            CashInBank cashIn = db.CashInBanks.Where(d => d.CIBDate == dateTime).FirstOrDefault();

            if (cashIn != null)
            {
                cashIn.CashIn += Amount;
                db.SaveChanges();
            }
            else
            {
                CreateCashInBank(db, dateTime, Amount, 0, saveit);
            }
        }
コード例 #14
0
ファイル: Utils.cs プロジェクト: war-man/TAS_AprajiataRetails
 public static void UpDateCashOutBank(AprajitaRetailsContext db, DateTime dateTime, decimal Amount, bool saveit = false)
 {
     {
         CashInBank cashIn = db.CashInBanks.Where(d => d.CIBDate == dateTime).FirstOrDefault();
         if (cashIn != null)
         {
             cashIn.CashOut += Amount;
             db.SaveChanges();
         }
         else
         {
             //  db.CashInBanks.Add(new CashInBank() { CIBDate = dateTime, CashIn = 0, OpenningBalance = 0, ClosingBalance = 0, CashOut = Amount });
             //if (saveit) db.SaveChanges();
             CreateCashInBank(db, dateTime, 0, Amount, saveit);
         }
     }
 }
コード例 #15
0
        public static void CreateCashInBank(eStoreDbContext db, DateTime date, decimal inAmt, decimal outAmt, bool saveit = false)
        {
            //throw new NotImplementedException();

            CashInBank today;

            DateTime   yDate     = date.AddDays(-1);
            CashInBank yesterday = db.CashInBanks.Where(c => c.CIBDate == yDate).FirstOrDefault();


            today = new CashInBank()
            {
                CashIn = inAmt, CashOut = outAmt, CIBDate = date, ClosingBalance = 0, OpenningBalance = 0
            };

            if (yesterday != null)
            {
                yesterday.ClosingBalance = yesterday.OpenningBalance + yesterday.CashIn - yesterday.CashOut;
                today.ClosingBalance     = today.OpenningBalance = yesterday.ClosingBalance;
                db.CashInBanks.Add(today);
                if (saveit)
                {
                    db.SaveChanges();
                }
            }
            else
            {
                //TODO: need to option to create cashinbank entry for all missing entry and correct
                //if (db.CashInBanks.Count() > 0)
                //    throw new Exception();
                //else
                {
                    today.ClosingBalance = today.OpenningBalance = 0;
                    db.CashInBanks.Add(today);
                    if (saveit)
                    {
                        db.SaveChanges();
                    }
                }
            }
        }
コード例 #16
0
ファイル: Utils.cs プロジェクト: war-man/TAS_AprajiataRetails
        public static void CreateCashInBank(AprajitaRetailsContext db, DateTime date, decimal inAmt, decimal outAmt, bool saveit = false)
        {
            CashInBank today;

            DateTime   yDate     = date.AddDays(-1);
            CashInBank yesterday = db.CashInBanks.Where(c => c.CIBDate == yDate).FirstOrDefault();


            today = new CashInBank()
            {
                CashIn = inAmt, CashOut = outAmt, CIBDate = date, ClosingBalance = 0, OpenningBalance = 0
            };

            if (yesterday != null)
            {
                yesterday.ClosingBalance = yesterday.OpenningBalance + yesterday.CashIn - yesterday.CashOut;
                today.ClosingBalance     = today.OpenningBalance = yesterday.ClosingBalance;
                db.CashInBanks.Add(today);
                if (saveit)
                {
                    db.SaveChanges();
                }
            }
            else
            {
                if (db.CashInBanks.Count() > 0)
                {
                    throw new Exception();
                }
                else
                {
                    today.ClosingBalance = today.OpenningBalance = 0;
                    db.CashInBanks.Add(today);
                    if (saveit)
                    {
                        db.SaveChanges();
                    }
                }
            }
        }
コード例 #17
0
        public async Task <IActionResult> Create([Bind("CashInBankID,Amount,AmountInWords,BankID,CompanyID,CreatedBy,CreationDate,CurrencyID,Date,DepositedBy,ExternalRef,Particulars,PartiesID")] CashInBank cashInBank)
        {
            string CompId = User.Claims.Where(r => r.Type == "CompanyID").FirstOrDefault().Value;
            int    CompID = Convert.ToInt32(CompId);

            cashInBank.CompanyID    = CompID;
            cashInBank.CreatedBy    = User.Identity.Name;
            cashInBank.CreationDate = DateTime.Now;

            if (ModelState.IsValid)
            {
                _context.Add(cashInBank);
                await _context.SaveChangesAsync();

                int CIB = cashInBank.CashInBankID;

                CashFlow CF2 = new CashFlow();
                CF2.Credit       = cashInBank.Amount;
                CF2.CashInBankID = CIB;
                CF2.CompanyID    = CompID;
                CF2.PartiesID    = cashInBank.PartiesID;
                // Party Credit
                int?PartyTransID   = _context.Parties.Where(r => r.CompanyID == CompID).Where(r => r.PartiesID == cashInBank.PartiesID).FirstOrDefault().TransactionAccountID;
                int PartMainAcc1_2 = _context.MainAccount.Where(r => r.CompanyID == CompID).Where(r => r.MainAccountNumber == "00").FirstOrDefault().MainAccountID;
                int PartSubAcc1_2  = _context.SubAccount.Where(r => r.CompanyID == CompID).Where(r => r.SubAccountNumber == "0000").FirstOrDefault().SubAccountID;

                CF2.MainAccountID        = PartMainAcc1_2;
                CF2.SubAccountID         = PartSubAcc1_2;
                CF2.TransactionAccountID = (int)PartyTransID;
                CF2.VoucherType          = "Cash In Bank Voucher";
                CF2.DateCreation         = DateTime.Now.Date;
                //   CF2.Narration =

                _context.CashFlow.Add(CF2);
                await _context.SaveChangesAsync();

                CashFlow CF3 = new CashFlow();
                CF3.Debit        = cashInBank.Amount;
                CF3.CashInBankID = CIB;
                CF3.CompanyID    = CompID;
                CF3.PartiesID    = cashInBank.PartiesID;
                // Bank Debit
                int?bankID      = cashInBank.BankID;
                int transBankID = _context.Bank.Where(r => r.CompanyID == CompID).Where(r => r.BankID == bankID).FirstOrDefault().TransactionAccountID;
                int MainAccID_3 = _context.MainAccount.Where(r => r.CompanyID == CompID).Where(r => r.MainAccountNumber == "01").FirstOrDefault().MainAccountID;
                int SubAccID_3  = _context.SubAccount.Where(r => r.CompanyID == CompID).Where(r => r.MainAccountID == MainAccID_3).Where(r => r.SubAccountNumber == "0002").FirstOrDefault().SubAccountID;

                CF3.MainAccountID        = MainAccID_3;
                CF3.SubAccountID         = SubAccID_3;
                CF3.TransactionAccountID = transBankID;
                CF3.VoucherType          = "Cash In Bank Voucher";
                CF3.DateCreation         = DateTime.Now.Date;

                _context.CashFlow.Add(CF3);
                await _context.SaveChangesAsync();

                if (User.IsInRole("CompanyAdmin"))
                {
                    return(RedirectToAction("Index"));
                }
                else
                {
                    return(RedirectToAction("Index", "Home", new { area = "CompanyUser" }));
                }
            }
            ViewData["BankID"]     = new SelectList(_context.Bank.Where(r => r.CompanyID == CompID), "BankID", "BankName", cashInBank.BankID);
            ViewData["CurrencyID"] = new SelectList(_context.Currency.Where(r => r.CompanyID == CompID), "CurrencyID", "CurrencyName", cashInBank.CurrencyID);
            ViewData["PartiesID"]  = new SelectList(_context.Parties.Where(r => r.CompanyID == CompID), "PartiesID", "PartyName", cashInBank.PartiesID);
            return(View(cashInBank));
        }
コード例 #18
0
ファイル: Utils.cs プロジェクト: war-man/TAS_AprajiataRetails
        public static void ProcessOpenningClosingBankBalance(AprajitaRetailsContext db, DateTime date, bool isclosing = false, bool saveit = false)
        {
            if (!isclosing)
            {
                CashInBank today;
                today = db.CashInBanks.Where(c => DbFunctions.TruncateTime(c.CIBDate) == DbFunctions.TruncateTime(date)).FirstOrDefault();
                DateTime   yDate     = date.AddDays(-1);
                CashInBank yesterday = db.CashInBanks.Where(c => DbFunctions.TruncateTime(c.CIBDate) == DbFunctions.TruncateTime(yDate)).FirstOrDefault();

                if (today == null)
                {
                    today = new CashInBank()
                    {
                        CashIn = 0, CashOut = 0, CIBDate = date, ClosingBalance = 0, OpenningBalance = 0
                    };

                    if (yesterday != null)
                    {
                        yesterday.ClosingBalance = yesterday.OpenningBalance + yesterday.CashIn - yesterday.CashOut;
                        today.ClosingBalance     = today.OpenningBalance = yesterday.ClosingBalance;
                        db.CashInBanks.Add(today);
                        if (saveit)
                        {
                            db.SaveChanges();
                        }
                    }
                    else
                    {
                        if (db.CashInBanks.Count() > 0)
                        {
                            throw new Exception();
                        }
                        else
                        {
                            today.ClosingBalance = today.OpenningBalance = 0;
                            db.CashInBanks.Add(today);
                            if (saveit)
                            {
                                db.SaveChanges();
                            }
                        }
                    }
                }
                else
                {
                    if (yesterday != null)
                    {
                        today.ClosingBalance  = today.OpenningBalance = yesterday.ClosingBalance;
                        db.Entry(today).State = EntityState.Modified;
                        if (saveit)
                        {
                            db.SaveChanges();
                        }
                    }
                    else
                    {
                        if (db.CashInBanks.Count() > 1)
                        {
                            throw new Exception();
                        }
                        else
                        {
                            today.ClosingBalance  = today.OpenningBalance = 0;
                            db.Entry(today).State = EntityState.Modified;
                            if (saveit)
                            {
                                db.SaveChanges();
                            }
                        }
                    }
                }
            }
            else
            {
                //ClosingBalance;
                CashInBank today;
                today = db.CashInBanks.Where(c => DbFunctions.TruncateTime(c.CIBDate) == DbFunctions.TruncateTime(date)).FirstOrDefault();

                if (today != null)
                {
                    if (today.ClosingBalance != today.OpenningBalance + today.CashIn - today.CashOut)
                    {
                        today.ClosingBalance  = today.OpenningBalance + today.CashIn - today.CashOut;
                        db.Entry(today).State = EntityState.Modified;
                        if (saveit)
                        {
                            db.SaveChanges();
                        }
                    }
                }
                else
                {
                    //TODO: Implement this on urgent basis
                    throw new Exception();
                }
            }
        }