public BillSell CreateBillSell(Employe employe, Customer customer = null, Tables table = null)
{
if (customer == null && !table.status)
{
CustomerService cust = new CustomerService(_context);
var _customer = cust.GetCustomer(Constants.Constants.customerDefault);
BillSell billSell = new BillSell()
{
createDate = DateTime.Now,
totalMoney = 0,
status = false,
};
UserService userService = new UserService(_context);
billSell.Employe = userService.GetUser(employe);
TableService tableService = new TableService(_context);
billSell.Table = tableService.GetTables(table);
_context.Entry(billSell);
_context.BillSells.Attach(billSell);
_context.BillSells.Add(billSell);
_context.SaveChanges();
tableService.SetStatusTable(table, true);
return(billSell);
}
return(null);
}
public bool SetStatusTable(Tables tables, bool status)
{
try
{
var table = _context.Tables.FirstOrDefault(x => x.Id == tables.Id);
table.status = status;
_context.SaveChanges();
return(true);
}
catch (Exception)
{
}
return(false);
}
//public List<string> GetAllNameString()
//{
// return _context.Offices.Select(x => x.nameOffice).ToList();
//}
public bool Insert(string name)
{
var off = _context.Offices.Where(x => x.nameOffice == name).SingleOrDefault();
if (off == null)
{
Office _off = new Office {
nameOffice = name, createdDay = DateTime.Now, updatedDay = DateTime.Now
};
_context.Offices.Add(_off);
_context.SaveChanges();
return(true);
}
return(false);
}
public bool Delete(string Id)
{
try
{
Guid _id = new Guid(Id);
var sup = _context.Suppliers.Where(x => x.Id == _id).SingleOrDefault();
if (sup == null)
{
return(false);
}
_context.Suppliers.Remove(sup);
_context.SaveChanges();
return(true);
}
catch (Exception)
{
}
return(false);
}
public bool updateArea(object are)
{
try
{
List <Area> areas = are as List <Area>;
foreach (Area item in areas)
{
var some = _context.Areas.Where(x => x.Id == item.Id).SingleOrDefault();
some.nameArea = item.nameArea;
some.Note = item.Note;
_context.SaveChanges();
}
return(true);
}
catch (Exception)
{
}
return(false);
}
public DetailBillSell CreateDetailBillSell(BillSell billSell, Product product, int number)
{
DetailBillSell detailBillSell = new DetailBillSell
{
Quantum = number,
Total = product.priceProduct * number,
};
ProductService productService = new ProductService(_context);
detailBillSell.Product = productService.GetProduct(product);
BillSellService billSellService = new BillSellService(_context);
detailBillSell.BillSells = new List <BillSell>()
{
billSellService.GetBillWithId(billSell.Id)
};
_context.DetailBillSells.Add(detailBillSell);
_context.SaveChanges();
return(detailBillSell);
}
public bool Delete(string Id)
{
try
{
Guid _id = new Guid(Id);
var product = _context.Products.Where(x => x.Id == _id).Include(x => x.Unit).Include(x => x.ProductType).SingleOrDefault();
if (product == null)
{
return(false);
}
_context.Products.Remove(product);
_context.SaveChanges();
return(true);
}
catch (Exception)
{
}
return(false);
}
public bool Update(object tables)
{
try
{
DataTable dataTable = new DataTable();
dataTable.Clear();
dataTable.Columns.Add("Id", typeof(string));
dataTable.Columns.Add("userName", typeof(string));
dataTable.Columns.Add("password", typeof(string));
dataTable.Columns.Add("fullName", typeof(string));
dataTable.Columns.Add("sex", typeof(bool));
dataTable.Columns.Add("birthDay", typeof(string));
dataTable.Columns.Add("address", typeof(string));
dataTable.Columns.Add("phoneNumber", typeof(string));
dataTable.Columns.Add("email", typeof(string));
dataTable.Columns.Add("dayAtWork", typeof(string));
dataTable.Columns.Add("statusOfWork", typeof(bool));
dataTable.Columns.Add("nameOffice", typeof(string));
OfficeService officeService = new OfficeService(_context);
dataTable = tables as DataTable;
int i = 0;
foreach (DataRow item in dataTable.Rows)
{
Guid Id = new Guid(item.Table.Rows[i]["Id"].ToString());
string username = item.Table.Rows[i]["userName"].ToString();
string password = item.Table.Rows[i]["password"].ToString();
string fullName = item.Table.Rows[i]["fullName"].ToString();
bool sex = (bool)item.Table.Rows[i]["sex"];
DateTime birthDay = Convert.ToDateTime(item.Table.Rows[i]["birthDay"].ToString());
string address = item.Table.Rows[i]["address"].ToString();
string phoneNumber = item.Table.Rows[i]["phoneNumber"].ToString();
string email = item.Table.Rows[i]["email"].ToString();
DateTime dayAtWork = Convert.ToDateTime(item.Table.Rows[i]["dayAtWork"].ToString());
bool statusOfWork = (bool)(item.Table.Rows[i]["statusOfWork"]);
string nameOffice = item.Table.Rows[i]["nameOffice"].ToString();
Office off = officeService.GetOffice(nameOffice);
if (off != null)
{
var user = _context.Employes.Where(x => x.Id == Id).Include(x => x.Offices).SingleOrDefault();
user.userName = username;
if (user.password != password)
{
user.password = GenerateHash.Instance.ComputeSha256Hash(password);
}
user.fullName = fullName;
user.sex = sex;
user.birthDay = birthDay;
user.address = address;
user.phoneNumber = phoneNumber;
user.email = email;
user.dayAtWork = dayAtWork;
user.statusOfWork = statusOfWork;
user.Offices = off;
_context.SaveChanges();
}
i++;
}
return(true);
}
catch (Exception)
{
}
return(false);
}