protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { TechnetworkEntities db = new TechnetworkEntities(); var empId = int.Parse(Session["EmployeeId"].ToString()); if (!string.IsNullOrEmpty(empId.ToString())) { var employee = db.Employees.Where(x => x.Id == empId).FirstOrDefault(); Empnm.Text = employee.Name; EmpEmail.Text = employee.EmailId; EmpPass.Text = employee.Password; EmpPhone.Text = employee.Phone_number; EmpAddress.Text = employee.Address; } } catch (Exception ex) { Label1.Text = $"Session expired. Please signIn and retry."; Label1.ForeColor = System.Drawing.Color.Red; Label1.Visible = true; } } }
protected void Btn_submit_Click(object sender, EventArgs e) { try { TechnetworkEntities db = new TechnetworkEntities(); Service service = new Service(); service.Details = TextBox5.Text; service.Service_cost = decimal.Parse(TextBox4.Text); service.Service_name = TextBox1.Text; service.Service_provider_name = TextBox2.Text; service.Servicing_last_date = DateTime.Parse(TextBox3.Text); db.Services.Add(service); db.SaveChanges(); TextBox1.Text = ""; TextBox2.Text = ""; TextBox3.Text = ""; TextBox4.Text = ""; TextBox5.Text = ""; Label1.Text = "Service successfully posted"; Label1.Visible = true; }catch (Exception ex) { Label1.Text = "Something went wrong. Service is not posted. "; Label1.Visible = true; } }
protected void Sbmt_btn_Click(object sender, EventArgs e) { try { TechnetworkEntities db = new TechnetworkEntities(); Developer developer = new Developer(); developer.Developer_name = Devnm.Text; developer.Developer_code = DevCode.Text; developer.Email_id = DevEmail.Text; developer.Phone_number = DevPhone.Text; developer.Designation = DevDesg.Text; developer.Details = DevDet.Text; developer.Address = DevAdd.Text; db.Developers.Add(developer); db.SaveChanges(); Label1.Text = $"{Devnm.Text} successfully added"; Devnm.Text = ""; DevEmail.Text = ""; DevPhone.Text = ""; DevDet.Text = ""; DevDesg.Text = ""; DevAdd.Text = ""; DevCode.Text = ""; Label1.Visible = true; } catch (Exception ex) { Label1.Text = $"Something went wrong. Developer is not added. Error: {ex.Message} "; Label1.ForeColor = System.Drawing.Color.Red; Label1.Visible = true; } }
protected void Sbmt_btn_Click(object sender, EventArgs e) { try { TechnetworkEntities db = new TechnetworkEntities(); Product product = new Product(); product.Details = productDet.Text; product.Price = decimal.Parse(ProductPrc.Text); product.Product_name = productnm.Text; product.Storage_require = ProdctStrg.Text; db.Products.Add(product); db.SaveChanges(); Label1.Text = $"{productnm.Text} successfully posted"; productDet.Text = ""; ProductPrc.Text = ""; productnm.Text = ""; ProdctStrg.Text = ""; Label1.Visible = true; } catch (Exception ex) { Label1.Text = $"Something went wrong. Service is not posted. Error: {ex.Message} "; Label1.Visible = true; } }
protected void Sbmt_btn_Click(object sender, EventArgs e) { TechnetworkEntities db = new TechnetworkEntities(); if (db.Admins.Where(x => x.EmailId == EmailId.Text && x.Password == Password.Text).Any()) { Session["Authorizer"] = "Admin"; Session["AdminName"] = db.Admins.Where(x => x.EmailId == EmailId.Text && x.Password == Password.Text) .Select(z => z.Name).FirstOrDefault(); Response.Redirect("Admin.aspx"); } else if (db.Employees.Where(x => x.EmailId == EmailId.Text && x.Password == Password.Text).Any()) { Session["Authorizer"] = "Employee"; Session["EmployeeName"] = db.Employees.Where(x => x.EmailId == EmailId.Text && x.Password == Password.Text) .Select(z => z.Name).FirstOrDefault(); Session["EmployeeId"] = db.Employees.Where(x => x.EmailId == EmailId.Text && x.Password == Password.Text) .Select(z => z.Id).FirstOrDefault(); Response.Redirect("Employee.aspx"); } else { Session["Authorizer"] = ""; } }
protected void Sbmt_btn_Click(object sender, EventArgs e) { try { TechnetworkEntities db = new TechnetworkEntities(); var empId = int.Parse(Session["EmployeeId"].ToString()); if (!string.IsNullOrEmpty(empId.ToString())) { Model.Employee employee = db.Employees.Where(x => x.Id == empId).FirstOrDefault(); employee.Name = Empnm.Text; if (!string.IsNullOrEmpty(EmpPass.Text)) { employee.Password = EmpPass.Text; } employee.EmailId = EmpEmail.Text; employee.Phone_number = EmpPhone.Text; employee.Address = EmpAddress.Text; employee.Designation = EmpDesg.Text; employee.Details = EmpDet.Text; db.SaveChanges(); Label1.Text = $"Congrats {Empnm.Text}, your profile is successfully updated"; Label1.Visible = true; } else { Label1.Text = $"Session expired. Please signIn and retry."; Label1.Visible = true; } } catch (Exception ex) { Label1.Text = $"Something went wrong. Service is not posted. Error: {ex.Message} "; Label1.ForeColor = System.Drawing.Color.Red; Label1.Visible = true; } }
protected void Sbmt_btn_Click(object sender, EventArgs e) { try { TechnetworkEntities db = new TechnetworkEntities(); Model.Employee employee = new Model.Employee(); employee.Name = Empnm.Text; if (!string.IsNullOrEmpty(EmpPass.Text)) { employee.Password = EmpPass.Text; } else { Random rd = new Random(); employee.Password = $"Pass@{rd.Next(1111, 9999).ToString()}"; } employee.EmailId = EmpEmail.Text; employee.Phone_number = EmpPhone.Text; employee.Designation = EmpDesg.Text; employee.Details = EmpDet.Text; db.Employees.Add(employee); db.SaveChanges(); Label1.Text = $"{Empnm.Text} successfully added"; Empnm.Text = ""; EmpEmail.Text = ""; EmpPhone.Text = ""; EmpPass.Text = ""; EmpDet.Text = ""; EmpDesg.Text = ""; Label1.Visible = true; } catch (Exception ex) { Label1.Text = $"Something went wrong. Employee is not added. Error: {ex.Message} "; Label1.ForeColor = System.Drawing.Color.Red; Label1.Visible = true; } }
public List <Service> ListOfServices() { TechnetworkEntities db = new TechnetworkEntities(); return(db.Services.Distinct().ToList()); }
public List <Developer> ListOfDevelopers() { TechnetworkEntities db = new TechnetworkEntities(); return(db.Developers.Distinct().ToList()); }
public List <Model.Employee> ListOfEmployees() { TechnetworkEntities db = new TechnetworkEntities(); return(db.Employees.Distinct().ToList()); }
public List <Product> prolist() { TechnetworkEntities db = new TechnetworkEntities(); return(db.Products.Distinct().ToList()); }