public BaseResponse UpdateProvider(EntityProvider provider)
{
var returnEntity = new BaseResponse();
var entityUser = new EntityLoginResponse();
var resu = new EntityProvider();
try
{
using (var db = GetSqlConnection())
{
const string sql = "update_provider";
var p = new DynamicParameters();
p.Add(name: "@Ruc", value: provider.ruc, dbType: DbType.String, direction: ParameterDirection.Input);
p.Add(name: "@NomEmp", value: provider.name, dbType: DbType.String, direction: ParameterDirection.Input);
p.Add(name: "@Distrito", value: provider.district, dbType: DbType.String, direction: ParameterDirection.Input);
p.Add(name: "@Direccion", value: provider.address, dbType: DbType.String, direction: ParameterDirection.Input);
p.Add(name: "@NomRepresent", value: provider.firtsname_representative, dbType: DbType.String, direction: ParameterDirection.Input);
p.Add(name: "@ApeRepresent", value: provider.lastname_representative, dbType: DbType.String, direction: ParameterDirection.Input);
p.Add(name: "@idprovider", dbType: DbType.Int32, direction: ParameterDirection.Output);
resu = db.Query <EntityProvider>(sql, param: p, commandType: CommandType.StoredProcedure).FirstOrDefault();
int idprovider = p.Get <int>("@idprovider");
if (idprovider > 0)
{
returnEntity.isSuccess = true;
returnEntity.errorCode = "0000";
returnEntity.errorMessage = string.Empty;
returnEntity.data = idprovider;
}
else
{
returnEntity.isSuccess = false;
returnEntity.errorCode = "0000";
returnEntity.errorMessage = string.Empty;
returnEntity.data = idprovider;
}
}
}
catch (Exception ex)
{
returnEntity.isSuccess = false;
returnEntity.errorCode = "0001";
returnEntity.errorMessage = ex.Message;
returnEntity.data = null;
}
return(returnEntity);
}
public BaseResponse Login(EntityLogin login)
{
var returnEntity = new BaseResponse();
var entityUser = new EntityLoginResponse();
try
{
using (var db = GetSqlConnection())
{
const string sql = @"usp_user_login";
var p = new DynamicParameters();
p.Add(name: "@LOGINUSUARIO", value: login.LoginUsuario, dbType: DbType.String, direction: ParameterDirection.Input);
p.Add(name: "@PASSWORDUSUARIO", value: login.PasswordUsuario, dbType: DbType.String, direction: ParameterDirection.Input);
entityUser = db.Query <EntityLoginResponse>(sql,
param: p, commandType: CommandType.StoredProcedure).FirstOrDefault();
if (entityUser != null)
{
returnEntity.isSuccess = true;
returnEntity.errorCode = "0000";
returnEntity.errorMessage = string.Empty;
returnEntity.data = entityUser;
}
else
{
returnEntity.isSuccess = false;
returnEntity.errorCode = "0000";
returnEntity.errorMessage = string.Empty;
returnEntity.data = null;
}
}
}
catch (Exception ex)
{
returnEntity.isSuccess = false;
returnEntity.errorCode = "0001";
returnEntity.errorMessage = ex.Message;
returnEntity.data = null;
}
return(returnEntity);
}
