private void btnsaveub_Click(object sender, EventArgs e)
{
insusuariobio inser = new insusuariobio();
string idub = inser.buscaub(Convert.ToString(txtrut.Text));
if (idub == "")//no existe usuario
{
idub = inser.buscatar(Convert.ToString(txttarnum.Text));
if (idub == "")//tarjeta no asignada
{
txtdv.Text = Convert.ToString("t no asigned");
idub = inser.inserta(txtnoms.Text, txtapepat.Text, txtapemat.Text, txtrut.Text, txtdv.Text, txttarnum.Text);
MessageBox.Show("Usuario y tarjeta igresados correctamente !!" + idub, "En hora buena !!", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
else
{
txtdv.Text = Convert.ToString("t asignada " + idub);
MessageBox.Show("Usuario no existe pero la tarjeta ya esta asignada !!", "Alerta !!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
else//usuario ya existe
{
MessageBox.Show("Usuario ya existe !!","Alerta !!",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);
txtdv.Text = Convert.ToString("nopes");
}
}
private void Form7_Load(object sender, EventArgs e)
{
insusuariobio datosub = new insusuariobio();
DataTable nombre = datosub.traerub(datz);
string tarjeta = datosub.buscatarpeerid(datz);
DataTable puerta = datosub.traepuerta(datz);
try
{
txtnombre.Text = Convert.ToString(nombre.Rows[0][1]);
txtrut.Text = Convert.ToString(nombre.Rows[0][5]);
txttarjeta.Text = tarjeta;
txtaccgrp.Text = Convert.ToString(puerta.Rows[0][1]);
}
catch(IndexOutOfRangeException)
{
MessageBox.Show("Usuario no tiene grupo de acceso asignado !!", "Alerta !!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public string inserta(string nombres, string apepat, string apemat, string rut, string dv,string numtar)
{
string sard = " bien";
try
{
String consulta = "Insert into BioStar.dbo.TB_USER(sUserID,sUserName,nDepartmentIdn,nStartDate,nEndDate,nAdminLevel,nEncryption,sTelNumber,sEmail,bPassword2,nAuthMode,nAuthLimitCount,nTimedAPB,sPassword) values('" + rut + "','" + apepat + " " + apemat + " " + nombres + "',0,946684800,1924988400,241,0,0,' ',0x0000000000000000000000000000000000000000000000000000000000000000,0,0,0,' ');";
SqlCommand sqd = new SqlCommand(consulta, con1._SqlConnetion);
con1._SqlConnetion.Open();
sqd.ExecuteNonQuery();
con1._SqlConnetion.Close();
insusuariobio proc = new insusuariobio();
string dat1 = proc.buscaub(rut);
String consultab = "insert into TB_USER_EX(nUserIdn,sSurName,sFirstName,sMiddleName,nImageSize,sImageFilePath,nDuration,nCountPerDay,nUsePrivateImage,sGreetingMsg,nEncryption) values(" + dat1 + ",'','','',0,'',0,0,0,'',0);";
String consultac = "insert into TB_USER_CARD(nUserIdn,nType,sCardNo,sCustomNo,nSecurityLevel,nDateTime,nExpiryDateTime,nBypass,nStatus,nLatest,nEncryption) values(" + dat1 + ",1," + numtar + ",0,0,DATEDIFF(second,{d '1970-01-01'},getdate()),0,1,1,1,0);";
SqlCommand sqd2 = new SqlCommand(consultab, con1._SqlConnetion);
SqlCommand sqd3 = new SqlCommand(consultac, con1._SqlConnetion);
con1._SqlConnetion.Open();
sqd2.ExecuteNonQuery();
sqd3.ExecuteNonQuery();
con1._SqlConnetion.Close();
}
catch (Exception ex)
{
sard = ex.Message;
}
return "ok" + sard;
}
