public async Task <int> Insert(Marcador marcador)
{
using SqlConnection con = _connection.DBPLANILLA();
SqlCommand cmd = new SqlCommand("usp_tbl_Marcador_Insert", con)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.Add("@emp_codigo", SqlDbType.VarChar).Value = marcador.emp_codigo;
cmd.Parameters.Add("@fecha_hora_marcador", SqlDbType.DateTime).Value = marcador.fecha_hora_marcador;
cmd.Parameters.Add("@longitud", SqlDbType.Decimal).Value = marcador.longitud;
cmd.Parameters.Add("@latitud", SqlDbType.Decimal).Value = marcador.latitud;
cmd.Parameters.Add("@id", SqlDbType.Int).Value = 0;
cmd.Parameters["@id"].Direction = ParameterDirection.Output;
if (con.State != ConnectionState.Open)
{
con.Open();
}
await cmd.ExecuteNonQueryAsync();
int newId = Convert.ToInt32(cmd.Parameters["@id"].Value);
if (con.State == ConnectionState.Open)
{
con.Close();
}
return(newId);
}
public List <AreaList> List(AreaFilter pFilter)
{
List <AreaList> List = new List <AreaList>();
using (SqlConnection con = _connection.DBPLANILLA())
{
using (SqlCommand cmd = new SqlCommand("usp_tbl_Area_List", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@com_codigo", SqlDbType.VarChar).Value = pFilter.com_codigo;
if (con.State != ConnectionState.Open)
{
con.Open();
}
using (var dr = cmd.ExecuteReader())
{
while (dr.Read())
{
List.Add(new AreaList
{
are_codigo = DataReader.GetStringValue(dr, "ARE_CODIGO"),
are_descripcion = DataReader.GetStringValue(dr, "ARE_DESCRIPCION"),
});
}
}
}
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(List);
}
public List <SucursalList> List(SucursalFilter pFilter)
{
List <SucursalList> List = new List <SucursalList>();
using (SqlConnection con = _connection.DBPLANILLA())
{
using (SqlCommand cmd = new SqlCommand("usp_tbl_Sucursal_List", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@com_codigo", SqlDbType.VarChar).Value = pFilter.com_codigo;
if (con.State != ConnectionState.Open)
{
con.Open();
}
using (var dr = cmd.ExecuteReader())
{
while (dr.Read())
{
List.Add(new SucursalList
{
cod_ofi = DataReader.GetStringValue(dr, "COD_OFI"),
nom_ofi = DataReader.GetStringValue(dr, "NOM_OFI"),
});
}
}
}
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(List);
}
public SucursalConfiguracion Select(int pId)
{
using (SqlConnection con = _connection.DBPLANILLA())
{
using (SqlCommand cmd = new SqlCommand("usp_tbl_SucursalConfiguracion_Select", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Id", SqlDbType.Int).Value = pId;
if (con.State != ConnectionState.Open)
{
con.Open();
}
using (var dr = cmd.ExecuteReader())
{
while (dr.Read())
{
return(new SucursalConfiguracion
{
id = DataReader.GetIntValue(dr, "Id"),
codigo_sucursal = DataReader.GetStringValue(dr, "Codigo_Sucursal"),
descripcion_sucursal = DataReader.GetStringValue(dr, "Descripcion_Sucursal"),
direccion_fisica = DataReader.GetStringValue(dr, "Direccion_Fisica"),
latitud = DataReader.GetDecimalValue(dr, "Latitud"),
longitud = DataReader.GetDecimalValue(dr, "Longitud"),
distancia_metros_permitida = DataReader.GetIntValue(dr, "Distancia_Metros_Permitida"),
});
}
}
}
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(null);
}
public List <EmpresaList> List()
{
List <EmpresaList> List = new List <EmpresaList>();
using (SqlConnection con = _connection.DBPLANILLA())
{
using (SqlCommand cmd = new SqlCommand("usp_tbl_Empresa_List ", con))
{
cmd.CommandType = CommandType.StoredProcedure;
if (con.State != ConnectionState.Open)
{
con.Open();
}
using (var dr = cmd.ExecuteReader())
{
while (dr.Read())
{
List.Add(new EmpresaList
{
com_codigo = DataReader.GetStringValue(dr, "COM_CODIGO"),
com_descripcion = DataReader.GetStringValue(dr, "COM_DESCRIPCION"),
com_nit = DataReader.GetStringValue(dr, "COM_NIT").ToString(),
com_direccion1 = DataReader.GetStringValue(dr, "COM_DIRECCION1").ToString(),
com_ano = DataReader.GetStringValue(dr, "Com_Ano").ToString(),
com_tipo = DataReader.GetStringValue(dr, "Com_Tipo").ToString(),
com_departamento = DataReader.GetStringValue(dr, "Com_Departamento"),
com_representante = DataReader.GetStringValue(dr, "Com_Representante"),
logo = DataReader.GetStringValue(dr, "logo"),
firma = DataReader.GetStringValue(dr, "Firma"),
});
}
}
}
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(List);
}
public Empleado ObtenerEmpleado(string nroDocumento)
{
using (SqlConnection con = _connection.DBPLANILLA())
{
if (con.State != ConnectionState.Open)
{
con.Open();
}
using (SqlCommand cmd = new SqlCommand("usp_List_Empleado", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@emp_nrodocumento", SqlDbType.VarChar, 30).Value = nroDocumento;
using (var dr = cmd.ExecuteReader())
{
while (dr.Read())
{
return(new Empleado
{
emp_codigo = Convert.ToString(dr["Emp_codigo"]),
emp_tipo = Convert.ToString(dr["emp_tipo"]),
emp_nombre = Convert.ToString(dr["emp_nombre"]),
suc_codigo = Convert.ToString(dr["suc_codigo"]),
are_codigo = Convert.ToString(dr["are_codigo"]),
suc_nombre = Convert.ToString(dr["SUC_NOMBRE"]),
are_descripcion = Convert.ToString(dr["ARE_DESCRIPCION"]),
aresub_codigo = Convert.ToString(dr["ARESUB_CODIGO"]),
aresub_descripcion = Convert.ToString(dr["ARESUB_DESCRIPCION"]),
});
}
}
}
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(null);
}
public UserDataType Login(string pAccess, string pPassword)
{
using (SqlConnection con = _connection.DBPLANILLA())
{
if (con.State != ConnectionState.Open)
{
con.Open();
}
using (SqlCommand cmd = new SqlCommand("usp_tbl_User_Login", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@pUserName", SqlDbType.VarChar).Value = pAccess;
cmd.Parameters.Add("@pUserPassword", SqlDbType.VarChar).Value = pPassword;
using (var dr = cmd.ExecuteReader())
{
while (dr.Read())
{
return(new UserDataType
{
cod_user = Convert.ToString(dr["Cod_User"]),
nom_user = Convert.ToString(dr["Nom_User"]),
pass_user = Convert.ToString(dr["Pass_User"]),
est_user = Convert.ToString(dr["Est_User"]),
nivel = Convert.ToString(dr["Nivel"]),
codi_sucursal = Convert.ToString(dr["Codi_Sucursal"]),
});
}
}
}
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return(null);
}
