public bool UpdateInfo(Stock st)
{
bool flag = true;
using (UnileverEntities entity = new UnileverEntities())
{
var stData = entity.Stocks.Where(s => s.DistributorId == st.DistributorId &&
s.ProId == st.ProId &&
s.Year == st.Year &&
s.Month == st.Month)
.FirstOrDefault();
if (stData != null)
{
stData.Quantity = st.Quantity;
entity.SaveChanges();
}
else
{
flag = false;
}
}
return(flag);
}
public bool Add(Category cat)
{
bool flag = true;
if (IsExistedName(cat) == true)
{
flag = false;
}
else
{
try
{
using (UnileverEntities entity = new UnileverEntities())
{
entity.Categories.Add(cat);
entity.SaveChanges();
}
}
catch (System.Exception ex)
{
ex.Message.ToString();
flag = false;
}
}
return(flag);
}
public bool UpdateInfo(Distributor dist)
{
bool flag = true;
using (UnileverEntities entity = new UnileverEntities())
{
var distData = entity.Distributors.Where(d => d.Id == dist.Id).FirstOrDefault();
if (distData != null)
{
distData.Name = dist.Name;
distData.Address = dist.Address;
distData.Email = dist.Email;
distData.Phone = dist.Phone;
distData.TimeLimit = dist.TimeLimit;
//distData.ProvinceId = dist.ProvinceId;
entity.SaveChanges();
}
else
{
flag = false;
}
}
return(flag);
}
public DbSet <Order> GetAllDbSet()
{
using (UnileverEntities ent = new UnileverEntities())
{
return(ent.Orders);
}
}
public List <FixedRegister> GetAll()
{
using (UnileverEntities ent = new UnileverEntities())
{
return(ent.FixedRegisters.Include("Product").Include("Distributor").ToList());
}
}
public List <Distributor> GetAll()
{
using (UnileverEntities entity = new UnileverEntities())
{
return(entity.Distributors.ToList());
}
}
public void AutoAdd()
{
int curYear = DateTime.Now.Year;
using (UnileverEntities ent = new UnileverEntities())
{
var lstDis = ent.Distributors.ToList();
foreach (var dis in lstDis)
{
if (!dis.Debts.Where(c => c.Year == curYear).Any())
{
Debt debt = new Debt
{
DistributorId = dis.Id,
Year = curYear
};
ent.Debts.Add(debt);
}
else
{
}
}
ent.SaveChanges();
}
}
public bool Update(Category cat)
{
bool flag = true;
if (IsExistedName(cat) == true)
{
flag = false;
}
else
{
using (UnileverEntities entity = new UnileverEntities())
{
var catData = entity.Categories.Where(i => i.Id == cat.Id).FirstOrDefault();
if (catData != null)
{
catData.Name = cat.Name;
entity.SaveChanges();
}
else
{
flag = false;
}
}
}
return(flag);
}
public List <Staff> GetAll()
{
using (UnileverEntities entity = new UnileverEntities())
{
return(entity.Staffs.ToList());
}
}
public List <OrderDetail> GetAll(int ordId)
{
using (UnileverEntities ent = new UnileverEntities())
{
return(ent.OrderDetails.Include("Product").Where(c => c.OrderId == ordId).ToList());
}
}
public List <Category> GetAll()
{
using (UnileverEntities entity = new UnileverEntities())
{
return(entity.Categories.ToList());
}
}
private void crystalReportsViewer1_Loaded(object sender, RoutedEventArgs e)
{
ReportDocument report = new ReportDocument();
report.Load(@"D:\MyGitHub\project-wpf-final\Unilever\Unilever\Views\CrystalReport\SaleReport.rpt");
using (UnileverEntities ent = new UnileverEntities())
{
var lstSale = (from c in ent.Sales
select new
{
DisId = c.DistributorId,
DisName = c.Distributor.Name,
ProId = c.ProId,
ProName = c.Product.Name,
c.Year,
c.Month,
Quantity = c.Quantity.Value,
Sales = c.Sales.Value
}).ToList();
report.SetDataSource(lstSale);
crystalReportsViewer1.ViewerCore.ReportSource = report;
}
}
private void btnOpenReport2_Click(object sender, RoutedEventArgs e)
{
DateTime date = txtDate2.DateTime;
using (UnileverEntities ent = new UnileverEntities())
{
var lstSale = (from c in ent.Sales
where c.Year == date.Year
select new
{
DisId = c.DistributorId,
DisName = c.Distributor.Name,
ProId = c.ProId,
ProName = c.Product.Name,
c.Year,
c.Month,
Quantity = c.Quantity.Value,
Sales = c.Sales.Value
}).ToList();
if (lstSale.Count == 0)
{
DXMessageBox.Show("Không có dữ liệu thống kê");
return;
}
ReportDocument report = new ReportDocument();
report.Load("./Views/CrystalReport/SaleReport.rpt");
report.SetDataSource(lstSale);
crystalReportsViewer1.ViewerCore.ReportSource = report;
}
}
public Product GetById(int Id)
{
using (UnileverEntities entity = new UnileverEntities())
{
return(entity.Products.Include("Category").Where(p => p.Id == Id).FirstOrDefault());
}
}
public bool UpdateInfo(Product pro)
{
bool flag = true;
using (UnileverEntities entity = new UnileverEntities())
{
var proData = entity.Products.Where(p => p.Id == pro.Id).FirstOrDefault();
if (proData != null)
{
proData.Name = pro.Name;
proData.Price = pro.Price;
proData.Quantity = pro.Quantity;
proData.Sale = pro.Sale;
proData.Description = pro.Description;
proData.CatId = pro.CatId;
entity.SaveChanges();
}
else
{
flag = false;
}
}
return(flag);
}
public bool Update(Province provine)
{
bool flag = true;
if (IsExistedName(provine) == true)
{
flag = false;
}
else
{
using (UnileverEntities entity = new UnileverEntities())
{
var catData = entity.Provinces.Where(i => i.Id == provine.Id).FirstOrDefault();
if (catData != null)
{
catData.ProvinceName = provine.ProvinceName;
entity.SaveChanges();
}
else
{
flag = false;
}
}
}
return(flag);
}
public List <Product> GetAll()
{
using (UnileverEntities entity = new UnileverEntities())
{
return(entity.Products.ToList());
}
}
public List <InterestOfYear> GetAll()
{
using (UnileverEntities entity = new UnileverEntities())
{
return(entity.InterestOfYears.ToList());
}
}
public bool Remove(int id)
{
bool flag = true;
using (UnileverEntities entity = new UnileverEntities())
{
var staff = entity.Staffs.Where(c => c.Id == id).FirstOrDefault();
if (staff != null)
{
if (staff.Permission != 0)
{
flag = false;
}
else
{
entity.Staffs.Remove(staff);
entity.SaveChanges();
}
}
else
{
flag = false;
}
}
return(flag);
}
public Boolean UpdateMonth(int distrId, int year, decimal debtVal, int month)
{
Boolean success = true;
using (UnileverEntities ent = new UnileverEntities())
{
var debt = ent.Debts.Where(c => c.DistributorId == distrId && c.Year == year).First();
if (debt != null)
{
switch (month)
{
case 1: debt.Month1 = debtVal;
break;
case 2: debt.Month2 = debtVal;
break;
case 3: debt.Month3 = debtVal;
break;
case 4: debt.Month4 = debtVal;
break;
case 5: debt.Month5 = debtVal;
break;
case 6: debt.Month6 = debtVal;
break;
case 7: debt.Month7 = debtVal;
break;
case 8: debt.Month8 = debtVal;
break;
case 9: debt.Month9 = debtVal;
break;
case 10: debt.Month10 = debtVal;
break;
case 11: debt.Month11 = debtVal;
break;
case 12: debt.Month12 = debtVal;
break;
}
}
else
{
success = false;
}
ent.SaveChanges();
}
return(success);
}
public bool Remove(int id)
{
bool flag = true;
using (UnileverEntities entity = new UnileverEntities())
{
var cat = entity.Categories.Where(c => c.Id == id).FirstOrDefault();
if (cat != null)
{
try
{
entity.Categories.Remove(cat);
entity.SaveChanges();
}
catch (System.Exception ex)
{
ex.Message.ToString();
return(false);
}
}
else
{
flag = false;
}
}
return(flag);
}
public bool Remove(int distributorId, int proId, int year, int month)
{
bool flag = true;
using (UnileverEntities entity = new UnileverEntities())
{
var st = entity.Stocks.Where(s => s.DistributorId == distributorId &&
s.ProId == proId &&
s.Year == year &&
s.Month == month)
.FirstOrDefault();
if (st != null)
{
try
{
entity.Stocks.Remove(st);
entity.SaveChanges();
}
catch (System.Exception ex)
{
ex.Message.ToString();
return(false);
}
}
else
{
flag = false;
}
}
return(flag);
}
public void UpdateRemainder(int ordId, decimal payment)
{
using (UnileverEntities ent = new UnileverEntities())
{
var ord = ent.Orders.Where(c => c.Id == ordId).FirstOrDefault();
ent.SaveChanges();
}
}
public decimal GetCurrentDebt(int orderId)
{
using (UnileverEntities ent = new UnileverEntities())
{
Order ord = ent.Orders.Where(c => c.Id == orderId).FirstOrDefault();
return(ord.Remainder.Value);
}
}
public Staff GetByUsername(string username, string password)
{
string encPassword = MD5Encrypt.Encrypt(password);
using (UnileverEntities entity = new UnileverEntities())
{
return(entity.Staffs.Where(s => s.Username == username && s.Password == encPassword).FirstOrDefault());
}
}
public void Update(int disId, int proId, int quantity)
{
using (UnileverEntities ent = new UnileverEntities())
{
var reg = ent.FixedRegisters.Where(c => c.DistributorId == disId && c.ProId == proId).FirstOrDefault();
reg.Quantity = quantity;
ent.SaveChanges();
}
}
public void Remove(int disId, int proId)
{
using (UnileverEntities ent = new UnileverEntities())
{
var reg = ent.FixedRegisters.Where(c => c.DistributorId == disId && c.ProId == proId).FirstOrDefault();
ent.FixedRegisters.Remove(reg);
ent.SaveChanges();
}
}
public bool Add(Distributor dist)
{
using (UnileverEntities entity = new UnileverEntities())
{
entity.Distributors.Add(dist);
entity.SaveChanges();
return(true);
}
}
public bool Add(Staff staff)
{
using (UnileverEntities entity = new UnileverEntities())
{
staff.Password = MD5Encrypt.Encrypt(staff.Password);
entity.Staffs.Add(staff);
entity.SaveChanges();
return(true);
}
}
public Order GetById(int id)
{
Order ord = null;
using (UnileverEntities ent = new UnileverEntities())
{
ord = ent.Orders.Where(c => c.Id == id).FirstOrDefault();
}
return(ord);
}
