public bool UpdateInfo(Customer dist)
{
bool flag = true;
using (SellerEntities entity = new SellerEntities())
{
var distData = entity.Customers.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;
distData.AllowDebt = distData.AllowDebt;
entity.SaveChanges();
}
else
{
flag = false;
}
}
return(flag);
}
public bool Update(Category cat)
{
bool flag = true;
if (IsExistedName(cat) == true)
{
flag = false;
}
else
{
using (SellerEntities entity = new SellerEntities())
{
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 <Customer> GetAll()
{
using (SellerEntities entity = new SellerEntities())
{
return(entity.Customers.ToList());
}
}
private void btnOpenReport2_Click(object sender, RoutedEventArgs e)
{
DateTime date = txtDate2.DateTime;
using (SellerEntities ent = new SellerEntities())
{
var lstSale = (from c in ent.GeneralSales
where c.Year == date.Year
select new
{
ProId = c.ProId,
ProName = c.Product.Name,
c.Year,
c.Month,
Quantity = c.Quantity.Value,
Amount = c.Amount.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/GeneralSaleReport.rpt");
report.SetDataSource(lstSale);
crystalReportsViewer1.ViewerCore.ReportSource = report;
}
}
public bool Remove(int id)
{
bool flag = true;
using (SellerEntities entity = new SellerEntities())
{
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 Product GetById(int Id)
{
using (SellerEntities entity = new SellerEntities())
{
return(entity.Products.Include("Category").Where(p => p.Id == Id).FirstOrDefault());
}
}
public bool Remove(int id)
{
bool flag = true;
using (SellerEntities entity = new SellerEntities())
{
var pro = entity.Products.Where(p => p.Id == id).FirstOrDefault();
if (pro != null)
{
try
{
entity.Products.Remove(pro);
entity.SaveChanges();
}
catch (System.Exception ex)
{
ex.Message.ToString();
return(false);
}
}
else
{
flag = false;
}
}
return(flag);
}
public List <OrderDetail> GetAll(int ordId)
{
using (SellerEntities ent = new SellerEntities())
{
return(ent.OrderDetails.Include("Product").Where(c => c.OrderId == ordId).ToList());
}
}
public List <Product> GetAll()
{
using (SellerEntities entity = new SellerEntities())
{
return(entity.Products.ToList());
}
}
public List <Category> GetAll()
{
using (SellerEntities entity = new SellerEntities())
{
return(entity.Categories.ToList());
}
}
public void AutoAdd()
{
int curYear = DateTime.Now.Year;
using (SellerEntities ent = new SellerEntities())
{
var lstDis = ent.Customers.ToList();
foreach (var dis in lstDis)
{
if (!dis.Debts.Where(c => c.Year == curYear).Any())
{
Debt debt = new Debt
{
CusId = dis.Id,
Year = curYear
};
ent.Debts.Add(debt);
}
else
{
}
}
ent.SaveChanges();
}
}
public Boolean UpdateMonth(int distrId, int year, decimal debtVal, int month)
{
Boolean success = true;
using (SellerEntities ent = new SellerEntities())
{
var debt = ent.Debts.Where(c => c.CusId == 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 DbSet <Order> GetAllDbSet()
{
using (SellerEntities ent = new SellerEntities())
{
return(ent.Orders);
}
}
public bool UpdateInfo(Product pro)
{
bool flag = true;
using (SellerEntities entity = new SellerEntities())
{
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 Remove(int id)
{
bool flag = true;
using (SellerEntities entity = new SellerEntities())
{
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 List <InterestOfYear> GetAll()
{
using (SellerEntities entity = new SellerEntities())
{
return(entity.InterestOfYears.ToList());
}
}
public List <Staff> GetAll()
{
using (SellerEntities entity = new SellerEntities())
{
return(entity.Staffs.ToList());
}
}
public bool Add(Category cat)
{
bool flag = true;
if (IsExistedName(cat) == true)
{
flag = false;
}
else
{
try
{
using (SellerEntities entity = new SellerEntities())
{
entity.Categories.Add(cat);
entity.SaveChanges();
}
}
catch (System.Exception ex)
{
ex.Message.ToString();
flag = false;
}
}
return(flag);
}
public void UpdateRemainder(int ordId, decimal payment)
{
using (SellerEntities ent = new SellerEntities())
{
var ord = ent.Orders.Where(c => c.Id == ordId).FirstOrDefault();
ent.SaveChanges();
}
}
public decimal GetCurrentDebt(int orderId)
{
using (SellerEntities ent = new SellerEntities())
{
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 (SellerEntities entity = new SellerEntities())
{
return(entity.Staffs.Where(s => s.Username == username && s.Password == encPassword).FirstOrDefault());
}
}
public bool Add(Customer dist)
{
using (SellerEntities entity = new SellerEntities())
{
entity.Customers.Add(dist);
entity.SaveChanges();
return(true);
}
}
public void Add(Order ord, List <OrderDetail> lstOrdD)
{
using (SellerEntities ent = new SellerEntities())
{
Order tempOrd = new Order
{
IsFixed = ord.IsFixed,
DateOfIssue = ord.DateOfIssue,
Payment = ord.Payment,
Remainder = ord.Remainder,
Total = ord.Total,
CusId = ord.CusId,
};
ent.Orders.Add(tempOrd);
ent.SaveChanges();
foreach (OrderDetail ordD in lstOrdD)
{
OrderDetail tempOrdD = new OrderDetail
{
OrderId = tempOrd.Id,
Price = ordD.Price,
ProId = ordD.ProId,
Quantity = ordD.Quantity,
Amount = ordD.Amount
};
ent.OrderDetails.Add(tempOrdD);
Product proc = ent.Products.Where(c => c.Id == tempOrdD.ProId).FirstOrDefault();
proc.Quantity -= tempOrdD.Quantity;
GeneralSale sale = new GeneralSale
{
ProId = ordD.ProId,
Amount = ordD.Amount,
Quantity = ordD.Quantity,
Month = DateTime.Now.Month,
Year = DateTime.Now.Year
};
new GeneralSaleDAO().Add(sale);
ent.SaveChanges();
}
PaymentDetail paym = new PaymentDetail
{
OrderId = tempOrd.Id,
PayDate = tempOrd.DateOfIssue.Value,
Paid = tempOrd.Payment,
Remainder = tempOrd.Remainder
};
ent.PaymentDetails.Add(paym);
ent.SaveChanges();
}
}
public Debt Get(int distrId, int year)
{
Debt debt = null;
using (SellerEntities ent = new SellerEntities())
{
debt = ent.Debts.Where(c => c.CusId == distrId && c.Year == year).FirstOrDefault();
}
return(debt);
}
public Order GetById(int id)
{
Order ord = null;
using (SellerEntities ent = new SellerEntities())
{
ord = ent.Orders.Where(c => c.Id == id).FirstOrDefault();
}
return(ord);
}
public List <Order> GetAll()
{
List <Order> lst = new List <Order>();
using (SellerEntities ent = new SellerEntities())
{
lst = ent.Orders.Include("Customer").ToList();
}
return(lst);
}
public List <Debt> GetAll(int CusId)
{
List <Debt> lst = new List <Debt>();
using (SellerEntities ent = new SellerEntities())
{
lst = ent.Debts.Where(c => c.CusId == CusId).ToList();
}
return(lst);
}
public bool Add(Staff staff)
{
using (SellerEntities entity = new SellerEntities())
{
staff.Password = MD5Encrypt.Encrypt(staff.Password);
entity.Staffs.Add(staff);
entity.SaveChanges();
return(true);
}
}
public bool IsExistAccount(String username)
{
using (SellerEntities entity = new SellerEntities())
{
if (entity.Staffs.Where(c => c.Username.Equals(username)).Any())
{
return(true);
}
}
return(false);
}
public bool Login(String username, String password)
{
using (SellerEntities entity = new SellerEntities())
{
String encryptedPwd = MD5Encrypt.Encrypt(password);
if (entity.Staffs.Where(c => c.Username.Equals(username) && c.Password.Equals(encryptedPwd)).Any())
{
return(true);
}
}
return(false);
}
