public IEnumerable <sp_schedule_course_search_Result> search(scheduleCourseModel value) { StandardCanEntities context = new StandardCanEntities(); IEnumerable <sp_schedule_course_search_Result> result = context.sp_schedule_course_search(value.year_from, value.year_to, value.prj_from, value.prj_to, value.course_name, value.start_date, value.stop_date).AsEnumerable(); return(result); }
public projectFormulaMasterModel master(projectFormularModel value) { projectFormulaMasterModel result = new projectFormulaMasterModel(); try { using (var context = new StandardCanEntities()) { if (String.IsNullOrEmpty(value.user_id)) { throw new Exception("Unauthorized Access"); } var userId = JwtHelper.GetUserIdFromToken(value.user_id); if (String.IsNullOrEmpty(userId)) { throw new Exception("Unauthorized Access"); } string sql = "select convert(nvarchar(4), MFT_ID) code, MFT_NAME [text] "; sql += " from MAS_FORMULA_TYPE "; sql += " order by MFT_NAME "; result.type = context.Database.SqlQuery <dropdown>(sql).ToList(); } } catch (Exception ex) { throw new Exception(ex.Message); } return(result); }
public UserRoleDDL getDDLData() { UserRoleDDL result = new UserRoleDDL(); using (var context = new StandardCanEntities()) { result.UserGroupList = new List <DDLViewModel>(); var programList = context.MAS_PROGRAM.ToList(); result.UserGroupList = context.USER_GROUP.Select(a => new DDLViewModel { id = a.Group_ID.ToString(), name = a.Group_Name, detail = a.Group_Name, active = a.Active == true ? "True" : "False", roleList = context.USER_ROLE.Where(x => x.Group_ID == a.Group_ID.ToString()).Select(r => new UserRoleProgramViewModel { program_id = r.Program_ID, // program_name = programList.SingleOrDefault(x => x.Program_ID.ToString() == r.Program_ID) != null ? programList.SingleOrDefault(x => x.Program_ID.ToString() == r.Program_ID).Program_Name : "" }).ToList() }).ToList(); result.ProgramList = new List <DDLViewModel>(); result.ProgramList = context.MAS_PROGRAM.Where(a => a.Active).Select(a => new DDLViewModel { id = a.Program_ID.ToString(), name = a.Program_Name, detail = a.Url_Path, order = a.Order_Item }).OrderBy(a => a.order.Value).ToList(); } return(result); }
public messageModel update(projectModel value) { messageModel result = new messageModel(); try { using (var context = new StandardCanEntities()) { if (String.IsNullOrEmpty(value.user_id)) { throw new Exception("Unauthorized Access"); } var userId = JwtHelper.GetUserIdFromToken(value.user_id); if (String.IsNullOrEmpty(userId)) { throw new Exception("Unauthorized Access"); } int ret = context.sp_project_update_v2(value.prj_id, value.prj_name, value.start_date, value.stop_date, value.prj_detail, value.prj_status, userId); } result.status = "S"; result.message = ""; } catch (Exception ex) { result.status = "E"; result.message = ex.Message.ToString(); } return(result); }
public List <UserRoleViewModel> searchUserGroup() { List <UserRoleViewModel> result = new List <UserRoleViewModel>(); using (var context = new StandardCanEntities()) { //result = context.USER_GROUP.Where().Select(a => new UserRoleViewModel //{ // roleId = a.role, // Name = a.OfficeName //}).ToList(); //var data = new List<USER_ROLE>(); //if (String.IsNullOrEmpty(role.usergroup)) //{ // data = context.USER_ROLE.ToList(); //} //else //{ // data = context.USER_ROLE.Where(a => a.Group_ID.Equals(role.group_id)).ToList(); //} //foreach (var item in data) //{ // UserRoleViewModel model = new UserRoleViewModel(); // model.roleId = item.Role_ID.ToString(); // model.userGroupId = item.Group_ID; // model.userGroup = context.USER_GROUP.SingleOrDefault(a => a.Group_Name == item.Group_ID).Group_Detail; // model.programId = item.Program_ID; // model.programName = item.Program_Name; // model.active = item.Active ? "True" : null; // result.Add(model); //} } return(result); }
public List <sp_calendar_dashboard_Result> searchCalendar_v2(dashBoardModel value) { try { using (StandardCanEntities context = new StandardCanEntities()) { if (String.IsNullOrEmpty(value.user_id)) { throw new Exception("Unauthorized Access"); } var userId = JwtHelper.GetUserIdFromToken(value.user_id); if (String.IsNullOrEmpty(userId)) { throw new Exception("Unauthorized Access"); } JavaScriptSerializer js = new JavaScriptSerializer(); string json = js.Serialize(value); context.interface_log.Add(new interface_log { data_log = json, module = "dashBoard", update_date = DateTime.Now }); context.SaveChanges(); List <sp_calendar_dashboard_Result> result = context.sp_calendar_dashboard(userId).ToList(); return(result); } } catch (Exception ex) { throw new Exception(ex.Message); } }
public empTabNoteModel tab_note_search(employeeModel value) { empTabNoteModel result = new empTabNoteModel(); try { using (var context = new StandardCanEntities()) { if (String.IsNullOrEmpty(value.user_id)) { throw new Exception("Unauthorized Access"); } var userId = JwtHelper.GetUserIdFromToken(value.user_id); if (String.IsNullOrEmpty(userId)) { throw new Exception("Unauthorized Access"); } var note = context.sp_emp_profile_tabnote_search(value.emp_code).FirstOrDefault(); result.note = note ?? ""; } } catch (Exception ex) { //result.status = "E"; //result.message = ex.Message.ToString(); throw new Exception(ex.Message); } return(result); }
public empMasterModel master(employeeModel value) { empMasterModel result = new empMasterModel(); try { using (var context = new StandardCanEntities()) { if (String.IsNullOrEmpty(value.user_id)) { throw new Exception("Unauthorized Access"); } var userId = JwtHelper.GetUserIdFromToken(value.user_id); if (String.IsNullOrEmpty(userId)) { throw new Exception("Unauthorized Access"); } result.sh = context.sp_sh_search().ToList(); result.depart = context.sp_depart_search().ToList(); result.emp_status = context.sp_emp_status_search().ToList(); } } catch (Exception ex) { //result.status = "E"; //result.message = ex.Message.ToString(); throw new Exception(ex.Message); } return(result); }
public empTab3Model tab3_search(employeeModel value) { empTab3Model result = new empTab3Model(); try { using (var context = new StandardCanEntities()) { if (String.IsNullOrEmpty(value.user_id)) { throw new Exception("Unauthorized Access"); } var userId = JwtHelper.GetUserIdFromToken(value.user_id); if (String.IsNullOrEmpty(userId)) { throw new Exception("Unauthorized Access"); } result.quota = context.sp_emp_profile_tab3_quota(value.emp_code).ToList(); result.data = context.sp_emp_profile_tab3(value.emp_code, value.start_date, value.stop_date).ToList(); } } catch (Exception ex) { //result.status = "E"; //result.message = ex.Message.ToString(); throw new Exception(ex.Message); } return(result); }
public IEnumerable <sp_car_search_v3_Result> search(carModel value) { StandardCanEntities context = new StandardCanEntities(); IEnumerable <sp_car_search_v3_Result> result = context.sp_car_search_v3(value.car_type_from, value.car_type_to, value.car_from, value.car_to).AsEnumerable(); return(result); }
public projectMasterModel master(scheduleCourseModel value) { projectMasterModel result = new projectMasterModel(); try { using (var context = new StandardCanEntities()) { string sql = "select convert(nvarchar(4), MPJ_YEAR) code, convert(nvarchar(4), MPJ_YEAR) [text] "; sql += " from MAS_PROJECT "; sql += " where MPJ_YEAR is not null "; sql += " group by MPJ_YEAR "; result.year = context.Database.SqlQuery <dropdown>(sql).ToList(); sql = "select convert(nvarchar(5), MPJ_ID) code "; sql += " , MPJ_NAME [text] "; sql += " from MAS_PROJECT "; sql += " where MPJ_STATUS = 1 "; sql += " order by MPJ_NAME "; result.project = context.Database.SqlQuery <dropdown>(sql).ToList(); } } catch (Exception ex) { throw new Exception(ex.Message); } return(result); }
public IEnumerable <sp_emp_temporary_search_v2_Result> search_Temporary(empCheckInModel value) { try { JavaScriptSerializer js = new JavaScriptSerializer(); string json = js.Serialize(value); StandardCanEntities context = new StandardCanEntities(); if (String.IsNullOrEmpty(value.user_id)) { throw new Exception("Unauthorized Access"); } var userId = JwtHelper.GetUserIdFromToken(value.user_id); if (String.IsNullOrEmpty(userId)) { throw new Exception("Unauthorized Access"); } context.interface_log.Add(new interface_log { ID = 1, data_log = json, module = "search_Temporary", update_date = DateTime.Now }); context.SaveChanges(); IEnumerable <sp_emp_temporary_search_v2_Result> result = context.sp_emp_temporary_search_v2(userId, value.start_date, value.stop_date, value.emp_code_from, value.emp_code_to, value.depart_from, value.depart_to, value.fname, value.lname).AsEnumerable(); return(result); } catch (Exception ex) { throw new Exception(ex.Message); } }
public holidayMasterModel master(holidayModel value) { holidayMasterModel result = new holidayMasterModel(); try { using (var context = new StandardCanEntities()) { if (String.IsNullOrEmpty(value.user_id)) { throw new Exception("Unauthorized Access"); } var userId = JwtHelper.GetUserIdFromToken(value.user_id); if (String.IsNullOrEmpty(userId)) { throw new Exception("Unauthorized Access"); } string sql = "select convert(nvarchar(4), year(mhd_date)) code "; sql += " , convert(nvarchar(4), year(mhd_date)) [text] "; sql += " from MAS_HOLIDAY "; sql += " group by year(mhd_date) "; sql += " order by year(mhd_date) "; result.year = context.Database.SqlQuery <dropdown>(sql).ToList(); } } catch (Exception ex) { throw new Exception(ex.Message); } return(result); }
public IEnumerable <sp_emp_profile_search_v2_Result> search(employeeModel value) { try { if (String.IsNullOrEmpty(value.user_id)) { throw new Exception("Unauthorized Access"); } var userId = JwtHelper.GetUserIdFromToken(value.user_id); if (String.IsNullOrEmpty(userId)) { throw new Exception("Unauthorized Access"); } StandardCanEntities context = new StandardCanEntities(); IEnumerable <sp_emp_profile_search_v2_Result> result = context.sp_emp_profile_search_v2(value.emp_code_start, value.emp_code_stop, value.sh_start, value.sh_stop, value.depart_start, value.depart_stop, value.emp_status_start, value.emp_status_stop, value.emp_fname, value.emp_lname, value.head_fname, value.head_lname).AsEnumerable(); return(result); } catch (Exception ex) { throw new Exception(ex.Message); } }
public timeAttRealtimeMasterModel master(empCheckInModel value) { timeAttRealtimeMasterModel result = new timeAttRealtimeMasterModel(); try { using (var context = new StandardCanEntities()) { if (String.IsNullOrEmpty(value.user_id)) { throw new Exception("Unauthorized Access"); } var userId = JwtHelper.GetUserIdFromToken(value.user_id); if (String.IsNullOrEmpty(userId)) { throw new Exception("Unauthorized Access"); } string sql = "select convert(nvarchar(5), MD_ID) code "; sql += " , md_name [text] "; sql += " from MAS_DEPARTMENT "; sql += " where md_status = 1 "; sql += " order by md_name "; result.department = context.Database.SqlQuery <dropdown>(sql).ToList(); } } catch (Exception ex) { throw new Exception(ex.Message); } return(result); }
public IEnumerable <sp_trainning_search_Result> searchTraining(projectTrainingScheduleModel value) { try { //if (String.IsNullOrEmpty(value.user_id)) //{ // throw new Exception("Unauthorized Access"); //} //var userId = JwtHelper.GetUserIdFromToken(value.user_id); //if (String.IsNullOrEmpty(userId)) //{ // throw new Exception("Unauthorized Access"); //} StandardCanEntities context = new StandardCanEntities(); JavaScriptSerializer js = new JavaScriptSerializer(); string json = js.Serialize(value); context.interface_log.Add(new interface_log { data_log = json, module = "searchTraining", update_date = DateTime.Now }); context.SaveChanges(); IEnumerable <sp_trainning_search_Result> result = context.sp_trainning_search(value.project_year, value.project_id, value.date_form, value.date_to, value.training_name, "", value.status_id).AsEnumerable(); return(result); } catch (Exception ex) { throw new Exception(ex.Message); } }
public messageModel delete(carModel value) { messageModel result = new messageModel(); try { using (var context = new StandardCanEntities()) { if (String.IsNullOrEmpty(value.user_id)) { throw new Exception("Unauthorized Access"); } var userId = JwtHelper.GetUserIdFromToken(value.user_id); if (String.IsNullOrEmpty(userId)) { throw new Exception("Unauthorized Access"); } int ret = context.sp_car_delete(value.id, userId); } result.status = "S"; result.message = ""; } catch (Exception ex) { result.status = "E"; result.message = ex.Message.ToString(); } return(result); }
public projectTrainingMasterModel master(projectTrainingScheduleModel value) { projectTrainingMasterModel result = new projectTrainingMasterModel(); try { using (var context = new StandardCanEntities()) { //if (String.IsNullOrEmpty(value.user_id)) //{ // throw new Exception("Unauthorized Access"); //} //var userId = JwtHelper.GetUserIdFromToken(value.user_id); //if (String.IsNullOrEmpty(userId)) //{ // throw new Exception("Unauthorized Access"); //} JavaScriptSerializer js = new JavaScriptSerializer(); string json = js.Serialize(value); context.interface_log.Add(new interface_log { data_log = json, module = "Training_master", update_date = DateTime.Now }); context.SaveChanges(); string sql = "select convert(nvarchar(4), MPJ_YEAR) code, convert(nvarchar(4), MPJ_YEAR) [text] "; sql += " from MAS_PROJECT "; sql += " where MPJ_YEAR is not null "; sql += " group by MPJ_YEAR "; result.project_year = context.Database.SqlQuery <dropdown>(sql).ToList(); sql = "select convert(nvarchar(5), MPJ_ID) code "; sql += " , MPJ_NAME [text] "; sql += " from MAS_PROJECT "; sql += " where MPJ_STATUS = 1 "; sql += " order by MPJ_NAME "; result.project_name = context.Database.SqlQuery <dropdown>(sql).ToList(); var expenseData = context.MAS_EXPENSE.ToList(); foreach (var item in expenseData) { projectTrainingExpenseModel expenseModel = new projectTrainingExpenseModel(); expenseModel.id = item.MEXP_ID.ToString(); expenseModel.expense_name = item.MEXP_NAME; result.project_expense.Add(expenseModel); } result.depart = context.sp_depart_search().ToList(); } } catch (Exception ex) { throw new Exception(ex.Message); } return(result); }
public benefitsDataResultModel search(benefitsModel value) { benefitsDataResultModel result = new benefitsDataResultModel(); result.message = new messageModel(); try { using (StandardCanEntities context = new StandardCanEntities()) { var _Gapi = context.MAS_GLOBAL_CONFIG.SingleOrDefault(x => x.GGC_KEY == "API_PATH"); var _Gpath = context.MAS_GLOBAL_CONFIG.SingleOrDefault(x => x.GGC_KEY == "FILE_PATH"); JsonPathModel jsonPath = new JsonPathModel(); if (_Gpath != null) { jsonPath = (JsonPathModel)Newtonsoft.Json.JsonConvert.DeserializeObject(_Gpath.GGC_VAL, typeof(JsonPathModel)); } if (String.IsNullOrEmpty(value.user_id)) { throw new Exception("Unauthorized Access"); } var userId = JwtHelper.GetUserIdFromToken(value.user_id); if (String.IsNullOrEmpty(userId)) { throw new Exception("Unauthorized Access"); } JavaScriptSerializer js = new JavaScriptSerializer(); string json = js.Serialize(value); context.interface_log.Add(new interface_log { data_log = json, module = "Benefits_search", update_date = DateTime.Now }); context.SaveChanges(); var data = context.MAS_BENEFITS.Where(a => a.mb_title.Contains(value.title)).ToList(); result.benefitData = new List <benefitsModel>(); foreach (var item in data) { benefitsModel news = new benefitsModel(); news.id = item.MB_ID.ToString(); news.title = item.mb_title; news.detail = item.mb_detail; news.url = !String.IsNullOrEmpty(item.mb_link_url) ? _Gapi.GGC_VAL + jsonPath.benefits + item.mb_link_url : null; result.benefitData.Add(news); } result.message.status = "S"; result.message.message = "Success"; } } catch (Exception ex) { result.message.status = "E"; result.message.message = ex.Message.ToString(); } return(result); }
public dashBoardModel search(dashBoardModel value) { dashBoardModel result = new dashBoardModel(); result.message = new messageModel(); try { using (StandardCanEntities context = new StandardCanEntities()) { var _Gapi = context.MAS_GLOBAL_CONFIG.SingleOrDefault(x => x.GGC_KEY == "API_PATH"); var _Gpath = context.MAS_GLOBAL_CONFIG.SingleOrDefault(x => x.GGC_KEY == "FILE_PATH"); JsonPathModel jsonPath = new JsonPathModel(); if (_Gpath != null) { jsonPath = (JsonPathModel)Newtonsoft.Json.JsonConvert.DeserializeObject(_Gpath.GGC_VAL, typeof(JsonPathModel)); } if (String.IsNullOrEmpty(value.user_id)) { throw new Exception("Unauthorized Access"); } var userId = JwtHelper.GetUserIdFromToken(value.user_id); if (String.IsNullOrEmpty(userId)) { throw new Exception("Unauthorized Access"); } JavaScriptSerializer js = new JavaScriptSerializer(); string json = js.Serialize(value); context.interface_log.Add(new interface_log { data_log = json, module = "dashBoard", update_date = DateTime.Now }); context.SaveChanges(); var data = context.IMAGE_SLIDE.Where(a => a.is_status == 1).ToList().OrderBy(a => a.is_order_by).ToList(); result.imgList = new List <dashBoardImg>(); foreach (var item in data) { dashBoardImg news = new dashBoardImg(); string path = Path.Combine(HostingEnvironment.MapPath("~" + jsonPath.imageSlide), Path.GetFileName(item.is_url_image)); byte[] bytes = File.ReadAllBytes(path); news.base64 = Convert.ToBase64String(bytes); result.imgList.Add(news); } result.message.status = "S"; result.message.message = "Success"; } } catch (Exception ex) { result.message.status = "E"; result.message.message = ex.Message.ToString(); } return(result); }
public FileContentResult exportFileWeb(timeAttRealModel value) { try { if (String.IsNullOrEmpty(value.user_id)) { throw new Exception("Unauthorized Access"); } var userId = JwtHelper.GetUserIdFromToken(value.user_id); if (String.IsNullOrEmpty(userId)) { throw new Exception("Unauthorized Access"); } using (var context = new StandardCanEntities()) { var _Gapi = context.MAS_GLOBAL_CONFIG.SingleOrDefault(x => x.GGC_KEY == "API_PATH"); var _Gpath = context.MAS_GLOBAL_CONFIG.SingleOrDefault(x => x.GGC_KEY == "FILE_PATH"); JsonPathModel jsonPath = new JsonPathModel(); if (_Gpath != null) { jsonPath = (JsonPathModel)Newtonsoft.Json.JsonConvert.DeserializeObject(_Gpath.GGC_VAL, typeof(JsonPathModel)); } string out_put_dir = System.AppDomain.CurrentDomain.BaseDirectory + jsonPath.timeAttRealtime; Directory.CreateDirectory(out_put_dir); string filePath = out_put_dir + value.fileName; var microsoftDateFormatSettings = new JsonSerializerSettings { DateParseHandling = DateParseHandling.None, DateFormatHandling = DateFormatHandling.IsoDateFormat, Formatting = Formatting.Indented, }; using (StreamWriter writer = new StreamWriter(filePath, true)) { var v_date_from = String.IsNullOrEmpty(value.start_date) ? "" : DateTime.ParseExact(value.start_date, "yyyy-MM-dd", CultureInfo.InvariantCulture).ToString("dd/MM/yyyy"); var v_date_to = String.IsNullOrEmpty(value.stop_date) ? "" : DateTime.ParseExact(value.stop_date, "yyyy-MM-dd", CultureInfo.InvariantCulture).ToString("dd/MM/yyyy"); IEnumerable <sp_report_timeatt_v2_Result> dataList = context.sp_report_timeatt_v2(value.start_date, value.stop_date, value.emp_code_from, value.emp_code_to, value.depart_from, value.depart_to, value.fname, value.lname, value.node_from, value.node_to, userId).ToList(); foreach (var item in dataList) { writer.WriteLine(item.emp_code + " " + item.type1 + " " + item.tar_date + " " + item.tar_time + " " + item.type2); } } var file = System.IO.Path.Combine(out_put_dir, value.fileName); byte[] fileBytes = System.IO.File.ReadAllBytes(file); FileContentResult result = new FileContentResult(fileBytes, "application/octet-stream"); result.FileDownloadName = value.fileName; return(result); } } catch (Exception ex) { throw new Exception(ex.Message); } }
public projectCourseDetailModel detail2(projectCourseModel value) { projectCourseDetailModel result = new projectCourseDetailModel(); try { using (var context = new StandardCanEntities()) { if (String.IsNullOrEmpty(value.user_id)) { throw new Exception("Unauthorized Access"); } var userId = JwtHelper.GetUserIdFromToken(value.user_id); if (String.IsNullOrEmpty(userId)) { throw new Exception("Unauthorized Access"); } result.data = context.sp_project_course_detail_v4(value.id).ToList(); string sql = ""; sql = "select convert(nvarchar(5), MPJ_ID) code "; sql += " , MPJ_NAME [text] "; sql += " from MAS_PROJECT "; sql += " where MPJ_STATUS = 1 "; sql += " order by MPJ_NAME "; result.project = context.Database.SqlQuery <dropdown>(sql).ToList(); sql = "select convert(nvarchar(5), MEP_ID) code "; sql += " , MEP_NAME [text] "; sql += " from MAS_EXPERT "; sql += " where MEP_STATUS = 1 "; sql += " order by MEP_NAME "; result.expert = context.Database.SqlQuery <dropdown>(sql).ToList(); sql = "select convert(nvarchar(5), MTD_ID) code "; sql += " , MTD_NAME [text] "; sql += " from MAS_TRAIN_DESTINATION "; sql += " where MTD_STATUS = 1 "; sql += " order by MTD_NAME "; result.location = context.Database.SqlQuery <dropdown>(sql).ToList(); sql = "select convert(nvarchar(5), MFL_ID) code "; sql += " , MFL_NAME [text] "; sql += " from MAS_FORMULA "; sql += " where MFL_STATUS = 1 "; sql += " order by MFL_NAME "; result.formula = context.Database.SqlQuery <dropdown>(sql).ToList(); } } catch (Exception ex) { throw new Exception(ex.Message); } return(result); }
public messageModel insert(projectFormularModel value) { messageModel result = new messageModel(); try { if (String.IsNullOrEmpty(value.user_id)) { throw new Exception("Unauthorized Access"); } var userId = JwtHelper.GetUserIdFromToken(value.user_id); if (String.IsNullOrEmpty(userId)) { throw new Exception("Unauthorized Access"); } System.Data.Entity.Core.Objects.ObjectParameter myOutputParamInt = new System.Data.Entity.Core.Objects.ObjectParameter("r_id", typeof(Int32)); using (var context = new StandardCanEntities()) { int ret = context.sp_formular_insert(value.fml_name, value.fml_type, value.fml_input_type, value.user_id, myOutputParamInt); int countRange = value.formularRange.Count(); for (int i = 0; i < countRange; i++) { int ret2 = context.sp_formularrange_insert(ret.ToString(), value.formularRange[i].fml_range_no, value.formularRange[i].fml_range_score, value.formularRange[i].fml_range_display, value.user_id, myOutputParamInt); } int countvalue = value.formularValue.Count(); for (int i = 0; i < countvalue; i++) { int ret2 = context.sp_formularvalue_insert(ret.ToString(), value.formularValue[i].fmlv_orderby, value.formularValue[i].fmlv_value, value.formularValue[i].fmlv_text, value.user_id, myOutputParamInt); } } if (myOutputParamInt.Value != null) { int r_id = Convert.ToInt32(myOutputParamInt.Value); result.status = "S"; result.message = ""; result.value = r_id.ToString(); } else { result.status = "E"; result.message = ""; } } catch (Exception ex) { result.status = "E"; result.message = ex.Message.ToString(); } return(result); }
public FileContentResult exportFileQRCode(qrCodeViewModel value) { try { if (String.IsNullOrEmpty(value.user_id)) { throw new Exception("Unauthorized Access"); } var userId = JwtHelper.GetUserIdFromToken(value.user_id); if (String.IsNullOrEmpty(userId)) { throw new Exception("Unauthorized Access"); } using (var context = new StandardCanEntities()) { var fileName = "QRCode"; var qrCodeData = String.Format("{0},{1},{2},{3}", value.id, value.req_date, value.start_date, value.stop_date); QRCodeGenerator _qrCode = new QRCodeGenerator(); QRCodeData _qrCodeData = _qrCode.CreateQrCode(qrCodeData, QRCodeGenerator.ECCLevel.Q); QRCode qrCode = new QRCode(_qrCodeData); Bitmap qrCodeImage = qrCode.GetGraphic(20); var microsoftDateFormatSettings = new JsonSerializerSettings { DateParseHandling = DateParseHandling.None, DateFormatHandling = DateFormatHandling.IsoDateFormat, Formatting = Formatting.Indented, }; Bitmap newBitmap; PointF roomLocation = new PointF(70, 30); PointF dateLocation = new PointF(70, 660); PointF topicLocation = new PointF(70, 700); using (Graphics graphics = Graphics.FromImage(qrCodeImage)) { using (Font arialFont = new Font("Arial", 22, FontStyle.Bold)) { graphics.TextRenderingHint = System.Drawing.Text.TextRenderingHint.AntiAlias; graphics.DrawString(value.room_name, arialFont, Brushes.Blue, roomLocation); graphics.DrawString(value.req_date + " " + value.start_date + "-" + value.stop_date, arialFont, Brushes.Blue, dateLocation); graphics.DrawString(value.topic, arialFont, Brushes.Blue, topicLocation); } } newBitmap = new Bitmap(qrCodeImage); byte[] fileBytes = BitmapToBytesCode(newBitmap); FileContentResult result = new FileContentResult(fileBytes, "application/octet-stream"); result.FileDownloadName = fileName; return(result); } } catch (Exception ex) { throw new Exception(ex.Message); } }
public messageModel save_Regular(empCheckInModel value) { messageModel result = new messageModel(); try { JavaScriptSerializer js = new JavaScriptSerializer(); string json = js.Serialize(value); using (var context = new StandardCanEntities()) { if (String.IsNullOrEmpty(value.user_id)) { throw new Exception("Unauthorized Access"); } var userId = JwtHelper.GetUserIdFromToken(value.user_id); if (String.IsNullOrEmpty(userId)) { throw new Exception("Unauthorized Access"); } context.interface_log.Add(new interface_log { ID = 1, data_log = json, module = "save_Regular", update_date = DateTime.Now }); context.SaveChanges(); int ret = context.sp_emp_regular_delete(userId); if (value.data != null) { foreach (var item in value.data) { context.sp_emp_regular_insert(userId, item.emp_code); } } } result.status = "S"; result.message = ""; } catch (Exception ex) { result.status = "E"; result.message = ex.Message.ToString(); } return(result); }
public carMasterModel master(carModel value) { carMasterModel result = new carMasterModel(); try { using (var context = new StandardCanEntities()) { if (String.IsNullOrEmpty(value.user_id)) { throw new Exception("Unauthorized Access"); } var userId = JwtHelper.GetUserIdFromToken(value.user_id); if (String.IsNullOrEmpty(userId)) { throw new Exception("Unauthorized Access"); } string sql = "select convert(nvarchar(5), MCT_ID) code "; sql += " , MCT_NAME [text] "; sql += " from MAS_CAR_TYPE "; sql += " where MCT_STATUS = 1 "; sql += " order by MCT_NAME "; result.car_type = context.Database.SqlQuery <dropdown>(sql).ToList(); sql = "select convert(nvarchar(5), MCA_ID) code "; sql += " , MCA_NAME [text] "; sql += " from MAS_CAR "; sql += " where MCT_ID = " + (value.carTypes ?? "0") + "AND MCA_STATUS = 1 "; sql += " order by MCA_NAME "; result.car_license = context.Database.SqlQuery <dropdown>(sql).ToList(); sql = "select convert(nvarchar(5), MCR_ID) code "; sql += " , MCR_NAME[text] "; sql += " from MAS_CAR_REASON "; sql += " where MCR_STATUS = 1 "; sql += " order by MCR_NAME "; result.car_reason = context.Database.SqlQuery <dropdown>(sql).ToList(); sql = " select convert(nvarchar(5), MAS_ID) code, mas_name [text] "; sql += " from MAS_APPROVE_STATUS "; sql += " where MAS_ID != 0 "; sql += " order by mas_orderby "; result.car_status = context.Database.SqlQuery <dropdown>(sql).ToList(); } } catch (Exception ex) { throw new Exception(ex.Message); } return(result); }
public IEnumerable <sp_emp_profile_tabcard_search_Result> tab_card_search(employeeModel value) { try { StandardCanEntities context = new StandardCanEntities(); IEnumerable <sp_emp_profile_tabcard_search_Result> result = context.sp_emp_profile_tabcard_search(value.emp_code).AsEnumerable(); return(result); } catch (Exception ex) { throw new Exception(ex.Message); } }
public bookRoomMasterModel master(bookRoomModel value) { bookRoomMasterModel result = new bookRoomMasterModel(); try { using (var context = new StandardCanEntities()) { if (String.IsNullOrEmpty(value.user_id)) { throw new Exception("Unauthorized Access"); } var userId = JwtHelper.GetUserIdFromToken(value.user_id); if (String.IsNullOrEmpty(userId)) { throw new Exception("Unauthorized Access"); } string sql = "select convert(nvarchar(5), MRM_ID) code "; sql += " , MRM_CODE [text] "; sql += " from MAS_ROOM "; sql += " order by MRM_CODE "; result.room = context.Database.SqlQuery <dropdown>(sql).ToList(); sql = " select convert(nvarchar(5), MAS_ID) code, mas_name [text] "; sql += " from MAS_APPROVE_STATUS "; sql += " where MAS_ID != 0 "; sql += " order by mas_orderby "; result.status = context.Database.SqlQuery <dropdown>(sql).ToList(); } //if (myOutputParamInt.Value != null) //{ // int r_id = Convert.ToInt32(myOutputParamInt.Value); // result.status = "S"; // result.message = ""; // result.value = r_id.ToString(); //} //else //{ // result.status = "E"; // result.message = ""; //} } catch (Exception ex) { throw new Exception(ex.Message); } return(result); }
public messageAuthenticationModel LoginToken(string token) { messageAuthenticationModel result = new messageAuthenticationModel(); try { using (var context = new StandardCanEntities()) { result.message = new messageModel(); var userId = JwtHelper.GetUserIdFromToken(token); //var passEncrypt = Cipher.Encrypt(password, secrectKey); var userGroupList = context.USER_GROUP.ToList(); var empDetail = context.EMP_PROFILE.SingleOrDefault(a => a.EMP_ID.ToString() == userId); if (empDetail != null) { var countBoss = context.EMP_PROFILE.Where(a => a.emp_boss_id == empDetail.EMP_ID).ToList().Count(); result.message.status = "1"; result.message.message = ""; var groupName = userGroupList.SingleOrDefault(a => a.Group_ID == empDetail.emp_group); if (countBoss > 0) { result.permission = "2"; } else if (groupName.Group_Name == "EMP") { result.permission = "1"; } else if (groupName.Group_Name == "ADMIN") { result.permission = "3"; } else if (groupName.Group_Name == "ACC") { result.permission = "4"; } result.token_login = CreateToken(empDetail.EMP_ID.ToString(), result.permission, groupName.Group_Name); } else { throw new Exception("The username or password is incorrect"); } } } catch (Exception ex) { throw new Exception("The username or password is incorrect"); } return(result); }
public projectFomularResult searchFomulay(projectTrainingScheduleModel value) { projectFomularResult result = new projectFomularResult(); result.message = new messageModel(); try { using (StandardCanEntities context = new StandardCanEntities()) { //if (String.IsNullOrEmpty(value.user_id)) //{ // throw new Exception("Unauthorized Access"); //} //var userId = JwtHelper.GetUserIdFromToken(value.user_id); //if (String.IsNullOrEmpty(userId)) //{ // throw new Exception("Unauthorized Access"); //} JavaScriptSerializer js = new JavaScriptSerializer(); string json = js.Serialize(value); context.interface_log.Add(new interface_log { data_log = json, module = "searchFomulay", update_date = DateTime.Now }); context.SaveChanges(); string sql = ""; sql += "select convert(int, b.MFV_ORDER_BY) order_by, MFV_VALUE value, MFV_TEXT text "; sql += " from MAS_COURSE a inner "; sql += " join MAS_FORMULA_VALUE b on a.MFL_ID = b.MFL_ID "; sql += " where a.MCS_ID = " + value.course_id + " and MFV_STATUS = 1 "; sql += " order by b.MFV_ORDER_BY "; result.data = context.Database.SqlQuery <fomularField>(sql).ToList(); result.message.status = "S"; result.message.message = "Success"; } } catch (Exception ex) { result.message.status = "E"; result.message.message = ex.Message.ToString(); } return(result); }