public async Task <DataTableOutDto> Select(int class_seq, DataTableInputDto dataTableInputDto) { var result = ( from cls in _context.ClassContext join order_item in _context.OrderItemContext on class_seq equals order_item.class_seq join order in _context.OrderContext on order_item.order_id equals order.order_id join user in _context.UserContext on order.order_user_seq equals user.user_seq where cls.class_seq == class_seq select new { order_id = order.order_id, order_user_seq = order.order_user_seq, name = user.name, order_date = order.order_date, order_type = order.order_type, order_price = order.order_price, address = order.address, }); var paging = await result.Skip((dataTableInputDto.pageNumber - 1) *dataTableInputDto.size).Take(dataTableInputDto.size).ToListAsync(); DataTableOutDto dataTableOutDto = new DataTableOutDto(); dataTableOutDto.pageNumber = dataTableInputDto.pageNumber; dataTableOutDto.size = dataTableInputDto.size; dataTableOutDto.data = paging; dataTableOutDto.totalPages = (result.Count() % dataTableInputDto.size) > 0 ? result.Count() / dataTableInputDto.size + 1 : result.Count() / dataTableInputDto.size; dataTableOutDto.totalElements = result.Count(); return(dataTableOutDto); }
public async Task <DataTableOutDto> Select(DataTableInputDto dataTableInputDto, List <Filter> filters) { var result = ( from ord in _context.OrderContext select ord); foreach (var filter in filters) { if (filter.k == "order_type") { result = result.Where(w => w.order_type.Contains(filter.v.Replace(" ", ""))); } else if (filter.k == "address") { result = result.Where(w => w.address.Contains(filter.v.Replace(" ", ""))); } } result = result.OrderByDescending(o => o.order_id); var paging = await result.Skip((dataTableInputDto.pageNumber - 1) *dataTableInputDto.size).Take(dataTableInputDto.size).ToListAsync(); DataTableOutDto dataTableOutDto = new DataTableOutDto(); dataTableOutDto.pageNumber = dataTableInputDto.pageNumber; dataTableOutDto.size = dataTableInputDto.size; dataTableOutDto.data = paging; dataTableOutDto.totalPages = (result.Count() % dataTableInputDto.size) > 0 ? result.Count() / dataTableInputDto.size + 1 : result.Count() / dataTableInputDto.size; dataTableOutDto.totalElements = result.Count(); return(dataTableOutDto); }
public async Task <DataTableOutDto> Select(DataTableInputDto dataTableInputDto, List <Filter> filters) { var result = ( from teacher in _context.TeacherContext where teacher.use_yn == 1 orderby teacher.name select new TeacherModel { teacher_seq = teacher.teacher_seq, name = teacher.name, email = teacher.email, phone = teacher.phone, address = teacher.address }); foreach (var filter in filters) { if (filter.k == "name") { result = result.Where(w => w.name.Contains(filter.v.Replace(" ", ""))); } } var paging = await result.Skip((dataTableInputDto.pageNumber - 1) *dataTableInputDto.size).Take(dataTableInputDto.size).ToListAsync(); DataTableOutDto dataTableOutDto = new DataTableOutDto(); dataTableOutDto.pageNumber = dataTableInputDto.pageNumber; dataTableOutDto.size = dataTableInputDto.size; dataTableOutDto.data = paging; dataTableOutDto.totalPages = (result.Count() % dataTableInputDto.size) > 0 ? result.Count() / dataTableInputDto.size + 1 : result.Count() / dataTableInputDto.size; dataTableOutDto.totalElements = result.Count(); return(dataTableOutDto); }
public async Task <DataTableOutDto> Select(DataTableInputDto dataTableInputDto, List <Filter> filters) { var result = ( from user in _context.UserContext select user); foreach (var filter in filters) { if (filter.k == "name") { result = result.Where(w => w.name.Contains(filter.v.Replace(" ", ""))); } else if (filter.k == "email") { result = result.Where(w => w.email.Contains(filter.v.Replace(" ", ""))); } } var paging = await result.Skip((dataTableInputDto.pageNumber - 1) *dataTableInputDto.size).Take(dataTableInputDto.size).ToListAsync(); DataTableOutDto dataTableOutDto = new DataTableOutDto(); dataTableOutDto.pageNumber = dataTableInputDto.pageNumber; dataTableOutDto.size = dataTableInputDto.size; dataTableOutDto.data = paging; dataTableOutDto.totalPages = (result.Count() % dataTableInputDto.size) > 0 ? result.Count() / dataTableInputDto.size + 1 : result.Count() / dataTableInputDto.size; dataTableOutDto.totalElements = result.Count(); return(dataTableOutDto); }
public async Task <DataTableOutDto> SelectFamily(DataTableInputDto dataTableInputDto, int teacher_seq) { var result = ( from addfare in _context.IncamAddfareContext join contract in _context.IncamContractContext on addfare.contract_seq equals contract.contract_seq join teacher in _context.TeacherContext on contract.teacher_seq equals teacher.teacher_seq join company in _context.CodeContext on contract.original_company equals company.code_id join incom in _context.CodeContext on addfare.income_type equals incom.code_id where company.codegroup_id == "cooperative" where incom.codegroup_id == "incom" where addfare.use_yn == 1 where teacher.teacher_seq == teacher_seq orderby addfare.addfare_seq descending select new IncamAddfareModel { addfare_seq = addfare.addfare_seq, contract_seq = addfare.contract_seq, hour = addfare.hour, addfare_date = addfare.addfare_date, income_type = addfare.income_type, income_type_nm = incom.code_nm, income = addfare.income, original_company_nm = company.code_nm, @class = contract.@class, hour_price = contract.hour_price, hour_incen = contract.hour_incen, contract_price = contract.contract_price, name = teacher.name, teacher_seq = teacher.teacher_seq, check_yn = addfare.check_yn }); var paging = await result.Skip((dataTableInputDto.pageNumber - 1) *dataTableInputDto.size).Take(dataTableInputDto.size).ToListAsync(); DataTableOutDto dataTableOutDto = new DataTableOutDto(); dataTableOutDto.pageNumber = dataTableInputDto.pageNumber; dataTableOutDto.size = dataTableInputDto.size; dataTableOutDto.data = paging; dataTableOutDto.totalPages = (result.Count() % dataTableInputDto.size) > 0 ? result.Count() / dataTableInputDto.size + 1 : result.Count() / dataTableInputDto.size; dataTableOutDto.totalElements = result.Count(); return(dataTableOutDto); }
public async Task <DataTableOutDto> Select(DataTableInputDto dataTableInputDto) { var result = ( from class_notice in _context.ClassNoticeContext select class_notice); var paging = await result.Skip((dataTableInputDto.pageNumber - 1) *dataTableInputDto.size).Take(dataTableInputDto.size).ToListAsync(); DataTableOutDto dataTableOutDto = new DataTableOutDto(); dataTableOutDto.pageNumber = dataTableInputDto.pageNumber; dataTableOutDto.size = dataTableInputDto.size; dataTableOutDto.data = paging; dataTableOutDto.totalPages = (result.Count() % dataTableInputDto.size) > 0 ? result.Count() / dataTableInputDto.size + 1 : result.Count() / dataTableInputDto.size; dataTableOutDto.totalElements = result.Count(); return(dataTableOutDto); }
public async Task <DataTableOutDto> Select(DataTableInputDto dataTableInputDto) { var result = ( from board in _context.CommunityContext orderby board.board_seq descending select board); var paging = await result.Skip((dataTableInputDto.pageNumber - 1) *dataTableInputDto.size).Take(dataTableInputDto.size).ToListAsync(); DataTableOutDto dataTableOutDto = new DataTableOutDto(); dataTableOutDto.pageNumber = dataTableInputDto.pageNumber; dataTableOutDto.size = dataTableInputDto.size; dataTableOutDto.data = paging; dataTableOutDto.totalPages = (result.Count() % dataTableInputDto.size) > 0 ? result.Count() / dataTableInputDto.size + 1 : result.Count() / dataTableInputDto.size; dataTableOutDto.totalElements = result.Count(); return(dataTableOutDto); }
public async Task <DataTableOutDto> Select(DataTableInputDto dataTableInputDto, int class_seq) { var result = ( from class_qna in _context.ClassQnaContext where class_qna.class_seq == class_seq orderby class_qna.reg_dt descending select class_qna); var paging = await result.Skip((dataTableInputDto.pageNumber - 1) *dataTableInputDto.size).Take(dataTableInputDto.size).ToListAsync(); DataTableOutDto dataTableOutDto = new DataTableOutDto(); dataTableOutDto.pageNumber = dataTableInputDto.pageNumber; dataTableOutDto.size = dataTableInputDto.size; dataTableOutDto.data = paging; dataTableOutDto.totalPages = (result.Count() % dataTableInputDto.size) > 0 ? result.Count() / dataTableInputDto.size + 1 : result.Count() / dataTableInputDto.size; dataTableOutDto.totalElements = result.Count(); return(dataTableOutDto); }
public async Task <DataTableOutDto> Select(DataTableInputDto dataTableInputDto) { var result = ( from codegroup in _context.CodegroupContext select codegroup); result = result.OrderByDescending(o => o.reg_dt); var paging = await result.Skip((dataTableInputDto.pageNumber - 1) *dataTableInputDto.size).Take(dataTableInputDto.size).ToListAsync(); DataTableOutDto dataTableOutDto = new DataTableOutDto(); dataTableOutDto.pageNumber = dataTableInputDto.pageNumber; dataTableOutDto.size = dataTableInputDto.size; dataTableOutDto.data = paging; dataTableOutDto.totalPages = (result.Count() % dataTableInputDto.size) > 0 ? result.Count() / dataTableInputDto.size + 1 : result.Count() / dataTableInputDto.size; dataTableOutDto.totalElements = result.Count(); return(dataTableOutDto); }
public async Task <DataTableOutDto> Select(DataTableInputDto dataTableInputDto) { var result = ( from class_review in _context.ClassReviewContext where class_review.class_seq == dataTableInputDto.class_seq select class_review); result = result.OrderByDescending(o => o.class_review_seq); var paging = await result.Skip((dataTableInputDto.pageNumber - 1) *dataTableInputDto.size).Take(dataTableInputDto.size).ToListAsync(); DataTableOutDto dataTableOutDto = new DataTableOutDto(); dataTableOutDto.pageNumber = dataTableInputDto.pageNumber; dataTableOutDto.size = dataTableInputDto.size; dataTableOutDto.data = paging; dataTableOutDto.totalPages = (result.Count() % dataTableInputDto.size) > 0 ? result.Count() / dataTableInputDto.size + 1 : result.Count() / dataTableInputDto.size; dataTableOutDto.totalElements = result.Count(); return(dataTableOutDto); }
public async Task <DataTableOutDto> Select(DataTableInputDto dataTableInputDto) { var result = ( from emaillog in _context.EmailLogContext where emaillog.use_yn == 1 select emaillog); // result = result.OrderByDescending(o => o.reg_dt); var paging = await result.Skip((dataTableInputDto.pageNumber - 1) *dataTableInputDto.size).Take(dataTableInputDto.size).ToListAsync(); DataTableOutDto dataTableOutDto = new DataTableOutDto(); dataTableOutDto.pageNumber = dataTableInputDto.pageNumber; dataTableOutDto.size = dataTableInputDto.size; dataTableOutDto.data = paging; dataTableOutDto.totalPages = (result.Count() % dataTableInputDto.size) > 0 ? result.Count() / dataTableInputDto.size + 1 : result.Count() / dataTableInputDto.size; dataTableOutDto.totalElements = result.Count(); return(dataTableOutDto); }
public async Task <DataTableOutDto> Select(DataTableInputDto dataTableInputDto) { var result = ( from code in _context.CodeContext where code.codegroup_id == dataTableInputDto.codegroup_id select code); result = result.OrderBy(o => o.order_num); var paging = await result.Skip((dataTableInputDto.pageNumber - 1) *dataTableInputDto.size).Take(dataTableInputDto.size).ToListAsync(); DataTableOutDto dataTableOutDto = new DataTableOutDto(); dataTableOutDto.pageNumber = dataTableInputDto.pageNumber; dataTableOutDto.size = dataTableInputDto.size; dataTableOutDto.data = paging; dataTableOutDto.totalPages = (result.Count() % dataTableInputDto.size) > 0 ? result.Count() / dataTableInputDto.size + 1 : result.Count() / dataTableInputDto.size; dataTableOutDto.totalElements = result.Count(); return(dataTableOutDto); }
public async Task <DataTableOutDto> SelectReview(DataTableInputDto dataTableInputDto) { string sql = @" SELECT uid, title, category1, category2, date FROM insightcampus.wp_kboard_board_content WHERE category1 = '수강생후기' ORDER BY uid DESC "; var result = _context.WPBoardNoticeModel.FromSql(sql); var paging = await result.Skip((dataTableInputDto.pageNumber - 1) *dataTableInputDto.size).Take(dataTableInputDto.size).ToListAsync(); DataTableOutDto dataTableOutDto = new DataTableOutDto(); dataTableOutDto.pageNumber = dataTableInputDto.pageNumber; dataTableOutDto.size = dataTableInputDto.size; dataTableOutDto.data = paging; dataTableOutDto.totalPages = (result.Count() % dataTableInputDto.size) > 0 ? result.Count() / dataTableInputDto.size + 1 : result.Count() / dataTableInputDto.size; dataTableOutDto.totalElements = result.Count(); return(dataTableOutDto); }
public async Task <DataTableOutDto> Select(DataTableInputDto dataTableInputDto, List <Filter> filters) { var result = ( from cls in _context.ClassContext join teacher in _context.TeacherContext on cls.teacher equals teacher.teacher_seq into _t from teacher in _t.DefaultIfEmpty() join category in _context.CategoryContext on cls.category equals category.category_seq into _c from category in _c.DefaultIfEmpty() orderby cls.class_seq descending select new ClassModel { class_seq = cls.class_seq, class_nm = cls.class_nm, teacher = cls.teacher, category = cls.category, start_date = cls.start_date, end_date = cls.end_date, duration_nm = cls.duration_nm, thumbnail = cls.thumbnail, online_yn = cls.online_yn, price = cls.price, real_price = cls.real_price, template = cls.template, zoom_link = cls.zoom_link, zoom_pw = cls.zoom_pw, view_yn = cls.view_yn, status = cls.status, teacher_name = teacher.name, category_name = category.category_nm, survey_url = cls.survey_url, } ); // result = result.OrderByDescending(o => o.reg_dt); foreach (var filter in filters) { if (filter.k == "class_nm") { result = result.Where(w => w.class_nm.Contains(filter.v.Replace(" ", ""))); } else if (filter.k == "teacher") { result = result.Where(w => w.teacher_name.Contains(filter.v.Replace(" ", ""))); } else if (filter.k == "online_yn") { result = result.Where(w => w.online_yn == Convert.ToInt16(filter.v)); } } var paging = await result.Skip((dataTableInputDto.pageNumber - 1) *dataTableInputDto.size).Take(dataTableInputDto.size).ToListAsync(); DataTableOutDto dataTableOutDto = new DataTableOutDto(); dataTableOutDto.pageNumber = dataTableInputDto.pageNumber; dataTableOutDto.size = dataTableInputDto.size; dataTableOutDto.data = paging; dataTableOutDto.totalPages = (result.Count() % dataTableInputDto.size) > 0 ? result.Count() / dataTableInputDto.size + 1 : result.Count() / dataTableInputDto.size; dataTableOutDto.totalElements = result.Count(); return(dataTableOutDto); }
public async Task <DataTableOutDto> Select(DataTableInputDto dataTableInputDto, List <Filter> filters) { var result = ( from contract in _context.IncamContractContext join company in _context.CodeContext on contract.original_company equals company.code_id join teacher in _context.TeacherContext on contract.teacher_seq equals teacher.teacher_seq where company.codegroup_id == "cooperative" where contract.use_yn == 1 orderby contract.contract_seq descending select new IncamContractModel { contract_seq = contract.contract_seq, teacher_seq = contract.teacher_seq, @class = contract.@class, original_company = contract.original_company, original_company_nm = company.code_nm, hour_price = contract.hour_price, hour_incen = contract.hour_incen, contract_price = contract.contract_price, contract_start_date = contract.contract_start_date, contract_end_date = contract.contract_end_date, name = teacher.name }); foreach (var filter in filters) { if (filter.k == "name") { result = result.Where(w => w.name.Contains(filter.v.Replace(" ", ""))); } else if (filter.k == "company") { result = result.Where(w => w.original_company_nm.Contains(filter.v.Replace(" ", ""))); } else if (filter.k == "class") { result = result.Where(w => [email protected](filter.v.Replace(" ", ""))); } else if (filter.k == "start_date") { result = result.Where(w => w.contract_start_date >= Convert.ToDateTime(filter.v)); } else if (filter.k == "end_date") { result = result.Where(w => w.contract_end_date <= Convert.ToDateTime(filter.v)); } } var paging = await result.Skip((dataTableInputDto.pageNumber - 1) *dataTableInputDto.size).Take(dataTableInputDto.size).ToListAsync(); DataTableOutDto dataTableOutDto = new DataTableOutDto(); dataTableOutDto.pageNumber = dataTableInputDto.pageNumber; dataTableOutDto.size = dataTableInputDto.size; dataTableOutDto.data = paging; dataTableOutDto.totalPages = (result.Count() % dataTableInputDto.size) > 0 ? result.Count() / dataTableInputDto.size + 1 : result.Count() / dataTableInputDto.size; dataTableOutDto.totalElements = result.Count(); return(dataTableOutDto); }
public async Task <DataTableOutDto> Select(DataTableInputDto dataTableInputDto, List <Filter> filters) { var result = ( from addfare in _context.IncamAddfareContext join contract in _context.IncamContractContext on addfare.contract_seq equals contract.contract_seq join teacher in _context.TeacherContext on contract.teacher_seq equals teacher.teacher_seq join company in _context.CodeContext on contract.original_company equals company.code_id join incom in _context.CodeContext on addfare.income_type equals incom.code_id join evidence in _context.CodeContext on new { type = addfare.evidence_type, codegroup_id = "evidence_type" } equals new { type = evidence.code_id, codegroup_id = evidence.codegroup_id } into _t from evidence in _t.DefaultIfEmpty() where company.codegroup_id == "cooperative" where incom.codegroup_id == "incom" where addfare.use_yn == 1 orderby addfare.addfare_seq descending select new IncamAddfareModel { addfare_seq = addfare.addfare_seq, contract_seq = addfare.contract_seq, hour = addfare.hour, addfare_date = addfare.addfare_date, income_type = addfare.income_type, evidence_type = addfare.evidence_type, income_type_nm = incom.code_nm, income = addfare.income, original_company_nm = company.code_nm, @class = contract.@class, hour_price = contract.hour_price, hour_incen = contract.hour_incen, contract_price = contract.contract_price, name = teacher.name, teacher_seq = teacher.teacher_seq, check_yn = addfare.check_yn, evidence_type_nm = evidence.code_nm }); foreach (var filter in filters) { if (filter.k == "name") { result = result.Where(w => w.name.Contains(filter.v.Replace(" ", ""))); } else if (filter.k == "company") { result = result.Where(w => w.original_company_nm.Contains(filter.v.Replace(" ", ""))); } else if (filter.k == "class") { result = result.Where(w => [email protected](filter.v.Replace(" ", ""))); } else if (filter.k == "start_date") { result = result.Where(w => w.addfare_date >= Convert.ToDateTime(filter.v)); } else if (filter.k == "end_date") { result = result.Where(w => w.addfare_date <= Convert.ToDateTime(filter.v)); } else if (filter.k == "deposit") { result = result.Where(w => w.check_yn == Convert.ToInt16(filter.v)); } else if (filter.k == "evidenceType") { if (filter.v == "00") { result = result.Where(w => w.evidence_type == null); } else { result = result.Where(w => w.evidence_type == filter.v); } } } var paging = await result.Skip((dataTableInputDto.pageNumber - 1) *dataTableInputDto.size).Take(dataTableInputDto.size).ToListAsync(); DataTableOutDto dataTableOutDto = new DataTableOutDto(); dataTableOutDto.pageNumber = dataTableInputDto.pageNumber; dataTableOutDto.size = dataTableInputDto.size; dataTableOutDto.data = paging; dataTableOutDto.totalPages = (result.Count() % dataTableInputDto.size) > 0 ? result.Count() / dataTableInputDto.size + 1 : result.Count() / dataTableInputDto.size; dataTableOutDto.totalElements = result.Count(); return(dataTableOutDto); }