public DataTable adminRoleApplication(RequestAdminRoleApplicationData request) { try { DataTable response = new DataTable(); SqlParameter[] param = new SqlParameter[1]; DataBase db = new DataBase(); param[0] = new SqlParameter("@tblRoleApplication", "tblRoleApplication"); param[0].Value = request.dtRoleApplication; response = db.executeDataTable("spAdminRoleApplication", param); return(response); } catch (Exception ex) { throw ex; } }
public ResponseAdminRoleApplication adminRoleApplication(RequestAdminRoleApplicationList request) { try { DataTable dt = new DataTable(); DataTable dtRoleApp = LogicPrincipal.makeDt("id,idRole,idApplication,stateRecord,userRegister,dateRegister,userUpdate,dateUpdate,flag"); DataAdminRoleApplication datRoleApplication = new DataAdminRoleApplication(); RequestAdminRoleApplicationData requesData = new RequestAdminRoleApplicationData(); ResponseAdminRoleApplication response = new ResponseAdminRoleApplication(); // Transformar la lista a un DataTable foreach (RequestAdminRoleApplication i in request.lst) { DataRow r = dtRoleApp.NewRow(); r["id"] = i.id.ToString(); r["idRole"] = i.idRole.ToString(); r["idApplication"] = i.idApplication.ToString(); r["stateRecord"] = i.stateRecord.ToString(); r["userRegister"] = i.userRegister.ToString(); r["dateRegister"] = i.dateRegister.ToString(); r["userUpdate"] = i.userUpdate.ToString(); r["dateUpdate"] = i.dateUpdate.ToString(); r["flag"] = "N"; dtRoleApp.Rows.Add(r); } requesData.dtRoleApplication = dtRoleApp; dt = datRoleApplication.adminRoleApplication(requesData); if (dt != null) { if (dt.Rows.Count > 0) { response.code = int.Parse(dt.Rows[0]["code"].ToString()); response.message = dt.Rows[0]["message"].ToString(); response.status = int.Parse(dt.Rows[0]["state"].ToString()); } } return(response); } catch (System.Data.SqlClient.SqlException exSql) { // Cuando sea una excepción por SQL ya vendrá el mensaje de error controlado throw exSql; } catch (Exception ex) { // Registrar el error real DataLogError datError = new DataLogError(); LogError error = new LogError(); error.module = "ADMIN"; error.method = "adminRoleApplication"; error.errorMessage = ex.Message; error.moreInfo = ""; datError.newError(error); // Modificar la excepción Exception exResult = new Exception("Error no controlado, favor consultar con el administrador del sistema."); throw exResult; } }