public async Task <ActionResult <MainStore> > PostMainStore(MainStore mainStore)
{
_context.MainStore.Add(mainStore);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetMainStore", new { id = mainStore.MainStoreId }, mainStore));
}
public async Task <IActionResult> PutMainStore(int id, MainStore mainStore)
{
if (id != mainStore.MainStoreId)
{
return(BadRequest());
}
_context.Entry(mainStore).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MainStoreExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
protected void OnStoreRefresh(object sender, StoreRefreshDataEventArgs e)
{
try {
var start = Int32.Parse(e.Parameters["start"]);
var limit = Int32.Parse(e.Parameters["limit"]);
var end = start + limit;
var data = new List <object>(limit);
var userData = UserData;
var cacheKey = WebUtility.GetCacheKeyName(userData, "energy-detail-data");
var details = HttpRuntime.Cache[cacheKey] as List <EnergyDetailInfo>;
if (details == null)
{
details = AddDataToCache();
}
if (details != null && details.Count > 0)
{
if (end > details.Count)
{
end = details.Count;
}
for (int i = start; i < end; i++)
{
data.Add(details[i]);
}
}
e.Total = (details != null ? details.Count : 0);
MainStore.DataSource = data;
MainStore.DataBind();
} catch (Exception err) {
WebUtility.WriteLog(EnmSysLogLevel.Error, EnmSysLogType.Exception, err.ToString(), Page.User.Identity.Name);
WebUtility.ShowMessage(EnmErrType.Error, err.Message);
}
}
void Awake()
{
Store = this;
Camera = GameObject.FindGameObjectWithTag("MainCamera").GetComponent <Camera>();
Player = GameObject.FindGameObjectWithTag("Player");
Dialogue = GetComponent <DialogueManager>();
CheckPointsForAI = CheckPoints;
GameOverLabel = GameOverlbl;
}
/// <summary>
/// Store Refresh
/// </summary>
protected void OnMainStoreRefresh(object sender, StoreRefreshDataEventArgs e)
{
try {
var start = Int32.Parse(e.Parameters["start"]);
var limit = Int32.Parse(e.Parameters["limit"]);
var end = start + limit;
var data = new List <object>(limit);
var cacheKey = WebUtility.GetCacheKeyName(UserData, "kpi-report-002");
var result = HttpRuntime.Cache[cacheKey] as List <Report002Entity>;
if (result == null)
{
result = AddDataToCache();
}
if (result != null && result.Count > 0)
{
if (end > result.Count)
{
end = result.Count;
}
for (int i = start; i < end; i++)
{
var devcnt = 0; var fm = 0d; var interval = 0d; var pinterval = 0d;
if (result[i].LscID == -100)
{
devcnt = result.Sum(r => r.Devices.Count) / (result.Count - 1);
fm = devcnt * result[i].EndTime.Subtract(result[i].BeginTime).TotalMinutes;
interval = result.Sum(r => r.Alarms.Sum(alarm => (alarm.EndTime == WebUtility.DefaultDateTime ? result[i].EndTime : alarm.EndTime).Subtract(alarm.StartTime).TotalMinutes)) / (result.Count - 1);
pinterval = result.Sum(r => r.PAlarms.Sum(alarm => (alarm.EndTime == WebUtility.DefaultDateTime ? result[i].EndTime : alarm.EndTime).Subtract(alarm.StartTime).TotalMinutes)) / (result.Count - 1);
}
else
{
devcnt = result[i].Devices.Count;
fm = devcnt * result[i].EndTime.Subtract(result[i].BeginTime).TotalMinutes;
interval = result[i].Alarms.Sum(alarm => (alarm.EndTime == WebUtility.DefaultDateTime ? result[i].EndTime : alarm.EndTime).Subtract(alarm.StartTime).TotalMinutes);
pinterval = result[i].PAlarms.Sum(alarm => (alarm.EndTime == WebUtility.DefaultDateTime ? result[i].EndTime : alarm.EndTime).Subtract(alarm.StartTime).TotalMinutes);
}
data.Add(new {
ID = i + 1,
LscID = result[i].LscID,
LscName = result[i].LscName,
DevCnt = devcnt,
Interval = Math.Round(interval, 2),
PInterval = Math.Round(pinterval, 2),
Rate = String.Format("{0:P2}", fm != 0 ? (1 - (interval + pinterval) / fm) : 1)
});
}
}
e.Total = (result != null ? result.Count : 0);
MainStore.DataSource = data;
MainStore.DataBind();
} catch (Exception err) {
WebUtility.WriteLog(EnmSysLogLevel.Error, EnmSysLogType.Exception, err.ToString(), Page.User.Identity.Name);
WebUtility.ShowMessage(EnmErrType.Error, err.Message);
}
}
// This method gets called by the runtime. Use this method to add services to the container.
public void ConfigureServices(IServiceCollection services)
{
services.AddCors();
services.AddControllers();
services.AddTransient <IUsersRepository, UsersRepository>();
// Inyecta un singleton que funciona como store, para no usar una base de datos.
var store = new MainStore();
services.AddSingleton <IMainStore>(store);
}
/// <inheritdoc />
public bool TryGetTimeZone(int id, [MaybeNullWhen(false)] out TZAbbr value)
{
if (!MainStore.ContainsKey(id))
{
value = MainStore[id];
return(true);
}
value = null;
return(false);
}
/// <summary>
/// Store Refresh
/// </summary>
protected void OnMainStoreRefresh(object sender, StoreRefreshDataEventArgs e)
{
try {
var start = Int32.Parse(e.Parameters["start"]);
var limit = Int32.Parse(e.Parameters["limit"]);
var end = start + limit;
var data = new List <object>(limit);
var cacheKey = WebUtility.GetCacheKeyName(UserData, "kpi-report-106");
var result = HttpRuntime.Cache[cacheKey] as List <Report106Entity>;
if (result == null)
{
result = AddDataToCache();
}
if (result != null && result.Count > 0)
{
if (end > result.Count)
{
end = result.Count;
}
for (int i = start; i < end; i++)
{
var fm = result[i].Nodes.Count * result[i].EndTime.Subtract(result[i].BeginTime).TotalMinutes;
var interval = result[i].Alarms.Sum(alarm => (alarm.EndTime == WebUtility.DefaultDateTime || alarm.EndTime > result[i].EndTime ? result[i].EndTime : alarm.EndTime).Subtract(alarm.StartTime).TotalMinutes);
data.Add(new {
ID = i + 1,
LscID = result[i].Station.LscID,
LscName = result[i].Station.LscName,
Area1Name = result[i].Station.Area1Name,
Area2Name = result[i].Station.Area2Name,
Area3ID = result[i].Station.Area3ID,
Area3Name = result[i].Station.Area3Name,
BuildingID = result[i].Station.BuildingID,
BuildingName = result[i].Station.BuildingName == WebUtility.DefaultString ? "--" : result[i].Station.BuildingName,
NodeCnt = result[i].Nodes.Count,
AlarmCnt = result[i].Alarms.Count,
Interval = Math.Round(interval, 2),
Rate = String.Format("{0:P2}", fm != 0 ? (1 - interval / fm) : 1)
});
}
}
e.Total = (result != null ? result.Count : 0);
MainStore.DataSource = data;
MainStore.DataBind();
} catch (Exception err) {
WebUtility.WriteLog(EnmSysLogLevel.Error, EnmSysLogType.Exception, err.ToString(), Page.User.Identity.Name);
WebUtility.ShowMessage(EnmErrType.Error, err.Message);
}
}
/// <summary>
/// Store Refresh
/// </summary>
protected void OnMainStoreRefresh(object sender, StoreRefreshDataEventArgs e)
{
try {
var start = Int32.Parse(e.Parameters["start"]);
var limit = Int32.Parse(e.Parameters["limit"]);
var end = start + limit;
var data = new List <object>(limit);
var cacheKey = WebUtility.GetCacheKeyName(UserData, "kpi-report-102");
var result = HttpRuntime.Cache[cacheKey] as List <Report102Entity>;
if (result == null)
{
result = AddDataToCache();
}
if (result != null && result.Count > 0)
{
if (end > result.Count)
{
end = result.Count;
}
for (int i = start; i < end; i++)
{
data.Add(new {
ID = i + 1,
LscID = result[i].Station.LscID,
LscName = result[i].Station.LscName,
Area1Name = result[i].Station.Area1Name,
Area2Name = result[i].Station.Area2Name,
Area3ID = result[i].Station.Area3ID,
Area3Name = result[i].Station.Area3Name,
BuildingID = result[i].Station.BuildingID,
BuildingName = result[i].Station.BuildingName == WebUtility.DefaultString ? "--" : result[i].Station.BuildingName,
FillCapacity = Math.Round(result[i].FillCapacity, 2),
CurrentCapacity = Math.Round(result[i].CurrentCapacity, 2),
DesignCapacity = result[i].DesignCapacity,
RedundanceCapacity = result[i].RedundanceCapacity,
Rate = String.Format("{0:P2}", result[i].DesignCapacity - result[i].RedundanceCapacity != 0 ? (result[i].FillCapacity + result[i].CurrentCapacity) / (result[i].DesignCapacity - result[i].RedundanceCapacity) : 1)
});
}
}
e.Total = (result != null ? result.Count : 0);
MainStore.DataSource = data;
MainStore.DataBind();
} catch (Exception err) {
WebUtility.WriteLog(EnmSysLogLevel.Error, EnmSysLogType.Exception, err.ToString(), Page.User.Identity.Name);
WebUtility.ShowMessage(EnmErrType.Error, err.Message);
}
}
/// <summary>
/// Store Refresh
/// </summary>
protected void OnMainStoreRefresh(object sender, StoreRefreshDataEventArgs e)
{
try {
var start = Int32.Parse(e.Parameters["start"]);
var limit = Int32.Parse(e.Parameters["limit"]);
var end = start + limit;
var data = new List <object>(limit);
var cacheKey = WebUtility.GetCacheKeyName(UserData, "kpi-oil-engine-report");
var result = HttpRuntime.Cache[cacheKey] as List <OilEngineEntity>;
if (result == null)
{
result = AddDataToCache();
}
if (result != null && result.Count > 0)
{
if (end > result.Count)
{
end = result.Count;
}
for (int i = start; i < end; i++)
{
data.Add(new {
ID = i + 1,
LscID = result[i].Station.LscID,
LscName = result[i].Station.LscName,
Area2ID = result[i].Station.Area2ID,
Area2Name = result[i].Station.Area2Name,
Area3ID = result[i].Station.Area3ID,
Area3Name = result[i].Station.Area3Name,
StaID = result[i].Station.StaID,
StaName = result[i].Station.StaName,
PowerOff = result[i].SNodes.Sum(s => s.Divs.Count(d => d.Value == GJ)),
OffInterval = result[i].SNodes.Sum(s => s.Interval),
PowerOn = result[i].YNodes.Sum(y => y.Divs.Count(d => d.Value == GJ)),
OnInterval = result[i].YNodes.Sum(y => y.Interval)
});
}
}
e.Total = (result != null ? result.Count : 0);
MainStore.DataSource = data;
MainStore.DataBind();
} catch (Exception err) {
WebUtility.WriteLog(EnmSysLogLevel.Error, EnmSysLogType.Exception, err.ToString(), Page.User.Identity.Name);
WebUtility.ShowMessage(EnmErrType.Error, err.Message);
}
}
/// <summary>
/// Operating Events Refresh
/// </summary>
protected void OnMainStoreRefresh(object sender, StoreRefreshDataEventArgs e)
{
try {
var start = Int32.Parse(e.Parameters["start"]);
var limit = Int32.Parse(e.Parameters["limit"]);
var end = start + limit;
var data = new List <object>(limit);
var cacheKey = WebUtility.GetCacheKeyName(UserData, "netking-events");
var events = HttpRuntime.Cache[cacheKey] as List <AcEventInfo>;
if (events == null)
{
events = AddEventsToCache();
}
if (events != null && events.Count > 0)
{
if (end > events.Count)
{
end = events.Count;
}
for (int i = start; i < end; i++)
{
data.Add(new {
ID = i + 1,
LscID = events[i].LscId,
LscName = events[i].LscName,
NetGroupID = events[i].NetGroupID,
NetGroupName = events[i].NetGroupName,
PointName = events[i].PointName,
UserID = events[i].UserID,
UserName = events[i].UserName,
Department = events[i].Department,
MessageID = events[i].MessageID,
Message = events[i].Message,
EventTime = WebUtility.GetDateString(events[i].EventTime)
});
}
}
e.Total = (events != null ? events.Count : 0);
MainStore.DataSource = data;
MainStore.DataBind();
} catch (Exception err) {
WebUtility.WriteLog(EnmSysLogLevel.Error, EnmSysLogType.Exception, err.ToString(), Page.User.Identity.Name);
WebUtility.ShowMessage(EnmErrType.Error, err.Message);
}
}
/// <summary>
/// Grid Refresh
/// </summary>
protected void OnMainStoreRefresh(object sender, StoreRefreshDataEventArgs e)
{
try {
var start = Int32.Parse(e.Parameters["start"]);
var limit = Int32.Parse(e.Parameters["limit"]);
var end = start + limit;
var data = new List <object>(limit);
var cacheKey = WebUtility.GetCacheKeyName(UserData, "projects");
var datas = HttpRuntime.Cache[cacheKey] as List <ProjectInfo>;
if (datas == null)
{
datas = AddDataToCache();
}
if (datas != null && datas.Count > 0)
{
if (end > datas.Count)
{
end = datas.Count;
}
for (int i = start; i < end; i++)
{
data.Add(new {
ID = i + 1,
LscID = datas[i].LscID,
LscName = datas[i].LscName,
ProjectId = datas[i].ProjectId,
ProjectName = datas[i].ProjectName,
BeginTime = WebUtility.GetDateString(datas[i].BeginTime),
EndTime = WebUtility.GetDateString(datas[i].EndTime),
Responsible = datas[i].Responsible,
ContactPhone = datas[i].ContactPhone,
Company = datas[i].Company,
Comment = datas[i].Comment,
Enabled = datas[i].Enabled
});
}
}
e.Total = (datas != null ? datas.Count : 0);
MainStore.DataSource = data;
MainStore.DataBind();
} catch (Exception err) {
WebUtility.WriteLog(EnmSysLogLevel.Error, EnmSysLogType.Exception, err.ToString(), Page.User.Identity.Name);
WebUtility.ShowMessage(EnmErrType.Error, err.Message);
}
}
protected void MainStoreRefresh(object sender, StoreRefreshDataEventArgs e)
{
try {
var start = Int32.Parse(e.Parameters["start"]);
var limit = Int32.Parse(e.Parameters["limit"]);
var end = start + limit;
var length = MainGridPanel.ColumnModel.Columns.Count;
var data = CreateCustomizeTable(0);
var cacheKey = WebUtility.GetCacheKeyName(UserData, "energy-005-report");
var result = HttpRuntime.Cache[cacheKey] as List <EnergyInfo05>;
if (result == null)
{
result = AddDataToCache();
}
if (result != null && result.Count > 0)
{
if (end > result.Count)
{
end = result.Count;
}
data = CreateCustomizeTable(7);
for (int i = start; i < end; i++)
{
var current = result[i];
var row = data.NewRow();
row[0] = current.Period;
row[1] = current.A;
row[2] = current.B;
row[3] = current.AValue;
row[4] = current.BValue;
row[5] = current.AValue - current.BValue;
row[6] = String.Format("{0:P2}", result[i].BValue != 0 ? (result[i].AValue - result[i].BValue) / result[i].BValue : 1);
data.Rows.Add(row);
}
}
e.Total = (result != null ? result.Count : 0);
MainStore.DataSource = data;
MainStore.DataBind();
} catch (Exception err) {
WebUtility.WriteLog(EnmSysLogLevel.Error, EnmSysLogType.Exception, err.ToString(), Page.User.Identity.Name);
WebUtility.ShowMessage(EnmErrType.Error, err.Message);
}
}
/// <summary>
/// Store Refresh
/// </summary>
protected void OnMainStoreRefresh(object sender, StoreRefreshDataEventArgs e)
{
try {
var start = Int32.Parse(e.Parameters["start"]);
var limit = Int32.Parse(e.Parameters["limit"]);
var end = start + limit;
var data = new List <object>(limit);
var cacheKey = WebUtility.GetCacheKeyName(UserData, "kpi-report-122");
var result = HttpRuntime.Cache[cacheKey] as List <Report122Entity>;
if (result == null)
{
result = AddDataToCache();
}
if (result != null && result.Count > 0)
{
if (end > result.Count)
{
end = result.Count;
}
for (int i = start; i < end; i++)
{
data.Add(new {
ID = i + 1,
LscID = result[i].LscID,
LscName = result[i].LscName,
Date = result[i].Date,
Count = result[i].Gstations.Count,
TotalCount = result[i].Stations.Count,
Rate = String.Format("{0:P2}", result[i].Stations.Count != 0 ? (1 - (double)result[i].Gstations.Count / (double)result[i].Stations.Count) : 1)
});
}
}
e.Total = (result != null ? result.Count : 0);
MainStore.DataSource = data;
MainStore.DataBind();
} catch (Exception err) {
WebUtility.WriteLog(EnmSysLogLevel.Error, EnmSysLogType.Exception, err.ToString(), Page.User.Identity.Name);
WebUtility.ShowMessage(EnmErrType.Error, err.Message);
}
}
protected void MainStoreRefresh(object sender, StoreRefreshDataEventArgs e)
{
try {
var start = Int32.Parse(e.Parameters["start"]);
var limit = Int32.Parse(e.Parameters["limit"]);
var end = start + limit;
var data = new List <object>(limit);
var cacheKey = WebUtility.GetCacheKeyName(UserData, "energy-003-report");
var result = HttpRuntime.Cache[cacheKey] as List <EnergyInfo03>;
if (result == null)
{
result = AddDataToCache();
}
if (result != null && result.Count > 0)
{
if (end > result.Count)
{
end = result.Count;
}
for (int i = start; i < end; i++)
{
data.Add(new {
Key = result[i].Key,
Current = result[i].Current,
Period = result[i].Period,
Value = result[i].Value,
TValue = result[i].TValue,
CValue = result[i].Value - result[i].TValue,
Rate = String.Format("{0:P2}", result[i].TValue != 0 ? (result[i].Value - result[i].TValue) / result[i].TValue : 1)
});
}
}
e.Total = (result != null ? result.Count : 0);
MainStore.DataSource = data;
MainStore.DataBind();
} catch (Exception err) {
WebUtility.WriteLog(EnmSysLogLevel.Error, EnmSysLogType.Exception, err.ToString(), Page.User.Identity.Name);
WebUtility.ShowMessage(EnmErrType.Error, err.Message);
}
}
static void Main(string[] args)
{
var repo = new PizzaBoxRepository();
var db = new PizzaBox.Storing.PizzaBoxDbContext();
Store MainStore;
List <Store> stores = repo.ReadStores();
int num;
bool storeEnd = true;
do
{
int storeCount = 1;
System.Console.WriteLine("Pick the number for the store you would like to use.");
foreach (Store s in stores)
{
System.Console.WriteLine($"{storeCount} - {s.Location}");
storeCount += 1;
}
if (int.TryParse(System.Console.ReadLine(), out num))
{
System.Console.WriteLine();
storeEnd = false;
}
else
{
System.Console.WriteLine("Invalid Choice");
continue;
}
if (num > stores.Count)
{
System.Console.WriteLine("Invalid Choice");
storeEnd = true;
}
} while (storeEnd);
MainStore = stores[num - 1];
string choice;
System.Console.WriteLine("Are you a [Store] or [User]?");
choice = System.Console.ReadLine();
System.Console.WriteLine();
if (choice == "Store")
{
bool check = true;
int select;
do
{
System.Console.WriteLine("Pick the number for what you would like to do.");
System.Console.WriteLine("1 - Check Orders");
System.Console.WriteLine("2 - Check Sales");
System.Console.WriteLine("3 - Quit");
if (int.TryParse(System.Console.ReadLine(), out select))
{
System.Console.WriteLine();
}
else
{
System.Console.WriteLine("Invalid Choice");
continue;
}
switch (select)
{
case 1:
MainStore.DisplayOrders();
break;
case 2:
MainStore.DisplaySales(new DateTime());
break;
default:
check = false;
break;
}
} while (check);
}
else
{
string email;
System.Console.WriteLine("Please enter your username");
email = System.Console.ReadLine();
System.Console.WriteLine();
User user = repo.ReadUser(email);
bool check = true;
int select;
do
{
System.Console.WriteLine("Pick the number for what you would like to do.");
System.Console.WriteLine("1 - Check Orders");
System.Console.WriteLine("2 - Create");
System.Console.WriteLine("3 - Quit");
if (int.TryParse(System.Console.ReadLine(), out select))
{
System.Console.WriteLine();
}
else
{
System.Console.WriteLine("Invalid Choice");
continue;
}
switch (select)
{
case 1:
user.DisplayOrders();
break;
case 2:
Order order = new Order();
MainStore.ModifyOrder(user, order);
repo.CreateOrder(order, user.Id, MainStore.Id);
break;
// bool orderEnd = true;
// int choices;
// Order order;
// do
// {
// System.Console.WriteLine("Pick the number to create or modify an order.");
// System.Console.WriteLine();
// System.Console.WriteLine("0 - New Order");
// System.Console.WriteLine();
// System.Console.WriteLine("---------------------");
// user.DisplayOrders();
// if (int.TryParse(System.Console.ReadLine(), out choices))
// {
// System.Console.WriteLine();
// orderEnd = false;
// }
// else
// {
// System.Console.WriteLine("Invalid Choice");
// System.Console.WriteLine();
// continue;
// }
// if (choices >= user.Orders.Count)
// {
// System.Console.WriteLine("Invalid Choice");
// System.Console.WriteLine();
// orderEnd = true;
// }
// } while (orderEnd);
// if (choices == 0)
// {
// order = new Order();
// MainStore.ModifyOrder(user, order);
// }
// else
// {
// order = user.Orders[choices - 1];
// MainStore.ModifyOrder(user, order, "mod");
// }
// break;
default:
check = false;
break;
}
} while (check);
// repo.UpdateUser(user, MainStore.Id, MainStore.Location, DateTime.Now);
}
}
public JsonResult AddOrderAndOrderDetials(OrderViewModel orderViewModel)
{
bool status = true;
var isValidModel = TryUpdateModel(orderViewModel);
if (isValidModel)
{
using (ApplicationDbContext db = new ApplicationDbContext())
{
var cusname = db.CUST_TBLs.Find(orderViewModel.Cust_TBLId);
MndStkOut order = new MndStkOut()
{
OrderDate = System.DateTime.Now,
MndId = orderViewModel.Cust_TBLId,
MndName = cusname.CUST_NAME
};
db.mndStkOuts.Add(order);
if (db.SaveChanges() > 0)
{
int orderID = db.mndStkOuts.Max(o => o.Id);
foreach (var item in orderViewModel.Items)
{
MainStore orderDetails = new MainStore()
{
MndStkOutId = orderID,
Product_TbleId = item.ProductID,
Price = item.Quantity,
QtyIn = Convert.ToInt32(item.Price),
QtyOut = 0,
Amount = item.TotalPrice
};
Stock stock = new Stock()
{
Prod_Id = item.ProductID,
StQty = -Convert.ToInt32(item.Price),
Case = "مرتجع مندوب",
Date = System.DateTime.Now,
MndId = cusname.MND_TBLId,
Cust_Id = 0
};
db.mainStores.Add(orderDetails);
db.stocks.Add(stock);
}
if (db.SaveChanges() > 0)
{
return(new JsonResult {
Data = new { status = status, message = "Order Added Successfully" }
});
}
}
}
}
status = false;
return(new JsonResult {
Data = new { status = status, message = "Error !" }
});
}
static void Main(string[] args)
{
GetAppSettings settings = new GetAppSettings();
Console.WriteLine(settings.GetSetting("Test"));
Spelling spelling = new Spelling();
string word = "";
word = "PORK";
Console.WriteLine("{0} => {1}", word, spelling.Correct(word));
word = "FUU"; // 'correcter' is not in the dictionary file so this doesn't work
Console.WriteLine("{0} => {1}", word, spelling.Correct(word));
word = "LAMM";
Console.WriteLine("{0} => {1}", word, spelling.Correct(word));
word = "PAINT";
Console.WriteLine("{0} => {1}", word, spelling.Correct(word));
word = "ETAE";
Console.WriteLine("{0} => {1}", word, spelling.Correct(word));
// A sentence
string sentence = "I havve speled thes woord wwrong"; // sees speed instead of spelled (see notes on norvig.com)
string correction = "";
foreach (string item in sentence.Split(' '))
{
correction += " " + spelling.Correct(item);
}
Console.WriteLine("Did you mean:" + correction);
Enumerable.Range(Convert.ToInt32('A'), 26).Union(Enumerable.Range(Convert.ToInt32('0'), 10)).ToList().
ForEach(e => Console.WriteLine(Convert.ToChar(e)));
Console.WriteLine($"{DuoVia.FuzzyStrings.StringExtensions.FuzzyMatch("HONG", "HONG")}");
Console.WriteLine($"{DuoVia.FuzzyStrings.StringExtensions.FuzzyMatch("HOONG", "HONG")}");
Console.WriteLine($"{DuoVia.FuzzyStrings.StringExtensions.FuzzyMatch("HOONG", "HSOUNG")}");
Console.WriteLine($"{DuoVia.FuzzyStrings.StringExtensions.FuzzyMatch("HOONG", "HSIN")}");
Console.WriteLine($"{DuoVia.FuzzyStrings.StringExtensions.FuzzyMatch("Hello Wor1ld3", "Hello Warl12d3")}");
Console.WriteLine($"{FuzzyString.ComparisonMetrics.JaccardDistance("Hello World", "Hello World")}");
Console.WriteLine($"{FuzzyString.ComparisonMetrics.JaccardDistance("Hello World", "Hello Warld")}");
Console.WriteLine($"{FuzzyString.ComparisonMetrics.JaccardDistance("Hello World", "Hello Warl12d3")}");
Console.WriteLine($"{FuzzyString.ComparisonMetrics.JaccardDistance("Hello Wor1ld3", "Hello Warl12d3")}");
Console.WriteLine($"{FuzzyString.ComparisonMetrics.HammingDistance("Hello World", "Hello World")}");
Console.WriteLine($"{FuzzyString.ComparisonMetrics.HammingDistance("Hello World", "Hello Warld")}");
Console.WriteLine($"{FuzzyString.ComparisonMetrics.HammingDistance("Hello World", "Hello Warl12d3")}");
Console.WriteLine($"{FuzzyString.ComparisonMetrics.HammingDistance("Hello Wor1ld3", "Hello Warl12d3")}");
Console.WriteLine($"{FuzzyString.ComparisonMetrics.SorensenDiceDistance("Hello World", "Hello World")}");
Console.WriteLine($"{FuzzyString.ComparisonMetrics.SorensenDiceDistance("Hello World", "Hello Warld")}");
Console.WriteLine($"{FuzzyString.ComparisonMetrics.SorensenDiceDistance("Hello World", "Hello Warl12d3")}");
Console.WriteLine($"{FuzzyString.ComparisonMetrics.SorensenDiceDistance("Hello Wor1ld3", "Hello Warl12d3")}");
Console.WriteLine("Hello World".DiceCoefficient("Hello World"));
Console.WriteLine("Hello World".DiceCoefficient("Hello Warld"));
Console.WriteLine("Hello World".DiceCoefficient("Heo Warl12d3"));
Console.WriteLine("Hello World".DiceCoefficient("Hello Warl12d3"));
StringTrie <string> Trie = new StringTrie <string>();
Trie.Add("ABC", "ABC");
Trie.Add("ABCDEF", "ABCDEF");
Trie.Add("FGHIJK", "FGHIJK");
Trie.Add("KKK", "KKK");
Trie.Add("LLLLL", "LLLLL");
Trie.Add("LLLLLT", "LLLLLT");
Trie.Add("Tai Po", "Tai Po");
Trie.Add("Tai Po ABC", "Tai Po ABC");
Trie.Add("Tai Po ABC DEF", "Tai Po ABC DEF");
Trie.Add("Tai Po XXX", "Tai Po XXX");
Trie.Add("Tai Po YYY", "Tai Po YYY");
TraverseTrie(Trie,
n =>
{
Console.WriteLine($"Node: {n.Value}");
},
lf =>
{
Console.WriteLine($"Leaf: *****");
});
var node = Trie.Find("Tai Po A");
Console.WriteLine(node.IsLeaf + " " + node.HasValue);
Console.WriteLine("*************************");
node.Descendants.ToList().ForEach(e =>
{
if (e.HasValue)
{
Console.WriteLine(e.Value);
}
});
Console.WriteLine("*************************");
node = Trie.Find("Tai Po AB");
Console.WriteLine(node.IsLeaf + " " + node.HasValue);
node = Trie.Find("Tai Po ABC");
Console.WriteLine(node.IsLeaf + " " + node.HasValue);
List <string> l = new List <string>();
l.Add("");
l.Add(null);
l.Add("Hello World");
foreach (var ll in l)
{
if (string.IsNullOrEmpty(ll))
{
continue;
}
Console.WriteLine(ll);
}
var s = "([([}) [] A [] [] Test ]]]]] ";
Console.WriteLine(s.Replace('(', Convert.ToChar(32)).Replace(')', Convert.ToChar(32)).Replace('[', Convert.ToChar(32)));
/*
* FileStream fs = new FileStream(@"C:\Temp\TestAddr.csv", FileMode.Open, FileAccess.Read);
* var reader = new CsvReader(new StreamReader(fs));
* reader.ReadHeader();
* int i = 0;
* while (reader.Read())
* {
* var addr = reader.GetRecord<Addr>();
* Console.WriteLine(addr);
* if (i++ >= 10)
* break;
* }
* var p = System.IO.Path.GetTempPath();
*/
var r = "A".CompareTo("B");
var cm = new CodeMappings();
HashSet <int> hs = new HashSet <int>();
hs.Add(1);
hs.Add(2);
hs.Add(1);
hs.Add(2);
hs.Add(3);
foreach (var x in hs)
{
Console.WriteLine(x);
}
Console.WriteLine("First Result Set ******************************************************************************");
var res1 = LCSFinder.GetLCS("A B C D E F G H", "A B C D U V Y K");
var res2 = LCSFinder.GetLCS("A B C D E F G H", "A I B T C O D L");
Console.WriteLine(res1);
Console.WriteLine(res2);
Console.WriteLine("Second Result Set ******************************************************************************");
var res3 = LCSFinder.GetLCS("AA BB CC DDD EE FFFF GG H", "AA XXXX BDB YYYYYY CC DD123DD U EE V Y K");
var res4 = LCSFinder.GetLCS("AA BB CC DDD EE FFFF GG H", "AA I BB T CC OXXXXX DDD L EE");
Console.WriteLine(res3);
Console.WriteLine(res4);
Console.WriteLine("Third Result Set ******************************************************************************");
var res5 = LCSFinder.GetLCS("AA BB CC DD E F G", "AA BB CC BB II CC KK DD H I K");
var res6 = LCSFinder.GetLCS("AA BB CC DD E F G", "AA BB CCCC DD II E A F B G");
Console.WriteLine(res5);
Console.WriteLine(res6);
Console.WriteLine("******************************************************************************");
Console.WriteLine("First Result Set ******************************************************************************");
var resX = "A B C D E F G H".LongestCommonSubsequence("A B C D U V Y K");
var resY = "A B C D E F G H".LongestCommonSubsequence("A I B T C O D L");
Console.WriteLine(resX);
Console.WriteLine(resY);
Console.WriteLine("Second Result Set ******************************************************************************");
var resA = "AA BB CC DDD EE FFFF GG H".LongestCommonSubsequence("AA XXXX BDB YYYYYY CC DD123DD U EE V Y K");
var resB = "AA BB CC DDD EE FFFF GG H".LongestCommonSubsequence("AA I BB T CC OXXXXX DDD L EE");
Console.WriteLine(resA);
Console.WriteLine(resB);
Console.WriteLine("Third Result Set ******************************************************************************");
var resC = "AA BB CC DD E F G".LongestCommonSubsequence("AA BB CC BB II CC KK DD H I K");
var resD = "AA BB CC DD E F G".LongestCommonSubsequence("AA BB CCCC DD II E A F B G");
Console.WriteLine(resC);
Console.WriteLine(resD);
Console.WriteLine("******************************************************************************");
Console.WriteLine("1 Result Set ******************************************************************************");
var r1 = "ABCDEFGH".LongestCommonSubsequence("ABCDUVYK");
var r2 = "ABCDEFGH".LongestCommonSubsequence("AIBTCODL");
Console.WriteLine(r1);
Console.WriteLine(r2);
Console.WriteLine("2 Result Set ******************************************************************************");
var r3 = "AABBCCDDDEEFFFFGGH".LongestCommonSubsequence("AAXXXXBDBYYYYYYCCDD123DDUEEVYK");
var r4 = "AABBCCDDDEEFFFFGGH".LongestCommonSubsequence("AAIBBTCCOXXXXXDDDLEE");
Console.WriteLine(r3);
Console.WriteLine(r4);
Console.WriteLine("3 Result Set ******************************************************************************");
var r5 = "AABBCCDDEFG".LongestCommonSubsequence("AABBCCBBIICCKKDDHIK");
var r6 = "AABBCCDDEFG".LongestCommonSubsequence("AABBCCCCDDIIEAFBG");
Console.WriteLine(r5);
Console.WriteLine(r6);
Console.WriteLine("******************************************************************************");
Console.WriteLine("4 Result Set ******************************************************************************");
var r7 = "SUN FUNG WAI".LongestCommonSubsequence("SAN FUNG WAI");
var r8 = "SUN FUNG WAI".LongestCommonSubsequence("SAN WAI COURT");
Console.WriteLine(r7);
Console.WriteLine(r8);
Console.WriteLine("******************************************************************************");
Enumerable.Range(1, 20).ToList().ForEach(e =>
{
var rA = ToRoman(e);
var sA = ConvertRomanToNumber(rA);
Console.WriteLine($"{rA}->{sA}");
});
MainStore ms = new MainStore();
ms.Serialize(@"C:\Temp\tt.json");
List <StreetNoExpansion> stl = new List <StreetNoExpansion>()
{
new StreetNoExpansion(13, "A", 13, "A"), //0
new StreetNoExpansion(13, "L", 14, "L"), //1
new StreetNoExpansion(13, "L", 17, "L"), //2
new StreetNoExpansion(13, "L", 20, "L"), //3
new StreetNoExpansion(13, "L", 14, "M"), //4
new StreetNoExpansion(12, "", 12, ""), //5
new StreetNoExpansion(12, "A", 12, "A"), //6
new StreetNoExpansion(12, "", 19, ""), //7
new StreetNoExpansion(12, "", 20, ""), //8
new StreetNoExpansion(12, "", 12, ""), //9
new StreetNoExpansion(12, "", 13, ""), //10
new StreetNoExpansion(12, "A", 12, "B"), //11
new StreetNoExpansion(14, "D", 21, "S"), //12
new StreetNoExpansion(15, "A", 17, ""), //13
new StreetNoExpansion(15, "A", 29, ""), //14
new StreetNoExpansion(15, "B", 16, ""), //15
new StreetNoExpansion(15, "C", 15, ""), //16
new StreetNoExpansion(16, "", 17, "B"), //17
new StreetNoExpansion(16, "", 18, "B"), //18
new StreetNoExpansion(16, "", 16, "B"), //19
new StreetNoExpansion(16, "", 20, "D"), //20
new StreetNoExpansion(16, "A", 17, ""), //21
new StreetNoExpansion(16, "B", 18, ""), //22
new StreetNoExpansion(16, "C", 16, ""), //23
new StreetNoExpansion(16, "D", 20, ""), //24
new StreetNoExpansion(3, "EA3", 3, "EA3"), //25
new StreetNoExpansion(3, "A", 0, ""), //26
new StreetNoExpansion(3, "", 0, ""), //27
};
stl.ForEach(e => Console.WriteLine(e));
var line = "";
while (!string.IsNullOrEmpty(line = Console.ReadLine()))
{
Console.Write(">");
if (!ConvertStreetNoFromStringToComponents(line, out int from, out string fromA, out int to, out string toA))
{
Console.WriteLine("Conversion Failed");
continue;
}
int idx = 0;
stl.ForEach(e =>
{
Console.WriteLine($"{idx++}->{e.MatchStreetNo(from, fromA, to, toA)}");
});
}
}
public JsonResult AddReturnDetials(OrderViewModel orderViewModel)
{
bool status = true;
var isValidModel = TryUpdateModel(orderViewModel);
if (isValidModel)
{
using (ApplicationDbContext db = new ApplicationDbContext())
{
var subname = db.suply_Tbls.Find(orderViewModel.Cust_TBLId);
ReBUy_tbl order = new ReBUy_tbl()
{
OrderDate = System.DateTime.Now,
Sup_Id = orderViewModel.Cust_TBLId,
Sup_Name = subname.Name
};
db.rbuy_Tbls.Add(order);
if (db.SaveChanges() > 0)
{
int orderID = db.rsal_Tbls.Max(o => o.Id);
foreach (var item in orderViewModel.Items)
{
MainStore orderDetails = new MainStore()
{
ReBUy_tblId = orderID,
Product_TbleId = item.ProductID,
Price = item.Price,
QtyOut = item.Quantity,
QtyIn = 0,
Amount = item.TotalPrice,
Date = DateTime.Now
};
var stck = db.product_Tbles.Where(p => p.Id == item.ProductID).FirstOrDefault();
stck.SQty = stck.SQty + item.Quantity;
Sub_Acount sub = new Sub_Acount()
{
Suply_TblId = orderViewModel.Cust_TBLId,
RbyNo = orderID,
ByNo = 0,
EslNo = 0,
Amount = -item.TotalPrice,
Date = System.DateTime.Now
};
db.mainStores.Add(orderDetails);
db.sub_Acounts.Add(sub);
}
if (db.SaveChanges() > 0)
{
return(new JsonResult {
Data = new { status = status, message = "Order Added Successfully" }
});
}
}
}
}
status = false;
return(new JsonResult {
Data = new { status = status, message = "Error !" }
});
}
public JsonResult OutMndStockDetials(OrderViewModel orderViewModel)
{
bool status = true;
var isValidModel = TryUpdateModel(orderViewModel);
if (isValidModel)
{
using (ApplicationDbContext db = new ApplicationDbContext())
{
var mndname = db.MND_TBLs.Find(orderViewModel.Cust_TBLId);
MndStkOut order = new MndStkOut()
{
OrderDate = System.DateTime.Now,
MndId = orderViewModel.Cust_TBLId,
MndName = mndname.MND_NAME
};
db.mndStkOuts.Add(order);
if (db.SaveChanges() > 0)
{
int orderID = db.mndStkOuts.Max(o => o.Id);
foreach (var item in orderViewModel.Items)
{
MainStore orderDetails = new MainStore()
{
MndStkOutId = orderID,
Product_TbleId = item.ProductID,
Price = item.Price,
QtyIn = item.Quantity,
QtyOut = 0,
Date = DateTime.Now,
Amount = item.TotalPrice
};
Stock stock = new Stock()
{
Prod_Id = item.ProductID,
MndId = mndname.Id,
StQty = -item.Quantity,
Date = DateTime.Now,
Case = "مرتجع مندوب",
Cust_Id = 0
};
var stk = db.product_Tbles.Where(x => x.Id == item.ProductID).FirstOrDefault();
stk.SQty = stk.SQty + item.Quantity;
db.stocks.Add(stock);
db.mainStores.Add(orderDetails);
}
if (db.SaveChanges() > 0)
{
return(new JsonResult {
Data = new { status = status, message = "Order Added Successfully" }
});
}
}
}
}
status = false;
return(new JsonResult {
Data = new { status = status, message = "Error !" }
});
}
