/// <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); } } } }
/// <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 }); } }
/// <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 }); } }
/// <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 }); } }
public ActionResult Index() { var repo = new Repository.Repository(); var calculations = repo.GetCalculations(); return(View(calculations)); }
/// <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); } } }
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); } }
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); }
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) })); }
/// <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 }); } }
/// <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 }); } }
/// <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 }); } }
public void SalvarPontos(int pontos) { var usuario = Request.Cookies["usuario"].Value; var rp = new Repository.Repository(); rp.SalvarPontos(usuario, pontos); }
/// <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; }
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")); }
/// <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 }); } }
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); } } } }
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>(); }
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>(); }
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" } } })); }
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; }
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>")); }
static void Main(string[] args) { Repository.RepoInterface<Leguma> repo = new Repository.Repository<Leguma>(); Controller.Controller ctrl = new Controller.Controller(repo); }