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