/// <summary>
        /// Load data of Khach hang from Database
        /// </summary>
        public void LoadKhachHang(Repository.Repository repository)
        {
            this.listKhachHang = new List <Models.Customer>();

            string queryString = "select * from customer";

            repository.cmd.CommandText = queryString;

            using (DbDataReader reader = repository.cmd.ExecuteReader())
            {
                if (!reader.HasRows)
                {
                    MessageBox.Show(
                        "Data chưa có dữ liệu",
                        "Lỗi",
                        MessageBoxButtons.OK,
                        MessageBoxIcon.Error);
                    return;
                }
                else
                {
                    while (reader.Read())
                    {
                        Models.Customer temp = new Models.Customer(
                            reader.GetInt32(0),
                            reader.GetString(1),
                            reader.GetString(2),
                            reader.GetString(3),
                            reader.GetInt32(4),
                            reader.GetBoolean(5));
                        this.listKhachHang.Add(temp);
                    }
                }
            }
        }
Esempio n. 2
0
        /// <summary>
        /// Check login information
        /// </summary>
        /// <param name="username"></param>
        /// <param name="password"></param>
        /// <returns>user's data if user exist</returns>
        /// <returns>null user if user doesn't exist</returns>
        public User checkLogin(Repository.Repository repository, string username, string password)
        {
            // Using username to query from DB
            string queryString = "select* from User where username='******' and isDeleted=false";

            repository.cmd.CommandText = queryString;

            using (DbDataReader reader = repository.cmd.ExecuteReader())
            {
                if (!reader.HasRows)
                {
                    return(new User());
                }
                else
                {
                    User temp = new User();
                    while (reader.Read())
                    {
                        temp = new User(
                            reader.GetInt32(0),
                            reader.GetString(1),
                            reader.GetString(2),
                            reader.GetString(3),
                            reader.GetInt32(4));
                        break;
                    }
                    if (temp.password != password)
                    {
                        return(new User());
                    }
                    return(temp);
                }
            }
        }
        public Models.Customer LoadKhachHangByID(Repository.Repository repository, int id)
        {
            string queryString = $"select * from customer where id = {id}";

            repository.cmd.CommandText = queryString;

            using (DbDataReader reader = repository.cmd.ExecuteReader())
            {
                if (!reader.HasRows)
                {
                    MessageBox.Show(
                        "Data chưa có dữ liệu",
                        "Lỗi",
                        MessageBoxButtons.OK,
                        MessageBoxIcon.Error);
                    return(null);
                }
                else
                {
                    while (reader.Read())
                    {
                        Models.Customer temp = new Models.Customer(
                            reader.GetInt32(0),
                            reader.GetString(1),
                            reader.GetString(2),
                            reader.GetString(3),
                            reader.GetInt32(4),
                            reader.GetBoolean(5));
                        return(temp);
                    }
                }
            }
            return(null);
        }
        /// <summary>
        /// ثبت گروه تفصیلی جدید
        /// </summary>
        /// <param name="model">
        /// مدل پايه گروه تفصیلی
        /// </param>
        /// <returns></returns>
        public Models.ActionResultModelBinding InsertTafsiliGroupAccount(Models.TafsiliGroup model)
        {
            try
            {
                using (var repo = new Repository.Repository(this, "usp_insertTafisiliGroup"))
                {
                    repo.cmd.Parameters.AddWithValue("@code", model.Code);
                    repo.cmd.Parameters.AddWithValue("@title", model.Title);
                    repo.cmd.Parameters.AddWithValue("@editable", model.Editable);

                    repo.ExecuteNonQuery();
                    return(new Models.ActionResultModelBinding
                    {
                        Message = repo.rMsg,
                        Status = repo.rCode == 1 ? Models.ActionResult.Success : Models.ActionResult.Failed
                    });
                }
            }
            catch (Exception c)
            {
                return(new Models.ActionResultModelBinding
                {
                    Message = c.Message,
                    Status = Models.ActionResult.Failed
                });
            }
        }
