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