public static string GenerateQuery(VendorPage vendor)
{
if (vendor.npcTb.Text == "")
{
throw new Exception("Please enter NPC ID.");
}
else if (vendor.itemTb.Text == "")
{
throw new Exception("Please enter item ID.");
}
return(SelectedEmulator.GenerateQuery(vendor));
}
public Dictionary <string, string> Vendor(VendorPage vendor)
{
var kvplist = new Dictionary <string, string>
{
{ "entry", vendor.npcTb.Text },
{ "slot", vendor.slotTb.Text },
{ "item", vendor.itemTb.Text },
{ "maxcount", vendor.maxcountTb.Text },
{ "incrtime", vendor.incrTimeTb.Text },
{ "extendedcost", vendor.extendedCostTb.Text },
};
return(kvplist);
}
// Vendor is dynamic, loop through the UI elements
public static string Vendor(VendorPage vendor)
{
Logger.Log($"Export: Called Vendor with profile: '{Profile.Active.Name}' - Revision {Profile.Active.Revision}");
string sql = String.Empty;
int NpcEntry;
if (!int.TryParse(vendor.npcTb.Text, out NpcEntry))
{
Logger.Log("NPC ID was not numeric. Query was not saved.", Logger.Status.Error, true);
return("");
}
foreach (VendorEntryControl row in vendor.vendorEntriesWp.Children)
{
int Item, Slot, MaxCount, IncrTime, ExtendedCost;
if (!int.TryParse(row.itemTb.Text, out Item) ||
!int.TryParse(row.slotTb.Text, out Slot) ||
!int.TryParse(row.maxcountTb.Text, out MaxCount) ||
!int.TryParse(row.incrTimeTb.Text, out IncrTime) ||
!int.TryParse(row.extendedCostTb.Text, out ExtendedCost))
{
Logger.Log("All values in Vendor must be numeric. Query was not saved.", Logger.Status.Error, true);
return("");
}
// Default values
var vendorEntry = new List <ExpKvp>()
{
new ExpKvp("NpcEntry", NpcEntry, C.Vendor),
new ExpKvp("Item", Item, C.Vendor),
new ExpKvp("Slot", Slot, C.Vendor),
new ExpKvp("MaxCount", MaxCount, C.Vendor),
new ExpKvp("IncrTime", IncrTime, C.Vendor),
new ExpKvp("ExtendedCost", ExtendedCost, C.Vendor),
};
// Add Custom fields
IncludeCustomFields(ref vendorEntry, C.Vendor, row);
// Generate vendor entry
sql += GenerateSql(vendorEntry) + Environment.NewLine;
}
return(sql);
}
// Vendor is dynamic, loop through the UI elements
public static string Vendor(VendorPage vendor)
{
string sql = String.Empty;
int NpcEntry;
if (!int.TryParse(vendor.npcTb.Text, out NpcEntry))
{
Logger.Log("NPC ID was not numeric. Query was not saved.", Logger.Status.Error, true);
return("");
}
foreach (VendorEntryControl row in vendor.vendorEntriesWp.Children)
{
int Item, Slot, MaxCount, IncrTime, ExtendedCost;
if (!int.TryParse(row.itemTb.Text, out Item) ||
!int.TryParse(row.slotTb.Text, out Slot) ||
!int.TryParse(row.maxcountTb.Text, out MaxCount) ||
!int.TryParse(row.incrTimeTb.Text, out IncrTime) ||
!int.TryParse(row.extendedCostTb.Text, out ExtendedCost))
{
Logger.Log("All values in Vendor must be numeric. Query was not saved.", Logger.Status.Error, true);
return("");
}
sql += GenerateSql(new List <ExpKvp>()
{
new ExpKvp("NpcEntry", NpcEntry, C.Vendor),
new ExpKvp("Item", Item, C.Vendor),
new ExpKvp("Slot", Slot, C.Vendor),
new ExpKvp("MaxCount", MaxCount, C.Vendor),
new ExpKvp("IncrTime", IncrTime, C.Vendor),
new ExpKvp("ExtendedCost", ExtendedCost, C.Vendor),
}) + Environment.NewLine;
}
// todo: Custom fields not supported for vendor
return(sql);
}
public ActionResult Index()
{
Users LoggedUser = Login.GetLoggedUser();
ViewBag.user = LoggedUser;
if (LoggedUser != null)
{
if (LoggedUser.Role == Roles.Usuario)
{
var products = Products.ListProductsOnUser(LoggedUser).Where(i => i.Amount > 0);
var Allocates = ProductsAllocated.Queryable.Where(i => i.Vendor.UserBoss == LoggedUser && i.Amount > 0);
double stockValue = 0;
foreach (var item in products)
{
stockValue = stockValue + item.Cost * item.Amount;
}
var stockAmount = products.Select(i => i.Amount).Sum();
var allAllocatedAmount = Allocates.ToList().Sum(i => i.Amount);
double allAllocatedCost = 0;
foreach (var item in Allocates)
{
allAllocatedCost = allAllocatedCost + (item.Cost * item.Amount);
}
double allocatedToReceive = 0;
foreach (var item in Allocates)
{
allocatedToReceive = allocatedToReceive + (item.Amount * (item.Price - ((item.Price / 100) * item.Commision)));
}
var AllBuy = Charges.Queryable.Where(i => i.Amount > 0 && i.Client == LoggedUser && i.Type == Models.ChargesExtensions.ChargesTypes.Compra).Select(i => i.Value).ToList().Sum();
var AllSell = Charges.Queryable.Where(i => i.Amount > 0 && i.Client == LoggedUser && i.Type == Models.ChargesExtensions.ChargesTypes.Venda).Select(i => i.Value).ToList().Sum();
var totalVendor = Users.ListVendors(LoggedUser).Count;
var vendorWithProductAllocated = Allocates.Select(i => i.Vendor).Distinct().Count();
ViewBag.statistic = new HomeStatistics
{
AllAllocatedAmount = allAllocatedAmount,
AllAllocatedCost = allAllocatedCost,
AllAllocatedToReceive = allocatedToReceive,
AllProductsAmount = stockAmount,
AllProductsValue = stockValue,
TotalVendors = totalVendor,
VendorsWithAllocatedProducts = vendorWithProductAllocated,
TotalGain = AllSell,
TotalPayd = AllBuy
};
}
if (LoggedUser.Role == Roles.Vendedor)
{
VendorPage vendorPage = new VendorPage();
List <ProductsAllocated> products = ProductsAllocated.Queryable.Where(i => i.Vendor == LoggedUser && i.Amount > 0).ToList();
vendorPage.Name = LoggedUser.Name + " " + LoggedUser.SurName;
foreach (var item in products)
{
vendorPage.TotalAmountAllocatedProducts += item.Amount;
vendorPage.TotalValueInProducts += Convert.ToDecimal(item.Price);
vendorPage.TotalValueToEarnInComission += Convert.ToDecimal(item.Price - ((item.Price / 100) * item.Commision));
}
vendorPage.AccontabilityDelayed = products.Where(i => i.DateAccountability <= DateTime.Now.Date).ToList();
vendorPage.NextProductToAccontability = products.Where(i => i.DateAccountability >= DateTime.Now.Date).OrderBy(i => i.DateAccountability).Take(6).ToList();
ViewBag.vendorPage = vendorPage;
return(View());
}
}
return(View());
}
public string GenerateQuery(VendorPage vendor)
{
return(SqlQuery.GenerateInsert("npc_vendor", Vendor(vendor)));
}
public string GenerateQuery(VendorPage vendor)
{
throw new NotImplementedException();
}
