public ActionResult UpdateRate(string fromDate, string toDate, int?page) { const int pageSize = 3; int pageNumber = (page ?? 1); var model = new RateModel(); var rate = db.Rates.First(); if (rate != null) { model.Rate = rate; if (!string.IsNullOrEmpty(fromDate) && !string.IsNullOrEmpty(toDate)) { var fromdate = DateTime.ParseExact(fromDate, "dd/MM/yyyy", CultureInfo.InvariantCulture); var todate = DateTime.ParseExact(toDate, "dd/MM/yyyy", CultureInfo.InvariantCulture); var rateHistories = (from rateHistory in db.RateHistorys where fromdate <= rateHistory.LastUpdate && rateHistory.LastUpdate <= todate select rateHistory).ToList(); model.ListRateHistory = rateHistories.ToPagedList(pageNumber, pageSize); } model.ListRateHistory = db.RateHistorys.OrderByDescending(a => a.LastUpdate).Take(10).ToPagedList(pageNumber, pageSize); } return(View(model)); }
public ActionResult GenerateInvoice() { if (Request.IsAuthenticated) { string user_id = User.Identity.GetUserId(); //Request List List <RequestHistories> request_list = db.RequestHistories.Where(x => x.user_id == user_id && x.payment_status == "unpaid").OrderByDescending(m => m.request_date).ToList(); //Number of request ViewBag.no_of_item = request_list.Count(); //ViewBag.amt_per_item = Convert.ToInt32(ConfigurationManager.AppSettings["amt_per_unit"]);//amount payable in each request for verification ViewBag.amt_per_item = RateModel.getCurrentRate(); ViewBag.total = ViewBag.no_of_item * ViewBag.amt_per_item;//Total amount payable List <RequestViewModel> invoice_list = new List <RequestViewModel>(); foreach (RequestHistories row in request_list) { invoice_list.Add(new RequestViewModel(row)); } return(View(invoice_list)); } else { return(RedirectToAction("Login", "Account")); } }
public async Task <IActionResult> RateBoardGame(string id, RateModel model) { try { var user = await _hexadoUserService.GetSingleOrMaybeAsync(u => u.Email == UserEmail); if (!user.HasValue) { return(Unauthorized()); } var result = await _rateService.RateBoardGame( model.ToBoardGameRateEntity( user.Value.Id, id)); return(result.HasValue ? OkJson(result.Value) : NotFound()); } catch (Exception ex) { _logger.LogError(ex, "Error while applying rate to board game! " + $"Id: {id}"); return(InternalServerErrorJson(ex)); } }
public static List <RateModel> ImportRatesFromXml(string filePath, string currencyCode) { List <RateModel> rates = new List <RateModel>(); string currencyTag = GlobalConfig.GetAppConfig("CurrencyXml_TagPrefix") + currencyCode; XDocument doc = XDocument.Load(filePath); XNamespace ns = doc.Root.Name.Namespace; if (doc.Descendants(ns + currencyTag).FirstOrDefault() != null) { var elements = doc.Descendants(ns + GlobalConfig.GetAppConfig("RateXml_RowTag")); foreach (XElement elem in elements) { RateModel tempModel = new RateModel(); string date = elem.Element(ns + GlobalConfig.GetAppConfig("RateXml_DateTag")).Value; string rate = elem.Element(ns + currencyTag).Value; rate = rate.Replace(',', '.'); tempModel.rate_date = Convert.ToDateTime(date); tempModel.rate = Convert.ToDecimal(rate); rates.Add(tempModel); } } return(rates); }
public ActionResult UpdateRateByManger(RateModel obj) { SqlConnection conn = new SqlConnection(_conString); SqlCommand cmd = new SqlCommand("Garbage", conn); cmd.Parameters.Add(new SqlParameter("@Title", SqlDbType.NVarChar) { Value = obj.Title }); cmd.Parameters.Add(new SqlParameter("@Rate", SqlDbType.NVarChar) { Value = obj.Rate }); cmd.Parameters.Add(new SqlParameter("@RateId", SqlDbType.NVarChar) { Value = obj.RateId }); cmd.Parameters.Add(new SqlParameter("@Action", SqlDbType.NVarChar) { Value = "UpdateRateByManger" }); cmd.CommandTimeout = 99999; cmd.CommandType = CommandType.StoredProcedure; conn.Open(); int result = cmd.ExecuteNonQuery(); conn.Close(); return(Json(result, JsonRequestBehavior.AllowGet)); }
public object rate(RateModel rates) { try { if (rates == null) { rates.Amount = 1; rates.CurrencyCode = "USD"; } if (!supportedCurrencies.Contains(rates.CurrencyCode)) { return(new { err = "Currency not supported", returncode = -2 }); } return(GetResponse(rates.CurrencyCode, rates.Amount)); } catch (Exception ex) { return(new { err = "Please try again later", returncode = -1 }); } }
public ActionResult Rates(RateModel model) { if (ModelState.IsValid) { var _db = new SquareDanceDb(); try { var userId = User.Identity.GetUserId(); var rates = _db.ServiceAndRate.Find(userId); if (rates != null) { rates.DogBoardingFee = model.DogBoardingFee; rates.DoggyDayCareFee = model.DoggyDayCareFee; rates.DogWalkingFee = model.DogWalkingFee; rates.DropInVisitsFee = model.DropInVisitsFee; rates.HouseSittingFee = model.HouseSittingFee; _db.SaveChanges(); } } catch (Exception e) { logger.Error("An error occurred while SaveRates. Error: " + e); } finally { _db.Dispose(); } return(RedirectToAction("ServiceOptions", "Sitter")); } return(View(model)); }
public static bool ActualizarTarifas(RateModel model) { using (var dc = new TurismoDataContext()) { var cupounidad = dc.CupoUnidads.SingleOrDefault(s => s.IDCUPOUNIDAD == model.Id); if (cupounidad != null) { cupounidad.MONTO = model.MontoRACDTR; cupounidad.MONTO_EXT_CD_TR = model.MontoEXTCDTR ?? cupounidad.MONTO_EXT_CD_TR; cupounidad.MONTO_MER_CD_TR = model.MontoMERCDTR ?? cupounidad.MONTO_MER_CD_TR; cupounidad.MONTO_RA_SD_TR = model.MontoRASDTR ?? cupounidad.MONTO_RA_SD_TR; cupounidad.MONTO_EXT_SD_TR = model.MontoEXTSDTR ?? cupounidad.MONTO_EXT_SD_TR; cupounidad.MONTO_MER_SD_TR = model.MontoMERSDTR ?? cupounidad.MONTO_MER_SD_TR; cupounidad.MONTO_RA_CD_TNR = model.MontoRACDTNR ?? cupounidad.MONTO_RA_CD_TNR; cupounidad.MONTO_EXT_CD_TNR = model.MontoEXTCDTNR ?? cupounidad.MONTO_EXT_CD_TNR; cupounidad.MONTO_MER_CD_TNR = model.MontoMERCDTNR ?? cupounidad.MONTO_MER_CD_TNR; cupounidad.MONTO_RA_SD_TNR = model.MontoRASDTNR ?? cupounidad.MONTO_RA_SD_TNR; cupounidad.MONTO_EXT_SD_TNR = model.MontoEXTSDTNR ?? cupounidad.MONTO_EXT_SD_TNR; cupounidad.MONTO_MER_SD_TNR = model.MontoMERSDTNR ?? cupounidad.MONTO_MER_SD_TNR; dc.SubmitChanges(); return(true); } } return(false); }
public static bool SaveRate(RateModel rate) { if (rate != null) { using (var dc = new TurismoDataContext()) { var tarifas = dc.CupoUnidads.SingleOrDefault(s => s.IDCUPOUNIDAD == rate.Id); tarifas.CUPOMAXIMO = rate.CupoMaximo; tarifas.CUPORESERVADO = rate.CupoReservado; tarifas.MONTO = rate.MontoRACDTR; tarifas.MONTO_EXT_CD_TR = rate.MontoEXTCDTR; tarifas.MONTO_MER_CD_TR = rate.MontoMERCDTR; tarifas.MONTO_RA_SD_TR = rate.MontoRASDTR; tarifas.MONTO_EXT_SD_TR = rate.MontoEXTSDTR; tarifas.MONTO_MER_SD_TR = rate.MontoMERSDTR; tarifas.MONTO_RA_CD_TNR = rate.MontoRACDTNR; tarifas.MONTO_EXT_CD_TNR = rate.MontoEXTCDTNR; tarifas.MONTO_MER_CD_TNR = rate.MontoMERCDTNR; tarifas.MONTO_RA_SD_TNR = rate.MontoRASDTNR; tarifas.MONTO_EXT_SD_TNR = rate.MontoEXTSDTNR; tarifas.MONTO_MER_SD_TNR = rate.MontoMERSDTNR; dc.SubmitChanges(); } return(true); } return(false); }
public double GetRateByDate(DateTime date, string currencyCode) { currencyCode = currencyCode.ToUpper(); string changedUrl = string.Format(URL, date.ToString("yyyy-MM-dd"), currencyCode); var httpWebRequest = (HttpWebRequest)WebRequest.Create(changedUrl); // https://openexchangerates.org/api/latest.json?app_id=ef9bd5f8a2824d24a6efbfb699ee1cf7&symbols=RUB httpWebRequest.ContentType = "text/json"; httpWebRequest.Method = "GET";//Можно GET httpWebRequest.Accept = "application/json"; httpWebRequest.ContentType = "application/x-www-form-urlencoded"; var httpResponse = (HttpWebResponse)httpWebRequest.GetResponse(); using (var streamReader = new StreamReader(httpResponse.GetResponseStream())) { //ответ от сервера var result = streamReader.ReadToEnd(); //Десериализация RateModel rateModel = JsonConvert.DeserializeObject <RateModel>(result); var currencyRate = rateModel.rates.ContainsKey(currencyCode) ? rateModel.rates[currencyCode] : "0"; return(Convert.ToDouble(currencyRate, CultureInfo.InvariantCulture)); } }
/// <summary> /// 取得台幣存放款利率 /// </summary> /// <returns>JSON</returns> public JsonResult <RateModel> Get() { RateModel model = new RateModel(); model.GenTest(); return(Json(model)); }
public static int insertRate(RateModel r) { string cmd = "insert into Tbl_RateMaster (StockId,Rate) values ('" + r.StockId + "','" + r.Rate + "');"; SqlHandler sqlh = new SqlHandler(); int i = sqlh.ExecuteQuery(cmd); return(i); }
public ActionResult RateEntry(RateModel r_model) { if (string.IsNullOrWhiteSpace(r_model.Mode)) { r_model.Mode = "New"; } return(View(r_model)); }
public void setRate(RateModel rate) { using (Conn) { string query = @"INSERT INTO Rates (Prod_Type_ID, EntryDate, Rate, IsActive) VALUES (@Prod_Type_ID, @EntryDate, @Rate, @IsActive)"; Conn.Execute(query, new { Prod_Type_ID = rate.Prod_Type_ID, EntryDate = rate.EntryDate, Rate = rate.Rate, IsActive = true }); } }
public string M_Rate_ExistsCheck([FromBody] RateModel rmodel) { if (rmodel == null) { rmodel = new RateModel(); } Rate_BL rbl = new Rate_BL(); return(rbl.M_Rate_ExistsCheck(rmodel)); }
public IActionResult Rate(int id) { var rateModel = new RateModel(); //var alcohol = Context.AlcoholVintages.Include(x => x.Alcohol).Single(x => x.AlcoholId == id); //Context.AlcoholVintages.Include(x=>x.Alcohol).Single(x => x.AlcoholId == Id); rateModel.AlcoholId = Context.Alcohols.Include(x => x.Wine).Single(x => x.Id == id).Id; rateModel.Name = Context.Alcohols.Include(x => x.Wine).Single(x => x.Id == id).Wine.Name; return(View(rateModel)); }
public ActionResult RateUser(RateModel rate) { double RatesSum = 0; using (DbContextModel db = new DbContextModel()) { int userWhoAddRateIdInt = Convert.ToInt32(System.Web.HttpContext.Current.Session["UserId"]); rate.Project = db.Projects.Where(x => x.ProjectId.Equals(rate.Project.ProjectId)).FirstOrDefault(); rate.UserWhoGetRate = db.UserAccounts.Where(x => x.UserId.Equals(rate.UserWhoGetRate.UserId)).FirstOrDefault(); rate.UserWhoAddRate = db.UserAccounts.Where(x => x.UserId.Equals(userWhoAddRateIdInt)).FirstOrDefault(); RatesSum += (double)rate.Communication; RatesSum += (double)rate.MeetingTheConditions; RatesSum += (double)rate.Professionalism; RatesSum += (double)rate.WantToCoworkAgain; if (rate.UserWhoGetRate.Role.ToString() == "Pracownik") { RatesSum += (double)rate.Punctuality; RatesSum += (double)rate.Quality; RatesSum += (double)rate.Skills; string roundedAverageRate = string.Format("{0:0.00}", RatesSum / 7); rate.AverageRate = Convert.ToDouble(roundedAverageRate); } else if (rate.UserWhoGetRate.Role.ToString() == "Menadzer") { RatesSum += (double)rate.ManageSkills; string roundedAverageRate = string.Format("{0:0.00}", RatesSum / 5); rate.AverageRate = Convert.ToDouble(roundedAverageRate); } else { string roundedAverageRate = string.Format("{0:0.00}", RatesSum / 4); rate.AverageRate = Convert.ToDouble(roundedAverageRate); } var userRates = db.Rates.Where(x => x.UserWhoGetRate.UserId.Equals(x.UserWhoGetRate.UserId)).ToList(); double oldRatesSum = 0; foreach (var oldRate in userRates) { oldRatesSum += oldRate.AverageRate; } oldRatesSum += rate.AverageRate; double oldRatesCount = Convert.ToDouble(userRates.Count()); oldRatesCount++; string roundedAverageRateOverall = string.Format("{0:0.00}", oldRatesSum / oldRatesCount); rate.UserWhoGetRate.AverageRate = Convert.ToDouble(roundedAverageRateOverall); rate.RateDate = DateTime.Now; db.Entry(rate.UserWhoGetRate).State = EntityState.Modified; db.Notifications.Add(new NotificationModel { Project = rate.Project, NotificationType = NotificationTypes.NowaOcena, IsSeen = false, DateSend = DateTime.Now, NotificationReceiver = rate.UserWhoGetRate, Title = "Nowa ocena", Content = string.Format("Użytkownik {0} wystawił Ci ocenę za projekt {1}. Średnia ocen to: {2}", rate.UserWhoAddRate.Username, rate.Project.ProjectTitle, rate.AverageRate) }); db.Rates.Add(rate); db.SaveChanges(); } return(RedirectToAction("RateUsersFromProject", new { projectId = rate.Project.ProjectId })); }
public IHttpActionResult PostRate(RateModel rateModel) { Rate rate = db.Rates.Where(i => i.CustomerId == rateModel.CustomerId && i.ProductId == rateModel.ProductId).Include(i => i.Customer).Include(i => i.Customer).FirstOrDefault(); if (rate == null) { return(NotFound()); } return(Ok(rate)); }
public async Task <ActionResult> RateUser(int projectId, int userId) { RateModel rate = new RateModel(); using (DbContextModel db = new DbContextModel()) { rate.Project = db.Projects.Where(x => x.ProjectId.Equals(projectId)).FirstOrDefault(); rate.UserWhoGetRate = db.UserAccounts.Where(x => x.UserId.Equals(userId)).FirstOrDefault(); } return(PartialView("_rateUser", rate)); }
public static PubRate ToPubRateEntity(this RateModel model, string userId, string pubId, string?rateId) { return(new PubRate { Id = rateId, HexadoUserId = userId, PubId = pubId, UserRate = model.UserRate, Comment = model.Comment }); }
/// <summary> /// 获取习题答题状况详情(饼图) /// </summary> /// <param name="vguid"></param> /// <returns></returns> public List <RateModel> GetExerciseRateDetail(string vguid, string departmentVguid) { List <RateModel> listRateModel = new List <RateModel>(); List <U_QuestionSsetsRate> exerciseSsetsRate = _ss.GetQuestionRateDetail(vguid, departmentVguid); RateModel rateModel1 = new RateModel(); rateModel1.Browser = "答题人数"; if (exerciseSsetsRate[0].numberofanswer == 0) { rateModel1.Share = "0%"; } else { rateModel1.Share = (exerciseSsetsRate[0].Questionsperson / exerciseSsetsRate[0].numberofanswer * 100).ToString("F2") + "%"; } listRateModel.Add(rateModel1); RateModel rateModel2 = new RateModel(); rateModel2.Browser = "未答题人数"; if (exerciseSsetsRate[0].numberofanswer == 0) { rateModel2.Share = "0%"; } else { rateModel2.Share = ((1 - exerciseSsetsRate[0].Questionsperson / exerciseSsetsRate[0].numberofanswer) * 100).ToString("F2") + "%"; } listRateModel.Add(rateModel2); RateModel rateModel3 = new RateModel(); rateModel3.Browser = "答题总人数"; rateModel3.Share = exerciseSsetsRate[0].Questionsperson.ToString(); listRateModel.Add(rateModel3); RateModel rateModel4 = new RateModel(); rateModel4.Browser = "未答题总人数"; if (exerciseSsetsRate[0].numberofanswer == 0) { rateModel4.Share = "0"; } else { rateModel4.Share = (exerciseSsetsRate[0].numberofanswer - exerciseSsetsRate[0].Questionsperson).ToString(); } listRateModel.Add(rateModel4); return(listRateModel); }
public IHttpActionResult GetWineryRates(int Id) { try { return(Ok(RateModel.GetWineryRates(Id, db))); } catch (Exception ex) { return(Content(HttpStatusCode.BadRequest, ex)); } }
public IHttpActionResult PostAddToWishList(RateModel wishlist) { AddToWishList addToWishList = db.AddToWishLists.Where(i => i.ProducId == wishlist.ProductId && i.CustomerId == wishlist.CustomerId && i.Block == false).Include(i => i.Customer).Include(i => i.Product).FirstOrDefault(); if (addToWishList == null) { return(NotFound()); } return(Ok(addToWishList)); }
public static BoardGameRate ToBoardGameRateEntity(this RateModel model, string userId, string gameBoardId, string?rateId) { return(new BoardGameRate { Id = rateId, HexadoUserId = userId, BoardGameId = gameBoardId, UserRate = model.UserRate, Comment = model.Comment }); }
public ActionResult RecordPaymentRate(RateModel rate) { rate.id = generateRandomString(26); rate.created_at = DateTime.Now; PaymentRates paymentRate = rate.ToPaymentRateModel(); context.PaymentRates.Add(paymentRate); context.SaveChanges(); List <PaymentRates> rate_list = context.PaymentRates.OrderByDescending(m => m.created_at).ToList(); return(Json(new { msg = "You have successfully set new amount.", list = rate_list })); }
public string Rate_CUD(RateModel rmodel) { BaseDL bdl = new BaseDL(); if (rmodel.Mode.Equals("New")) { rmodel.SPName = "M_Rate_Insert"; rmodel.Sqlprms = new SqlParameter[3]; rmodel.Sqlprms[0] = new SqlParameter("@BrandCD", SqlDbType.VarChar) { Value = rmodel.BrandCD }; rmodel.Sqlprms[1] = new SqlParameter("@CategoryCD", SqlDbType.VarChar) { Value = rmodel.CategoryCD }; rmodel.Sqlprms[2] = new SqlParameter("@Rate", SqlDbType.Decimal) { Value = rmodel.Rate }; } else if (rmodel.Mode.Equals("Edit")) { rmodel.SPName = "M_Rate_Update"; rmodel.Sqlprms = new SqlParameter[3]; rmodel.Sqlprms[0] = new SqlParameter("@BrandCD", SqlDbType.VarChar) { Value = rmodel.BrandCD }; rmodel.Sqlprms[1] = new SqlParameter("@CategoryCD", SqlDbType.VarChar) { Value = rmodel.CategoryCD }; rmodel.Sqlprms[2] = new SqlParameter("@Rate", SqlDbType.Decimal) { Value = rmodel.Rate }; } else if (rmodel.Mode.Equals("Delete")) { rmodel.SPName = "M_Rate_Delete"; rmodel.Sqlprms = new SqlParameter[2]; rmodel.Sqlprms[0] = new SqlParameter("@BrandCD", SqlDbType.VarChar) { Value = rmodel.BrandCD }; rmodel.Sqlprms[1] = new SqlParameter("@CategoryCD", SqlDbType.VarChar) { Value = rmodel.CategoryCD }; } return(bdl.SelectJson(rmodel.SPName, rmodel.Sqlprms)); }
public ActionResult EditRate(RateModel model) { if (ModelState.IsValid) { if (DbAccess.SaveRate(model)) { return(Json(new { success = true }, JsonRequestBehavior.DenyGet)); } } return(Json(new { success = false }, JsonRequestBehavior.DenyGet));; }
public async Task <ActionResult> AddRate(RateModel rate) { try { rate.R_Ip = Request.HttpContext.Connection.RemoteIpAddress.ToString(); return(new JsonResult(await this._raterepository.Insert(rate))); } catch (Exception ex) { return(null); } }
public ActionResult CreateOrUpdateRates(RateModel model) { if (ModelState.IsValid) { if (DbAccess.CreateOrUpdateRates(model)) { return(Json(new { success = true }, JsonRequestBehavior.DenyGet)); } } return(Json(new { success = false }, JsonRequestBehavior.DenyGet));; }
private bool TryConversionToFrom(TransactionViewModel transaction) { bool processedConversion = false; if (rates.Any(x => x.From == transaction.CurrencyConverted && x.To == currentCurrency)) { RateModel rate = rates.Single(x => x.From == transaction.CurrencyConverted && x.To == currentCurrency); currentAmount = ConvertAmountToFrom(currentAmount, rate); currentCurrency = rate.From; processedConversion = true; } return(processedConversion); }