public async Task <IActionResult> UpdateImgOfCategory([FromBody] PictureUpdate pictureUpdate)
{
try
{
if (pictureUpdate.Picture.Length > 0)
{
var category = await _uow.Repository <Category>()
.GetAll().FirstOrDefaultAsync(x => x.CategoryId == pictureUpdate.CategoryId);
if (category is not null)
{
_mapper.Map(pictureUpdate, category);
await _uow.SaveChangesAsync();
return(Ok(new { info = "The picture of category has been updated." }));
}
return(BadRequest(new
{
error = "The selected category is not available."
}));
}
return(BadRequest(new
{
error = $"The picture name field cannot be empty. The picture was not updated."
}));
}
catch (Exception e)
{
return(Problem(e.Message, null, null, e.Source));
}
}
private void timer1_Tick(object sender, EventArgs e)
{
string[] list = new string[9];
ListViewItem item;
bool Updated = false;
var term = "";
if (Term != "خودکار")
{
term = "AND FoodTermName = '" + Term + "'";
}
cmd = new SqlCommand("SELECT * FROM [Framework].[Rst].[Monitoring] WHERE OnlineUserID = 123456789 and ResturantName = '" + Rest + "' " + term + " AND ServeDate = '" + selecteddate + "' and ID > " + ID + " ORDER BY ID ASC OFFSET 0 ROWS fetch next 100 rows only", con);
using (var data = cmd.ExecuteReader())
{
while (true)
{
if (data.Read())
{
try
{
Updated = true;
list[1] = data.safeGetString(data.GetOrdinal("PersonID"));
list[2] = data.safeGetString(data.GetOrdinal("PersonName"));
list[3] = data.safeGetString(data.GetOrdinal("DeptName"));
list[4] = data.safeGetString(data.GetOrdinal("FoodName"));
list[5] = data.safeGetString(data.GetOrdinal("Time"));
list[6] = data.safeGetString(data.GetOrdinal("FoodTermName"));
list[7] = data.safeGetString(data.GetOrdinal("ResturantName"));
list[8] = data.safeGetString(data.GetOrdinal("StrError"));
lastTerm = data.safeGetString(data.GetOrdinal("FoodTermName"));
ID = data.GetInt32(data.GetOrdinal("ID"));
if (!data.IsDBNull(data.GetOrdinal("FishNo")))
{
FishNo = data.GetInt32(data.GetOrdinal("FishNo"));
list[0] = FishNo.ToString();
}
else
{
list[0] = "-";
}
}
catch
{
continue;
}
finally
{
item = new ListViewItem(list);
listView1.Items.Insert(0, item);
pictureBox1.Image = null;
PictureUpdate.Stop();
PictureUpdate.Start();
}
}
else
{
break;
}
}
}
var total = listView1.Items.Count;
for (int i = total; i > 2000; i--)
{
listView1.Items.RemoveAt(i - 1);
}
if (Updated)
{
FishNum.Text = list[0];
PersonID.Text = list[1];
PersonName.Text = list[2];
DeptName.Text = list[3];
FoodName.Text = list[4];
Time.Text = list[5];
FoodTerm.Text = list[6];
RestName.Text = list[7];
StrError.Text = list[8];
if (list[8] != "مجاز به استفاده")
{
StrError.ForeColor = Color.Red;
}
else
{
StrError.ForeColor = Color.MediumSeaGreen;
}
}
}
