private Conversacion obtenerConversacion(int UsuarioHost, int UsuarioGuest, string facultadbd)
{
//RETORNA UNA CONVERSACION EN CASO DE ESTAR CREADA UNA QUE TENGA A AMBOS USUARIOS (EN AMBOS ROLES)
//CREA Y RETORNA UNA EN CASO DE NO HABER
//FALTA VERIFICAR QUE EXISTA EL USUARIO EN LA BASE DE DATOS RELACIONAL
var facultad = _contextoGeneral.Facultad.SingleOrDefault(f => f.Url == facultadbd);
if (facultad != null)
{
Mongodb mdb = new Mongodb(facultad.NombreBD);
List <Conversacion> listConv = mdb.LoadRecord <Conversacion>(collection).ToList();
foreach (Conversacion conv in listConv)
{
if ((conv.UsuarioGuest.Equals(UsuarioGuest) &&
conv.UsuarioHost.Equals(UsuarioHost)) ||
(conv.UsuarioGuest.Equals(UsuarioHost) &&
conv.UsuarioHost.Equals(UsuarioGuest)))
{
return(conv);
}
}
return(nuevaConversacion(UsuarioHost, UsuarioGuest, facultad.NombreBD));
}
else
{
throw (new Exception("No se encuentran datos de facultad con ese nombre"));
}
}
public void TestInitialize()
{
Mongodb.IgnoreExtraElements();
Mapper.Run();
var mongo = Mongodb.MongoDbClient();
_mongoDBContext = new MongoDBContext(mongo.client, mongo.database);
InitCategoryRepo();
var categoryService = new Mock <ICategoryService>();
_categoryService = categoryService.Object;
var urlRecordService = new Mock <IUrlRecordService>();
_urlRecordService = urlRecordService.Object;
var pictureService = new Mock <IPictureService>();
_pictureService = pictureService.Object;
var localizationService = new Mock <ILocalizationService>();
_localizationService = localizationService.Object;
var customerActivityService = new Mock <ICustomerActivityService>();
_customerActivityService = customerActivityService.Object;
_categoryApiService = new CategoryApiService(_mongoDBContext, _categoryService, _urlRecordService, _pictureService, _customerActivityService, _localizationService);
}
public List <BasicConversacionResponse> listarConversacionesUsuario(int UsuarioId, string facultadbd)
{
var facultad = _contextoGeneral.Facultad.SingleOrDefault(f => f.Url == facultadbd);
Mongodb mdb = new Mongodb(facultad.NombreBD);
List <Conversacion> listConv = mdb.LoadRecord <Conversacion>(collection).ToList();
List <BasicConversacionResponse> lb = new List <BasicConversacionResponse>();
foreach (Conversacion conv in listConv)
{
if ((conv.UsuarioGuest == UsuarioId) || (conv.UsuarioHost == UsuarioId))
{
var cuenta_host = _context.Cuenta
.Include(z => z.PersonaCuenta)
.SingleOrDefault(x => x.Id == conv.UsuarioHost);
var cuenta_guest = _context.Cuenta
.Include(z => z.PersonaCuenta)
.SingleOrDefault(x => x.Id == conv.UsuarioGuest);
lb.Add(new BasicConversacionResponse()
{
UsuarioHost = conv.UsuarioHost,
NombreHost = cuenta_host.PersonaCuenta.Nombre + " " + cuenta_host.PersonaCuenta.Apellido,
UsuarioGuest = conv.UsuarioGuest,
NombreGuest = cuenta_guest.PersonaCuenta.Nombre + " " + cuenta_guest.PersonaCuenta.Apellido,
});
}
}
return(lb);
}
protected void Button1_Click(object sender, EventArgs e)
{
Mongodb bd = new Mongodb();
String[] values = bd.login("User", "Correo", TextBox1.Text, TextBox2.Text);
for (int i = 0; i < values.Length; i++)
{
values[i] = (values[i].Substring(values[i].LastIndexOf(':') + 2)).Replace("\"", "");
}
if (values.Length != 1)
{
if (values[4] == TextBox2.Text)
{
Session["Usuario"] = values[1];
Session["Apellido"] = values[2];
Session["Correo"] = values[3];
Session["Carrera"] = values[5];
Session["Semestre"] = values[6];
Session["Busqueda"] = "Buscar en Empleos";
Response.Redirect("Index.aspx");
mensaje("Inicio Correcto");
}
}
else
{
mensaje("Correo o contraseña incorrecto, intente nuevamente");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
Mongodb bd = new Mongodb();
try
{
BsonDocument documento = new BsonDocument
{
{ "Empresa", nom.Text },
{ "Cargo", car.Text },
{ "Fecha Inicio", fechafin.Text },
{ "Fecha Fin", fechafin.Text },
{ "Correo Registrado", Session["Correo"].ToString() },
};
bd.insert("Trabajo", documento);
mensaje("Trabajo subido con exito");
nom.Text = "";
car.Text = "";
fechaini.Text = "";
fechafin.Text = "";
}
catch (Exception)
{
throw;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
Mongodb bd = new Mongodb();
try
{
BsonDocument documento = new BsonDocument
{
{ "Empresa", nom.Text },
{ "Nombre Contacto", ncontacto.Text },
{ "Telefono de Contacto", tel.Text },
{ "Descripcion", desc.Text },
{ "Carrera", carrerasop.SelectedItem.ToString() },
{ "Salario", sal.Text },
};
bd.insert("Oferta", documento);
mensaje("Oferta subida con exito");
nom.Text = "";
ncontacto.Text = "";
tel.Text = "";
desc.Text = "";
carrerasop.SelectedValue = "1";
sal.Text = "";
}
catch (Exception)
{
throw;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
Mongodb bd = new Mongodb();
try
{
if (Int32.Parse(experiencia.Text).Equals(""))
{
mensaje("Años de experiencia no valido invalido");
}
else
{
if (bd.find("User", "Correo", correo.Text) == "null")
{
BsonDocument documento = new BsonDocument
{
{ "Nombre", nom.Text },
{ "Apellido", ape.Text },
{ "Correo", correo.Text },
{ "Contraseña", contra.Text },
{ "Especialidad", carrerasop.SelectedItem.ToString() },
{ "Semestre", experiencia.Text }
};
BsonDocument documento2 = new BsonDocument
{
{ "Nombre", nom.Text },
{ "Apellido", ape.Text },
{ "Correo", correo.Text },
{ "Especialidad", carrerasop.SelectedItem.ToString() },
{ "Semestre", experiencia.Text }
};
bd.insert("User", documento);
bd.insert("UserF", documento2);
mensaje("Registro Exitoso");
Session["Usuario"] = nom.Text;
Session["Apellido"] = ape.Text;
Session["Correo"] = correo.Text;
Session["Carrera"] = carrerasop.SelectedItem.ToString();
Session["Semestre"] = experiencia.Text;
nom.Text = "";
ape.Text = "";
correo.Text = "";
contra.Text = "";
carrerasop.SelectedValue = "1";
experiencia.Text = "";
Response.Redirect("Index.aspx");
}
else
{
mensaje("Ya existe un usuario con este correo electronico, intene nuevamente");
}
}
}
catch (Exception)
{
mensaje("Campos no validos ");
//throw;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Server.UrlDecode(Request.QueryString["examId"]) != null || Session["Question_Save"] != null)
{
if (Server.UrlDecode(Request.QueryString["examId"]) != null)
{
string examId = Server.UrlDecode(Request.QueryString["examId"]);
Mongodb mongodb = new Mongodb();
mongodb.GetCollection("exam");
BsonDocument document = mongodb.Query("examId", examId);
question_one = Exam_Drector.GetQuestionsOrChoosed(document, "question_one");
question_more = Exam_Drector.GetQuestionsOrChoosed(document, "question_more");
question_judge = Exam_Drector.GetQuestionsOrChoosed(document, "question_judge");
questions_one_chosed = Exam_Drector.GetQuestionsOrChoosed(document, "questions_one_chosed");
questions_more_chosed = Exam_Drector.GetQuestionsOrChoosed(document, "questions_more_chosed");
questions_judge_chosed = Exam_Drector.GetQuestionsOrChoosed(document, "questions_judge_chosed");
score.Text = Request.QueryString["score"].ToString();
}
else if (Session["Question_Save"] != null)
{
Hashtable Question_Save = (Hashtable)Session["Question_Save"];
question_one = (ArrayList)Question_Save["questions_one"];
question_more = (ArrayList)Question_Save["questions_more"];
question_judge = (ArrayList)Question_Save["questions_judge"];
// 获取存储用户选择的项
hashtable_question_one = (Hashtable)Session["hashtable_question_one"];
hashtable_question_more = (Hashtable)Session["hashtable_question_more"];
hashtable_question_judge = (Hashtable)Session["hashtable_question_judge"];
questions_one_chosed = (ArrayList)hashtable_question_one["questions_one_chosed"];
questions_more_chosed = (ArrayList)hashtable_question_more["questions_more_chosed"];
questions_judge_chosed = (ArrayList)hashtable_question_judge["questions_judge_chosed"];
score.Text = Session["score_total"].ToString();
}
DataList_Questoin_One.DataSource = question_one;
DataList_Questoin_One.DataBind();
DataList_Questoin_More.DataSource = question_more;
DataList_Questoin_More.DataBind();
DataList_Questoin_Judge.DataSource = question_judge;
DataList_Questoin_Judge.DataBind();
Exam_Drector.Loading_Question(DataList_Questoin_One, question_one, "questions_one");
Exam_Drector.Loading_Question(DataList_Questoin_More, question_more, "questions_more");
Exam_Drector.Loading_Result(DataList_Questoin_One, question_one, "questions_one", questions_one_chosed);
Exam_Drector.Loading_Result(DataList_Questoin_More, question_more, "questions_more", questions_more_chosed);
Exam_Drector.Loading_Result(DataList_Questoin_Judge, question_judge, "questions_judge", questions_judge_chosed);
number.Text = Session["sn"].ToString();
name.Text = Session["username"].ToString();
}
else
{
Response.Redirect("~/Login.aspx");
}
}
private Conversacion nuevaConversacion(int UsuarioHost, int UsuarioGuest, string nombreFacultad)
{
Conversacion conv = new Conversacion()
{
UsuarioGuest = UsuarioGuest,
UsuarioHost = UsuarioHost,
Mensajes = new List <Datos.MongoDB.Clases.Mensaje>()
};
Mongodb mdb = new Mongodb(nombreFacultad);
mdb.InsertRecord(collection, conv);
return(conv);
}
public bool enviarMensaje(MensajeRequest mensajeRequest)
{
Conversacion conversacion = obtenerConversacion(mensajeRequest.UsuarioEmisor, mensajeRequest.UsuarioReceptor, mensajeRequest.Facultad);
Mongodb mdb = new Mongodb(_contextoGeneral.Facultad.SingleOrDefault(x => x.Url == mensajeRequest.Facultad).NombreBD);
conversacion.Mensajes.Add(new Datos.MongoDB.Clases.Mensaje()
{
Texto = mensajeRequest.Texto,
UsuarioEmisor = mensajeRequest.UsuarioEmisor,
});
mdb.UpsertRecord(collection, conversacion.Id, conversacion);
PusherUtil.Enviar(PusherUtil.canal, PusherUtil.evento, conversacion.Mensajes.LastOrDefault());
return(true);
}
public void TestInitialize()
{
Mongodb.IgnoreExtraElements();
InitCategoryRepo();
var tempCategoryApiService = new Mock <ICategoryApiService>();
{
tempCategoryApiService.Setup(instance => instance.GetCategories()).Returns(_categoryDto.AsQueryable());
tempCategoryApiService.Setup(instance => instance.GetById(_id1)).ReturnsAsync(_categoryDto.AsQueryable().FirstOrDefault(x => x.Id == _id1));
tempCategoryApiService.Setup(instance => instance.InsertOrUpdateCategory(modelInsertOrUpdate)).ReturnsAsync(InsertOrUpdate(modelInsertOrUpdate));
_categoryApiService = tempCategoryApiService.Object;
}
var tempPermissionService = new Mock <IPermissionService>();
{
tempPermissionService.Setup(instance => instance.Authorize(PermissionSystemName.Categories)).ReturnsAsync(true);
_permissionService = tempPermissionService.Object;
}
_categoryController = new CategoryController(_categoryApiService, _permissionService);
}
private void button1_Click(object sender, EventArgs e)
{
List <ManifiestoProvisional> listaMani = new List <ManifiestoProvisional>();
try
{
int i = 0;
HtmlElementCollection elements = webBrowserAduana.Document.GetElementsByTagName("TR");
foreach (HtmlElement element in elements)
{
if (i > 4)
{
ManifiestoProvisional mani = new ManifiestoProvisional();
int j = 0;
HtmlElementCollection elementsChild = element.GetElementsByTagName("TD");
foreach (HtmlElement elemenTD in elementsChild)
{
switch (j)
{
case 0:
mani.Manifiesto = elemenTD.InnerText;
break;
case 1:
mani.FechaLlegada = elemenTD.InnerText;
break;
case 2:
mani.FechaTransmision = elemenTD.InnerText;
break;
case 3:
mani.Aerolinea = elemenTD.InnerText;
break;
case 4:
break;
case 5:
mani.Vuelo = elemenTD.InnerText;
break;
default:
break;
}
j++;
}
listaMani.Add(mani);
}
i++;
}
Mongodb.insertar(listaMani);
MessageBox.Show("Se proceso correctamente");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public CartMongo()
{
mongodb = new Mongodb <TEntity>();
}
private void obtenerDatosAppBD(int codApp)
{
aplicacion = Mongodb.getAplicaciones(codApp);
}
public IMongoCollection <T> MongoDbCollection <T>()
{
return(Mongodb.GetCollection <T>(_collectionName));
}
private void ConnectMongo()
{
mongodb = new Mongodb();
}
