Ejemplo n.º 1
0
        public ActionResult Create([Bind(Include = "Id, Employee, PaymentGroup, Month, Opening, NormalLoans, IncomingLoans, Restitution, OutgoingLoans, SalaryPayment, CashPayment")] MonthlyBalance monthlyBalance)
        {
            Db db = new Db(DbServices.ConnectionString);

            if (ModelState.IsValid)
            {
                try
                {
                    MonthlyBalanceServices.Insert(CurrentUser.Id, monthlyBalance, db);
                    TempData["Success"] = ResourceServices.GetString(Cf.Data.Resources.ResourceBase.Culture, "UI", "InsertConfirmed");
                    return(RedirectToAction("Index"));
                }
                catch (CfException cfex)
                {
                    TempData["Failure"] = cfex.ErrorDefinition.LocalizedMessage;
                }
                catch (Exception ex)
                {
                    TempData["Failure"] = ex.Message;
                }
            }

            ViewBag.EmployeeList     = new SelectList(EmployeeServices.List(db), "Id", "FirstName");
            ViewBag.PaymentGroupList = new SelectList(PaymentGroupServices.List(db), "Id", "Name");
            return(View(monthlyBalance));
        }
Ejemplo n.º 2
0
        // GET: MonthlyBalance/Delete/5
        public ActionResult Delete(Nullable <int> id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }

            Db             db             = new Db(DbServices.ConnectionString);
            MonthlyBalance monthlyBalance = MonthlyBalanceServices.Get(id.Value, db);

            if (monthlyBalance == null)
            {
                return(HttpNotFound());
            }
            return(View(monthlyBalance));
        }
