protected void cmd_save_credentials_Click(object sender, EventArgs e)
{
string str_ip = txt_ip.Text;
string str_user = txt_user.Text;
string str_pass = txt_pass.Text;
Guid id_fcenter = Guid.Parse(lbl_idcenter.Text);
int str_count;
using (db_transcriptEntities data_user = new db_transcriptEntities())
{
var items_user = (from c in data_user.inf_credenciales
select c).Count();
str_count = items_user;
}
if (str_count == 0)
{
using (var insert_fiscal = new db_transcriptEntities())
{
var items_fiscal = new inf_credenciales
{
ip = str_ip,
usuario = str_user,
clave = str_pass,
id_usuario = id_fuser,
id_centro = id_fcenter,
fecha_registro = DateTime.Now
};
insert_fiscal.inf_credenciales.Add(items_fiscal);
insert_fiscal.SaveChanges();
}
clean_txt();
using (db_transcriptEntities data_user = new db_transcriptEntities())
{
var inf_user = (from u in data_user.inf_credenciales
where u.ip == str_ip
select new
{
u.id_credenciales,
u.ip,
u.usuario,
u.fecha_registro
}).ToList();
gv_credentialsf.DataSource = inf_user;
gv_credentialsf.DataBind();
gv_credentialsf.Visible = true;
}
rb_add_credentials.Visible = false;
lblModalTitle.Text = "tranScript";
lblModalBody.Text = "Datos de conexión guardados con éxito";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
else if (rb_edit_credentials.Checked)
{
foreach (GridViewRow row in gv_credentials.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
CheckBox chkRow = (row.Cells[0].FindControl("chk_select") as CheckBox);
if (chkRow.Checked)
{
int str_code = Convert.ToInt32(row.Cells[1].Text);
using (var data_address = new db_transcriptEntities())
{
var items_address = (from c in data_address.inf_credenciales
where c.id_credenciales == str_code
select c).FirstOrDefault();
items_address.ip = str_ip;
items_address.usuario = str_user;
items_address.clave = str_pass;
data_address.SaveChanges();
}
clean_txt();
lblModalTitle.Text = "tranScript";
lblModalBody.Text = "Horario de Conversión de videos, actualizado con éxito";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
using (db_transcriptEntities data_user = new db_transcriptEntities())
{
var inf_user = (from u in data_user.inf_credenciales
where u.ip == str_ip
select new
{
u.id_credenciales,
u.ip,
u.usuario,
u.fecha_registro
}).ToList();
gv_credentials.DataSource = inf_user;
gv_credentials.DataBind();
gv_credentials.Visible = true;
}
}
}
}
}
}
protected void cmd_save_credentials_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txt_ip.Text))
{
txt_ip.BackColor = Color.Yellow;
}
else
{
txt_ip.BackColor = Color.Transparent;
if (string.IsNullOrEmpty(txt_user.Text))
{
txt_user.BackColor = Color.Yellow;
}
else
{
txt_user.BackColor = Color.Transparent;
if (string.IsNullOrEmpty(txt_pass.Text))
{
txt_pass.BackColor = Color.Yellow;
}
else
{
txt_pass.BackColor = Color.Transparent;
string str_ip = txt_ip.Text;
string str_user = txt_user.Text;
string str_pass = txt_pass.Text;
int str_count;
using (db_transcriptEntities edm_conexion = new db_transcriptEntities())
{
var i_conexion = (from c in edm_conexion.inf_credenciales
select c).Count();
str_count = i_conexion;
}
if (str_count == 0)
{
using (var edm_conexion = new db_transcriptEntities())
{
var ii_conexion = new inf_credenciales
{
ip = str_ip,
usuario = str_user,
clave = str_pass,
fecha_registro = DateTime.Now
};
edm_conexion.inf_credenciales.Add(ii_conexion);
edm_conexion.SaveChanges();
}
using (db_transcriptEntities edm_fecha_transf = new db_transcriptEntities())
{
var ii_fecha_transf = (from u in edm_fecha_transf.inf_credenciales
select u).ToList();
if (ii_fecha_transf.Count == 0)
{
}
else
{
using (var insert_user = new db_transcriptEntities())
{
var items_user = new inf_credenciales_dep
{
id_usuario = guid_fidusuario,
id_credenciales = ii_fecha_transf[0].id_credenciales,
id_tipo_accion = id_accion(),
fecha_registro = DateTime.Now,
};
insert_user.inf_credenciales_dep.Add(items_user);
insert_user.SaveChanges();
}
}
}
clean_txt();
using (db_transcriptEntities edm_conexion = new db_transcriptEntities())
{
var ii_conexion = (from u in edm_conexion.inf_credenciales
where u.ip == str_ip
select new
{
u.id_credenciales,
u.ip,
u.usuario,
u.fecha_registro
}).ToList();
gv_credentialsf.DataSource = ii_conexion;
gv_credentialsf.DataBind();
gv_credentialsf.Visible = true;
}
rb_add_credentials.Visible = false;
lblModalTitle.Text = "transcript";
lblModalBody.Text = "Datos de conexión, guardados con éxito";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
else if (rb_edit_credentials.Checked)
{
foreach (GridViewRow row in gv_credentials.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
CheckBox chkRow = (row.Cells[0].FindControl("chk_select") as CheckBox);
if (chkRow.Checked)
{
int str_code = Convert.ToInt32(row.Cells[1].Text);
using (var edm_conexion = new db_transcriptEntities())
{
var i_conexion = (from c in edm_conexion.inf_credenciales
where c.id_credenciales == str_code
select c).FirstOrDefault();
i_conexion.ip = str_ip;
i_conexion.usuario = str_user;
i_conexion.clave = str_pass;
edm_conexion.SaveChanges();
}
using (db_transcriptEntities edm_fecha_transf = new db_transcriptEntities())
{
var ii_fecha_transf = (from u in edm_fecha_transf.inf_credenciales
select u).ToList();
if (ii_fecha_transf.Count == 0)
{
}
else
{
using (var insert_user = new db_transcriptEntities())
{
var items_user = new inf_credenciales_dep
{
id_usuario = guid_fidusuario,
id_credenciales = ii_fecha_transf[0].id_credenciales,
id_tipo_accion = id_accion(),
fecha_registro = DateTime.Now,
};
insert_user.inf_credenciales_dep.Add(items_user);
insert_user.SaveChanges();
}
}
}
clean_txt();
lblModalTitle.Text = "transcript";
lblModalBody.Text = "Datos de conexión, actualizados con éxito";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
using (db_transcriptEntities edm_conexion = new db_transcriptEntities())
{
var i_conexion = (from u in edm_conexion.inf_credenciales
select new
{
u.id_credenciales,
u.ip,
u.usuario,
u.fecha_registro
}).ToList();
gv_credentials.DataSource = i_conexion;
gv_credentials.DataBind();
gv_credentials.Visible = true;
}
}
}
}
}
//else if (rb_del_credentials.Checked)
//{
// foreach (GridViewRow row in gv_credentials.Rows)
// {
// if (row.RowType == DataControlRowType.DataRow)
// {
// CheckBox chkRow = (row.Cells[0].FindControl("chk_select") as CheckBox);
// if (chkRow.Checked)
// {
// int str_code = Convert.ToInt32(row.Cells[1].Text);
// using (var data_user = new db_transcriptEntities())
// {
// var items_user = (from c in data_user.inf_credenciales
// where c.id_credenciales == str_code
// select c).FirstOrDefault();
// data_user.inf_credenciales.Remove(items_user);
// data_user.SaveChanges();
// }
// clean_txt();
// lblModalTitle.Text = "transcript";
// lblModalBody.Text = "Datos de conexión, actualizado con éxito";
// ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
// upModal.Update();
// using (db_transcriptEntities edm_conexion = new db_transcriptEntities())
// {
// var i_conexion = (from u in edm_conexion.inf_credenciales
// select new
// {
// u.id_credenciales,
// u.ip,
// u.usuario,
// u.fecha_registro
// }).ToList();
// gv_credentials.DataSource = i_conexion;
// gv_credentials.DataBind();
// gv_credentials.Visible = true;
// }
// }
// }
// }
//}
}
}
}
}