private void inf_user()
{
int n_useradmin;
try
{
using (db_posEntities data_user = new db_posEntities())
{
var v_user = (from u in data_user.inf_usuarios
where u.id_tipo_usuario == 2
select u).Count();
n_useradmin = v_user;
if (n_useradmin == 0)
{
lbl_registro.Visible = true;
lblModalTitle.Text = "POS Punto Cero";
lblModalBody.Text = "No existe administrador ni empresa en la aplicación, favor de registrarlos";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
else
{
}
}
}
catch
{
lblModalTitle.Text = "POS Punto Cero";
lblModalBody.Text = "Sin conexión a base de datos, contactar al administrador";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
}
protected void cmd_save_Click(object sender, EventArgs e)
{
Guid id_fempresa = Guid.NewGuid();;
Guid str_iduser = Guid.NewGuid();
string str_nameuser = txt_name_user.Text.ToUpper();
string str_apater = txt_apater.Text.ToUpper();
string str_amater = txt_amater.Text.ToUpper();
string str_codeuser = txt_code_user.Text.ToLower();
string str_password = mdl_encrypta.Encrypt(txt_password.Text.ToLower());
string str_business_name = txt_business_name.Text.ToUpper();
using (var insert_fiscal = new db_posEntities())
{
var items_fiscal = new inf_empresa
{
id_estatus = 1,
fecha_registro = DateTime.Now,
razon_social = str_business_name,
id_empresa = id_fempresa,
};
insert_fiscal.inf_empresa.Add(items_fiscal);
insert_fiscal.SaveChanges();
}
using (var insert_user = new db_posEntities())
{
var items_user = new inf_usuarios
{
id_usuario = str_iduser,
nombres = str_nameuser,
a_paterno = str_apater,
a_materno = str_amater,
id_tipo_usuario = 2,
codigo_usuario = str_codeuser,
clave = str_password,
id_estatus = 1,
fecha_registro = DateTime.Now,
id_empresa = id_fempresa
};
insert_user.inf_usuarios.Add(items_user);
insert_user.SaveChanges();
}
clean_text();
lblModalTitle.Text = "POS Punto Cero";
lblModalBody.Text = "Datos de administrador y empresa guardados con éxito";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
public static Guid code_user(string str_codeuser)
{
using (db_posEntities data_user = new db_posEntities())
{
var inf_user = (from i_u in data_user.inf_usuarios
where i_u.codigo_usuario == str_codeuser
select new
{
i_u.id_usuario,
}).FirstOrDefault();
Guid str_iduser_o = inf_user.id_usuario;
return(inf_user.id_usuario);
}
}
protected void cmd_login_Click(object sender, EventArgs e)
{
string str_codeuser = txt_code_user.Text;
string str_password = mdl_encrypta.Encrypt(txt_password.Text);
string str_password_V;
int? str_id_type_user, str_iduser_status;
try
{
using (db_posEntities data_user = new db_posEntities())
{
var items_user = (from c in data_user.inf_usuarios
where c.codigo_usuario == str_codeuser
select c).FirstOrDefault();
str_id_user = items_user.id_usuario;
str_password_V = items_user.clave;
str_id_type_user = items_user.id_tipo_usuario;
str_iduser_status = items_user.id_estatus;
if (str_password_V == str_password && str_iduser_status == 1)
{
Session["ss_id_user"] = mdl_user.code_user(str_codeuser);
Response.Redirect("ctrl_panel.aspx");
}
else
{
lblModalTitle.Text = "POS Punto Cero";
lblModalBody.Text = "Contraseña incorrecta, favor de contactar al Administrador.";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
}
}
catch
{
lblModalTitle.Text = "POS Punto Cero";
lblModalBody.Text = "Usuario incorrecto, favor de contactar al Administrador.";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
}