Ejemplo n.º 3
0
        // GET: MonthlyBalance/Edit/5
        public ActionResult Edit(Nullable <int> id)
        {
            Db db = new Db(DbServices.ConnectionString);

            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            MonthlyBalance monthlyBalance = MonthlyBalanceServices.Get(id.Value, db);

            if (monthlyBalance == null)
            {
                return(HttpNotFound());
            }

            ViewBag.EmployeeList     = new SelectList(EmployeeServices.List(db), "Id", "FirstName", monthlyBalance.Employee);
            ViewBag.PaymentGroupList = new SelectList(PaymentGroupServices.List(db), "Id", "Name", monthlyBalance.PaymentGroup);
            return(View(monthlyBalance));
        }
        public async Task <BaseResponse> Create(MonthlyBalanceDto monthlyBalance)
        {
            var response = new BaseResponse();

            User currentUser = await _requestDataService.GetCurrentUser();

            var currentMonthlyBalance = await _monthlyBalanceRepository.GetNewestMonthlyBalance(currentUser.UserId);

            if (currentMonthlyBalance != null && currentMonthlyBalance.ValidUntil > DateTime.Now)
            {
                response.Infos.Errors.Add($"You already have a monthly balance until {currentMonthlyBalance.ValidUntil.ToString("dd.MM.yyyy")}. Please delete it first to set a new one.");
                response.StatusCode = HttpStatusCode.Conflict;
                return(response);
            }

            MonthlyBalanceDtoValidator validator = new MonthlyBalanceDtoValidator();
            var result = validator.Validate(monthlyBalance);

            if (!result.IsValid)
            {
                response.Infos.Errors.AddRange(result.Errors.ToList().Select(error => error.ErrorMessage));
                response.StatusCode = HttpStatusCode.UnprocessableEntity;
                return(response);
            }

            var newMonthlyBalance = new MonthlyBalance
            {
                ValidUntil = monthlyBalance.ValidUntil,
                AvailableMonthlyBalance = monthlyBalance.AvailableMonthlyBalance,
                BalanceUser             = currentUser
            };

            var dbBalance = await _monthlyBalanceRepository.Insert(newMonthlyBalance);

            dbBalance.BalanceUser = null;

            response.Data.Add("balance", dbBalance);

            return(response);
        }
        public void Upload()
        {
            var file = Request.Form.Files[0];

            // Get content of your Excel file
            var ms = new MemoryStream();

            file.CopyTo(ms);


            //Excel File Read
            try
            {
                string heading = ExcelReader.GetCellValue(ms, "Sheet1", "A1");

                string[] headingChunks = heading.Split(' ');
                string   year          = headingChunks.Last();
                int      lastTwoIndex  = headingChunks.Count() - 2;
                string   month         = headingChunks[lastTwoIndex];
                string   iMonthNo      = Convert.ToDateTime("01-" + month + "-" + year).Month.ToString("D2");
                string   idString      = year + iMonthNo;
                int      orderNo       = Int32.Parse(idString);

                List <MonthlyBalance> monthlyAccBalancesToInsert = new List <MonthlyBalance>();

                //Account R&D

                MonthlyBalance monthlyBalanceRDToInsert = new MonthlyBalance();
                monthlyBalanceRDToInsert.Id        = Guid.NewGuid();
                monthlyBalanceRDToInsert.Account   = accountDataService.GetAccountsByName(ExcelReader.GetCellValue(ms, "Sheet1", "A3"));
                monthlyBalanceRDToInsert.AddedTime = DateTime.Now;
                monthlyBalanceRDToInsert.Balance   = ExcelReader.GetCellValue(ms, "Sheet1", "B3");
                monthlyBalanceRDToInsert.IsLatest  = true;
                monthlyBalanceRDToInsert.Month     = month + " " + year;
                monthlyBalanceRDToInsert.Order     = orderNo;
                monthlyBalanceRDToInsert.AddedBy   = User.Identity.Name;

                monthlyAccBalancesToInsert.Add(monthlyBalanceRDToInsert);

                //Canteen

                MonthlyBalance monthlyBalanceCanteenToInsert = new MonthlyBalance();
                monthlyBalanceCanteenToInsert.Id        = Guid.NewGuid();
                monthlyBalanceCanteenToInsert.Account   = accountDataService.GetAccountsByName(ExcelReader.GetCellValue(ms, "Sheet1", "A4"));
                monthlyBalanceCanteenToInsert.AddedTime = DateTime.Now;
                monthlyBalanceCanteenToInsert.Balance   = ExcelReader.GetCellValue(ms, "Sheet1", "B4");
                monthlyBalanceCanteenToInsert.IsLatest  = true;
                monthlyBalanceCanteenToInsert.Month     = month + " " + year;
                monthlyBalanceCanteenToInsert.Order     = orderNo;
                monthlyBalanceCanteenToInsert.AddedBy   = User.Identity.Name;

                monthlyAccBalancesToInsert.Add(monthlyBalanceCanteenToInsert);

                //CEO’s car

                MonthlyBalance monthlyBalanceCarToInsert = new MonthlyBalance();
                monthlyBalanceCarToInsert.Id        = Guid.NewGuid();
                monthlyBalanceCarToInsert.Account   = accountDataService.GetAccountsByName(ExcelReader.GetCellValue(ms, "Sheet1", "A5"));
                monthlyBalanceCarToInsert.AddedTime = DateTime.Now;
                monthlyBalanceCarToInsert.Balance   = ExcelReader.GetCellValue(ms, "Sheet1", "B5");
                monthlyBalanceCarToInsert.IsLatest  = true;
                monthlyBalanceCarToInsert.Month     = month + " " + year;
                monthlyBalanceCarToInsert.Order     = orderNo;
                monthlyBalanceCarToInsert.AddedBy   = User.Identity.Name;

                monthlyAccBalancesToInsert.Add(monthlyBalanceCarToInsert);

                //Marketing

                MonthlyBalance monthlyBalanceMarketingToInsert = new MonthlyBalance();
                monthlyBalanceMarketingToInsert.Id        = Guid.NewGuid();
                monthlyBalanceMarketingToInsert.Account   = accountDataService.GetAccountsByName(ExcelReader.GetCellValue(ms, "Sheet1", "A6"));
                monthlyBalanceMarketingToInsert.AddedTime = DateTime.Now;
                monthlyBalanceMarketingToInsert.Balance   = ExcelReader.GetCellValue(ms, "Sheet1", "B6");
                monthlyBalanceMarketingToInsert.IsLatest  = true;
                monthlyBalanceMarketingToInsert.Month     = month + " " + year;
                monthlyBalanceMarketingToInsert.Order     = orderNo;
                monthlyBalanceMarketingToInsert.AddedBy   = User.Identity.Name;

                monthlyAccBalancesToInsert.Add(monthlyBalanceMarketingToInsert);

                //Parking fines

                MonthlyBalance monthlyBalanceParkingToInsert = new MonthlyBalance();
                monthlyBalanceParkingToInsert.Id        = Guid.NewGuid();
                monthlyBalanceParkingToInsert.Account   = accountDataService.GetAccountsByName(ExcelReader.GetCellValue(ms, "Sheet1", "A7"));
                monthlyBalanceParkingToInsert.AddedTime = DateTime.Now;
                monthlyBalanceParkingToInsert.Balance   = ExcelReader.GetCellValue(ms, "Sheet1", "B7");
                monthlyBalanceParkingToInsert.IsLatest  = true;
                monthlyBalanceParkingToInsert.Month     = month + " " + year;
                monthlyBalanceParkingToInsert.Order     = orderNo;
                monthlyBalanceParkingToInsert.AddedBy   = User.Identity.Name;

                monthlyAccBalancesToInsert.Add(monthlyBalanceParkingToInsert);


                accountDataService.AddAccounts(monthlyAccBalancesToInsert);
            }

            //CSV File Read
            catch (Exception e)
            {
                try
                {
                    TextReader textReader = new StreamReader(ms);
                    string     heading    = textReader.ReadLine();

                    string[] headingChunks = heading.Split(' ');
                    string   year          = headingChunks.Last();
                    int      lastTwoIndex  = headingChunks.Count() - 2;
                    string   month         = headingChunks[lastTwoIndex];
                    string   iMonthNo      = Convert.ToDateTime("01-" + month + "-" + year).Month.ToString("D2");
                    string   idString      = year + iMonthNo;
                    int      orderNo       = Int32.Parse(idString);

                    var csv = new CsvReader(textReader);

                    csv.Configuration.HasHeaderRecord = false;

                    var balances = csv.GetRecords <MonthlyAccountBalanceViewModel>().ToList();

                    List <MonthlyBalance> monthlyAccBalancesToInsert = new List <MonthlyBalance>();

                    foreach (MonthlyAccountBalanceViewModel monthlyBalancesAcc in balances)
                    {
                        MonthlyBalance monthlyBalanceRecToInsert = new MonthlyBalance();
                        monthlyBalanceRecToInsert.Id        = Guid.NewGuid();
                        monthlyBalanceRecToInsert.Account   = accountDataService.GetAccountsByName(monthlyBalancesAcc.DisplayAccountName);
                        monthlyBalanceRecToInsert.AddedTime = DateTime.Now;
                        monthlyBalanceRecToInsert.Balance   = monthlyBalancesAcc.DisplayAccountBalance;
                        monthlyBalanceRecToInsert.IsLatest  = true;
                        monthlyBalanceRecToInsert.Month     = month + " " + year;
                        monthlyBalanceRecToInsert.Order     = orderNo;
                        monthlyBalanceRecToInsert.AddedBy   = User.Identity.Name;

                        monthlyAccBalancesToInsert.Add(monthlyBalanceRecToInsert);
                    }

                    accountDataService.AddAccounts(monthlyAccBalancesToInsert);
                }
                catch (Exception)
                {
                    throw;
                }
            }
        }