Esempio n. 5
0
 /// <summary>
 /// ثبت حساب معین جديد
 /// </summary>
 /// <param name="model">
 /// مدل پايه حساب معین
 /// </param>
 /// <returns></returns>
 public Models.ActionResultModelBinding InsertMoinAccount(Models.Moin model)
 {
     try
     {
         using (var repo = new Repository.Repository(this, "usp_insertAccountingMoein"))
         {
             repo.cmd.Parameters.AddWithValue("@code", model.Code);
             repo.cmd.Parameters.AddWithValue("@title", model.Title);
             repo.cmd.Parameters.AddWithValue("@natureId", model.NatureId);
             repo.cmd.Parameters.AddWithValue("@isDefault", model.IsDefault);
             repo.cmd.Parameters.AddWithValue("@isPermanent", model.IsPermanent);
             repo.cmd.Parameters.AddWithValue("@kolId", model.KolId);
             var param = repo.cmd.Parameters.AddWithValue("@tafiliGroupList", model.TafsiliGroupBinding);
             param.SqlDbType = System.Data.SqlDbType.Structured;
             repo.ExecuteNonQuery();
             return(new Models.ActionResultModelBinding
             {
                 Message = repo.rMsg,
                 Status = repo.rCode == 1 ? Models.ActionResult.Success : Models.ActionResult.Failed
             });
         }
     }
     catch (Exception c)
     {
         return(new Models.ActionResultModelBinding
         {
             Message = c.Message,
             Status = Models.ActionResult.Failed
         });
     }
 }
Esempio n. 6
0
 /// <summary>
 /// ویرایش الگو
 /// </summary>
 /// <param name="model"></param>
 /// <returns></returns>
 public Models.ActionResultModelBinding UpdateTafsilAccountTemplate(Models.TafsilAccountTemplateModelBinding model)
 {
     try
     {
         using (var repo = new Repository.Repository(this, "usp_updateTafsilAccountTemplate"))
         {
             repo.cmd.Parameters.AddWithValue("@id", model.Id);
             repo.cmd.Parameters.AddWithValue("@entityId", model.EntityId);
             repo.cmd.Parameters.AddWithValue("@tafsiliGroupId", model.TafsiliGroupId);
             repo.cmd.Parameters.AddWithValue("@peopleGroupId", model.PeopleGroupId);
             repo.ExecuteNonQuery();
             return(new Models.ActionResultModelBinding
             {
                 Message = repo.rMsg,
                 Status = repo.rCode == 1 ? Models.ActionResult.Success : Models.ActionResult.Failed
             });
         }
     }
     catch (Exception c)
     {
         return(new Models.ActionResultModelBinding
         {
             Message = c.Message,
             Status = Models.ActionResult.Failed
         });
     }
 }
Esempio n. 7
0
        public ActionResult Index()
        {
            var repo         = new Repository.Repository();
            var calculations = repo.GetCalculations();

            return(View(calculations));
        }
