protected void GetWorkshopDetails(string workshopname) { SqlConnection con = GetSqlCon.GetCon(); SqlDataAdapter com = new SqlDataAdapter("GetWorkshopDetails", con); com.SelectCommand.CommandType = CommandType.StoredProcedure; com.SelectCommand.Parameters.AddWithValue("@param1", workshopname); DataTable dtWorkshops = new DataTable(); com.Fill(dtWorkshops); DescOficina.DataSource = dtWorkshops; DescOficina.DataBind(); //rating double rating = Commissions.GetAvgRating(Users.GetWorkshopId(workshopname)); Label ratinglb = DescOficina.FindControl("ratinglabel") as Label; if (rating == -1) { ratinglb.Text = "Sem Avaliação"; } else { ratinglb.Text = rating.ToString() + "/5" + "★"; } }
public static List <Commissions> getCommissions() { int annee = DateTime.Now.Year; String DebutAnnee = annee + "-01-01"; String FinAnnee = annee + "-12-31"; string connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; SqlConnection connection = new SqlConnection(connectionString); string request = "SELECT * FROM Commissions WHERE DATE >'" + DebutAnnee + "' AND DATE <'" + FinAnnee + "'"; SqlCommand command = new SqlCommand(request, connection); try { connection.Open(); SqlDataReader reader = command.ExecuteReader(); List <Commissions> list = new List <Commissions>(); Commissions ev = null; while (reader.Read()) { ev = new Commissions((int)reader["Id"], (int)reader["Taux"], (Decimal)reader["Prix"], (string)reader["IdEnchere"], (DateTime)reader["Date"]); list.Add(ev); } reader.Close(); return(list); } catch (Exception e) { System.Console.WriteLine(e.Message); } finally { connection.Close(); } return(null); }
/// <summary> /// Gets the buy commissions. /// </summary> /// <returns></returns> public Commissions GetBuyCommissions() { if (_buyCommissions == null) { var setting = _settingRepository.GetByKey(BuyCommissionsKey); if (setting == null) { // No settings found - Create the application default settings. _buyCommissions = new Commissions { Fixed = new List <CommissionRange> { new CommissionRange { Min = 0, Max = 100000000, Value = 50 } }, Percentage = new List <CommissionRange> { new CommissionRange { Min = 0, Max = 100000000, Value = 1 } } }; SaveBuyCommissions(_buyCommissions); } else { _buyCommissions = JsonConvert.DeserializeObject <Commissions>(setting.Value); } } return(_buyCommissions); }
protected void GetPrices() { foreach (GridViewRow row in PendingComissions.Rows) { int id, price; int.TryParse(row.Cells[1].Text, out id); price = Commissions.GetPrice(id); TextBox txtPrice = row.FindControl("txtPrice") as TextBox; Button BtnOrcamento = row.FindControl("BtnSetPrice") as Button; Button BtnReject = row.FindControl("BtnRejectComission") as Button; if (price != 0) { BtnOrcamento.Visible = false; BtnReject.Visible = false; txtPrice.Text = price.ToString(); } else { txtPrice.ReadOnly = false; txtPrice.Text = "N/A"; txtPrice.ReadOnly = true; } } }
protected void GetRatings() { int value, rejected; foreach (GridViewRow row in HistoryOfComissions.Rows) { value = Commissions.FillRatings(row.Cells[0].Text); if (value == -1) { Response.Redirect("~/Error.aspx"); } rejected = Commissions.IsRejected(row.Cells[0].Text); if (rejected == -1) { Response.Redirect("~/Error.aspx"); } if (value != -2) { ((HtmlInputGenericControl)row.FindControl("starating")).Value = value.ToString(); ((HtmlInputGenericControl)row.FindControl("starating")).Attributes.Add("readonly", "true"); ((Button)row.FindControl("BtnSubmitRating")).Visible = false; BadgeCountActiveComissions.Text = rejected.ToString(); } if (rejected == 0) { ((HtmlInputGenericControl)row.FindControl("starating")).Visible = false; ((Label)row.FindControl("labelrejected")).Visible = true; ((Button)row.FindControl("BtnSubmitRating")).Visible = false; } } }
public JsonResult Update(string id, string valor) { if (!String.IsNullOrWhiteSpace(id) && !String.IsNullOrWhiteSpace(valor)) { var valorUpdate = IsDecimal(valor.Replace(",", ".")) ? valor.Replace(",", ".") : valor; decimal valorAntigo; decimal valorModificado; //Monta o objeto para update var commission = new Commissions().GetById(Settings.AutenticationKeyEarningSystem, Convert.ToInt32(id)); if (commission != null) { valorAntigo = commission.Percentage.Value; valorModificado = decimal.Parse(valorUpdate, CultureInfo.InvariantCulture); commission.Percentage = decimal.Parse(valorUpdate, CultureInfo.InvariantCulture); var updateStatus = new Commissions().Update(Settings.AutenticationKeyEarningSystem, commission); if (updateStatus) { var user = FormsAuthenticationUtil.UserAuthenticated; SaveUpdateLog(user.Login, commission.Id.Value, valorAntigo, valorModificado); return Json(new JsonRequestResult { ResultType = JsonRequestResultType.Success, Message = Resources.Resource.GS_Commission_Update_Success }, JsonRequestBehavior.AllowGet); } } } return Json(new JsonRequestResult { ResultType = JsonRequestResultType.Error, Message = Resources.Resource.GS_Commission_Update_Error }, JsonRequestBehavior.AllowGet); }
public JsonResult CreatePackageCommissionsJSON(string clientName, string packageName, string packageCommissionRate) { clientName = clientName != null?clientName.Trim() : ""; packageName = packageName != null?packageName.Trim() : ""; packageCommissionRate = packageCommissionRate != null?packageCommissionRate.Trim() : ""; string errorMessage = ""; if (String.IsNullOrWhiteSpace(clientName)) { errorMessage += "Client Name not provided. "; } if (String.IsNullOrWhiteSpace(packageName)) { errorMessage += "Package Name not provided. "; } decimal decPackageCommissionRate = 0; if (!decimal.TryParse(packageCommissionRate, out decPackageCommissionRate)) { errorMessage += "Commission Rate is invalid. "; } errorMessage = errorMessage.Trim(); if (errorMessage != "") { return(new JsonResult { Data = new { success = false, message = errorMessage } }); } try { var results = Commissions.CreatePackageCommissions(clientName, packageName, decPackageCommissionRate); if (results.Count <= 0) { errorMessage += "Record already exists, or Client Name is wrong. "; } errorMessage = errorMessage.Trim(); return(new JsonResult { Data = new { success = results.Count > 0, message = errorMessage, packageCommissionID = (results.Count > 0 ? new int?(results[0].PackageCommissionID) : new int?()), clientID = (results.Count > 0 ? results[0].ClientID : ""), clientName = (results.Count > 0 ? results[0].ClientName : ""), packageCommissionRate = (results.Count > 0 ? results[0].PackageCommissionRate.ToString("f2") : "") } }); } catch (Exception ex) { errorMessage += "Record already exists, or Client Name is wrong. \n\n[" + ex.Message + "]"; errorMessage = errorMessage.Trim(); return(new JsonResult { Data = new { success = false, message = errorMessage } }); } }
public ActionResult ManageCommissionPayout() { var bankaccount = Commissions.GetDirectDeposit(); bankaccount.AccountNumber = ""; return(View(bankaccount)); }
public ActionResult ClientsSearchByClientNameJSON(string searchTerm) { var results = Commissions.ClientsSearchByClientName(searchTerm); return(new JsonResult { Data = new { success = true, results = results } }); }
protected void GridViewComissions_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "EditData") { int index = Convert.ToInt32(e.CommandArgument); GridViewComissions.EditIndex = index; _counter2 = index; } if (e.CommandName == "DeleteData") { int index = Convert.ToInt32(e.CommandArgument); GridViewRow row = GridViewComissions.Rows[index]; string id = row.Cells[1].Text; if (Commissions.DeleteComission(id) == false) { Response.Redirect("~/Error.aspx"); } } if (e.CommandName == "CancelEdit") { _counter2 = -1; GridViewComissions.EditIndex = _counter; } if (e.CommandName == "UpdateData") { int index = Convert.ToInt32(e.CommandArgument); GridViewRow row = GridViewComissions.Rows[index]; string id = row.Cells[1].Text; TextBox ClientId = row.FindControl("txtClientId") as TextBox; TextBox WorkshopId = row.FindControl("txtWorkshopId") as TextBox; DropDownList Concluded = row.FindControl("ddlConcluded") as DropDownList; TextBox txtCreationDate = row.FindControl("txtCreationDate") as TextBox; DateTime CreationDate = DateTime.Parse(txtCreationDate.Text); TextBox BicycleModel = row.FindControl("txtBicycleModel") as TextBox; TextBox BicycleType = row.FindControl("txtBicycleType") as TextBox; TextBox YearOfAquisition = row.FindControl("txtYearOfAquisition") as TextBox; TextBox Details = row.FindControl("txtDetails") as TextBox; DropDownList Accepted = row.FindControl("ddlAccepted") as DropDownList; TextBox ComissionNo = row.FindControl("txtComissionNo") as TextBox; TextBox Rating = row.FindControl("txtDetails") as TextBox; if (Commissions.UpdateComission(id, ClientId.Text, WorkshopId.Text, Concluded.SelectedValue, CreationDate, BicycleModel.Text, BicycleType.Text, YearOfAquisition.Text, Details.Text, Accepted.SelectedValue, ComissionNo.Text, Rating.Text) == false) { Response.Redirect("~/Error.aspx"); } GridViewComissions.EditIndex = -1; } UpdateBadges(); GridViewComissions.DataBind(); EditTablesUpdatePanel.Update(); }
public ActionResult UpdateDirectDeposit(CommissionPayout account) { if (Commissions.SetDirectDeposit(account)) { return(RedirectToAction("commissionpayout", "account", new { success = true })); } else { return(RedirectToAction("managecommissionpayout", "account", new { success = false })); } }
public int Update(Commissions pObjCommissions) { try { return(mObjCommissionsTableDAO.Update(pObjCommissions)); } catch (Exception lObjException) { LogService.WriteError(string.Format("[CommissionsService - Update]: {0}", lObjException.Message)); throw lObjException; } }
protected void BtnCreateComission_Click(object sender, EventArgs e) { int Ano; int.TryParse(TbAno.Text, out Ano); if (!Page.IsValid) { return; } ApplicationDbContext context = new ApplicationDbContext(); var UserManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(context)); string user = User.Identity.GetUserId(); BtnCreateComission.Enabled = false; //Prevenir Flood Random rnd = new Random(); if (LbOficinas.GetSelectedIndices().Count() > 1) { int var, groupno; do { groupno = rnd.Next(1, 10000); var = Commissions.CheckIfGroupExists(groupno); if (var == -1) { Response.Redirect("~/Error.aspx"); } } while (var != 0); foreach (int i in LbOficinas.GetSelectedIndices()) { if (Commissions.CreateComissionGroup(TbModelo.Text, DdlTipo.SelectedValue, LbOficinas.Items[i].Value, Ano, TbDetails.Text, user, groupno) == false) { Response.Redirect("~/Error.aspx"); } } } else { foreach (int i in LbOficinas.GetSelectedIndices()) { if (Commissions.CreateComission(TbModelo.Text, DdlTipo.SelectedValue, LbOficinas.Items[i].Value, Ano, TbDetails.Text, user) == false) { Response.Redirect("~/Error.aspx"); } } } Response.Redirect("ComissionCreated.aspx"); }
protected void RejectOthers(string id) { foreach (GridViewRow row in GridViewGroupDetails.Rows) { if (row.Cells[0].Text != id) { int comid; int.TryParse(row.Cells[0].Text, out comid); Commissions.RejectComission(comid); } } }
//public dtoAdvStepContainer(Domain.AdvStep step) //{ // Id = step.Id; // Name = step.Name; // Order = step.Order; // Status = step.Status; // CallId = (step.Call != null) ? step.Call.Id : -1; // if(step.Commissions != null && step.Commissions.Any()) // { // Commissions = (from Domain.AdvCommission comm in step.Commissions.OrderByDescending(c => c.IsMaster).ThenBy(c => c.Name).ToList() // select new dtoAdvCommissionContainer(comm)).ToList(); // } //} /// <summary> /// Costruttore da oggetti dominio /// </summary> /// <param name="step">Step di riferimento</param> /// <param name="userId">Id Utente (per calcolo permessi)</param> public dtoAdvStepContainer(Domain.AdvStep step, int userId, int creatorId) { Id = step.Id; Name = step.Name; Order = step.Order; Status = step.Status; CallId = (step.Call != null) ? step.Call.Id : -1; StepPermission = GenericStepPermission.none; if (step.Commissions != null) // && step.Commissions.Any()) { //Comm.Criteria.Select(bc => new Eval.dtoCriterion(bc)).OrderBy(c => c.DisplayOrder).ThenBy(c => c.Name).ToList(); Commissions = step.Commissions.Select(cm => new dtoAdvCommissionContainer(cm, userId)).OrderByDescending(c => c.IsMaster).ThenBy(c => c.Name).ToList(); StepPermission = GenericStepPermission.none; if (Commissions.Any(cm => (cm.GenericPermission & GenericStepPermission.MainPresident) == GenericStepPermission.MainPresident)) { StepPermission |= GenericStepPermission.MainPresident; } if (Commissions.Any(cm => (cm.GenericPermission & GenericStepPermission.MainSecretary) == GenericStepPermission.MainSecretary)) { StepPermission |= GenericStepPermission.MainSecretary; } if (Commissions.Any(cm => (cm.GenericPermission & GenericStepPermission.President) == GenericStepPermission.President)) { StepPermission |= GenericStepPermission.President; } if (Commissions.Any(cm => (cm.GenericPermission & GenericStepPermission.Secretary) == GenericStepPermission.Secretary)) { StepPermission |= GenericStepPermission.Secretary; } if (Commissions.Any(cm => (cm.GenericPermission & GenericStepPermission.Member) == GenericStepPermission.Member)) { StepPermission |= GenericStepPermission.Member; } } if (creatorId > 0 && creatorId == userId) { StepPermission |= GenericStepPermission.MainPresident; StepPermission |= GenericStepPermission.MainSecretary; StepPermission |= GenericStepPermission.President; StepPermission |= GenericStepPermission.Secretary; } }
/// <summary> /// Saves the sell commissions. /// </summary> /// <param name="commissions">The commissions.</param> public void SaveSellCommissions(Commissions commissions) { Validate.NotNull(commissions, nameof(commissions)); Validate.NotNull(commissions.Fixed, nameof(commissions.Fixed)); Validate.NotNull(commissions.Percentage, nameof(commissions.Percentage)); Validate.Minimum(commissions.Fixed.Count, 1, nameof(commissions.Fixed)); Validate.Minimum(commissions.Percentage.Count, 1, nameof(commissions.Percentage)); var value = JsonConvert.SerializeObject(commissions); var setting = Setting.Create(SellCommissionsKey, value); _settingRepository.Save(setting); }
protected void RejectOthers(string id) { foreach (GridViewRow row in GridViewGroupDetails.Rows) { if (row.Cells[0].Text != id) { int comid; int.TryParse(row.Cells[0].Text, out comid); if (Commissions.RejectComission(comid) == false) { Response.Redirect("~/Error.aspx"); } } } }
/// <summary> /// Sells the supplied quantity of shares at the current market price. /// </summary> /// <param name="symbol">The share symbol.</param> /// <param name="quantity">The quantity to sell.</param> /// <param name="price">The sell price per share.</param> /// <param name="commissions">The commissions to apply.</param> /// <param name="nonce">The nonce value required to detect duplicate orders.</param> public void SellShares(string symbol, long quantity, decimal price, Commissions commissions, long nonce) { Validate.NotNullOrWhitespace(symbol, nameof(symbol)); Validate.Minimum(quantity, 1, nameof(quantity)); Validate.Minimum(price, 0.001m, nameof(price)); Validate.NotNull(commissions, nameof(commissions)); // Check the nonce value. This will though an exception if invalid. CheckNonce(nonce); // Calculate all the individual amounts. decimal amount = quantity * price; decimal fixedCommissionAmount = GetCommission(commissions.Fixed, amount); decimal percentageCommission = GetCommission(commissions.Percentage, amount); decimal percentageCommissionAmount = amount * percentageCommission / 100; decimal totalFees = percentageCommissionAmount + fixedCommissionAmount; decimal totalAmount = totalFees - amount; if (totalAmount > Balance) { throw new InvalidTradeException($"The total amount of the transction exceeds the current account balance by ${(totalAmount - Balance):N2}."); } // Update the position. Position position = Positions.FirstOrDefault(p => p.Symbol == symbol); if (position == null || position.Quantity < quantity) { throw new InvalidTradeException($"You cannot sell {quantity} shares of {symbol} because the current position is only {position?.Quantity ?? 0}."); } position.Sell(quantity); if (position.Quantity == 0) { Positions.Remove(position); } // Create the transaction records and update the balances. Balance = Balance + amount; Transactions.Add(Transaction.Create(this, TransactionType.Sell, $"Sold {quantity} shares of {symbol} for ${price:N3} each", amount, Balance)); Balance = Balance - percentageCommissionAmount; Transactions.Add(Transaction.Create(this, TransactionType.Commission, $"Commission {percentageCommission:N2}%", -percentageCommissionAmount, Balance)); Balance = Balance - fixedCommissionAmount; Transactions.Add(Transaction.Create(this, TransactionType.Commission, $"Commission", -fixedCommissionAmount, Balance)); }
/// <summary> /// Buys the supplied quantity of shares at the current market price. /// </summary> /// <param name="symbol">The share symbol.</param> /// <param name="quantity">The quantity to buy.</param> /// <param name="price">The purchase price per share.</param> /// <param name="commissions">The commissions to apply.</param> /// <param name="nonce">The nonce value required to detect duplicate orders.</param> public void BuyShares(string symbol, long quantity, decimal price, Commissions commissions, long nonce) { Validate.NotNullOrWhitespace(symbol, nameof(symbol)); Validate.Minimum(quantity, 1, nameof(quantity)); Validate.Minimum(price, 0.001m, nameof(price)); Validate.NotNull(commissions, nameof(commissions)); // Check the nonce value. This will though an exception if invalid. CheckNonce(nonce); // Calculate all the individual amounts. decimal amount = quantity * price; decimal fixedCommissionAmount = GetCommission(commissions.Fixed, amount); decimal percentageCommission = GetCommission(commissions.Percentage, amount); decimal percentageCommissionAmount = amount * percentageCommission / 100; decimal totalFees = percentageCommissionAmount + fixedCommissionAmount; decimal totalAmount = amount + totalFees; if (totalAmount > Balance) { throw new InvalidTradeException($"The total amount of the transaction exceeds the current account balance by ${(totalAmount - Balance):N2}."); } // Find an existing position to update. If none exist, create a new one. Position position = Positions.FirstOrDefault(p => p.Symbol == symbol); if (position != null) { position.Buy(quantity, price, totalFees); } else { position = Position.Create(this, symbol, quantity, price, totalFees); Positions.Add(position); } // Create the transaction records and update the balances. Balance = Balance - amount; Transactions.Add(Transaction.Create(this, TransactionType.Buy, $"Purchased {quantity} shares of {symbol} for ${price:N3} each", -amount, Balance)); Balance = Balance - percentageCommissionAmount; Transactions.Add(Transaction.Create(this, TransactionType.Commission, $"Commission {percentageCommission:N2}%", -percentageCommissionAmount, Balance)); Balance = Balance - fixedCommissionAmount; Transactions.Add(Transaction.Create(this, TransactionType.Commission, $"Commission", -fixedCommissionAmount, Balance)); }
public JsonResult RemovePackageCommissionsJSON(string packageCommissionID) { packageCommissionID = packageCommissionID != null?packageCommissionID.Trim() : ""; string errorMessage = ""; int intPackageCommissionID = 0; if (!int.TryParse(packageCommissionID, out intPackageCommissionID)) { errorMessage += "PackageCommissionID is invalid. "; } errorMessage = errorMessage.Trim(); if (errorMessage != "") { return(new JsonResult { Data = new { success = false, message = errorMessage } }); } try { var results = Commissions.RemovePackageCommissions(intPackageCommissionID); if (results.Count <= 0) { errorMessage += "Record was already deleted. "; } errorMessage = errorMessage.Trim(); return(new JsonResult { Data = new { success = results.Count > 0, message = errorMessage, packageCommissionID = (results.Count > 0 ? new int?(results[0].PackageCommissionID) : new int?()), clientID = (results.Count > 0 ? results[0].ClientID : ""), clientName = (results.Count > 0 ? results[0].ClientName : ""), packageCommissionRate = (results.Count > 0 ? results[0].PackageCommissionRate.ToString("f2") : "") } }); } catch (Exception ex) { errorMessage += ex.Message; errorMessage = errorMessage.Trim(); return(new JsonResult { Data = new { success = false, message = errorMessage } }); } }
public DetailsProductionViewModel(string productionId) { this.productionId = productionId; this._popUp = DependencyService.Get <Services.IPopUp>(); DeleteCommand = new AsyncCommand(Delete); realm = Realm.GetInstance(MyRealmConfig.GetConfig()); var production = realm.Find <Production>(new ObjectId(productionId)); Date = production.DateText; Amount = production.Amount; foreach (var c in production.Commissions) { var dtoCommission = new CommissionDTO(c.Peon.Name, c.Value); Commissions.Add(dtoCommission); } }
protected void GetRatings() { int value; foreach (GridViewRow row in HistoryOfComissions.Rows) { value = Commissions.FillRatings(row.Cells[0].Text); if (value != -2) { ((HtmlInputGenericControl)row.FindControl("starating")).Value = value.ToString(); LabelComissoesAtivas.Text = value.ToString(); } else { ((HtmlInputGenericControl)row.FindControl("starating")).Visible = false; ((Label)row.FindControl("ratinglabel")).Visible = true; } } }
protected void Populate_Details(int groupno) { string storedprocedure = "GetComissionDetails"; SqlConnection cn = GetSqlCon.GetCon(); if (cn == null) { Response.Redirect("~/Error.aspx"); } DataTable dt = new DataTable(); SqlCommand cmd = new SqlCommand(storedprocedure, cn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@param1", groupno); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); GridViewGroupDetails.DataSource = dt; GridViewGroupDetails.DataBind(); cn.Close(); GridViewGroupDetails.Visible = true; foreach (GridViewRow row in GridViewGroupDetails.Rows) { int id, price; int.TryParse(row.Cells[0].Text, out id); price = Commissions.GetPrice(id); Label LabelPrice = row.FindControl("LabelPrice") as Label; if (price != 0) { LabelPrice.Text = price.ToString(); } else { Button BtnAcceptComission = row.FindControl("BtnAcceptComission") as Button; Button BtnRejectComission = row.FindControl("BtnRejectComission") as Button; BtnAcceptComission.Visible = false; BtnRejectComission.Visible = false; LabelPrice.Text = "N/A"; } } }
/// <summary> /// Sells the supplied quantity of shares at the current market price. /// </summary> /// <param name="userId">The unique identifier of the user who owns the trading account.</param> /// <param name="accountId">The unique identifier of the account.</param> /// <param name="symbol">The share symbol.</param> /// <param name="quantity">The quantity to sell.</param> /// <param name="nonce">The nonce value required to detect duplicate orders.</param> public void SellSharesAtMarketPrice(Guid userId, Guid accountId, string symbol, long quantity, long nonce) { Validate.NotEmpty(userId, nameof(userId)); Validate.NotEmpty(accountId, nameof(accountId)); Validate.NotNullOrWhitespace(symbol, nameof(symbol)); Quote quote = _shareQuoteProvider.GetQuote(symbol); if (quote == null) { throw new EntityNotFoundException($"Share with symbol '{symbol}' not found."); } Commissions commissions = _settingService.GetSellCommissions(); Account account = GetAccount(userId, accountId); account.SellShares(symbol, quantity, quote.Bid, commissions, nonce); _accountRepository.Save(account); }
public static bool insererCommissions(Commissions commi) { string cStr = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; using (SqlConnection cnx = new SqlConnection(cStr)) { string requete = "INSERT INTO Commissions (Taux, Prix, IdEnchere, Date) VALUES (" + commi.Taux + ", '" + commi.Prix + "', '" + commi.IdEnchere + "', '" + commi.Date.ToString("yyyy-MM-dd") + "')"; SqlCommand cmd = new SqlCommand(requete, cnx); cmd.CommandType = System.Data.CommandType.Text; try { cnx.Open(); cmd.ExecuteNonQuery(); return(true); } catch (Exception e) { System.Console.WriteLine(e.Message); return(false); } finally { cnx.Close(); } } }
protected void GetPrices() { foreach (GridViewRow row in GridViewComissionsPending.Rows) { int id, price; int.TryParse(row.Cells[1].Text, out id); price = Commissions.GetPrice(id); Label LabelPrice = row.FindControl("LabelPrice") as Label; if (price != 0) { LabelPrice.Text = price.ToString(); } else { Button BtnAcceptComission = row.FindControl("BtnAcceptComission") as Button; Button BtnRejectComission = row.FindControl("BtnRejectComission") as Button; BtnAcceptComission.Visible = false; BtnRejectComission.Visible = false; LabelPrice.Text = "N/A"; } } }
public ActionResult ListingPercent(int? page) { try { var commissionList = new Commissions().SelectAll(Settings.AutenticationKeyEarningSystem); var mvcList = new MvcList<CommissionPercentageModel>(commissionList .OrderBy(x => x.Id) .Take(Settings.PopupListTotalRegisters), page.GetValueOrDefault(), Settings.PopupListTotalRegisters, Settings.PopupListTotalRegisters); return PartialView(mvcList); } catch (Exception ex) { LogService.Log("GS.CommissionController.Listing() :: Exception : ", ex); } return PartialView("ListingPercent"); }
protected void Comissions_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "SubmitRating") { int index = Convert.ToInt32(e.CommandArgument), id, rating; GridViewRow row = HistoryOfComissions.Rows[index]; int.TryParse(row.Cells[0].Text, out id); int.TryParse(((HtmlInputGenericControl)row.FindControl("starating")).Value, out rating); if (Commissions.SetRating(id, rating) == false) { Response.Redirect("~/Error.aspx"); } Response.Redirect("Comissions.aspx"); } if (e.CommandName == "SetPrice") { int Price_int; int index = Convert.ToInt32(e.CommandArgument), id; GridViewRow row = PendingComissions.Rows[index]; int.TryParse(row.Cells[1].Text, out id); TextBox Price = row.FindControl("txtPrice") as TextBox; if (!int.TryParse(Price.Text, out Price_int)) { PriceServerValidator.IsValid = false; ValSum.ValidationGroup = "ComissionPrice"; } else if (PriceServerValidator.IsValid == false) { PriceServerValidator.IsValid = true; } if (Commissions.AddPrice(id, Price_int) == false) { Response.Redirect("~/Error.aspx"); } } if (e.CommandName == "RejectComissionWorkshop") { int index = Convert.ToInt32(e.CommandArgument), id; GridViewRow row = PendingComissions.Rows[index]; int.TryParse(row.Cells[1].Text, out id); if (Commissions.RejectComission(id) == false) { Response.Redirect("~/Error.aspx"); } } if (e.CommandName == "ConcludeComission") { int index = Convert.ToInt32(e.CommandArgument), id; GridViewRow row = ActiveComissions.Rows[index]; int.TryParse(row.Cells[1].Text, out id); LabelComissoesAtivas.Text = id.ToString(); if (Commissions.ConcludeComission(id) == false) { Response.Redirect("~/Error.aspx"); } } if (e.CommandName == "EditPrice") { int index = Convert.ToInt32(e.CommandArgument); GridViewRow row = PendingComissions.Rows[index]; TextBox Price = row.FindControl("txtPrice") as TextBox; if (Price.Text == "N/A") { Price.ReadOnly = false; Price.Text = ""; Button BtnSetPrice = row.FindControl("BtnSetPrice") as Button; BtnSetPrice.Visible = false; Button BtnAcceptComission = row.FindControl("BtnAcceptComission") as Button; BtnAcceptComission.Visible = true; } else { return; } return; } if (e.CommandName == "AcceptComission") { int index = Convert.ToInt32(e.CommandArgument), id; GridViewRow row = GridViewGroupDetails.Rows[index]; int.TryParse(row.Cells[0].Text, out id); if (Commissions.ActivateComission(id) == false) { Response.Redirect("~/Error.aspx"); } RejectOthers(row.Cells[0].Text); Response.Redirect("~/DualRole/Comissions.aspx");//Errado, mas se não for feito, as avaliações não são carregadas. (erro desconhecido) } if (e.CommandName == "RejectComission") { int index = Convert.ToInt32(e.CommandArgument), id; GridViewRow row = GridViewGroupDetails.Rows[index]; int.TryParse(row.Cells[0].Text, out id); if (Commissions.RejectComission(id) == false) { Response.Redirect("~/Error.aspx"); } Response.Redirect("~/DualRole/Comissions.aspx");//Errado, mas se não for feito, as avaliações não são carregadas. (erro desconhecido) } if (e.CommandName == "ShowGroupDetails") { int index = Convert.ToInt32(e.CommandArgument), groupno; GridViewRow row = GridViewGroupComissions.Rows[index]; int.TryParse(row.Cells[0].Text, out groupno); Populate_Details(groupno); } if (e.CommandName == "AcceptComissionNonGroup") { int index = Convert.ToInt32(e.CommandArgument), id; GridViewRow row = GridViewComissionsPending.Rows[index]; int.TryParse(row.Cells[1].Text, out id); if (Commissions.ActivateComission(id) == false) { Response.Redirect("~/Error.aspx"); } Response.Redirect("~/DualRole/Comissions.aspx");//Errado, mas se não for feito, as avaliações não são carregadas. (erro desconhecido) } if (e.CommandName == "RejectComissionNonGroup") { int index = Convert.ToInt32(e.CommandArgument), id; GridViewRow row = GridViewComissionsPending.Rows[index]; int.TryParse(row.Cells[1].Text, out id); if (Commissions.RejectComission(id) == false) { Response.Redirect("~/Error.aspx"); } Response.Redirect("~/DualRole/Comissions.aspx");//Errado, mas se não for feito, as avaliações não são carregadas. (erro desconhecido) } UpdateBadges(); PopulateGridViews(); GetRatings(); GetPrices(); EditTablesUpdatePanel.Update(); }
public ActionResult CommissionPayout() { var bankaccount = Commissions.GetDirectDeposit(); return(View(bankaccount)); }
/// <summary> /// Sums all commissions that a promoter has the rights. /// </summary> /// <param name="year"></param> /// <param name="idPromoter"></param> /// <returns></returns> public Decimal GetTotalCommissionsByYear(string year, int idPromoter) { var commissions = new Commissions().SelectConsolidatedCommissionsByYear(Settings.AutenticationKeyEarningSystem, year, idPromoter); return commissions .Where(commissionModel => !commissionModel.IsPago) .Sum(commissionModel => commissionModel.ValorComissionamento); }
protected void Comissions_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "SubmitRating") { int index = Convert.ToInt32(e.CommandArgument), id, rating; GridViewRow row = HistoryOfComissions.Rows[index]; int.TryParse(row.Cells[0].Text, out id); int.TryParse(((HtmlInputGenericControl)row.FindControl("starating")).Value, out rating); if (Commissions.SetRating(id, rating) == false) { Response.Redirect("~/Error.aspx"); } Response.Redirect("Comissions.aspx"); } if (e.CommandName == "SetPrice") { int Price_int; int index = Convert.ToInt32(e.CommandArgument), id; GridViewRow row = PendingComissions.Rows[index]; int.TryParse(row.Cells[1].Text, out id); TextBox Price = row.FindControl("txtPrice") as TextBox; if (!int.TryParse(Price.Text, out Price_int)) { PriceServerValidator.IsValid = false; ValSum.ValidationGroup = "ComissionPrice"; } else if (PriceServerValidator.IsValid == false) { PriceServerValidator.IsValid = true; } if (Commissions.AddPrice(id, Price_int) == false) { Response.Redirect("~/Error.aspx"); } } if (e.CommandName == "RejectComission") { int index = Convert.ToInt32(e.CommandArgument), id; GridViewRow row = PendingComissions.Rows[index]; int.TryParse(row.Cells[1].Text, out id); if (Commissions.RejectComission(id) == false) { Response.Redirect("~/Error.aspx"); } } if (e.CommandName == "ConcludeComission") { int index = Convert.ToInt32(e.CommandArgument), id; GridViewRow row = ActiveComissions.Rows[index]; int.TryParse(row.Cells[1].Text, out id); LabelComissoesAtivas.Text = id.ToString(); if (Commissions.ConcludeComission(id) == false) { Response.Redirect("~/Error.aspx"); } } if (e.CommandName == "EditPrice") { int index = Convert.ToInt32(e.CommandArgument); GridViewRow row = PendingComissions.Rows[index]; TextBox Price = row.FindControl("txtPrice") as TextBox; if (Price.Text == "N/A") { Price.ReadOnly = false; Price.Text = ""; Button BtnSetPrice = row.FindControl("BtnSetPrice") as Button; BtnSetPrice.Visible = false; Button BtnAcceptComission = row.FindControl("BtnAcceptComission") as Button; BtnAcceptComission.Visible = true; } else { return; } return; } UpdateBadges(); PopulateGridViews(); GetRatings(); GetPrices(); }
public ActionResult CommissionsReport(int idPeriod = 0, int page = 1) { var period = new Period().GetAll(Settings.AutenticationKeyEarningSystem).OrderByDescending(m => m.DataInicio).Where(m => m.IdStatusPeriodo == 2 || m.IdStatusPeriodo == 3).ToList(); ViewBag.Periods = GetPeriodSelectListItem(period, idPeriod); if (idPeriod != 0) { ViewBag.SelectedPeriod = idPeriod; } else { var periodAnterior = period.FirstOrDefault(m => m.DataTermino < DateTime.Today); if (periodAnterior == null || periodAnterior == new PeriodModel()) { periodAnterior = period.FirstOrDefault() ?? new PeriodModel(); } ViewBag.SelectedPeriod = periodAnterior.IdPeriodo; } var consolidatedCommissionModel = new List<ConsolidatedCommissionModel>(); if (idPeriod != 0) { consolidatedCommissionModel = new Commissions().SelectConsolidatedCommissions(Settings.AutenticationKeyEarningSystem, idPeriod).ToList(); ViewBag.TotalComissoes = consolidatedCommissionModel.Sum(m => m.ValorComissionamento); ViewBag.TotalComissoesPagas = consolidatedCommissionModel.Where(m => m.IsPago).Sum(m => m.ValorComissionamento); ViewBag.TotalCompras = consolidatedCommissionModel.Sum(m => m.ValorPedido); ViewBag.IsPartial = period.Any(m => m.IdPeriodo == idPeriod && m.IdStatusPeriodo == 3); } return View(CreateMvcList(consolidatedCommissionModel, page)); }
public ActionResult PrintCommissionsReport(int idPeriod = 0) { if (idPeriod != 0) { var period = new Period().Get(Settings.AutenticationKeyEarningSystem, idPeriod); ViewBag.Period = period.DataInicio.ToString(Resources.Resource.GS_CommissionsReport_DateFormat) + " - " + period.DataTermino.ToString(Resources.Resource.GS_CommissionsReport_DateFormat); if (period.IdStatusPeriodo == 3) { ViewBag.Partial = Resources.Resource.GS_CommissionsReport_PartialMsg; } } else { return View(new List<ConsolidatedCommissionModel>()); } var consolidatedCommissionModel = new List<ConsolidatedCommissionModel>(); if (idPeriod != 0) { consolidatedCommissionModel = new Commissions().SelectConsolidatedCommissions(Settings.AutenticationKeyEarningSystem, idPeriod).ToList(); ViewBag.TotalComissoes = consolidatedCommissionModel.Sum(m => m.ValorComissionamento); ViewBag.TotalComissoesPagas = consolidatedCommissionModel.Where(m => m.IsPago).Sum(m => m.ValorComissionamento); ViewBag.TotalCompras = consolidatedCommissionModel.Sum(m => m.ValorPedido); } return View(consolidatedCommissionModel); }
/// <summary> /// Method thats build the model with the Commissions for a Period /// </summary> /// <param name="idPeriod"></param> /// <returns></returns> public IEnumerable<CommissionModel> MontaModel(string idPeriod) { try { if (!String.IsNullOrWhiteSpace(idPeriod)) { var idPeriodo = Convert.ToInt32(idPeriod); var period = new WS.Period.Period().Get(Settings.AutenticationKeyEarningSystem, idPeriodo); var dtInicio = period != null ? period.DataInicio : DateTime.MinValue; var dtTermino = period != null ? period.DataTermino : DateTime.MaxValue; var promoter = new WS.Promoter.Promoter().GetPromoter( Settings.AutenticationKeyEarningSystem, RetornaidCliente()); if (promoter != null) { //Retorna as comissões var commissions = new Commissions().SelectFiltered( Settings.AutenticationKeyEarningSystem, dtInicio, dtTermino, promoter.IdPromoter); var commissionsGroup = (from c in commissions group c by c.Pedido.IdCliente into g select new CommissionModel { Cliente_Pedido = g.Select(m => m.Cliente_Pedido).FirstOrDefault(), Cliente = g.Select(m => m.Cliente).FirstOrDefault(), Nivel = g.Select(m => m.Nivel).FirstOrDefault(), ValorComissao = g.Sum(m => m.ValorComissao), ValorPedido = g.Sum(m => m.ValorPedido) }).ToArray(); return commissions.Any() ? commissionsGroup : new CommissionModel[0]; } } } catch (Exception ex) { LogService.Log("GS.CommissionController.Listing() :: Exception : ", ex); } return new CommissionModel[0]; }
public Commissions_PackageCommissions() { this.Results = Commissions.PackageCommissions(); }
private void CreateJournalEntry() { try { if (cboAcct.Selected == null) { UIApplication.ShowError("Seleccione una cuenta"); return; } string lStrBankAccountNum = cboAcct.Selected.Value; if (string.IsNullOrEmpty(lStrBankAccountNum)) { UIApplication.ShowError("Seleccione una cuenta"); return; } string lStrBankAccountCode = mObjTransportServiceFactory.GetBankService().GetBankAccount(lStrBankAccountNum).GLAccount; string lStrFolio = txtFolio.Value; string lStrReference = txtReference.Value; string lStrCmsDriverAcct = new QueryManager().GetValue("U_VALUE", "Name", "TR_ACC_LIQCHOF", "[@UG_Config]"); string lStrFilePath = string.Empty; if (string.IsNullOrEmpty(lStrFolio)) { UIApplication.ShowError("Seleccione un folio de comisión"); return; } if (string.IsNullOrEmpty(lStrBankAccountCode)) { UIApplication.ShowError(string.Format("No se encontró la cuenta para la cuenta bancaria {0}", lStrBankAccountNum)); return; } if (string.IsNullOrEmpty(lStrCmsDriverAcct)) { UIApplication.ShowError("Agregue un valor en la configuración para el campo TR_ACC_LIQCHOF"); return; } if (dtCommissions.Rows.Count == 0) { UIApplication.ShowError("No puede crear la comisión sin líneas"); return; } if (!string.IsNullOrEmpty(mStrFilePath)) { //mObjTransportServiceFactory.GetAttachmentDI().AttachFile(mStrFilePath); lStrFilePath = AttatchFile(mStrFilePath); } SAPbobsCOM.JournalEntries lObjJournalEntry = (SAPbobsCOM.JournalEntries)DIApplication.Company.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oJournalEntries); lObjJournalEntry.TransactionCode = "TRPG"; lObjJournalEntry.Reference = lStrFolio; lObjJournalEntry.Reference2 = lStrReference; lObjJournalEntry.ReferenceDate = DateTime.Now; lObjJournalEntry.TaxDate = DateTime.Now; lObjJournalEntry.DueDate = DateTime.Now; for (int i = 0; i < dtCommissions.Rows.Count; i++) { string lStrEmpId = dtCommissions.GetValue("EmpId", i).ToString(); string lStrEmployee = dtCommissions.GetValue("EmpNm", i).ToString(); double lDblImport = double.Parse(dtCommissions.GetValue("Import", i).ToString()); string lStrFolioLine = dtCommissions.GetValue("FolioCms", i).ToString(); string lStrAcctLine = dtCommissions.GetValue("Acct", i).ToString(); lObjJournalEntry.Lines.SetCurrentLine(lObjJournalEntry.Lines.Count - 1); lObjJournalEntry.Lines.TaxDate = DateTime.Now; lObjJournalEntry.Lines.AccountCode = lStrCmsDriverAcct; lObjJournalEntry.Lines.Debit = lDblImport; lObjJournalEntry.Lines.Credit = 0; lObjJournalEntry.Lines.CostingCode = "TR_TRANS"; lObjJournalEntry.Lines.UserFields.Fields.Item("U_GLO_TypeAux").Value = "2"; lObjJournalEntry.Lines.UserFields.Fields.Item("U_GLO_Auxiliar").Value = lStrEmpId; //code empleado lObjJournalEntry.Lines.UserFields.Fields.Item("U_GLO_CodeMov").Value = lStrFolio; lObjJournalEntry.Lines.UserFields.Fields.Item("U_GLO_File").Value = lStrFilePath; lObjJournalEntry.Lines.Add(); lObjJournalEntry.Lines.SetCurrentLine(lObjJournalEntry.Lines.Count - 1); lObjJournalEntry.Lines.TaxDate = DateTime.Now; lObjJournalEntry.Lines.AccountCode = lStrBankAccountCode; lObjJournalEntry.Lines.Debit = 0; lObjJournalEntry.Lines.Credit = lDblImport; lObjJournalEntry.Lines.CostingCode = "TR_TRANS"; lObjJournalEntry.Lines.UserFields.Fields.Item("U_GLO_TypeAux").Value = "2"; lObjJournalEntry.Lines.UserFields.Fields.Item("U_GLO_Auxiliar").Value = lStrEmpId; //code empleado lObjJournalEntry.Lines.UserFields.Fields.Item("U_GLO_CodeMov").Value = lStrFolio; lObjJournalEntry.Lines.UserFields.Fields.Item("U_GLO_File").Value = lStrFilePath; lObjJournalEntry.Lines.Add(); } if (lObjJournalEntry.Add() != 0) { string lStrLastError = DIApplication.Company.GetLastErrorDescription(); UIApplication.ShowMessageBox(string.Format("Error al generar el asiento de la comisión: {0}", DIApplication.Company.GetLastErrorDescription())); } else { int lIntDocEntry = int.Parse(DIApplication.Company.GetNewObjectKey()); LogUtility.WriteSuccess(String.Format("[frmDriversCommissions - CreateJournalEntry] Comisión creada correctamente con el DocEntry {0} para el Folio: {1}", lIntDocEntry, lStrFolio)); Commissions lObjCommission = mObjTransportServiceFactory.GetCommissionService().GetCommission(lStrFolio); lObjCommission.HasDriverCms = "Y"; if (mObjTransportServiceFactory.GetCommissionService().UpdateCommission(lObjCommission) != 0) { throw new Exception(string.Format("Error al modificar el estatus de la comisión {0}", lStrFolio)); } //SaveCommissionsRecords(lIntDocEntry); ClearControls(); UIApplication.ShowSuccess(string.Format("Comisión creada correctamente con el número de documento: {0}", lIntDocEntry)); } } catch (Exception lObjException) { LogUtility.WriteError(String.Format("[frmDriversCommissions - CreateJournalEntry] Error al crear el asiento contable: {0}", lObjException.Message)); throw new Exception(string.Format("Error al crear el asiento contable: {0}", lObjException.Message)); } finally { } }
/// <summary> /// Receive the Promoter Id and returns a Select /// list with Years that have an "Product Order" in database /// </summary> /// <param name="idPromoter"></param> /// <returns></returns> public List<SelectListItem> GetYearsSelectListItem(int idPromoter) { var commissions = new Commissions().SelectFiltered(Settings.AutenticationKeyEarningSystem, null, null, idPromoter); var firstDateCommission = new DateTime(); var lastDateCommission = new DateTime(); var firstOrDefault = commissions.FirstOrDefault(); if (firstOrDefault != null) { if (firstOrDefault.DataPedido != null) firstDateCommission = firstOrDefault.DataPedido.Value; } var lastOrDefault = commissions.LastOrDefault(); if (lastOrDefault != null) { if (lastOrDefault.DataPedido != null) lastDateCommission = lastOrDefault.DataPedido.Value; } var firstYear = firstDateCommission.Year; var lastYear = lastDateCommission.Year; var listYear = new List<Int32>(); for (var i = firstYear; i <= lastYear; i++) { listYear.Add(i); } return listYear.Select(item => new SelectListItem { Text = item.ToString(CultureInfo.InvariantCulture), Value = item.ToString(CultureInfo.InvariantCulture) }).ToList(); }