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);
}