Esempio n. 8
0
 /// <summary>
 /// ويرايش گروه اشخاص
 /// </summary>
 /// <param name="groupModel"></param>
 /// <returns></returns>
 public Models.ActionResultModelBinding UpdatePeopleGroup(Models.PeopleGroup groupModel)
 {
     try
     {
         using (var repo = new Repository.Repository(this, "usp_updatetPeopleGroup"))
         {
             repo.cmd.Parameters.AddWithValue("@id", groupModel.Id);
             repo.cmd.Parameters.AddWithValue("@code", groupModel.Code);
             repo.cmd.Parameters.AddWithValue("@title", groupModel.Title);
             repo.ExecuteNonQuery();
             return(new Models.ActionResultModelBinding
             {
                 Message = repo.rMsg,
                 Status = repo.rCode == 1 ? Models.ActionResult.Success : Models.ActionResult.Failed
             });
         }
     }
     catch (Exception c)
     {
         return(new Models.ActionResultModelBinding
         {
             Message = c.Message,
             Status = Models.ActionResult.Failed
         });
     }
 }
        /// <summary>
        /// Edit SanPham
        /// </summary>
        /// <param name="index"></param>
        /// <param name="sp"></param>
        public void UpdateSanPham(Repository.Repository repository, Models.Item sp)
        {
            string queryString = "update Item set name='" + sp.name +
                                 "',type='" + sp.type +
                                 "',amount=" + sp.amount +
                                 ",minimum=" + sp.minimum +
                                 ",provider='" + sp.provider +
                                 "',isRequestImport=" + sp.isImportOrder.ToString() +
                                 " where id=" + sp.ID;

            repository.cmd.CommandText = queryString;
            try
            {
                repository.cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                MessageBox.Show(
                    "Có lỗi xảy ra trong quá trình cập nhật dữ liệu, vui lòng thử lại!\nChi tiết: " + ex.StackTrace,
                    "Lỗi",
                    MessageBoxButtons.OK,
                    MessageBoxIcon.Error);
            }
            this.LoadSanPham(repository);
        }
        /// <summary>
        /// دريافت ليست انواع اسناد
        /// </summary>
        /// <param name="_pageNo">
        /// شماره صفحه
        /// </param>
        /// <param name="_seedNumber">
        /// تعداد ركوردهاي مدنظر براي مشاهده در خروجي
        /// </param>
        /// <returns></returns>
        public Models.SelectResultModelBinding <Models.PublicResultModel> GettDocumentTypes(short _pageNo = 0, short _seedNumber = 10, string search = null)
        {
            try
            {
                using (var repo = new Repository.Repository(this, "usp_getDocumentTypeList", true))
                {
                    pageNo     = _pageNo;
                    seedNumber = _seedNumber;


                    repo.ExecuteAdapter();
                    var info = repo.ds.Tables[0].AsEnumerable();

                    return(new Models.SelectResultModelBinding <Models.PublicResultModel>
                    {
                        Body = info.Select(i => new Models.PublicResultModel()
                        {
                            Id = Convert.ToInt32(i.Field <object>("id")),
                            Title = Convert.ToString(i.Field <object>("title")),
                        }).ToList(),
                        TotalCount = repo.totalCount
                    });
                }
            }
            catch (Exception c)
            {
                System.Windows.MessageBox.Show(c.Message);
                return(null);
            }
        }
        public Models.Item GetItemByID(Repository.Repository repository, int id)
        {
            string queryString = "select* from Item where id=" + id;

            repository.cmd.CommandText = queryString;

            using (DbDataReader reader = repository.cmd.ExecuteReader())
            {
                if (!reader.HasRows)
                {
                    return(new Models.Item());
                }
                else
                {
                    Models.Item temp = new Models.Item();
                    while (reader.Read())
                    {
                        temp = new Models.Item(
                            reader.GetInt32(0),
                            reader.GetString(1),
                            reader.GetString(2),
                            reader.GetInt64(3),
                            reader.GetInt64(4),
                            reader.GetString(5),
                            reader.GetBoolean(6));
                        break;
                    }
                    return(temp);
                }
            }
        }
Esempio n. 12
0
 public void Execute(IJobExecutionContext context)
 {
     try
     {
         var portfolio = new Repository.Repository().GetPortfolio().Result;
         if (!portfolio.Any())
         {
             for (int i = 45; i > 0; i--)
             {
                 var date          = DateTime.Now.AddDays(-i);
                 var buyOrSellInfo =
                     FindStocksToBuyOrSell(date).Where(
                         s => s.Value.Item1 >= DistinctByers || s.Value.Item2 >= DistinctSelles).ToDictionary(
                         item => item.Key, item => item.Value);
                 UpdatePortfolio(buyOrSellInfo, date);
             }
         }
         else
         {
             var date          = DateTime.Now.AddDays(-1);
             var buyOrSellInfo =
                 FindStocksToBuyOrSell(date).Where(
                     i => i.Value.Item1 >= DistinctByers || i.Value.Item2 >= DistinctSelles).ToDictionary(
                     i => i.Key, i => i.Value);
             UpdatePortfolio(buyOrSellInfo, date);
         }
         Logger.AddMessage("[OK] FindAndStoreActionJob " + DateTime.Now);
     }
     catch (Exception ex) {
         Logger.AddMessage("[ERROR] FindAndStoreActionJob " + ex.InnerException);
     }
 }
