public async Task <bool> Create(Province province)
{
ProvinceDAO provinceDAO = new ProvinceDAO
{
Id = province.Id,
Code = province.Code,
Name = province.Name,
Districts = province.Districts.Select(d => new DistrictDAO
{
Id = d.Id,
Code = d.Code,
Name = d.Name,
ProvinceId = d.ProvinceId,
Towns = d.Towns.Select(t => new TownDAO
{
Id = t.Id,
Code = t.Code,
Name = t.Name,
DistrictId = t.DistrictId
}).ToList()
}).ToList()
};
tFContext.Province.Add(provinceDAO);
await tFContext.SaveChangesAsync();
return(true);
}
public async Task <bool> Delete(Province Province)
{
ProvinceDAO ProvinceDAO = await DataContext.Province.Where(x => x.Id == Province.Id).FirstOrDefaultAsync();
DataContext.Province.Remove(ProvinceDAO);
await DataContext.SaveChangesAsync();
return(true);
}
public async Task <bool> Update(Province Province)
{
ProvinceDAO ProvinceDAO = DataContext.Province.Where(x => x.Id == Province.Id).FirstOrDefault();
ProvinceDAO.Id = Province.Id;
ProvinceDAO.Name = Province.Name;
ProvinceDAO.OrderNumber = Province.OrderNumber;
await DataContext.SaveChangesAsync();
return(true);
}
public static DoResult <Province> GetProvinceByLink(long?actionUserId, string link)
{
return(BUSCore.Do <Province>(
userId: actionUserId,
action: (c) =>
{
// Cập nhật hệ thống
var r = ProvinceDAO.GetByLink(c.Db, link);
return r;
}));
}
public static DoResult <List <Province> > GetAllProvince(long?actionUserId)
{
return(BUSCore.Do <List <Province> >(
userId: actionUserId,
action: (c) =>
{
// Cập nhật hệ thống
var r = ProvinceDAO.GetList(c.Db);
return r;
}));
}
public ActionResult Cuahang(FormCollection collection, string meta)
{
var tinh = int.Parse(collection["Tinh"]);
//Khai báo 1 biến lấy ra Tỉnh thành mà người dùng chọn
var temp = new ProvinceDAO().GetProvince(tinh);
CommonConstants.Tinh = temp.nameProvince;
var list = data.Stores.Where(p => p.Province.id == tinh).ToList();
ViewData["Tinh"] = new SelectList(data.Provinces.OrderBy(p => p.nameProvince).ToList(), "id", "nameProvince");
return(PartialView(list));
}
public async Task <bool> Create(Province province)
{
ProvinceDAO provinceDAO = new ProvinceDAO
{
Id = province.Id,
Code = province.Code,
Name = province.Name
};
tFContext.Province.Add(provinceDAO);
await tFContext.SaveChangesAsync();
return(true);
}
public async Task <bool> Create(Province Province)
{
ProvinceDAO ProvinceDAO = new ProvinceDAO();
ProvinceDAO.Id = Province.Id;
ProvinceDAO.Name = Province.Name;
ProvinceDAO.OrderNumber = Province.OrderNumber;
await DataContext.Province.AddAsync(ProvinceDAO);
await DataContext.SaveChangesAsync();
Province.Id = ProvinceDAO.Id;
return(true);
}
private List <ProvinceDAO> LoadFromExcel(string path)
{
List <ProvinceDAO> excelTemplates = new List <ProvinceDAO>();
using (var package = new ExcelPackage(new FileInfo(path)))
{
var worksheet = package.Workbook.Worksheets[6];
for (int i = worksheet.Dimension.Start.Row + 1; i <= worksheet.Dimension.End.Row; i++)
{
string provinceCode = worksheet.Cells[i, 1].Value?.ToString();
string provinceName = worksheet.Cells[i, 2].Value?.ToString();
ProvinceDAO excelTemplate = new ProvinceDAO()
{
Id = CreateGuid("Province" + provinceCode),
Code = provinceCode,
Name = provinceName
};
excelTemplates.Add(excelTemplate);
}
}
return(excelTemplates);
}
