public staffviewmodel GetInforById(int id) { staffviewmodel res = new staffviewmodel(); var staff_cur = _dbContext.staffs.Where(i => i.sta_id == id).FirstOrDefault(); var satffview = _mapper.Map <staffviewmodel>(staff_cur); res = satffview; var deparment = _dbContext.departments.FirstOrDefault(x => x.de_id == staff_cur.department_id); res.department_name = deparment.de_name; var position = _dbContext.positions.FirstOrDefault(x => x.pos_id == staff_cur.position_id); res.position_name = position.pos_name; var list_address = _dbContext.address.Where(i => i.staff_id == staff_cur.sta_id).ToList(); List <addressviewmodel> lst = new List <addressviewmodel>(); foreach (address i in list_address) { addressviewmodel add = _mapper.Map <addressviewmodel>(i); add.ward_id = _dbContext.ward.Where(t => t.Name.Contains(i.add_ward)).FirstOrDefault().Id; add.district_id = _dbContext.district.Where(t => t.Name.Contains(i.add_district)).FirstOrDefault().Id; add.province_id = _dbContext.province.Where(t => t.Name.Contains(i.add_province)).FirstOrDefault().Id; lst.Add(add); } res.list_address = lst; return(res); }
public customerviewmodel GetInfor(int cu_id) { customerviewmodel res = new customerviewmodel(); var customer_cur = _dbContext.customers.Where(i => i.cu_id == cu_id).FirstOrDefault(); var customerview = _mapper.Map <customerviewmodel>(customer_cur); res = customerview; var sources = _dbContext.sources.FirstOrDefault(x => x.src_id == customer_cur.source_id); var customergroup = _dbContext.customer_group.FirstOrDefault(x => x.cg_id == customer_cur.customer_group_id); res.source_name = sources.src_name; res.customer_group_name = customergroup.cg_name; for (int j = 0; j < 2; j++) { if (j == customer_cur.cu_type) { res.cu_type_name = EnumCustomer.cu_type[j]; } } var list_address = _dbContext.address.Where(i => i.customer_id == customer_cur.cu_id).ToList(); List <addressviewmodel> lst = new List <addressviewmodel>(); foreach (address i in list_address) { addressviewmodel add = _mapper.Map <addressviewmodel>(i); add.ward_id = _dbContext.ward.Where(t => t.Name.Contains(i.add_ward)).FirstOrDefault().Id; add.district_id = _dbContext.district.Where(t => t.Name.Contains(i.add_district)).FirstOrDefault().Id; add.province_id = _dbContext.province.Where(t => t.Name.Contains(i.add_province)).FirstOrDefault().Id; lst.Add(add); } res.list_address = lst; return(res); }