public IHttpActionResult PutDailyFile(DailyFile dailyFile)
{
int id = dailyFile.Id;
dailyFile.CreatedDate = DateTime.UtcNow;
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != dailyFile.Id)
{
return(BadRequest());
}
_db.Entry(dailyFile).State = EntityState.Modified;
try
{
_db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!DailyFileExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult GetDailyFile(int Id)
{
DailyFile dailyFile = _db.DailyFiles.Find(Id);
dailyFile.DailyFileDetailses = new List <DailyFileDetails>();
dailyFile.DailyFileDetailses =
_db.DailyFileDetailses.Where(x => x.DailyFileId == Id).Include("Employee").ToList();
if (dailyFile == null)
{
return(NotFound());
}
return(Ok(dailyFile));
}
private void InsertIntoDailyFiles(DailyFile dailyFile, string root, int newname)
{
dailyFile.FilePath = root + newname + ".xls";
string con =
(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + dailyFile.FilePath +
";Extended Properties='Excel 12.0 Xml; HDR = YES; IMEX = 1';");
//string con2 =
// (@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\File\Bank.xls;Extended Properties='Excel 12.0 Xml; HDR = YES; IMEX = 1';");
BL bl = new BL(con);
DataTable dtw = bl.GetTable("select * from [Sheet1$]");
List <DailyFileDetails> list = new List <DailyFileDetails>();
foreach (DataRow row in dtw.Rows)
{
if (row[6].ToString() != "")
{
int empid = Convert.ToInt32(row[4]);
if (Convert.ToDecimal(row[6]) > 0)
{
var firstOrDefault = _db.Employees.FirstOrDefault(x => x.Code == (empid));
if (firstOrDefault != null)
{
dailyFile.DailyFileDetailses.Add(new DailyFileDetails()
{
Net = Convert.ToDecimal(row[6]),
EmployeeId = firstOrDefault.Id,
DailyFileId = dailyFile.Id,
Employee = firstOrDefault
});
}
}
}
}
dailyFile.EmployeesNumber = dailyFile.DailyFileDetailses.Count;
dailyFile.FileTotalAmount = dailyFile.DailyFileDetailses.Sum(x => x.Net);
_db.DailyFiles.Add(dailyFile);
_db.SaveChanges();
}
public IHttpActionResult DeleteDailyFile(int Id)
{
DailyFile dailyFile = _db.DailyFiles.Find(Id);
if (dailyFile == null)
{
return(NotFound());
}
_db.DailyFiles.Remove(dailyFile);
if (File.Exists(dailyFile.FilePath))
{
File.Delete(dailyFile.FilePath);
}
_db.SaveChanges();
return(Ok(dailyFile));
}
private void AddBtn_Click(object sender, RoutedEventArgs e)
{
try
{
CheckoutProductViewModel viewModel;
var textBoxContent = CodeAndQuantityTxt.Text;
//Добавяне на продукт
if (Regex.Match(textBoxContent, @"^\d+\*{1}\d+$").Success&& textBoxContent != "*+")
{
var splittedText = textBoxContent.Split('*').ToList();
bool n = false;
foreach (var text in splittedText)
{
if (String.IsNullOrEmpty(text))
{
n = true;
}
}
if (!n)
{
var itemIdOrBarcode = 0;
int length = (int)(Math.Log10(int.MaxValue) + 1);
if (splittedText[1].Length < length)
{
itemIdOrBarcode = int.Parse(splittedText[1]);
}
var item = dBContext.Products.AsNoTracking().FirstOrDefault(p => p.Id == itemIdOrBarcode || p.Barcode == splittedText[1]);
if (item == null || item.IsDeleted)
{
SystemSounds.Hand.Play();
MessageBox.Show($"Няма такъв продукт с id/barcode {itemIdOrBarcode}!");
throw new Exception($"Няма такъв продукт с id/barcode {itemIdOrBarcode}!");
}
var itemQuantity = decimal.Parse(splittedText[0]);
totalPrice = item.Price * itemQuantity;
viewModel = new CheckoutProductViewModel()
{
Barcode = item.Barcode,
Id = item.Id,
Measure = item.Measure,
Name = item.Name,
Price = item.Price,
Quantity = itemQuantity,
TotalPrice = totalPrice
};
Products.Add(item);
ProductsList.Add(viewModel);
ProductsListGrid.ItemsSource = ProductsList;
totalPrice = ProductsList.Sum(x => x.TotalPrice);
TotalPriceTxt.Text = totalPrice.ToString();
log.Info($"Product {viewModel.Name} with quantity {viewModel.Quantity} added to the bill.");
}
else
{
SystemSounds.Hand.Play();
}
}
//Изтриване на последен добавен продукт
else if (textBoxContent == "--")
{
var newEventArgs = new RoutedEventArgs(Button.ClickEvent);
ClearLastBtn.RaiseEvent(newEventArgs);
}
//Завършване на продажба
else if (textBoxContent == "*+")
{
var newEventArgs = new RoutedEventArgs(Button.ClickEvent);
FinishBtn.RaiseEvent(newEventArgs);
}
//Дневен отчет
else if (textBoxContent == "/////")
{
DailyFile.SaveDailyFile();
}
else if (textBoxContent == "*+*")
{
var newEventArgs = new RoutedEventArgs(Button.ClickEvent);
BillBtn.RaiseEvent(newEventArgs);
}
else
{
SystemSounds.Hand.Play();
}
}
catch (Exception ex)
{
log.Error(ex.InnerException);
}
finally
{
CodeAndQuantityTxt.Text = string.Empty;
}
}
