public static DbUserRestriction FromRestriction(UserRestriction restriction) => new DbUserRestriction { Start = restriction.Start, End = restriction.End, ModeratorId = restriction.ModeratorId, Reason = restriction.Reason };
private void MnuUserRestriction_Click(object sender, EventArgs e) { var frm = new UserRestriction { MdiParent = this, StartPosition = FormStartPosition.CenterScreen, WindowState = FormWindowState.Normal }; frm.Show(); }
public void InserFoodRestriction(UserRestriction restrictions) { using (var userDb = new UsersContext()) { if (userDb.Users.Any(u => u.UserId == restrictions.User.UserId)) { var usuario = userDb.Users.First(user => user.UserId == restrictions.User.UserId); userDb.UserRestrictions.Add(restrictions); userDb.SaveChanges(); } else { throw new ArgumentException("usuário não existe"); } } }
public void SetRestriction(UserRestriction rest) { if (rest == null) { throw new ArgumentNullException("rest"); } if (restrictions.ContainsKey(rest.UserId)) { restrictions [rest.UserId] = rest; } else { restrictions.Add(rest.UserId, rest); } }
public async void SaveUserRestriction(Guid userId, List <string> restrictions, string other) { var user = _userRepository.GetUser(u => u.UserId == userId).Result; var outros = other.Split(","); restrictions.AddRange(outros); await _serviceBus.SendLogAsync($"Salvando as restrições do user \"{userId.ToString()}\" !!!"); foreach (var restriction in restrictions) { var userRestriction = new UserRestriction(user); userRestriction.Ingredient = restriction.Trim(); userRestriction.UserId = user.Id; _userRepository.InserFoodRestriction(userRestriction); } }
public void AddUserRestriction(UserRestriction userRestriction) { _dbContext.UserRestrictions.Add(userRestriction); _dbContext.SaveChanges(); }
private List <OrderReport> GetReportData(string jtSorting, List <Criterias> criteria) { List <OrderReport> lst = new List <OrderReport>(); os = new OrderSummary(); string userRestriction = UserRestriction.GetUserRestriction(User.Identity.GetUserName(), "OrderReport"); if (userRestriction == "") { return(lst); } string conStr = ConnectionStringManager.ProdConnectionString; using (con = new NpgsqlConnection(conStr)) { string query = "salesreport"; con.Open(); //ToDo : sorgu dinamik hale getirilecek. string prQuery = ""; if (criteria.Count > 0) { prQuery = prQuery + "(1 = 0 "; } foreach (var item in criteria) { prQuery = prQuery + " OR (1=1"; if (item.startdate != null) { prQuery = prQuery + " AND f.PostedDate >= '" + item.startdate + " 12:00:00 AM'"; } if (item.enddate != null) { prQuery = prQuery + " AND f.PostedDate <= '" + item.enddate + " 11:59:59 PM'"; } if (item.asin != null) { prQuery = prQuery + " AND s.asin = '" + item.asin + "'"; } if (item.sku != null) { prQuery = prQuery + " AND s.sku = '" + item.sku + "'"; } if (item.vendor != null) { prQuery = prQuery + " AND s.vendor = '" + item.vendor + "'"; } if (item.skutitle != null) { prQuery = prQuery + " AND s.title like '%" + item.skutitle + "%'"; } if (item.fulfill != null) { prQuery = prQuery + " AND s.FulfillmentBy = '" + item.fulfill + "'"; } prQuery = prQuery + ") "; } prQuery = prQuery + ")"; if (userRestriction != "") { prQuery = "(" + userRestriction + " AND " + prQuery + ")"; } DbString str = new DbString(); str.Value = prQuery; lst = con.Query <OrderReport>(query, new { parameterquery = str }, commandType: CommandType.StoredProcedure).ToList <OrderReport>(); long orderItems = 0; long unitsOrdered = 0; decimal orderProductSales = 0; decimal avgUnitsOrderedItem = 0; decimal avgSalesOrderedItem = 0; decimal refundAmount = 0; decimal profit = 0; foreach (var item in lst) { orderItems = orderItems + item.OrderItem; unitsOrdered = unitsOrdered + item.UnitsOrdered; orderProductSales = orderProductSales + item.OrderUAmount; refundAmount = refundAmount + item.RefundUAmount; profit = profit + item.Profit; } if (lst.Count > 0) { avgUnitsOrderedItem = Convert.ToDecimal(orderItems) / Convert.ToDecimal(unitsOrdered); avgSalesOrderedItem = Math.Round(orderProductSales / orderItems, 3); os.AvgSalesOrderItem = Math.Round(avgSalesOrderedItem, 3); os.AvgUnitsOrderItem = Math.Round(avgUnitsOrderedItem, 3); os.OrderedProductSales = orderProductSales; os.TotalOrderItems = orderItems; os.UnitsOrdered = unitsOrdered; os.RefundAmount = refundAmount; os.Profit = profit; } else { os.AvgSalesOrderItem = 0; os.AvgUnitsOrderItem = 0; os.OrderedProductSales = 0; os.Profit = 0; os.RefundAmount = 0; os.TotalOrderItems = 0; os.UnitsOrdered = 0; } //TODO : diğer alanlarda konacak. if (jtSorting != null && jtSorting != "") { lst.Sort(jtSorting); } } return(lst); }