Esempio n. 13
0
        public bool ChecarUsuario(string login)
        {
            try
            {
                var ret = new Repository.Repository();
                var obj = new Entity.Usuario()
                {
                    nome = login
                };

                if (ret.ChecarUsuario(login).idusuario > 0)
                {
                    return(true);
                }

                //return ret2;

                //return new Repository.Repository().ChecarUsuario(login);
            }
            catch (Exception ex)
            {
                new Exception(ex.Message.ToString());
            }
            // return new Entity.Usuario();

            return(false);
        }
Esempio n. 14
0
        public IActionResult TDMSFailedTradesSave(string idList, int tdxfailurereason, string resolveddate, string comment)
        {
            ViewBag.idList = idList;
            var rep = new Repository.Repository(_context);

            return(Json(new { success = rep.TdmsFailedTradesSave(idList, tdxfailurereason, resolveddate, comment, User.Identity.Name) }));
        }
Esempio n. 15
0
 /// <summary>
 /// حذف يك گروه حساب
 /// </summary>
 /// <param name="groupModel"></param>
 /// <returns></returns>
 public Models.ActionResultModelBinding RemovePeopleGroup(Models.PeopleGroup groupModel, bool confirmDeleteSubdivision)
 {
     try
     {
         using (var repo = new Repository.Repository(this, "usp_deletePeopleGroup"))
         {
             repo.cmd.Parameters.AddWithValue("@id", groupModel.Id);
             //repo.cmd.Parameters.AddWithValue("@confirmDeleteSubdivision", confirmDeleteSubdivision);
             repo.ExecuteNonQuery();
             return(new Models.ActionResultModelBinding
             {
                 Message = repo.rMsg,
                 Status = repo.rCode == 1 ? Models.ActionResult.Success : Models.ActionResult.Failed
             });
         }
     }
     catch (Exception c)
     {
         return(new Models.ActionResultModelBinding
         {
             Message = c.Message,
             Status = Models.ActionResult.Failed
         });
     }
 }
Esempio n. 16
0
        /// <summary>
        /// دريافت ليست گروه هاي اشخاص
        /// </summary>
        /// <param name="_pageNo">
        /// شماره صفحه
        /// </param>
        /// <param name="_seedNumber">
        /// تعداد ركوردهاي مدنظر براي مشاهده در خروجي
        /// </param>
        /// <returns></returns>
        public Models.SelectResultModelBinding <Models.PeopleGroup> GetPeopleGroup(short _pageNo = 0, short _seedNumber = 10, string search = null)
        {
            try
            {
                using (var repo = new Repository.Repository(this, "usp_getPeopleGroupList", true))
                {
                    pageNo     = _pageNo;
                    seedNumber = _seedNumber;
                    repo.cmd.Parameters.AddWithValue("@search", search);
                    repo.ExecuteAdapter();
                    var info = repo.ds.Tables[0].AsEnumerable();
                    return(new Models.SelectResultModelBinding <Models.PeopleGroup>
                    {
                        Body = info.Select(i => new Models.PeopleGroup
                        {
                            Id = Convert.ToInt32(i.Field <object>("id")),
                            Code = Convert.ToString(i.Field <object>("code")),
                            Title = Convert.ToString(i.Field <object>("title")),

                            SaveDateTime = Convert.ToDateTime(i.Field <object>("save_datetime"))
                        }).ToList(),
                        TotalCount = repo.totalCount
                    });
                }
            }
            catch (Exception c)
            {
                System.Windows.MessageBox.Show(c.Message);
                return(null);
            }
        }
 /// <summary>
 /// ویرایش الگوی سند
 /// </summary>
 /// <param name="model"></param>
 /// <returns></returns>
 public Models.ActionResultModelBinding UpdatetDocumentTemplate(Models.DocumnetTemplateModelBinding model)
 {
     try
     {
         using (var repo = new Repository.Repository(this, "usp_updateAccountingDocumentTemplate"))
         {
             repo.cmd.Parameters.AddWithValue("@id", model.Id);
             repo.cmd.Parameters.AddWithValue("@title", model.Title);
             repo.cmd.Parameters.AddWithValue("@descriptionHead", model.DescriptionHeader);
             repo.cmd.Parameters.AddWithValue("@documentTypeId", model.DocumentTypeId);
             repo.cmd.Parameters.AddWithValue("@accountCode", model.TafsilCode);
             repo.cmd.Parameters.AddWithValue("@natureId", model.NatureId);
             repo.cmd.Parameters.AddWithValue("@descriptionRow", model.DescriptionRow);
             repo.ExecuteNonQuery();
             return(new Models.ActionResultModelBinding
             {
                 Message = repo.rMsg,
                 Status = repo.rCode == 1 ? Models.ActionResult.Success : Models.ActionResult.Failed
             });
         }
     }
     catch (Exception c)
     {
         return(new Models.ActionResultModelBinding
         {
             Message = c.Message,
             Status = Models.ActionResult.Failed
         });
     }
 }
