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); }