public void btnShorten2_Click(object sender, EventArgs e)
{
if (txtLongUrl.Text != "" && IsValidUri(txtLongUrl.Text) != false)
{
string baseUrl = Request.Url.Scheme + "://" + Request.Url.Authority + Request.ApplicationPath.TrimEnd('/') + "/";
string shortenKey = RandomString(6);
string finalURL = baseUrl + shortenKey;
LearnEFEntities db = new LearnEFEntities();
tbl_shortenedUrl shortnDetails = new tbl_shortenedUrl();
shortnDetails.longUrl = txtLongUrl.Text;
shortnDetails.shortUrl = finalURL;
shortnDetails.urlKey = shortenKey;
shortnDetails.addedOn = DateTime.Now;
db.tbl_shortenedUrl.Add(shortnDetails);
db.SaveChanges();
//Console.Write(finalURL);
lblShortenedUrl.InnerText = finalURL;
btnCopy.Visible = true;
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Please specify a valid url!')", true);
}
}
protected void ddlEmployee_SelectedIndexChanged(object sender, EventArgs e)
{
Int32 empId = Convert.ToInt32(ddlEmployee.SelectedValue);
if (empId == 0)
{
ClearEmpForm();
return;
}
btnSave.CommandArgument = empId.ToString();
btnSave.Text = "UPDATE";
btnDelete.CommandArgument = empId.ToString();
LearnEFEntities db = new LearnEFEntities();
var empQuery = from emp in db.Employees
where emp.EmpId == empId
select emp;
Employee objEmp = empQuery.Single();
txtHREmpId.Text = objEmp.HREmpId;
txtFirstName.Text = objEmp.FirstName;
txtLastName.Text = objEmp.LastName;
txtAddress.Text = objEmp.Address;
txtCity.Text = objEmp.City;
}
public static bool IsExists(string chkMatch)
{
LearnEFEntities db = new LearnEFEntities();
if (db.tbl_shortenedUrl.Any(o => o.urlKey == chkMatch.ToString()))
{
return(true);
}
else
{
return(false);
}
}
private string getLongUrlFromKey(string key)
{
LearnEFEntities db = new LearnEFEntities();
var longUrl = db.tbl_shortenedUrl.Where(b => b.urlKey == key)
.Select(b => b.longUrl).FirstOrDefault();
if (longUrl != null)
{
return(longUrl.ToString());
}
else
{
return(null);
}
}
private void PopulateEmpList()
{
LearnEFEntities db = new LearnEFEntities();
//string ab = txtSrchFirstName.Text;
//string ac = txtSrchCity.Text;
//List<Employee> empList = db.SearchEmployee(txtSrchFirstName.Text, txtSrchCity.Text).ToList();
List <Employee> empList = new List <Employee>();
ddlEmployee.DataSource = empList;
ddlEmployee.DataValueField = "EmpId";
ddlEmployee.DataTextField = "FirstName";
ddlEmployee.DataBind();
ddlEmployee.Items.Insert(0, new ListItem("--Add New--", "0"));
//bind grid
grdEmployees.DataSource = empList;
grdEmployees.DataBind();
}
protected void btnDelete_Click(object sender, EventArgs e)
{
Int32 empId = Convert.ToInt32(btnSave.CommandArgument);
if (empId != 0)
{
LearnEFEntities db = new LearnEFEntities();
Employee objEmp = new Employee()
{
EmpId = empId
};
db.Employees.Attach(objEmp);
db.Employees.Remove(objEmp);
db.SaveChanges();
//reset the form and grid
ClearEmpForm();
PopulateEmpList();
}
}
public void btnShorten3_Click(object sender, EventArgs e)
{
string baseUrl = Request.Url.Scheme + "://" + Request.Url.Authority + Request.ApplicationPath.TrimEnd('/') + "/";
string customKey = txtShortCustom.Text;
if (txtLongUrl.Text != "")
{
if (customKey != "" && customKey.Length <= 6 && System.Text.RegularExpressions.Regex.IsMatch(customKey, @"^[a-zA-Z0-9]+$"))
{
if (!IsExists(customKey))
{
string finalURL = baseUrl + customKey;
LearnEFEntities db = new LearnEFEntities();
tbl_shortenedUrl shortnDetails = new tbl_shortenedUrl();
shortnDetails.longUrl = txtLongUrl.Text;
shortnDetails.shortUrl = finalURL;
shortnDetails.urlKey = customKey;
shortnDetails.addedOn = DateTime.Now;
db.tbl_shortenedUrl.Add(shortnDetails);
db.SaveChanges();
//Console.Write(finalURL);
lblShortenedUrl.InnerText = finalURL;
//btnCopy2.Visible = true;
btnCopy.Visible = true;
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Name has already been taken!')", true);
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Please specify valid custom url!')", true);
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Please specify a valid url to shorten!')", true);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
Int32 empId = Convert.ToInt32(btnSave.CommandArgument);
if (empId == 0)
{
//INSERT
LearnEFEntities db = new LearnEFEntities();
Employee objEmp = new Employee();
objEmp.HREmpId = txtHREmpId.Text;
objEmp.FirstName = txtFirstName.Text;
objEmp.LastName = txtLastName.Text;
objEmp.Address = txtAddress.Text;
objEmp.City = txtCity.Text;
db.Employees.Add(objEmp);
db.SaveChanges();
}
else
{
//UPDATE
LearnEFEntities db = new LearnEFEntities();
var empQuery = from emp in db.Employees
where emp.EmpId == empId
select emp;
Employee objEmp = empQuery.Single();
objEmp.HREmpId = txtHREmpId.Text;
objEmp.FirstName = txtFirstName.Text;
objEmp.LastName = txtLastName.Text;
objEmp.Address = txtAddress.Text;
objEmp.City = txtCity.Text;
db.SaveChanges();
}
ClearEmpForm();
PopulateEmpList();
}
