private static async Task ProcessMessagesAsync(Message message, CancellationToken cancellationToken)
{
var json = Encoding.UTF8.GetString(message.Body);
var userFoodRestriction = JsonConvert.DeserializeObject <UserFoodRestriction>(json);
if (userFoodRestriction.Restrictions.Count() > 0)
{
DbContextOptionsBuilder DbContextOptionsBuilder = new DbContextOptionsBuilder <DashboardDB>();
using (var context = new DashboardDB(DbContextOptionsBuilder.Options))
{
//context.FoodRestrictions.Add(new Models.FoodRestriction { UserId = userFoodRestriction.UserId, Restrictions = string.Join(", ", userFoodRestriction.Restrictions.OrderBy(p => p)) }); #FIX - User API
context.FoodRestrictions.Add(new Models.FoodRestriction {
UserId = new Random().Next(1, 99999), Restrictions = string.Join(", ", "soja,leite,pimenta,mel,carne".Split(",").OrderBy(p => p))
});
context.SaveChanges();
}
}
Console.WriteLine($"Received message: SequenceNumber:{message.SystemProperties.SequenceNumber} Body:{Encoding.UTF8.GetString(message.Body)}");
await _subscriptionClient.CompleteAsync(message.SystemProperties.LockToken);
}
private void grdDocumentList_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
DashboardDB dsDB = new DashboardDB();
try
{
if (e.RowIndex < 0)
{
return;
}
string columnName = grdDocumentList.Columns[e.ColumnIndex].Name;
if (columnName.Equals("Acknowledge") || columnName.Equals("Close"))
{
prevdsb.DocumentID = grdDocumentList.Rows[e.RowIndex].Cells["DocumentID"].Value.ToString();
prevdsb.DocumentName = grdDocumentList.Rows[e.RowIndex].Cells["DocumentName"].Value.ToString();
prevdsb.TemporaryNo = Convert.ToInt32(grdDocumentList.Rows[e.RowIndex].Cells["TemporaryNo"].Value.ToString());
prevdsb.TemporaryDate = Convert.ToDateTime(grdDocumentList.Rows[e.RowIndex].Cells["TemporaryDate"].Value.ToString());
prevdsb.DocumentNo = Convert.ToInt32(grdDocumentList.Rows[e.RowIndex].Cells["DocumentNo"].Value.ToString());
prevdsb.DocumentDate = Convert.ToDateTime(grdDocumentList.Rows[e.RowIndex].Cells["DocumentDate"].Value);
prevdsb.ActivityType = setActivityType(grdDocumentList.Rows[e.RowIndex].Cells["ActivityType"].Value.ToString());
prevdsb.FromUserName = grdDocumentList.Rows[e.RowIndex].Cells["FromUser"].Value.ToString();
if (columnName.Equals("Acknowledge"))
{
prevdsb.AckStatus = 1;
}
else
{
prevdsb.AckStatus = 0;
}
if (prevdsb.AckStatus == 1)
{
if (dsDB.updateDashboardAlarm(prevdsb, Login.userLoggedIn))
{
MessageBox.Show("Ack Status Updated");
}
else
{
MessageBox.Show("Failed to Updated");
}
}
else
{
if (dsDB.DeleteDashboardAlarm(prevdsb, Login.userLoggedIn))
{
MessageBox.Show("Dasboard detail deleted");
}
else
{
MessageBox.Show("Failed to delete");
}
}
}
ShowIncomingDocumentList();
}
catch (Exception ex)
{
}
}
public async Task <IActionResult> SalesAsync()
{
var list = new List <Sale>();
DbContextOptionsBuilder DbContextOptionsBuilder = new DbContextOptionsBuilder <DashboardDB>();
using (var context = new DashboardDB(DbContextOptionsBuilder.Options))
{
#region MOCK
context.Orders.Add(new Models.Order {
StoreId = new Random().Next(1, 3), OrderId = new Random().Next(1, 99999), Value = new Random().Next(1, 100), Date = DateTime.Now.AddMinutes(-30 * 1)
});
context.Orders.Add(new Models.Order {
StoreId = new Random().Next(1, 3), OrderId = new Random().Next(1, 99999), Value = new Random().Next(1, 100), Date = DateTime.Now.AddMinutes(-30 * 2)
});
context.Orders.Add(new Models.Order {
StoreId = new Random().Next(1, 3), OrderId = new Random().Next(1, 99999), Value = new Random().Next(1, 100), Date = DateTime.Now.AddMinutes(-30 * 3)
});
context.Orders.Add(new Models.Order {
StoreId = new Random().Next(1, 3), OrderId = new Random().Next(1, 99999), Value = new Random().Next(1, 100), Date = DateTime.Now.AddMinutes(-30 * 4)
});
context.Orders.Add(new Models.Order {
StoreId = new Random().Next(1, 3), OrderId = new Random().Next(1, 99999), Value = new Random().Next(1, 100), Date = DateTime.Now.AddMinutes(-30 * 5)
});
context.Orders.Add(new Models.Order {
StoreId = new Random().Next(1, 3), OrderId = new Random().Next(1, 99999), Value = new Random().Next(1, 100), Date = DateTime.Now.AddMinutes(-30 * 6)
});
context.Orders.Add(new Models.Order {
StoreId = new Random().Next(1, 3), OrderId = new Random().Next(1, 99999), Value = new Random().Next(1, 100), Date = DateTime.Now.AddMinutes(-30 * 7)
});
context.SaveChanges();
#endregion
if (context.Orders.Any())
{
var orders = await context.Orders.ToListAsync();
list = orders.GroupBy(x => x.StoreId).Select(g => new Sale
{
StoreId = g.Key,
Total = g.Count(),
Value = g.Sum(c => c.Value)
}).ToList();
}
}
return(Ok(list));
}
private Boolean updateDashBoard(smrn smrn, int stat)
{
Boolean status = true;
try
{
dashboardalarm dsb = new dashboardalarm();
DashboardDB ddsDB = new DashboardDB();
dsb.DocumentID = smrn.DocumentID;
dsb.TemporaryNo = smrn.SMRNNo;
dsb.TemporaryDate = smrn.SMRNDate;
//dsb.DocumentNo = smrn.ProductionPlanNo;
//dsb.DocumentDate = smrn.ProductionPlanDate;
dsb.FromUser = Login.userLoggedIn;
if (stat == 1)
{
dsb.ActivityType = 2;
dsb.ToUser = smrn.ForwardUser;
if (!ddsDB.insertDashboardAlarm(dsb))
{
MessageBox.Show("DashBoard Fail to update");
status = false;
}
}
else if (stat == 2)
{
dsb.ActivityType = 3;
List <documentreceiver> docList = DocumentReceiverDB.getDocumentWiseReceiver(prevsh.DocumentID);
foreach (documentreceiver docRec in docList)
{
dsb.ToUser = docRec.EmployeeID; //To store UserID Form DocumentReceiver for current Document
dsb.DocumentDate = UpdateTable.getSQLDateTime();
if (!ddsDB.insertDashboardAlarm(dsb))
{
MessageBox.Show("DashBoard Fail to update");
status = false;
}
}
}
}
catch (Exception ex)
{
status = false;
}
return(status);
}
private Boolean updateDashBoard(popiheader popih, int stat)
{
Boolean status = true;
try
{
dashboardalarm dsb = new dashboardalarm();
DashboardDB ddsDB = new DashboardDB();
dsb.DocumentID = popih.DocumentID;
dsb.TemporaryNo = popih.TemporaryNo;
dsb.TemporaryDate = popih.TemporaryDate;
dsb.DocumentNo = popih.TrackingNo;
dsb.DocumentDate = popih.TrackingDate;
dsb.FromUser = Login.userLoggedIn;
if (stat == 1)
{
dsb.ActivityType = 2;
dsb.ToUser = popih.ForwardUser;
if (!ddsDB.insertDashboardAlarm(dsb))
{
MessageBox.Show("DashBoard Fail to update");
status = false;
}
}
else if (stat == 2)
{
dsb.ActivityType = 3;
List <documentreceiver> docList = DocumentReceiverDB.getDocumentWiseReceiver(MatDel.DocumentID);
foreach (documentreceiver docRec in docList)
{
dsb.ToUser = docRec.EmployeeID;
dsb.DocumentDate = UpdateTable.getSQLDateTime();
if (!ddsDB.insertDashboardAlarm(dsb))
{
MessageBox.Show("DashBoard Fail to update");
status = false;
}
}
}
}
catch (Exception ex)
{
status = false;
}
return(status);
}
private static async Task ProcessMessagesAsync(Message message, CancellationToken cancellationToken)
{
var json = Encoding.UTF8.GetString(message.Body);
var order = JsonConvert.DeserializeObject <OrderChangedMessage>(json);
if (order.State == OrderState.Paid)
{
DbContextOptionsBuilder DbContextOptionsBuilder = new DbContextOptionsBuilder <DashboardDB>();
using (var context = new DashboardDB(DbContextOptionsBuilder.Options))
{
//context.Orders.Add(new Models.Order { StoreId = order.StoreId, OrderId = order.OrderId, Value = order.Value = DateTime.Now }); #FIX - Order API
context.Orders.Add(new Models.Order {
StoreId = new Random().Next(1, 3), OrderId = new Random().Next(1, 99999), Value = new Random().Next(1, 100), Date = DateTime.Now
});
context.SaveChanges();
}
}
Console.WriteLine($"Received message: SequenceNumber:{message.SystemProperties.SequenceNumber} Body:{Encoding.UTF8.GetString(message.Body)}");
await _subscriptionClient.CompleteAsync(message.SystemProperties.LockToken);
}
private void ShowIncomingDocumentList()
{
////Boolean stat = true;
try
{
grdDocumentList.Rows.Clear();
DashboardDB dsDB = new DashboardDB();
List <dashboardalarm> DSList = dsDB.getDashboardAlarms(Login.userLoggedIn);
foreach (dashboardalarm dsl in DSList)
{
grdDocumentList.Rows.Add();
grdDocumentList.Rows[grdDocumentList.RowCount - 1].Cells["LineNo"].Value = grdDocumentList.RowCount;
grdDocumentList.Rows[grdDocumentList.RowCount - 1].Cells["DocumentID"].Value = dsl.DocumentID;
grdDocumentList.Rows[grdDocumentList.RowCount - 1].Cells["DocumentName"].Value = dsl.DocumentName;
grdDocumentList.Rows[grdDocumentList.RowCount - 1].Cells["TemporaryNo"].Value = dsl.TemporaryNo;
grdDocumentList.Rows[grdDocumentList.RowCount - 1].Cells["TemporaryDate"].Value = dsl.TemporaryDate;
grdDocumentList.Rows[grdDocumentList.RowCount - 1].Cells["DocumentNo"].Value = dsl.DocumentNo;
grdDocumentList.Rows[grdDocumentList.RowCount - 1].Cells["DocumentDate"].Value = dsl.DocumentDate;
grdDocumentList.Rows[grdDocumentList.RowCount - 1].Cells["ActivityType"].Value = getActivityType(dsl.ActivityType);
grdDocumentList.Rows[grdDocumentList.RowCount - 1].Cells["FromUser"].Value = dsl.FromUserName;
}
if (grdDocumentList.Rows.Count > 0)
{
pnlShowCurrentDocument.Visible = true;
}
else
{
pnlShowCurrentDocument.Visible = false;
}
}
catch (Exception ex)
{
MessageBox.Show("Error in showing DocumentList Status");
}
////return stat;
}
public async Task <IActionResult> Sales(string Per, int Value)
{
var list = new List <Sale>();
DbContextOptionsBuilder DbContextOptionsBuilder = new DbContextOptionsBuilder <DashboardDB>();
using (var context = new DashboardDB(DbContextOptionsBuilder.Options))
{
#region MOCK
context.Orders.Add(new Models.Order {
StoreId = new Random().Next(1, 3), OrderId = new Random().Next(1, 99999), Value = new Random().Next(1, 100), Date = DateTime.Now.AddMinutes(-30 * 1)
});
context.Orders.Add(new Models.Order {
StoreId = new Random().Next(1, 3), OrderId = new Random().Next(1, 99999), Value = new Random().Next(1, 100), Date = DateTime.Now.AddMinutes(-30 * 2)
});
context.Orders.Add(new Models.Order {
StoreId = new Random().Next(1, 3), OrderId = new Random().Next(1, 99999), Value = new Random().Next(1, 100), Date = DateTime.Now.AddMinutes(-30 * 3)
});
context.Orders.Add(new Models.Order {
StoreId = new Random().Next(1, 3), OrderId = new Random().Next(1, 99999), Value = new Random().Next(1, 100), Date = DateTime.Now.AddMinutes(-30 * 4)
});
context.Orders.Add(new Models.Order {
StoreId = new Random().Next(1, 3), OrderId = new Random().Next(1, 99999), Value = new Random().Next(1, 100), Date = DateTime.Now.AddMinutes(-30 * 5)
});
context.Orders.Add(new Models.Order {
StoreId = new Random().Next(1, 3), OrderId = new Random().Next(1, 99999), Value = new Random().Next(1, 100), Date = DateTime.Now.AddMinutes(-30 * 6)
});
context.Orders.Add(new Models.Order {
StoreId = new Random().Next(1, 3), OrderId = new Random().Next(1, 99999), Value = new Random().Next(1, 100), Date = DateTime.Now.AddMinutes(-30 * 7)
});
context.SaveChanges();
#endregion
if (context.Orders.Any())
{
var orders = await context.Orders.ToListAsync();
DateTime compareDate = DateTime.Now;
switch (Per.ToLower().Trim())
{
case "minute":
compareDate = DateTime.Now.AddMinutes(-Value);
break;
case "hour":
compareDate = DateTime.Now.AddHours(-Value);
break;
case "day":
compareDate = DateTime.Now.AddDays(-Value);
break;
case "month":
compareDate = DateTime.Now.AddMonths(-Value);
break;
case "year":
compareDate = DateTime.Now.AddYears(-Value);
break;
default:
compareDate = DateTime.Now;
break;
}
list = orders.Where(x => x.Date >= compareDate).GroupBy(x => x.StoreId).Select(g => new Sale
{
StoreId = g.Key,
Total = g.Count(),
Value = g.Sum(c => c.Value)
}).ToList();
}
}
return(Ok(list));
}
public async Task <IActionResult> UsersWithLessOffer()
{
var list = new List <Restriction>();
DbContextOptionsBuilder DbContextOptionsBuilder = new DbContextOptionsBuilder <DashboardDB>();
using (var context = new DashboardDB(DbContextOptionsBuilder.Options))
{
#region MOCK
context.FoodRestrictions.Add(new Models.FoodRestriction {
UserId = new Random().Next(1, 99999), Restrictions = string.Join(", ", "soja".Split(",").OrderBy(p => p))
});
context.FoodRestrictions.Add(new Models.FoodRestriction {
UserId = new Random().Next(1, 99999), Restrictions = string.Join(", ", "soja,leite".Split(",").OrderBy(p => p))
});
context.FoodRestrictions.Add(new Models.FoodRestriction {
UserId = new Random().Next(1, 99999), Restrictions = string.Join(", ", "soja,leite".Split(",").OrderBy(p => p))
});
context.FoodRestrictions.Add(new Models.FoodRestriction {
UserId = new Random().Next(1, 99999), Restrictions = string.Join(", ", "soja,leite,pimenta".Split(",").OrderBy(p => p))
});
context.FoodRestrictions.Add(new Models.FoodRestriction {
UserId = new Random().Next(1, 99999), Restrictions = string.Join(", ", "soja,leite,pimenta".Split(",").OrderBy(p => p))
});
context.FoodRestrictions.Add(new Models.FoodRestriction {
UserId = new Random().Next(1, 99999), Restrictions = string.Join(", ", "soja,leite,pimenta".Split(",").OrderBy(p => p))
});
context.FoodRestrictions.Add(new Models.FoodRestriction {
UserId = new Random().Next(1, 99999), Restrictions = string.Join(", ", "soja,leite,pimenta,mel".Split(",").OrderBy(p => p))
});
context.FoodRestrictions.Add(new Models.FoodRestriction {
UserId = new Random().Next(1, 99999), Restrictions = string.Join(", ", "soja,leite,pimenta,mel,carne".Split(",").OrderBy(p => p))
});
context.FoodRestrictions.Add(new Models.FoodRestriction {
UserId = new Random().Next(1, 99999), Restrictions = string.Join(", ", "soja,leite,pimenta,mel,carne".Split(",").OrderBy(p => p))
});
context.FoodRestrictions.Add(new Models.FoodRestriction {
UserId = new Random().Next(1, 99999), Restrictions = string.Join(", ", "soja,leite,pimenta,mel,carne".Split(",").OrderBy(p => p))
});
context.FoodRestrictions.Add(new Models.FoodRestriction {
UserId = new Random().Next(1, 99999), Restrictions = string.Join(", ", "soja,leite,pimenta,mel,carne".Split(",").OrderBy(p => p))
});
context.FoodRestrictions.Add(new Models.FoodRestriction {
UserId = new Random().Next(1, 99999), Restrictions = string.Join(", ", "soja,leite,pimenta,mel,carne".Split(",").OrderBy(p => p))
});
context.SaveChanges();
#endregion
if (context.FoodRestrictions.Any())
{
var foodRestrictions = await context.FoodRestrictions.ToListAsync();
list = foodRestrictions.GroupBy(x => x.Restrictions).Select(g => new Restriction
{
Users = g.Count(),
Type = string.Join(", ", g.Key)
}).OrderByDescending(x => x.Users).ToList();
}
}
return(Ok(list));
}
