public Ceny GetRecordByID(int id)
{
using (TowaryDBEntities context = new TowaryDBEntities())
{
return(context.Cenies.First(x => x.Id == id));
}
}
public IEnumerable <Towary> GetAllRecords()
{
using (TowaryDBEntities context = new TowaryDBEntities())
{
return(context.Towaries.ToList());
}
}
public static void FillPricesGrid(DataGridView grid)
{
grid.AutoGenerateColumns = false;
using (TowaryDBEntities context = new TowaryDBEntities())
{
var prices = (from a in context.Cenies
select new PricesViewModel
{
PriceId = a.Id,
Price = a.Cena,
Discount = a.Rabat,
PriceListName = a.Cenniki.Nazwa,
ProductName = a.Towary.Nazwa
}).ToList();
grid.DataSource = prices;
var priceIndex = 1;
foreach (DataGridViewRow rows in grid.Rows)
{
rows.HeaderCell.Value = priceIndex++.ToString();
}
}
}
public void UpdateRecord(Towary product)
{
using (TowaryDBEntities context = new TowaryDBEntities())
{
context.Towaries.AddOrUpdate(product);
context.SaveChanges();
}
}
public void UpdateRecord(Ceny price)
{
using (TowaryDBEntities context = new TowaryDBEntities())
{
context.Cenies.AddOrUpdate(price);
context.SaveChanges();
}
}
public void CreateRecord(Cenniki priceList)
{
using (TowaryDBEntities context = new TowaryDBEntities())
{
context.Cennikis.Add(priceList);
context.SaveChanges();
}
}
public void DeleteRecord(Towary product)
{
using (TowaryDBEntities context = new TowaryDBEntities())
{
context.Towaries.Attach(product);
context.Towaries.Remove(product);
context.SaveChanges();
}
}
public void DeleteRecord(Ceny price)
{
using (TowaryDBEntities context = new TowaryDBEntities())
{
context.Cenies.Attach(price);
context.Cenies.Remove(price);
context.SaveChanges();
}
}
public static void FillSummaryGrid(DataGridView grid)
{
using (TowaryDBEntities context = new TowaryDBEntities())
{
var summaryGrid = (from a in context.Cenies
select new SummaryViewModel()
{
ProductName = a.Towary.Nazwa,
ProductCode = a.Towary.Kod,
ProductPrice = a.Cena,
Discount = a.Rabat,
ProductWeight = a.Towary.Masa,
UnitWeight = a.Towary.JM,
Promotion = a.Cenniki.Nazwa,
PromoStart = a.Cenniki.Data_Od,
PromoEnd = a.Cenniki.Data_Do
}).ToList();
grid.AutoGenerateColumns = false;
grid.DataSource = summaryGrid;
}
var summaryIndex = 1;
foreach (DataGridViewRow rows in grid.Rows)
{
rows.HeaderCell.Value = summaryIndex++.ToString();
}
//Obliczanie wartosci z uwzglednieniem rabatu
foreach (DataGridViewRow row in grid.Rows)
{
try
{
row.Cells[grid.Columns["CenaZRabatem"].Index].Value =
(1 - Convert.ToDouble(row.Cells[grid.Columns["Discount"].Index].Value) / 100) *
Convert.ToDouble(row.Cells[grid.Columns["ProductPrice"].Index].Value);
}
catch (Exception)
{
continue;
}
}
}