Esempio n. 18
0
        /// <summary>
        /// ثبت مرکز هزینه جديد
        /// </summary>
        /// <param name="groupModel">
        /// مدل پايه مرکز هزینه
        /// </param>
        /// <returns></returns>
        public Models.ActionResultModelBinding InsertCostCenter(Models.CostCenter groupModel)
        {
            try
            {
                using (var repo = new Repository.Repository(this, "usp_insertCostCenter"))
                {
                    repo.cmd.Parameters.AddWithValue("@code", groupModel.Code);
                    repo.cmd.Parameters.AddWithValue("@title", groupModel.Title);

                    repo.ExecuteNonQuery();
                    return(new Models.ActionResultModelBinding
                    {
                        Message = repo.rMsg,
                        Status = repo.rCode == 1 ? Models.ActionResult.Success : Models.ActionResult.Failed
                    });
                }
            }
            catch (Exception c)
            {
                return(new Models.ActionResultModelBinding
                {
                    Message = c.Message,
                    Status = Models.ActionResult.Failed
                });
            }
        }
Esempio n. 19
0
        public void SalvarPontos(int pontos)
        {
            var usuario = Request.Cookies["usuario"].Value;
            var rp      = new Repository.Repository();

            rp.SalvarPontos(usuario, pontos);
        }
Esempio n. 20
0
 /// <summary>
 /// The explicit constructor of the Controller class
 /// </summary>
 /// <param name="repository">A Repositroy, the class that handles the CRUD data</param>
 public Controller(Repository.Repository repository)
 {
     this.repository       = repository;
     this.currentQuestion  = 0;
     this.correctQuestions = 0;
     this.wrongQuestions   = 0;
 }
Esempio n. 21
0
        public ActionResult PaymentOk()
        {
            var saleModel = BaseController.SaleController.GetSale();

            Repository.Repository rep = new Repository.Repository();

            var result = rep.Pay(new PaymentModel.PayRequest(saleModel)
            {
                CreditCardModel = new PaymentModel.CreditCard
                {
                    CreditCardName = "Samet ÇINAR",
                    CardNumber     = "5571135571135575",
                    ExpiryMonth    = "12",
                    ExpiryYear     = "2018",
                    CVV            = "000"
                }
            });

            if (result.IsPay)
            {
                //Ödeme başarılı ise..
                var paymentModel = new LibraryModel.PaymentModel
                {
                    Name  = "PayU Ödeme",
                    Price = saleModel.RemainingPrice
                };
                saleModel.AddPayment(paymentModel);
                saleModel.SaveChanges();
            }
            return(RedirectToAction("Result"));
        }
