示例#1
0
        public async Task <ActionResult> CreateAccount(FinAccountViewModel model)
        {
            try
            {
                if (ModelState.IsValid)
                {
                    var resp = await FinAccountModel.CreateAccount(model, User.Identity.Name);

                    if (resp.IsSuccess)
                    {
                        ViewData["SuccessAdd"] = $"تم إضافة الحساب {model.Code} - {model.NameAr} بنجاح";
                        model = null;
                    }
                    else
                    {
                        ModelState.AddModelError("", resp.Message);
                    }
                }
            }
            catch (Exception ex)
            {
            }

            ViewData["CurrenciesList"] = await FinAccountModel.GetCurrenciesList();

            ViewData["AcctsList"] = await FinAccountModel.GetAccountsList();

            return(View(model));
        }
示例#2
0
        public static async Task <GenericResponse <FinAccountViewModel> > CreateAccount(FinAccountViewModel model, string AddedBy)
        {
            var resp = new GenericResponse <FinAccountViewModel>();

            try
            {
                using (var context = new NeomSoftDBEntities())
                {
                    var isExist = context.Accounts.Any(e => e.Code == model.Code);
                    if (isExist)
                    {
                        resp.Message = "يوجد حساب بنفس الرقم";
                        return(resp);
                    }
                    else
                    {
                        var newAcct = new Account
                        {
                            Code            = model.Code,
                            NameAr          = model.NameAr,
                            ParentAccountID = model.ParentAccountID,
                            Note            = model.Note,
                            AddedBy         = AddedBy,
                            AddedDate       = DateTime.Now,
                        };

                        if (model.SelectedCurrencies?.Any() == true)
                        {
                            newAcct.AccountCurrencies = model.SelectedCurrencies.Select(e => new AccountCurrency
                            {
                                CurrencyID = e,
                                IsDeleted  = false,
                                AddedBy    = AddedBy,
                                AddedDate  = newAcct.AddedDate,
                            }).ToList();
                        }

                        context.Accounts.Add(newAcct);
                        await context.SaveChangesAsync();

                        model.AccountID = newAcct.AccountID;

                        resp.IsSuccess     = true;
                        resp.ReturnedValue = model;
                    }
                }
            }
            catch (Exception ex)
            {
                resp.IsSuccess = false;
            }

            return(resp);
        }
示例#3
0
        public static async Task <GenericResponse <FinAccountViewModel> > EditAccount(FinAccountViewModel model, string UserName)
        {
            var resp = new GenericResponse <FinAccountViewModel>();

            try
            {
                using (var context = new NeomSoftDBEntities())
                {
                    var account = await context.Accounts.FirstOrDefaultAsync(e => e.AccountID == model.AccountID && !e.IsDeleted);

                    if (account == null)
                    {
                        resp.Message = "الحساب غير موجود";
                        return(resp);
                    }

                    var isExist = context.Accounts.Any(e => e.Code == model.Code && e.AccountID != model.AccountID);
                    if (isExist)
                    {
                        resp.Message = "يوجد حساب بنفس الرقم";
                        return(resp);
                    }
                    else
                    {
                        account.Code            = model.Code;
                        account.NameAr          = model.NameAr;
                        account.ParentAccountID = model.ParentAccountID;
                        account.Note            = model.Note;
                        account.LastUpdatedBy   = UserName;
                        account.LastUpdatedDate = DateTime.Now;


                        var currAcctCurrencies = account.AccountCurrencies.Where(e => !e.IsDeleted).ToList();
                        var currCurrencyIDs    = currAcctCurrencies.Select(e => e.CurrencyID).ToList();

                        //delete the deleted currencies
                        var deletedCurrentyIDs    = currCurrencyIDs.Where(e => !model.SelectedCurrencies.Contains(e)).ToList();
                        var deletedAcctCurrencies = currAcctCurrencies.Where(e => deletedCurrentyIDs.Contains(e.CurrencyID)).ToList();
                        deletedAcctCurrencies.ForEach(e => e.IsDeleted = true);

                        // add new currencies to the account
                        var newCurrencies = model.SelectedCurrencies.Where(e => !currCurrencyIDs.Contains(e))
                                            .Select(e => new AccountCurrency {
                            CurrencyID = e,
                            AccountID  = account.AccountID,
                            IsDeleted  = false,
                            AddedBy    = UserName,
                            AddedDate  = account.LastUpdatedDate.Value,
                        }).ToList();



                        context.AccountCurrencies.AddRange(newCurrencies);
                        await context.SaveChangesAsync();


                        resp.IsSuccess     = true;
                        resp.ReturnedValue = model;
                    }
                }
            }
            catch (Exception ex)
            {
                resp.IsSuccess = false;
            }

            return(resp);
        }