public static Result getListaHelp(string tabla, string[] prefiltros, string textoBusqueda, int registroPartida, int totalAExtraer, int usuarioId) { int totalRegistros = 0; MethodInfo metRange; object lst; try { helpController hc = new helpController(); lst = hc.getLista(tabla, prefiltros, textoBusqueda); Type tpLs = lst.GetType(); MethodInfo[] metArry = tpLs.GetMethods(BindingFlags.Public | BindingFlags.Instance | BindingFlags.DeclaredOnly); MethodInfo metCount = tpLs.GetMethod("get_Count"); metRange = tpLs.GetMethod("GetRange"); totalRegistros = int.Parse(metCount.Invoke(lst, null).ToString()); totalAExtraer = (totalRegistros - registroPartida) < totalAExtraer ? (totalRegistros - registroPartida) : totalAExtraer; } catch (Exception e) { return(new Result() { error = e.Message, id = 0, tipoAlerta = "warning" }); } return(new Result() { error = "", getCadena = new JavaScriptSerializer().Serialize(metRange.Invoke(lst, new object[] { registroPartida, totalAExtraer })), totalRegistros = totalRegistros }); }
public HttpResponseMessage GetRoles_byUser(string Username) ///ใส่หรือไม่ใส่ username ก็ได้ ทำงานได้ 2 แบบ แสดงชื่อทั้งหมดกับตาม user ที่ใส่ { get_role_byuser objUser_info = new get_role_byuser(); try { // DataSet ds; //ds = SqlHelper.ExecuteDataset(scc, CommandType.StoredProcedure, "spt_MoblieGetRoles_ByUser", new SqlParameter("@Oid", Oid)); ///อย่าลืมเปลี่ยน คอนเนคชั่นสติง //DataTable dt = new DataTable(); //dt = ds.Tables[0]; helpController result = new helpController(); objUser_info = result.get_Roles(Username); if (objUser_info.Status != 0) { return(Request.CreateResponse(HttpStatusCode.OK, objUser_info)); } { objUser_info.Status = 2; objUser_info.Message = "ใส่ Username ผิด"; return(Request.CreateResponse(HttpStatusCode.BadRequest, objUser_info)); } } //else { // objUser_info.status = "0"; //} //return Request.CreateResponse(HttpStatusCode.BadRequest, "ไม่เจอ User"); catch (Exception ex) { //Error case เกิดข้อผิดพลาด UserError err = new UserError(); err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ err.message = ex.Message; // Return resual return(Request.CreateResponse(HttpStatusCode.BadRequest, err)); } finally { Dispose(); } }
public static Result getHelp(string tabla, string valorBuscar, int usuarioId, string[] prefiltros) { object lst; try { helpController hc = new helpController(); lst = hc.getObject(tabla, valorBuscar, prefiltros); } catch (Exception e) { return(new Result() { error = e.Message, id = 0, tipoAlerta = "warning" }); } return(new Result() { error = "", getCadena = new JavaScriptSerializer().Serialize(lst) }); }
public HttpResponseMessage LoginAuthen() // ByVal UserName As String, ByVal password As String : { // HttpResponseMessage // IHttpActionResult User_info user = new User_info(); Roles_info rolename = new Roles_info(); try { object Token_key = ""; Login login = new Login(); if (HttpContext.Current.Request.Form["UserName"].ToString() != null) { login.Username = HttpContext.Current.Request.Form["UserName"].ToString(); } if (HttpContext.Current.Request.Form["Password"].ToString() != null) { login.Password = HttpContext.Current.Request.Form["Password"].ToString(); } helpController result = new helpController(); //login.resultLogin = result.CheckLogin_XAF(login.Username, login.Password); //if (login.resultLogin != null) //{ // TokenController token = new TokenController(); // Token_key = token.Get(login.Username, login.Password); //} // XpoTypesInfoHelper.GetXpoTypeInfoSource(); user = result.CheckLogin_XAF(login.Username, login.Password); SqlParameter[] prm = new SqlParameter[9]; /// parameter นับได้เท่าไร ใส่เท่านั้น c# user.Description = "ระบบ login"; prm[0] = new SqlParameter("@Username", user.User_Name); ///แต่ array ต้องนับจาก 0 prm[1] = new SqlParameter("@DisplayName", user.DisplayName); prm[2] = new SqlParameter("@Organization", user.OrganizationNameTH); prm[3] = new SqlParameter("@Tel", user.Tel); prm[4] = new SqlParameter("@Email", user.Email); prm[5] = new SqlParameter("@LogID", "2"); prm[6] = new SqlParameter("@IPAddress", GetClientIp(Request)); prm[7] = new SqlParameter("@Description", user.Message); if (user.Status == 1) { user.Message = "เข้าสู่ระบบสำเร็จ"; prm[8] = new SqlParameter("@EventName", user.Description); SqlHelper.ExecuteNonQuery(scc, CommandType.StoredProcedure, "insert_EventLog", prm); return(Request.CreateResponse(HttpStatusCode.OK, user)); } else if (user.Status == 0 || user.Status == 6) { user.Message = "เข้าสู่ระบบไม่สำเร็จ"; prm[8] = new SqlParameter("@EventName", user.Description); SqlHelper.ExecuteNonQuery(scc, CommandType.StoredProcedure, "insert_EventLog", prm); return(Request.CreateResponse(HttpStatusCode.BadRequest, user)); } } catch (Exception ex) { //Error case เกิดข้อผิดพลาด user.Status = 6; user.Message = ex.Message; return(Request.CreateResponse(HttpStatusCode.BadRequest, user)); } finally { Dispose(); } return(Request.CreateResponse(HttpStatusCode.BadRequest, user)); }