public List <dropdown> GetAllWardByIdDis(int?district_id)
{
List <dropdown> lst_res = new List <dropdown>();
var list = _dbContext.ward.Where(i => i.DistrictID == district_id).ToList();
foreach (Ward p in list)
{
dropdown dr = new dropdown();
dr.id = p.Id;
dr.name = p.Name;
lst_res.Add(dr);
}
return(lst_res);
}
public List <dropdown> GetAllProvince()
{
List <dropdown> lst_res = new List <dropdown>();
var list = _dbContext.province.ToList();
foreach (Province p in list)
{
dropdown dr = new dropdown();
dr.id = p.Id;
dr.name = p.Name;
lst_res.Add(dr);
}
return(lst_res);
}
public List <dropdown> GetAllDistrictByIdPro(int?province_id)
{
List <dropdown> lst_res = new List <dropdown>();
var list = _dbContext.district.Where(i => i.ProvinceId == province_id).ToList();
foreach (District d in list)
{
dropdown dr = new dropdown();
dr.id = d.Id;
dr.name = d.Name;
lst_res.Add(dr);
}
return(lst_res);
}
public List <dropdown> GetAllName()
{
List <dropdown> lst_res = new List <dropdown>();
var list = _dbContext.product_category.ToList();
foreach (product_category p in list)
{
dropdown dr = new dropdown();
dr.id = p.pc_id;
dr.name = p.pc_name;
lst_res.Add(dr);
}
return(lst_res);
}
public List <dropdown> GetAllType()
{
List <dropdown> res = new List <dropdown>();
for (int i = 0; i < 2; i++)
{
dropdown pu = new dropdown();
pu.id = i;
pu.name = EnumCustomer.cu_type[i];
res.Add(pu);
}
return(res);
}
public List <dropdown> GetUnit()
{
List <dropdown> res = new List <dropdown>();
for (int i = 0; i < 2; i++)
{
dropdown pu = new dropdown();
pu.id = i;
pu.name = EnumProduct.pu_unit[i];
res.Add(pu);
}
return(res);
}
public List <dropdown> GetInforManager()
{
List <dropdown> res = new List <dropdown>();
var staff = _dbContext.staffs.Where(s => s.sta_leader_flag == 1).ToList();
var totalNumberOfRecords = staff.Count();
foreach (staff i in staff)
{
dropdown dr = new dropdown();
dr.id = i.sta_id;
dr.name = i.sta_fullname;
res.Add(dr);
}
return(res);
}
public JsonResult LoadWard(int?districtID)
{
List <dropdown> res = new List <dropdown>();
List <Ward> lts = db.Wards.Where(x => x.DistrictID == districtID).ToList();
foreach (Ward d in lts)
{
dropdown dr = new dropdown();
dr.Id = d.Id;
dr.Name = d.Name;
res.Add(dr);
}
return(Json(new
{
data = res,
status = true
}));
}
public JsonResult LoadDistrict(int?provinceID)
{
List <dropdown> res = new List <dropdown>();
List <District> lts = db.Districts.Where(x => x.ProvinceId == provinceID).ToList();
foreach (District d in lts)
{
dropdown dr = new dropdown();
dr.Id = d.Id;
dr.Name = d.Name;
res.Add(dr);
}
return(Json(new
{
data = res,
status = true
}));
}
public JsonResult LoadProvince()
{
List <dropdown> res = new List <dropdown>();
List <Province> lts = db.Provinces.ToList();
foreach (Province d in lts)
{
dropdown dr = new dropdown();
dr.Id = d.Id;
dr.Name = d.Name;
res.Add(dr);
}
return(Json(new
{
data = res,
status = true
}));
}
public List <dropdown> GetAllName()
{
List <dropdown> res = new List <dropdown>();
var list = _dbContext.suppliers.OrderBy(t => t.su_id).ToList();
var totalNumberOfRecords = list.Count();
var results = list.ToList();
foreach (supplier i in results)
{
var dr = new dropdown();
dr.id = i.su_id;
dr.name = i.su_name;
res.Add(dr);
}
return(res);
}
