protected void cmd_save_days_Click(object sender, EventArgs e)
{
int str_ndias = Convert.ToInt32(txt_days.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_caducidad_videos
select c).Count();
str_count = items_user;
}
if (str_count == 0)
{
using (var insert_fiscal = new db_transcriptEntities())
{
var items_fiscal = new inf_caducidad_videos
{
dias_caducidad = str_ndias,
id_usuario = id_fuser,
id_centro = id_fcenter,
fecha_registro = DateTime.Now
};
insert_fiscal.inf_caducidad_videos.Add(items_fiscal);
insert_fiscal.SaveChanges();
}
txt_days.Text = "";
using (db_transcriptEntities data_user = new db_transcriptEntities())
{
var inf_user = (from u in data_user.inf_caducidad_videos
where u.dias_caducidad == str_ndias
select new
{
u.id_caducidad_videos,
u.dias_caducidad,
u.fecha_registro
}).ToList();
gv_dayvideosf.DataSource = inf_user;
gv_dayvideosf.DataBind();
gv_dayvideosf.Visible = true;
}
rb_add_dayvideos.Visible = false;
lblModalTitle.Text = "tranScript";
lblModalBody.Text = "Caducidad de videos, agregado con éxito";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
else
{
foreach (GridViewRow row in gv_dayvideos.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_caducidad_videos
where c.id_caducidad_videos == str_code
select c).FirstOrDefault();
items_address.dias_caducidad = str_ndias;
data_address.SaveChanges();
}
txt_days.Text = "";;
lblModalTitle.Text = "tranScript";
lblModalBody.Text = "Caducidad 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_caducidad_videos
where u.id_caducidad_videos == str_code
select new
{
u.id_caducidad_videos,
u.dias_caducidad,
u.fecha_registro
}).ToList();
gv_dayvideos.DataSource = inf_user;
gv_dayvideos.DataBind();
gv_dayvideos.Visible = true;
}
}
}
}
}
}
protected void cmd_save_days_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txt_days.Text))
{
txt_days.BackColor = Color.Yellow;
}
else
{
txt_days.BackColor = Color.Transparent;
int str_ndias = Convert.ToInt32(txt_days.Text);
int str_count;
using (db_transcriptEntities edm_cadvideos = new db_transcriptEntities())
{
var i_cadvideos = (from c in edm_cadvideos.inf_caducidad_videos
select c).Count();
str_count = i_cadvideos;
}
if (str_count == 0)
{
using (var edm_cadvideos = new db_transcriptEntities())
{
var i_cadvideos = new inf_caducidad_videos
{
dias_caducidad = str_ndias,
id_usuario = guid_fidusuario,
id_tribunal = guid_fidcentro,
fecha_registro = DateTime.Now
};
edm_cadvideos.inf_caducidad_videos.Add(i_cadvideos);
edm_cadvideos.SaveChanges();
}
using (db_transcriptEntities edm_fecha_transf = new db_transcriptEntities())
{
var ii_fecha_transf = (from u in edm_fecha_transf.inf_caducidad_videos
select u).ToList();
if (ii_fecha_transf.Count == 0)
{
}
else
{
using (var insert_user = new db_transcriptEntities())
{
var items_user = new inf_caducidad_videos_dep
{
id_usuario = guid_fidusuario,
id_caducidad_videos = ii_fecha_transf[0].id_caducidad_videos,
id_tipo_accion = id_accion(),
fecha_registro = DateTime.Now,
};
insert_user.inf_caducidad_videos_dep.Add(items_user);
insert_user.SaveChanges();
}
}
}
txt_days.Text = "";
using (db_transcriptEntities edm_cadvideos = new db_transcriptEntities())
{
var i_cadvideos = (from u in edm_cadvideos.inf_caducidad_videos
where u.dias_caducidad == str_ndias
select new
{
u.id_caducidad_videos,
u.dias_caducidad,
u.fecha_registro
}).ToList();
gv_dayvideosf.DataSource = i_cadvideos;
gv_dayvideosf.DataBind();
gv_dayvideosf.Visible = true;
}
rb_add_dayvideos.Visible = false;
lblModalTitle.Text = "transcript";
lblModalBody.Text = "Dias de respaldo, agregado con éxito";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
}
else
{
foreach (GridViewRow row in gv_dayvideos.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_cadvideos = new db_transcriptEntities())
{
var i_cadvideos = (from c in edm_cadvideos.inf_caducidad_videos
where c.id_caducidad_videos == str_code
select c).FirstOrDefault();
i_cadvideos.dias_caducidad = str_ndias;
edm_cadvideos.SaveChanges();
}
using (db_transcriptEntities edm_fecha_transf = new db_transcriptEntities())
{
var ii_fecha_transf = (from u in edm_fecha_transf.inf_caducidad_videos
select u).ToList();
if (ii_fecha_transf.Count == 0)
{
}
else
{
using (var insert_user = new db_transcriptEntities())
{
var items_user = new inf_caducidad_videos_dep
{
id_usuario = guid_fidusuario,
id_caducidad_videos = ii_fecha_transf[0].id_caducidad_videos,
id_tipo_accion = id_accion(),
fecha_registro = DateTime.Now,
};
insert_user.inf_caducidad_videos_dep.Add(items_user);
insert_user.SaveChanges();
}
}
}
txt_days.Text = "";;
lblModalTitle.Text = "transcript";
lblModalBody.Text = "Dias de respaldo, actualizado con éxito";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal();", true);
upModal.Update();
using (db_transcriptEntities edm_cadvideos = new db_transcriptEntities())
{
var i_cadvideos = (from u in edm_cadvideos.inf_caducidad_videos
where u.id_caducidad_videos == str_code
select new
{
u.id_caducidad_videos,
u.dias_caducidad,
u.fecha_registro
}).ToList();
gv_dayvideos.DataSource = i_cadvideos;
gv_dayvideos.DataBind();
gv_dayvideos.Visible = true;
}
}
}
}
}
}
}
