public bool Insert(ShortenResponse data)
{
try {
string sql = $"insert into dbo.Records(shorturl,longurl) values('{data.ShortUrl}','{data.MainUrl}')";
ConnectionManager.Connection.Open();
SqlCommand cmd = new SqlCommand(sql, ConnectionManager.Connection);
cmd.ExecuteNonQuery();
ConnectionManager.Connection.Close();
return(true);
}
catch (Exception exp) {
return(false);
}
}
public ShortenResponse Retrive(string shortUrlCode)
{
string sql = $"select * from dbo.Records where shorturl='{shortUrlCode}'";
ConnectionManager.Connection.Open();
SqlCommand cmd = new SqlCommand(sql, ConnectionManager.Connection);
SqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
var response = new ShortenResponse
{
ShortUrl = dataReader.GetValue(0).ToString(),
MainUrl = dataReader.GetValue(1).ToString()
};
ConnectionManager.Connection.Close();
return(response);
}
dataReader.Close();
ConnectionManager.Connection.Close();
return(null);
}
public ShortenResponse GetShortUrl(ShortenRequest urlShortenRequest)
{
ShortenResponse response;
if (!CheckUrlIsValidorNot(urlShortenRequest.MainUrl))
{
return(new ShortenResponse
{
StatusCode = 0,
StatusMessage = $"{urlShortenRequest.MainUrl} is not a valid url"
});
}
response = new ShortenResponse
{
StatusMessage = "Success",
StatusCode = 1,
ShortUrl = new RandomStringGenerator().GetRandomString(),
MainUrl = urlShortenRequest.MainUrl
};
new DbOperations().Insert(response);
return(response);
}