Esempio n. 22
0
 /// <summary>
 /// ويرايش حساب کل
 /// </summary>
 /// <param name="kolModel"></param>
 /// <returns></returns>
 public Models.ActionResultModelBinding UpdateKolAccount(Models.Kol kolModel)
 {
     try
     {
         using (var repo = new Repository.Repository(this, "usp_updateAccountingKol"))
         {
             repo.cmd.Parameters.AddWithValue("@id", kolModel.Id);
             repo.cmd.Parameters.AddWithValue("@code", kolModel.Code);
             repo.cmd.Parameters.AddWithValue("@title", kolModel.Title);
             repo.cmd.Parameters.AddWithValue("@natureId", kolModel.NatureId);
             repo.cmd.Parameters.AddWithValue("@isDefault", kolModel.IsDefault);
             repo.cmd.Parameters.AddWithValue("@groupId", kolModel.GroupId);
             repo.ExecuteNonQuery();
             return(new Models.ActionResultModelBinding
             {
                 Message = repo.rMsg,
                 Status = repo.rCode == 1 ? Models.ActionResult.Success : Models.ActionResult.Failed
             });
         }
     }
     catch (Exception c)
     {
         return(new Models.ActionResultModelBinding
         {
             Message = c.Message,
             Status = Models.ActionResult.Failed
         });
     }
 }
        /// <summary>
        /// Delete the order
        /// </summary>
        /// <param name="repository"></param>
        /// <param name="data"></param>
        public void DeleteItemOrder(Repository.Repository repository, Models.ItemOrder data, InitPage parent)
        {
            string queryString = "update ItemOrder set isDeleted=true where id=" + data.ID;

            Console.WriteLine(queryString);
            repository.cmd.CommandText = queryString;
            try
            {
                repository.cmd.ExecuteNonQuery();
                for (int i = 0; i < data.listSP.Count; i++)
                {
                    data.listSP[i].isImportOrder = false;
                    this.UpdateSanPham(repository, data.listSP[i]);
                }
                this.LoadSanPhamOrder(repository);
                parent.LoadSPOrderCallback();

                this.LoadSanPham(repository);
                parent.dataSanPham = this.listSanPham;
                parent.LoadSanPhamCallback();
                parent.selectedBillIndex = -1;
            }
            catch (Exception ex)
            {
                MessageBox.Show(
                    "Có lỗi xảy ra trong quá trình cập nhật dữ liệu, vui lòng thử lại!\nChi tiết: " + ex.StackTrace,
                    "Lỗi",
                    MessageBoxButtons.OK,
                    MessageBoxIcon.Error);
            }
        }
        /// <summary>
        /// ثبت سال مالی جديد
        /// </summary>
        /// <param name="model">
        /// مدل پايه سال مالی
        /// </param>
        /// <returns></returns>
        public Models.ActionResultModelBinding InsertFiscalYear(Models.FiscalYear model)
        {
            try
            {
                using (var repo = new Repository.Repository(this, "usp_insertFiscalYear"))
                {
                    repo.cmd.Parameters.AddWithValue("@title", model.Title);
                    repo.cmd.Parameters.AddWithValue("@startDate", model.StartDate);
                    repo.cmd.Parameters.AddWithValue("@endDate", model.EndDate);
                    repo.cmd.Parameters.AddWithValue("@taxable", model.Taxable);
                    repo.cmd.Parameters.AddWithValue("@taxes", model.Taxes);
                    repo.cmd.Parameters.AddWithValue("@duties", model.Duties);
                    repo.cmd.Parameters.AddWithValue("@is_active", model.IsActive);

                    repo.ExecuteNonQuery();
                    return(new Models.ActionResultModelBinding
                    {
                        Message = repo.rMsg,
                        Status = repo.rCode == 1 ? Models.ActionResult.Success : Models.ActionResult.Failed
                    });
                }
            }
            catch (Exception c)
            {
                return(new Models.ActionResultModelBinding
                {
                    Message = c.Message,
                    Status = Models.ActionResult.Failed
                });
            }
        }
