public async Task <bool> Delete(District District)
{
DistrictDAO DistrictDAO = await DataContext.District.Where(x => x.Id == District.Id).FirstOrDefaultAsync();
DataContext.District.Remove(DistrictDAO);
await DataContext.SaveChangesAsync();
return(true);
}
public static DoResult <List <District> > GetDistrict(long?actionUserId, long proviceId)
{
return(BUSCore.Do <List <District> >(
userId: actionUserId,
action: (c) =>
{
// Cập nhật hệ thống
var r = DistrictDAO.GetListByProviceId(c.Db, proviceId);
return r;
}));
}
public async Task <bool> Update(District District)
{
DistrictDAO DistrictDAO = DataContext.District.Where(x => x.Id == District.Id).FirstOrDefault();
DistrictDAO.Id = District.Id;
DistrictDAO.Name = District.Name;
DistrictDAO.OrderNumber = District.OrderNumber;
DistrictDAO.ProvinceId = District.ProvinceId;
await DataContext.SaveChangesAsync();
return(true);
}
public async Task <bool> Create(District district)
{
DistrictDAO DistrictDAO = new DistrictDAO
{
Id = district.Id,
Code = district.Code,
Name = district.Name,
ProvinceId = district.ProvinceId
};
tFContext.District.Add(DistrictDAO);
await tFContext.SaveChangesAsync();
return(true);
}
public async Task <bool> Create(District District)
{
DistrictDAO DistrictDAO = new DistrictDAO();
DistrictDAO.Id = District.Id;
DistrictDAO.Name = District.Name;
DistrictDAO.OrderNumber = District.OrderNumber;
DistrictDAO.ProvinceId = District.ProvinceId;
await DataContext.District.AddAsync(DistrictDAO);
await DataContext.SaveChangesAsync();
District.Id = DistrictDAO.Id;
return(true);
}
private List <DistrictDAO> LoadFromExcel(string path)
{
List <DistrictDAO> excelTemplates = new List <DistrictDAO>();
using (var package = new ExcelPackage(new FileInfo(path)))
{
var worksheet = package.Workbook.Worksheets[7];
for (int i = worksheet.Dimension.Start.Row + 1; i <= worksheet.Dimension.End.Row; i++)
{
string provinceCode = worksheet.Cells[i, 3].Value?.ToString();
string districtCode = worksheet.Cells[i, 1].Value?.ToString();
string districtName = worksheet.Cells[i, 2].Value?.ToString();
DistrictDAO excelTemplate = new DistrictDAO()
{
Id = CreateGuid("District" + provinceCode + districtCode),
ProvinceId = CreateGuid("Province" + worksheet.Cells[i, 3].Value?.ToString()),
Code = districtCode,
Name = districtName
};
excelTemplates.Add(excelTemplate);
}
}
return(excelTemplates);
}
//Quick Testing for methods
static void Main(string[] args)
{
SalespersonDAO spDAL = new SalespersonDAO();
DistrictDAO dDAL = new DistrictDAO();
StoreDAO sDAO = new StoreDAO();
//Test Insert
//var result = spDAL.Insert(new Salesperson { Name = "Sangey" });
//Test get single
//var result = spDAL.GetById(1).ToString();
//Test get all
//var result = spDAL.GetAll();
//foreach (Salesperson sp in result)
//{
// Console.WriteLine(sp.ToString());
//}
//Test Update
//spDAL.Update(new Salesperson { Id = 6, Name = "Updated" });
//var result = spDAL.GetById(6).ToString();
//Test Delete
//spDAL.Delete(spDAL.GetSalespersonById(9));
//Test District Insert
//var result = dDAL.Insert(new District { Name = "East Denmark", PrimarySalesperson = spDAL.GetById(5) });
//Test District Get
//var result = dDAL.GetById(1).ToString();
//Test District GetAll
//var result = dDAL.GetAll();
//foreach (District d in result)
//{
// Console.WriteLine(d.ToString());
//}
//Test District Update
//var result = dDAL.Update(new District { Id = 1, Name = "North Denmark Updated", PrimarySalesperson = spDAL.GetById(4) });
//var result = dDAL.UpdateDS(new District { Id = 1, Name = "North Denmark Update2", PrimarySalesperson = spDAL.GetById(5) });
//Test District Delete
//dDAL.Delete(dDAL.GetById(3));
//Test Get District using a data set
//var result = dDAL.GetByIdDataSet(3).ToString();
//Test Store Insert
//var result = sDAO.Insert(new Store { Name = "Fotex" });
//Test Store GetByID
//var result = sDAO.GetById(1);
//Test Store GetAll
//var result = sDAO.GetAll();
//foreach (Store s in result)
//{
// Console.WriteLine(s.ToString());
//}
// Test Store Update
//var result = sDAO.Update(new Store { Id = 1, Name = "Rema 1000 Updated"});
//Test Store Delete
//var result = sDAO.Delete(sDAO.GetById(3));
//District dist = dDAL.GetByIdDataSet(2);
//var tempSalespersons = new List<Salesperson>();
//tempSalespersons.Add(spDAL.GetById(1));
//tempSalespersons.Add(spDAL.GetById(3));
//tempSalespersons.Add(spDAL.GetById(5));
//tempSalespersons.Add(spDAL.GetById(7));
//dist.Salespersons = tempSalespersons;
//var result = dDAL.UpdateSalespersonsList(dist);
//Console.WriteLine(result.ToString());
Console.ReadLine();
}
