public void DA_Registrar_PLANILLA(VT_Planilla p)
{
try
{
using (SqlConnection conexion = new SqlConnection(conexionString))
{
SqlCommand cmd = new SqlCommand("VT_PLANILLA_INSERT", conexion);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id_Solicitud", p.Id_Solicitud);
cmd.Parameters.AddWithValue("@Tot_Num_Dias", p.Tot_Num_Dias);
cmd.Parameters.AddWithValue("@Tot_Num_Dias15", p.Tot_Num_Dias15);
cmd.Parameters.AddWithValue("@Pago_Total", p.Pago_Total);
cmd.Parameters.AddWithValue("@Rc_Iva", p.Rc_Iva);
cmd.Parameters.AddWithValue("@Liquido_Pagable", p.Liquido_Pagable);
cmd.Parameters.AddWithValue("@Num_Cheque", p.Num_Cheque);
cmd.Parameters.AddWithValue("@Tasa_Cambio", p.Tasa_Cambio);
cmd.Parameters.AddWithValue("@Fecha", p.Fecha);
cmd.Parameters.AddWithValue("@Fecha_Atendido", p.Fecha_Atendido);
cmd.Parameters.AddWithValue("@MontoPorDia", p.MontoPorDia);
conexion.Open();
cmd.ExecuteNonQuery();
conexion.Close();
}
}
catch (Exception err)
{
throw (new Exception(err.ToString() + "-" + err.Source.ToString() + "-" + err.Message.ToString()));
}
}
protected void BtnAceptar_Click(object sender, EventArgs e)
{
if (LblEstado.Text == "INF-APROBADO" || LblEstado.Text == "APROBADO")
{
DB_VT_Planilla ip = new DB_VT_Planilla();
VT_Planilla p = new VT_Planilla();
VT_PlanillaDia pd = new VT_PlanillaDia();
p = ip.DB_Seleccionar_PLANILLA(LblIdSolicitud.Text);
int idplanilla = p.Id_Planilla;
p.Id_Solicitud = LblIdSolicitud.Text;
p.Tot_Num_Dias = Convert.ToDecimal(LblDiasCom.Text);
p.Tot_Num_Dias15 = Convert.ToDecimal(LblDiasCom15.Text);
p.Pago_Total = Convert.ToDecimal(LblTotalMonto.Text);
p.Pago_Total15 = Convert.ToDecimal(LblTotalMonto15.Text);
p.Liquido_Pagable = Convert.ToDecimal(LblTotalPago.Text);
p.Num_Cheque = TxtNumCheque.Text;
p.Fecha_Atendido = DateTime.Now;
p.MontoPorDia = Convert.ToDecimal(Lbl100.Text);
ip.DB_Modificar_PLANILLA(p);
int contador = 1;
foreach (GridViewRow dgi in GVDetallePlanilla.Rows)
{
TextBox tx = (TextBox)dgi.Cells[5].Controls[1];
TextBox tx1 = (TextBox)dgi.Cells[7].Controls[1];
DropDownList ddl = (DropDownList)dgi.Cells[3].Controls[1];
pd.Id_Planilla = p.Id_Planilla;
pd.Cont = contador;
pd.Num_Dias = Convert.ToDecimal(tx.Text);
pd.Area = ddl.SelectedItem.Text;
pd.Destino = GVDetallePlanilla.Rows[dgi.RowIndex].Cells[4].Text;
pd.Monto = Convert.ToDecimal(GVDetallePlanilla.Rows[dgi.RowIndex].Cells[6].Text);
pd.Observacion = tx1.Text;
ip.DB_Modificar_PLANILLA_DIA(pd);
contador++;
}
DB_VT_Solicitud s = new DB_VT_Solicitud();
s.DB_Cambiar_ESTADO(LblIdSolicitud.Text, "PROCESADO");
BtnAceptar.Enabled = false;
StringBuilder sbMensaje = new StringBuilder();
sbMensaje.Append("<script type='text/javascript'>");
sbMensaje.AppendFormat("window.open('{0}','Titulo','top=0,left=0,width=1000,height=600,scrollbars=yes,resizable=no,directories=no,location=no,menubar=no,status=no,Titlebar=yes,toolbar=no');", "../Viaticos/repPlanillaPago.aspx?ci=" + p.Id_Solicitud);
sbMensaje.Append("</script>");
ClientScript.RegisterClientScriptBlock(this.GetType(), "Mensaje", sbMensaje.ToString());
//Response.Redirect("frmRevisarInformes.aspx");
}
else
{
Response.Write("<script>window.alert('No se puede procesar su planilla de pago, por que NO se tiene un informe de viaje APROBADO.');</script>");
}
}
public VT_Planilla DB_Seleccionar_PLANILLA(string idSolicitud)
{
DA_VT_Planilla data = new DA_VT_Planilla();
DataTable dt = new DataTable();
dt = data.DA_Seleccionar_PLANILLA(idSolicitud);
VT_Planilla pl = new VT_Planilla();
pl.Id_Planilla = Convert.ToInt32(dt.Rows[0][0]);
pl.Pago_Total = Convert.ToDecimal(dt.Rows[0][1]);
pl.Rc_Iva = Convert.ToDecimal(dt.Rows[0][2]);
pl.Liquido_Pagable = Convert.ToDecimal(dt.Rows[0][3]);
pl.Num_Cheque = dt.Rows[0][4].ToString();
pl.Tasa_Cambio = Convert.ToDecimal(dt.Rows[0][5].ToString());
pl.Fecha = Convert.ToDateTime(dt.Rows[0][6].ToString());
pl.Fecha_Atendido = Convert.ToDateTime(dt.Rows[0][7].ToString());
return(pl);
}
public VT_Planilla LlenadoPlanilla(string idSolicitud, DB_VT_Planilla ip, ref int idplanilla)
{
VT_Planilla regPlanilla = new VT_Planilla();
regPlanilla = ip.DB_Seleccionar_PLANILLA(idSolicitud);
idplanilla = regPlanilla.Id_Planilla;
regPlanilla.Id_Solicitud = idSolicitud;
regPlanilla.Tot_Num_Dias = Convert.ToDecimal(LblDiasCom.Text);
regPlanilla.Tot_Num_Dias15 = Convert.ToDecimal(LblDiasCom15.Text);
regPlanilla.Pago_Total = Convert.ToDecimal(LblTotalMonto.Text);
regPlanilla.Pago_Total15 = Convert.ToDecimal(LblTotalMonto15.Text);
regPlanilla.Rc_Iva = Convert.ToDecimal(lblRetencion.Text); //SE GUARDA EL CALCULO DE RETENCION
regPlanilla.Liquido_Pagable = Convert.ToDecimal(lblTotalPagar.Text);
regPlanilla.Num_Cheque = TxtNumCheque.Text;
regPlanilla.Fecha_Atendido = DateTime.Now;
regPlanilla.MontoPorDia = Convert.ToDecimal(Lbl100.Text);
return(regPlanilla);
}
protected void Cargar_PLANILLA(string idUser, string idSolicitud)
{
string lugar = "";
DB_VT_Planilla regP = new DB_VT_Planilla();
VT_Planilla p = new VT_Planilla();
VT_PlanillaDia pd = new VT_PlanillaDia();
VT_SolicitudDestino sd1 = new VT_SolicitudDestino();
VT_SolicitudDestino sd2 = new VT_SolicitudDestino();
DB_VT_Solicitud s1 = new DB_VT_Solicitud();
DB_AP_Registro_Org aux = new DB_AP_Registro_Org();
DataTable dt = new DataTable();
DataTable dt1 = new DataTable();
DataTable dt2 = new DataTable();
int numero = s1.DB_Numero_Filas_SOLICITUD(idSolicitud);// se modifico query con 'cont>0'
decimal contdias = Convert.ToDecimal("0");
p.Id_Solicitud = idSolicitud;
p.Tot_Num_Dias = 0;
p.Tot_Num_Dias15 = 0;
p.Pago_Total = 0;
p.Pago_Total15 = 0;
p.Rc_Iva = 13; /*********************************************************** OJO AQUI HAY QUE PONER LOS PARAMETROS DE GESTION ******/
p.Liquido_Pagable = 0;
p.Num_Cheque = "0";
p.Tasa_Cambio = 0;
p.Fecha = DateTime.Now;
p.Fecha_Atendido = DateTime.Now;
p.MontoPorDia = 1;
regP.DB_Registrar_PLANILLA(p);
int idplani = Convert.ToInt32(aux.DB_MaxId("VIAT_PLANILLA", "Id_Planilla"));
/**************************************************************/
DB_VT_Solicitud sol = new DB_VT_Solicitud();
dt = sol.DB_Seleccionar_SOLICITUD(idSolicitud);
/************************************************************/
DB_AdminUser us = new DB_AdminUser();
dt1 = us.DB_Desplegar_USUARIO(idUser);
/******************************************************/
DB_VT_Categoria cat = new DB_VT_Categoria();
string aux1 = dt1.Rows[0][11].ToString();
string aux2 = dt.Rows[0][3].ToString();
dt2 = cat.DB_Seleccionar_CATEGORIA(Convert.ToInt32(dt1.Rows[0][11].ToString()), dt.Rows[0][3].ToString());
/***************************************************************/
//DB_VT_Solicitud sol = new DB_VT_Solicitud();
int contador = 1;
int auxiliar = 0;
for (int i = 1; i <= (numero); i++)
{
sd1 = s1.DB_Seleccionar_SOLICITUD_DESTINO(idSolicitud, i);
sd2 = s1.DB_Seleccionar_SOLICITUD_DESTINO(idSolicitud, (i + 1));
int dias = sol.DB_NumDHM(Convert.ToDateTime(sd1.Fecha_Salida.ToString()), Convert.ToDateTime(sd2.Fecha_Salida.ToString()), "DD");
if (sd1.Fecha_Salida.ToString("dd/MM/yyyy") == sd2.Fecha_Salida.ToString("dd/MM/yyyy"))
{
if (numero == 2)
{
contdias = Convert.ToDecimal("0.5");
pd.Id_Planilla = idplani;
pd.Cont = contador;
pd.Num_Dias = contdias;
if (sd1.Zona == "Interdepartamental")
{
pd.Area = "Interdepartamental";
pd.Monto = contdias * Convert.ToDecimal(dt2.Rows[0][3].ToString());
}
else
{
pd.Area = "Al interior del Departamento";
pd.Monto = contdias * Convert.ToDecimal(dt2.Rows[0][4].ToString());
}
pd.Destino = sd1.Destino + " " + sd1.Lugar;
pd.Observacion = "SIN PERNOCTE";
pd.FechaDia = sd1.Fecha_Salida;
regP.DB_Registrar_PLANILLADIA(pd);
contador++;
break;
}
else
{
pd.Destino = sd1.Destino + " " + sd1.Lugar;
}
}
else
{
if (sd1.Tramo == "Salida")
{
contdias = s1.DB_NumDHM(sd1.Fecha_Salida, sd2.Fecha_Salida, "DD");
for (int j = 0; j < contdias; j++)
{
pd.Id_Planilla = idplani;
pd.Cont = contador;
pd.Num_Dias = 1;
if (sd1.Zona == "Interdepartamental")
{
pd.Area = "Interdepartamental";
pd.Monto = 1 * Convert.ToDecimal(dt2.Rows[0][3].ToString());
}
else
{
pd.Area = "Al interior del Departamento";
pd.Monto = 1 * Convert.ToDecimal(dt2.Rows[0][4].ToString());
}
pd.Destino = sd1.Destino + " " + sd1.Lugar;
pd.Observacion = "CON PERNOCTE";
pd.FechaDia = sd1.Fecha_Salida.AddDays(j);
regP.DB_Registrar_PLANILLADIA(pd);
auxiliar = j;
contador++;
}
}
else
{
contdias = s1.DB_NumDHM(Convert.ToDateTime(sd1.Fecha_Salida.ToString("dd/MM/yyyy") + " " + "08:00:00"), sd1.Fecha_Salida, "HH");
if (contdias > 4) /*************************************** OJO aqui calculamos por hora mayor a 4 horas se contabiliza como medio dia*/
{
contdias = Convert.ToDecimal("0.5");
pd.Id_Planilla = idplani;
pd.Cont = contador;
pd.Num_Dias = contdias;
if (sd1.Zona == "Interdepartamental")
{
pd.Area = "Interdepartamental";
pd.Monto = contdias * Convert.ToDecimal(dt2.Rows[0][3].ToString());
}
else
{
pd.Area = "Al interior del Departamento";
pd.Monto = contdias * Convert.ToDecimal(dt2.Rows[0][4].ToString());
}
pd.Destino = sd1.Destino + " " + sd1.Lugar;
pd.Observacion = "SIN PERNOCTE";
pd.FechaDia = sd1.Fecha_Salida.AddDays(0);
regP.DB_Registrar_PLANILLADIA(pd);
contador++;
}
else
{
contdias = Convert.ToDecimal("0.0");
pd.Id_Planilla = idplani;
pd.Cont = contador;
pd.Num_Dias = contdias;
if (sd1.Zona == "Interdepartamental")
{
pd.Area = "Interdepartamental";
pd.Monto = contdias * Convert.ToDecimal(dt2.Rows[0][3].ToString());
}
else
{
pd.Area = "Al interior del Departamento";
pd.Monto = contdias * Convert.ToDecimal(dt2.Rows[0][4].ToString());
}
pd.Destino = sd1.Destino + " " + sd1.Lugar;
pd.Observacion = "No se cumplió el periodo de 4 horas que se considera como medio día de viatico";
pd.FechaDia = sd1.Fecha_Salida.AddDays(0);
regP.DB_Registrar_PLANILLADIA(pd);
contador++;
}
}
}
}
}
protected void Cargar_VALORES()
{
DB_VT_Solicitud memo = new DB_VT_Solicitud();
DB_VT_Planilla pl = new DB_VT_Planilla();
DataTable data = new DataTable();
//data = pl.DB_Reporte_DETALLE_PLANILLA(LblIdSolicitud.Text, "DESTINOS");
//LblDestino.Text = data.Rows[0][0].ToString();
/**************************************************/
data = memo.DB_Reporte_SOLICITUD_US(LblIdSolicitud.Text, "DETALLE");
#region comentado
//if (data.Rows[0][3].ToString() == "Departamental")
//{
// data = pl.DB_Reporte_DETALLE_PLANILLA(LblIdSolicitud.Text, "DESTINOS_LUGAR");
//}
//else
//{
// data = pl.DB_Reporte_DETALLE_PLANILLA(LblIdSolicitud.Text, "DESTINOS");
//}
//LblDestino.Text = data.Rows[0][0].ToString();
//ini lrojas 27072017: se modifico para obtener destino y lugar segun la zona
#endregion
string destinos = string.Empty;
int fin = data.Rows.Count;
int cont = 1;
foreach (DataRow row in data.Rows)
{
string des = row["Zona"].ToString();
string tramo = row["Tramo"].ToString();
if (des == "Interdepartamental")
{
if (tramo == "Salida")
{
if (cont == fin)
{
destinos = destinos + row["Destino"].ToString();
}
else
{
destinos = destinos + row["Destino"].ToString() + ", ";
}
}
}
else
{
if (tramo == "Salida")
{
if (cont == fin)
{
destinos = destinos + row["Lugar"].ToString();
}
else
{
destinos = destinos + row["Lugar"].ToString() + ", ";
}
}
}
cont++;
}
LblDestino.Text = destinos;
//fin lrojas 27072017: se modifico para obtener destino y lugar segun la zona
/*****************************************************/
data = pl.DB_Reporte_DETALLE_PLANILLA(LblIdSolicitud.Text, "DIASMONTO");
//Lbl100.Text = data.Rows[0][12].ToString();
//Lbl70.Text = Convert.ToString((Convert.ToDecimal(data.Rows[0][12].ToString()) * 70) / 100)
//*ini* lrojas: 26/09/2016
decimal Monto_1 = (Math.Round(Convert.ToDecimal(data.Rows[0][12].ToString()), 0));
//decimal Monto = Convert.ToDecimal(data.Rows[0][12].ToString());
string AlCien = string.Format("{0:n0}", (Math.Truncate(Monto_1 * 100) / 100)); //string.Format("{0:N2}", (Monto_1 * 100) / 100);
Lbl100.Text = AlCien;
decimal Monto2 = ((Monto_1 * 70) / 100);
string AlSetenta = string.Format("{0:n0}", (Math.Truncate(Monto2 * 100) / 100));
//string AlSetenta = string.Format("{0:N2}", Convert.ToDecimal((Monto2 * 100) / 100));
Lbl70.Text = AlSetenta;
#region
//*fin*
//LblDiasCom.Text = data.Rows[0][2].ToString();
//LblDiasCom10.Text = data.Rows[0][3].ToString();
//decimal DiasC = (Math.Round(Convert.ToDecimal(data.Rows[0][2].ToString()), 0));
//string DiasC_S = string.Format("{0:n0}", (Math.Truncate(DiasC * 100) / 100));
//LblDiasCom.Text = DiasC_S;
#endregion
LblDiasCom.Text = Convert.ToDecimal(data.Rows[0][2].ToString()).ToString();
/*decimal DiasC10 = (Math.Round(Convert.ToDecimal(data.Rows[0][3].ToString()), 0));
* string DiasC10_S = string.Format("{0:n0}", (Math.Truncate(DiasC10 * 100) / 100));
* LblDiasCom10.Text = DiasC10_S;*/
LblDiasCom10.Text = Convert.ToDecimal(data.Rows[0][3].ToString()).ToString();
//LblTotalMonto.Text = Convert.ToString(Math.Round((Convert.ToDecimal(Lbl100.Text) * Convert.ToDecimal(LblDiasCom.Text)),0));
/*****************************/
int contdias = 0;
decimal totaldias = 0;
decimal total = 0;
decimal total15 = 0;
foreach (GridViewRow dgi in GVDetallePlanilla.Rows)
{
//TextBox tx = (TextBox)dgi.Cells[5].Controls[1];
decimal monto = Convert.ToDecimal(GVDetallePlanilla.Rows[dgi.RowIndex].Cells[6].Text);
//Convert.ToString(DataBinder.Eval(e.Row.DataItem, "Monto"));
//DropDownList ddl = (DropDownList)dgi.Cells[3].Controls[1];
contdias++;
if (totaldias <= 9)
{
if (GVDetallePlanilla.Rows[dgi.RowIndex].Cells[3].Text == "Interdepartamental")
{
total = total + monto;
}
else
{
total = total + monto;
}
totaldias = totaldias + Convert.ToDecimal(GVDetallePlanilla.Rows[dgi.RowIndex].Cells[5].Text);
}
else
{
if (GVDetallePlanilla.Rows[dgi.RowIndex].Cells[3].Text == "Interdepartamental")
{
total15 = total15 + (((monto * 70) / 100));
}
else
{
total15 = total15 + (((monto * 70) / 100));
}
}
}
/**********************/
//*ini* lrojas 26/09/2016
//LblTotalMonto.Text = Convert.ToString(Math.Round(total, 0));
decimal TotalMonto = (Math.Round(total, 0)); //total;
string TMonto = string.Format("{0:n0}", (Math.Truncate(TotalMonto * 100) / 100)); //string.Format("{0:N2}", (TotalMonto * 100) / 100);
LblTotalMonto.Text = TMonto;
//*fin*
if (Convert.ToDecimal(LblDiasCom10.Text) == 0)
{
LblTotalMonto10.Text = "0";
}
else
{
//LblTotalMonto10.Text = Convert.ToString(Math.Round(total,0)); //MI REVISION JLAH
//LblTotalMonto10.Text = Convert.ToString(Math.Round(total15, 0));
//*ini* lrojas 26/09/2016
decimal tm10 = (Math.Round(total15, 0)); //total15;
string tm10s = string.Format("{0:n0}", (Math.Truncate(tm10 * 100) / 100)); //string.Format("{0:N2}", (tm10 * 100) / 100);
LblTotalMonto10.Text = tm10s;
//*fin*
}
#region
//*ini* lrojas 26/09/2016
//LblConIVA.Text = Convert.ToString(Math.Round(((Convert.ToDecimal(LblTotalMonto.Text) * Convert.ToDecimal(data.Rows[0][6]))/100),0));
//LblConIVA10.Text = Convert.ToString(Math.Round(((Convert.ToDecimal(LblTotalMonto10.Text) * Convert.ToDecimal(data.Rows[0][6]))/100),0));
//decimal iva = Math.Round(((Convert.ToDecimal(LblTotalMonto.Text) * Convert.ToDecimal(data.Rows[0][6])) / 100), 0);
#endregion
//decimal v13Porciento = Convert.ToDecimal(data.Rows[0][6]);
//decimal valorpcte = Math.Round((Convert.ToDecimal(LblTotalMonto.Text) * v13Porciento / 100),2);
//decimal valorMonto10 = Convert.ToDecimal(LblTotalMonto10.Text) * v13Porciento/100;
//string iva = valorpcte.ToString();
//LblConIVA.Text = iva;
//decimal Ltotal = Convert.ToDecimal(LblTotalMonto.Text) - Convert.ToDecimal(iva);
//LblLiquidoTotal.Text = string.Format("{0:N2}", (Ltotal * 100) / 100);
//decimal iva10 = Math.Round((Convert.ToDecimal(LblTotalMonto10.Text) * v13Porciento / 100), 2); //valorMonto10 / 100;
//LblConIVA10.Text = iva10.ToString(); // string.Format("{0:N2}", (iva10 * 100) / 100);
//decimal Ltotal10 = Convert.ToDecimal(LblTotalMonto10.Text) - Convert.ToDecimal(LblConIVA10.Text);
//LblLiquidoTotal10.Text = string.Format("{0:N2}", (Ltotal10 * 100) / 100);
//#region
////LblLiquidoTotal.Text = Convert.ToString(Math.Round((Convert.ToDecimal(LblTotalMonto.Text)-Convert.ToDecimal(LblConIVA.Text)), 0));
////LblLiquidoTotal10.Text = Convert.ToString(Math.Round(Convert.ToDecimal(LblTotalMonto10.Text)-Convert.ToDecimal(LblConIVA10.Text), 0));
////var diferencia = string.Format("{0:N2}",(Convert.ToDecimal(LblTotalMonto.Text) - Convert.ToDecimal(LblConIVA10.Text)).ToString());
//#endregion
////LblTotalPago.Text = Convert.ToString(Math.Round(Convert.ToDecimal(data.Rows[0][7]),0));
//decimal TPago = Convert.ToDecimal(data.Rows[0][7]);
//LblTotalPago.Text = string.Format("{0:N2}", (TPago * 100) / 100);
//decimal iva = Math.Round(((Convert.ToDecimal(LblTotalMonto.Text) * Convert.ToDecimal(data.Rows[0][6])) / 100), 0);
//PARA NO DESCONTAR IVA
decimal iva = 0;
LblConIVA.Text = string.Format("{0:n0}", (Math.Truncate(iva * 100) / 100));
//decimal iva10 = Math.Round(((Convert.ToDecimal(LblTotalMonto10.Text) * Convert.ToDecimal(data.Rows[0][6])) / 100), 0);
//PARA NO DESCONTAR IVA
decimal iva10 = 0;
LblConIVA10.Text = string.Format("{0:n0}", (Math.Truncate(iva10 * 100) / 100));
//OCULTAR MONTOS DE DESCUENTO
LblConIVA.Visible = LblConIVA10.Visible = false;
//LblLiquidoTotal.Text = Convert.ToString(Math.Round((Convert.ToDecimal(LblTotalMonto.Text)-Convert.ToDecimal(LblConIVA.Text)), 0));
//LblLiquidoTotal10.Text = Convert.ToString(Math.Round(Convert.ToDecimal(LblTotalMonto10.Text)-Convert.ToDecimal(LblConIVA10.Text), 0));
decimal Ltotal = Math.Round((Convert.ToDecimal(LblTotalMonto.Text) - Convert.ToDecimal(LblConIVA.Text)), 0);
LblLiquidoTotal.Text = string.Format("{0:n0}", (Math.Truncate(Ltotal * 100) / 100));
decimal Ltotal10 = Math.Round(Convert.ToDecimal(LblTotalMonto10.Text) - Convert.ToDecimal(LblConIVA10.Text), 0);
LblLiquidoTotal10.Text = string.Format("{0:n0}", (Math.Truncate(Ltotal10 * 100) / 100));
lblTotal.Text = (Ltotal + Ltotal10).ToString();
lblRetencion.Text = string.Format("{0:n0}", data.Rows[0][6].ToString());
//LblTotalPago.Text = Convert.ToString(Math.Round(Convert.ToDecimal(data.Rows[0][7]),0));
decimal TPago = Math.Round(Convert.ToDecimal(data.Rows[0][7]), 0);
LblTotalPago.Text = string.Format("{0:n0}", (Math.Truncate(TPago * 100) / 100));
//*fin*
VT_Planilla planilla = new VT_Planilla();
planilla = pl.DB_Seleccionar_PLANILLA(LblIdSolicitud.Text);
LblNumCuenta.Text = planilla.Num_Cheque;
}
public void DB_Modificar_PLANILLA(VT_Planilla p)
{
DA_VT_Planilla dato = new DA_VT_Planilla();
dato.DA_Modificar_PLANILLA(p);
}
public void DB_Registrar_PLANILLA(VT_Planilla p)
{
DA_VT_Planilla InsPlani = new DA_VT_Planilla();
InsPlani.DA_Registrar_PLANILLA(p);
}
protected void Cargar_VALORES()
{
DB_VT_Solicitud memo = new DB_VT_Solicitud();
DB_VT_Planilla pl = new DB_VT_Planilla();
DataTable data = new DataTable();
data = memo.DB_Reporte_SOLICITUD_US(LblIdSolicitud.Text, "DETALLE");
string destinos = string.Empty;
int fin = data.Rows.Count;
int cont = 1;
foreach (DataRow row in data.Rows)
{
string des = row["Zona"].ToString();
string tramo = row["Tramo"].ToString();
if (tramo == "Salida")
{
destinos = cont == fin ? destinos + row["Lugar"].ToString() : destinos + row["Lugar"].ToString() + ", ";
}
cont++;
}
LblDestino.Text = destinos;
int contdias = 0;
decimal totaldias = 0;
decimal totaldias15 = 0;
decimal monto = 0;
decimal total = 0;
decimal total15 = 0;
foreach (GridViewRow dgi in GVDetallePlanilla.Rows)
{
TextBox tx = (TextBox)dgi.Cells[5].Controls[1];
DropDownList ddl = (DropDownList)dgi.Cells[3].Controls[1];
monto = Convert.ToDecimal(GVDetallePlanilla.Rows[dgi.RowIndex].Cells[6].Text);
contdias++;
if (totaldias <= 9)
{
total = total + monto;
Lbl100.Text = ddl.SelectedItem.Text == "Interdepartamental" ? LblPgoDiaUrbano.Text : LblPgoDiaRural.Text;
totaldias = totaldias + Convert.ToDecimal(tx.Text);
}
else
{
total15 = total15 + (((monto * 70) / 100));
totaldias15 = totaldias15 + Convert.ToDecimal(tx.Text);
}
}
Lbl70.Text = Convert.ToString((Convert.ToDecimal(Lbl100.Text) * 70) / 100);
LblDiasCom15.Text = totaldias15.ToString();
LblDiasCom.Text = totaldias.ToString();
LblTotDias.Text = (totaldias + totaldias15).ToString();
LblTotalMonto.Text = Convert.ToString(Math.Round(total, 0));
LblTotalMonto15.Text = Convert.ToString(Math.Round(total15, 0));
total15 = total = 0;
// QUITA EL RC IVA 13%
LblConIVA.Text = Convert.ToString(Math.Round(((total * 13) / 100), 0));
LblConIVA15.Text = Convert.ToString(Math.Round(((total15 * 13) / 100), 0));
LblConIVA.Visible = LblConIVA15.Visible = false; //OCULTA LOS CONTROLES DONDE APARECE EL DESCUENTO DEL RC IVA 13%
LblLiquidoTotal.Text = (Convert.ToInt32(LblTotalMonto.Text) - Convert.ToInt32(LblConIVA.Text)).ToString();
LblLiquidoTotal15.Text = (Convert.ToInt32(LblTotalMonto15.Text) - Convert.ToInt32(LblConIVA15.Text)).ToString();
LblTotalPago.Text = (Convert.ToInt32(LblLiquidoTotal.Text) + Convert.ToInt32(LblLiquidoTotal15.Text)).ToString();
decimal retencion = Convert.ToInt32(LblTotalPago.Text) - Convert.ToInt32(txtMontoFactura.Text);
retencion = retencion < 0 ? 0:retencion;
lblRetencion.Text = Math.Round((retencion * 13) / 100, 0).ToString();
lblTotalPagar.Text = (Convert.ToInt32(LblTotalPago.Text) - Convert.ToInt32(lblRetencion.Text)).ToString();
VT_Planilla plani = new VT_Planilla();
if (LblEstado.Text == "INF-APROBADO")
{
plani = pl.DB_Seleccionar_PLANILLA(LblIdSolicitud.Text);
TxtNumCheque.Text = plani.Num_Cheque;
TxtNumCheque.Visible = true;
}
}
protected void Cargar_VALORES()
{
DB_VT_Solicitud memo = new DB_VT_Solicitud();
DB_VT_Planilla pl = new DB_VT_Planilla();
DataTable data = new DataTable();
#region
//data = pl.DB_Reporte_DETALLE_PLANILLA(LblIdSolicitud.Text, "DESTINOS");
//LblDestino.Text = data.Rows[0][0].ToString();
/**************************************************/
////DataTable data = new DataTable();
#endregion
data = memo.DB_Reporte_SOLICITUD_US(LblIdSolicitud.Text, "DETALLE");
#region
//if (data.Rows[0][3].ToString() == "Departamental")
//{
// data = pl.DB_Reporte_DETALLE_PLANILLA(LblIdSolicitud.Text, "DESTINOS_LUGAR");
//}
//else
//{
// data = pl.DB_Reporte_DETALLE_PLANILLA(LblIdSolicitud.Text, "DESTINOS");
//}
//LblDestino.Text = data.Rows[0][0].ToString();
//ini lrojas 27072017: se modifico para obtener destino y lugar segun la zona
#endregion
string destinos = string.Empty;
int fin = data.Rows.Count;
int cont = 1;
foreach (DataRow row in data.Rows)
{
string des = row["Zona"].ToString();
string tramo = row["Tramo"].ToString();
if (des == "Interdepartamental")
{
if (tramo == "Salida")
{
if (cont == fin)
{
destinos = destinos + row["Destino"].ToString();
}
else
{
destinos = destinos + row["Destino"].ToString() + ", ";
}
}
}
else
{
if (tramo == "Salida")
{
if (cont == fin)
{
destinos = destinos + row["Lugar"].ToString();
}
else
{
destinos = destinos + row["Lugar"].ToString() + ", ";
}
}
}
cont++;
}
LblDestino.Text = destinos;
//fin lrojas 27072017: se modifico para obtener destino y lugar segun la zona
/**************************************************/
int contdias = 0;
decimal totaldias = 0;
decimal totaldias15 = 0;
decimal total = 0;
decimal total15 = 0;
foreach (GridViewRow dgi in GVDetallePlanilla.Rows)
{
TextBox tx = (TextBox)dgi.Cells[5].Controls[1];
decimal monto = Convert.ToDecimal(GVDetallePlanilla.Rows[dgi.RowIndex].Cells[6].Text);
//Convert.ToString(DataBinder.Eval(e.Row.DataItem, "Monto"));
DropDownList ddl = (DropDownList)dgi.Cells[3].Controls[1];
contdias++;
if (totaldias <= 9)
{
if (ddl.SelectedItem.Text == "Interdepartamental")
{
total = total + monto;
//total = total + ((Convert.ToDecimal(tx.Text) * Convert.ToDecimal(LblPgoDiaUrbano.Text)));
Lbl100.Text = LblPgoDiaUrbano.Text;
}
else
{
total = total + monto;
//total = total + ((Convert.ToDecimal(tx.Text) * Convert.ToDecimal(LblPgoDiaRural.Text)));
Lbl100.Text = LblPgoDiaRural.Text;
}
totaldias = totaldias + Convert.ToDecimal(tx.Text);
}
else
{
if (ddl.SelectedItem.Text == "Interdepartamental")
{
//total15 = total15 + ((((Convert.ToDecimal(tx.Text) * Convert.ToDecimal(LblPgoDiaUrbano.Text) * 70) / 100)));
total15 = total15 + (((monto * 70) / 100));
}
else
{
//total15 = total15 + ((((Convert.ToDecimal(tx.Text) * Convert.ToDecimal(LblPgoDiaRural.Text) * 70) / 100)));
total15 = total15 + (((monto * 70) / 100));
}
totaldias15 = totaldias15 + Convert.ToDecimal(tx.Text);
}
}
Lbl70.Text = Convert.ToString((Convert.ToDecimal(Lbl100.Text) * 70) / 100);
//Lbl70.Text = string.Format("{0:N2}",(Convert.ToDecimal(Lbl100.Text)*70)/100);
LblDiasCom15.Text = totaldias15.ToString();
LblDiasCom.Text = totaldias.ToString();
LblTotDias.Text = (totaldias + totaldias15).ToString();
#region Lineas anterior que no permitia el redondeo correcto.
//LblTotalMonto.Text = Convert.ToString(Math.Round(total, 0));
//LblTotalMonto15.Text = Convert.ToString(Math.Round(total15, 0));
//LblConIVA.Text = Convert.ToString(Math.Round(((total * 13) / 100), 0));
//LblConIVA15.Text = Convert.ToString(Math.Round(((total15 * 13) / 100), 0));
//LblLiquidoTotal.Text = Convert.ToString(Math.Round((total - ((total * 13) / 100)), 0));
//LblLiquidoTotal15.Text = Convert.ToString(Math.Round((total15 - ((total15 * 13) / 100)), 0));
//LblTotalPago.Text = Convert.ToString(Math.Round(((total - ((total * 13) / 100)) + (total15 - ((total15 * 13) / 100))), 0));
//==================================================================================================
#endregion
decimal vTotal = Convert.ToDecimal(total);
decimal vTotal15 = Convert.ToDecimal(total15);
decimal vPctajeIva = Convert.ToDecimal((vTotal * 13) / 100);
decimal vPctajeIva15 = Convert.ToDecimal((vTotal15 * 13) / 100);
LblTotalMonto.Text = Convert.ToString(Math.Round(total, 0)); //string.Format("{0:N2}",vTotal);
LblTotalMonto15.Text = Convert.ToString(Math.Round(total15, 0)); //string.Format("{0:N2}", vTotal15);
/*
* LblConIVA.Text = Convert.ToString(Math.Round(((total * 13) / 100), 0)); //string.Format("{0:N2}", vPctajeIva);
* LblConIVA15.Text = string.Format("{0:N2}", vPctajeIva15);
* LblLiquidoTotal.Text = string.Format("{0:N2}", vTotal - Convert.ToDecimal(LblConIVA.Text));
* LblLiquidoTotal15.Text = string.Format("{0:N2}", vTotal15 - Convert.ToDecimal(LblConIVA15.Text));
*/
LblConIVA.Text = Convert.ToString(Math.Round(((total * 13) / 100), 0));
LblConIVA15.Text = Convert.ToString(Math.Round(((total15 * 13) / 100), 0));
LblLiquidoTotal.Text = Convert.ToString(Math.Round((total - ((total * 13) / 100)), 0));
LblLiquidoTotal15.Text = Convert.ToString(Math.Round((total15 - ((total15 * 13) / 100)), 0));
LblTotalPago.Text = Convert.ToString(Math.Round(((total - ((total * 13) / 100)) + (total15 - ((total15 * 13) / 100))), 0)); //string.Format("{0:N2}", (vTotal - Convert.ToDecimal(LblConIVA.Text) ) + (vTotal15 - Convert.ToDecimal(LblConIVA15.Text) ));
VT_Planilla plani = new VT_Planilla();
if (LblEstado.Text == "INF-APROBADO")
{
plani = pl.DB_Seleccionar_PLANILLA(LblIdSolicitud.Text);
TxtNumCheque.Text = plani.Num_Cheque;
TxtNumCheque.Visible = true;
}
}