protected void btEdit_Click(object sender, EventArgs e)
{
if (!this.tb_url.Disabled)
{
try
{
dhuc = new GitHubUrlContext();
using (SqlConnection conn = new SqlConnection(dhuc.Database.Connection.ConnectionString))
{
string query = String.Format(CultureInfo.InvariantCulture, "UPDATE [URLS] SET [Url] = '{0}' WHERE Id = {1};", this.tb_url.Value, this.hdField.Value);
SqlCommand com = new SqlCommand(query, conn);
conn.Open();
if (com.ExecuteNonQuery() == 1)
{
SelectGridView(dhuc);
DisabledTexBox();
message.CssClass = "validation_success";
message.Text = "edit url";
}
}
}
catch (Exception ex)
{
DisabledTexBox();
message.CssClass = "validation_error";
message.Text = ex.Message;
}
}
else
{
DisabledTexBox();
message.CssClass = "validation_error";
message.Text = "tex box disabled";
}
}
protected void Page_Load(object sender, EventArgs e)
{
//int countUrl = Convert.ToInt32(Request.QueryString["cu"], CultureInfo.InvariantCulture);
try
{
using (GitHubUrlContext context = new GitHubUrlContext())
{
using (SqlConnection conn = new SqlConnection(context.Database.Connection.ConnectionString))
{
string query = String.Format(CultureInfo.InvariantCulture, "SELECT [URLS].[Url] FROM [URLS]");
SqlCommand com = new SqlCommand(query, conn);
conn.Open();
using (SqlDataReader reader = com.ExecuteReader())
{
Uri uri;
while (reader.Read())
{
uri = new Uri((string)reader[0]);
string[] res = uri.Segments;
GetInfo(res[1].Substring(0, res[1].Length - 1), res[2]);
}
}
}
}
}
catch (Exception ex)
{
message.Text = ex.Message;
}
}
protected void btAdd_Click(object sender, EventArgs e)
{
if (!this.tb_url.Disabled)
{
Ping p = new Ping();
PingReply pr = p.Send(@"github.com");
status = pr.Status;
reg = new Regex(pattern);
try
{
if (status == IPStatus.Success && tb_url.Value.Length > 0 &&
reg.Match(tb_url.Value, 0).Value == "github.com")
{
try
{
dhuc = new GitHubUrlContext();
using (SqlConnection conn = new SqlConnection(dhuc.Database.Connection.ConnectionString))
{
string query = String.Format(CultureInfo.InvariantCulture, "INSERT INTO [URLS] VALUES ('{0}')", tb_url.Value);
SqlCommand com = new SqlCommand(query, conn);
conn.Open();
if (com.ExecuteNonQuery() == 1)
{
SelectGridView(dhuc);
DisabledTexBox();
message.CssClass = "validation_success";
message.Text = "add url github.com";
}
}
}
catch (Exception ex)
{
DisabledTexBox();
message.CssClass = "validation_error";
message.Text = ex.Message;
}
}
}
catch (Exception expt)
{
DisabledTexBox();
message.CssClass = "validation_error";
message.Text = expt.Message;
}
}
else
{
DisabledTexBox();
message.CssClass = "validation_error";
message.Text = "tex box disabled";
}
}
private void SelectGridView(GitHubUrlContext gitHubUrlContext)
{
try
{
SqlDataSourceUrl.ConnectionString = gitHubUrlContext.Database.Connection.ConnectionString;
SqlDataSourceUrl.SelectCommand = "SELECT * FROM [URLS]";
GridViewUrl.DataSourceID = SqlDataSourceUrl.ID;
GridViewUrl.RowDataBound += GridViewUrl_RowDataBound;
}
catch (Exception ex)
{
message.Text = ex.Message;
}
finally
{
gitHubUrlContext.Dispose();
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
this.regUrl.CssClass = "validation_error";
dhuc = new GitHubUrlContext();
SelectGridView(dhuc);
message.Text = String.Empty;
if (!IsPostBack)
{
this.tb_url.Value = String.Empty;
tb_url.Disabled = true;
}
}
catch (Exception ex)
{
this.message.Text = ex.Message;
}
}