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));
}