Esempio n. 25
0
        private static void UpdatePortfolio(Dictionary <string, Tuple <int, int> > buyOrSellInfo, DateTime forDate)
        {
            foreach (var item in buyOrSellInfo)
            {
                var stock  = item.Key;
                var isSell = (item.Value.Item2 > DistinctSelles);
                var isBuy  = (item.Value.Item1 >= DistinctByers) && !isSell;


                var repository  = new Repository.Repository();
                var stockEntity = repository.GetPortfolio().Result.FirstOrDefault(s => s.Stock.Equals(stock));
                var ticker      = repository.GetTickers().FirstOrDefault(t => t.FullName.Equals(stock));
                //post in not one of the stocks in list to follow
                if (ticker == null)
                {
                    continue;
                }
                var price = QuoteService.GetHistoricalPrice(ticker.TickerName, forDate);
                if (price.Last == null)
                {
                    continue;
                }

                var addBuyToPortfolio  = (stockEntity == null && isBuy);
                var addSellToPortfolio = stockEntity != null && isSell;
                var calcPrice          = Double.Parse(price.Last, System.Globalization.CultureInfo.InvariantCulture);
                var number             = 10000 / Double.Parse(price.Last,
                                                              System.Globalization.CultureInfo.
                                                              InvariantCulture);

                if (addBuyToPortfolio)
                {
                    repository.StoreTransaction(stock, forDate, "Köp", number, calcPrice, 10000, 0);
                    repository.AddPostToPortfolio(new Portfolio
                    {
                        Stock        = stock,
                        BuyPrice     = calcPrice,
                        BuyAmount    = 10000,
                        BuyNumber    = number,
                        BuyDate      = forDate,
                        CurrentPrice = calcPrice
                    }
                                                  );
                }
                else if (addSellToPortfolio)
                {
                    if (forDate > stockEntity.BuyDate)
                    {
                        var entity = repository.Context.Portfolio.First(i => i.Id.Equals(stockEntity.Id));
                        repository.Context.Portfolio.Remove(entity);
                        repository.SaveChanges();
                        var todaysPrice = Double.Parse(QuoteService.GetTodaysPrice(ticker.TickerName).Last, System.Globalization.CultureInfo.InvariantCulture);
                        repository.StoreTransaction(stock, forDate, "Försäljning", stockEntity.BuyNumber, todaysPrice,
                                                    (calcPrice * stockEntity.BuyNumber),
                                                    (calcPrice * stockEntity.BuyNumber) - 10000);
                    }
                }
            }
        }
Esempio n. 26
0
 public AccountBiz()
 {
     repository = new Repository.Repository();
     Mapper.CreateMap <Client, POCO.Client>();
     Mapper.CreateMap <POCO.Client, Client>();
     Mapper.CreateMap <Account, POCO.Account>();
     Mapper.CreateMap <POCO.Account, Account>();
 }
Esempio n. 27
0
        public async Task <JsonResult> GetNotifyList(int tdTradet)
        {
            var rep        = new Repository.Repository(_context);
            var notifyList = await
                             rep.GetTradeRepairLogN(User.Identity.Name, tdTradet);

            return(Json(notifyList.ToList()));
        }
 public AccountBiz()
 {
     repository = new Repository.Repository();
     Mapper.CreateMap<Client, POCO.Client>();
     Mapper.CreateMap<POCO.Client, Client>();
     Mapper.CreateMap<Account, POCO.Account>();
     Mapper.CreateMap<POCO.Account, Account>();
 }
Esempio n. 29
0
        public JsonResult DeleteSort(string sortId)
        {
            var repo = new Repository.Repository(_context);

            repo.DeleteSort(sortId);
            // Take sort name and username and remove it
            return(Json(new { items = new[] { new { result = "true" } } }));
        }
Esempio n. 30
0
 public ChiPhiController(ILoaiChiPhiRepo loaiChiPhiRepo, IDoanRepo doanRepo, Repository.Repository repo, IChiPhiRepo chiPhiRepo)
 {
     this.loaiChiPhiRepo = loaiChiPhiRepo;
     this.doanRepo       = doanRepo;
     this.tourRepo       = tourRepo;
     this.repo           = repo;
     this.chiPhiRepo     = chiPhiRepo;
 }
Esempio n. 31
0
        public async Task <IActionResult> UpdateDetail(UspReturnTradeDetail tradeDetailVModel)
        {
            var rep = new Repository.Repository(_context);

            return(await rep.UpdateDetail(tradeDetailVModel, User.Identity.Name) > 0
                ? (ActionResult)
                   Content("<script language='javascript' type='text/javascript'>alert('Updated'); window.location='" + Request.Headers["referer"] + "'</script>")
                : Content("<script language='javascript' type='text/javascript'>alert('Not updated!');</script>"));
        }
Esempio n. 32
0
 static void Main(string[] args)
 {
     Repository.RepoInterface<Leguma> repo = new Repository.Repository<Leguma>();
     Controller.Controller ctrl = new Controller.Controller(repo);
 }