protected void Butto2_Click(object sender, EventArgs e) { try { List <int> selectedRows = new List <int>(); foreach (GridViewRow gvr in GridView1.Rows) { if ((gvr.FindControl("CheckBox2") as CheckBox).Checked == true) { selectedRows.Add(gvr.Cells[0].Text.ToInt()); } } if (selectedRows.Count > 0) { VPNsRepository vpnir = new VPNsRepository(); vpnir.DeleteVPN(selectedRows); LoadvpnData(); PersonTools.ShowMessage(lblmessage, Resources.DashboardText.msgDeleteSuccessfull, Color.Green); } } catch { PersonTools.ShowMessage(lblmessage, Resources.DashboardText.errDeleteFailed, Color.Red); } }
protected void Button1_Click(object sender, EventArgs e) { VPNsRepository vpn = new VPNsRepository(); if (vpn.FindByUsername(txtusername.Text) != null) { PersonTools.ShowMessage(lblmessage, Resources.DashboardText.errDuplicateUsername, Color.Red); return; } bool successfullCreateAccount = true; try { VPN newvpn = new VPN(); newvpn.DepartmentID = ddldepartment.SelectedValue.ToInt(); newvpn.UserTypeID = DropDownList1.SelectedValue.ToInt(); newvpn.UserID = ddluserid.SelectedValue.ToInt(); newvpn.Username = txtusername.Text; newvpn.Password = txtpass.Text; newvpn.VPNDescription = txtdes.Text; VPNsRepository vpnir = new VPNsRepository(); vpnir.Savevpn(newvpn); } catch (System.Exception err) { successfullCreateAccount = false; PersonTools.ShowMessage(lblmessage, Resources.DashboardText.errAddFailed, Color.Red); } if (successfullCreateAccount) { // ClearForm(); PersonTools.ShowMessage(lblmessage, Resources.DashboardText.msgAddSuccessfull, Color.Green); } }
protected void Button3_Click(object sender, EventArgs e) { VPNsRepository vstdir = new VPNsRepository(); if (vstdir.Getexeldata() != null) { DumpExcel(vstdir.Getexeldata(), "VPNs"); } }
public void LoadvpnData() { VPNsRepository vpnir = new VPNsRepository(); Session["VPNData"] = vpnir.GetAllvpns(); GridView1.DataSource = Session["VPNData"]; GridView1.DataBind(); lblrecordcount.Text = string.Format("{0} : {1}", vpnir.VPNCount().ToString().ToFarsiNumber(), Resources.DashboardText.RecordCount); lblSelectedDataCount.Text = string.Format("{0} : {1}", (Session["VPNData"] as DataTable).Rows.Count.ToString().ToFarsiNumber(), Resources.DashboardText.SelectRecordCount); }
protected void Button1_Click1(object sender, EventArgs e) { if (lblid.Text.Length > 0) { try { VPNsRepository vpnir = new VPNsRepository(); if ((txtusername.Text.Length > 0) && (txtusername.Text != lblusername.Text)) { if (vpnir.FindByUsername(txtusername.Text) != null) { PersonTools.ShowMessage(lblmessage, Resources.DashboardText.errRepeatemailTitle, Color.Red); return; } } VPN vpn = vpnir.FindvpnByid(lblid.Text.ToInt()); vpn.UserTypeID = Session["UserType"].ToString().ToInt(); vpn.UserID = Session["UserID"].ToString().ToInt(); vpn.DepartmentID = Session["DepartmentID"].ToString().ToInt(); if ((txtusername.Text.Length > 0) && (txtusername.Text != lblusername.Text)) { vpn.Username = txtusername.Text; } if ((txtpass.Text != null)) { vpn.Password = txtpass.Text; } vpnir.Savevpn(vpn); PersonTools.ShowMessage(lblmessage, Resources.DashboardText.msgUpdateSuccessfull, Color.Green); } catch { PersonTools.ShowMessage(lblmessage, Resources.DashboardText.errUpdateFailed, Color.Red); } } }
protected void ImageButton2_Click(object sender, ImageClickEventArgs e) { lblmessage.Text = ""; if (txtsearch.Text.Length > 0) { if (DropDownList1.SelectedValue == "0") { try { VPNsRepository vpnir = new VPNsRepository(); Session["ecid"] = vpnir.Searchusername(txtsearch.Text); GridView1.DataSource = Session["ecid"]; GridView1.DataBind(); lblrecordcount.Text = string.Format("{0} : {1}", vpnir.VPNCount().ToString(), Resources.DashboardText.RecordCount); lblSelectedDataCount.Text = string.Format("{0} : {1}", (Session["ecid"] as DataTable).Rows.Count.ToString(), Resources.DashboardText.SelectRecordCount); } catch { PersonTools.ShowMessage(lblmessage, Resources.DashboardText.errSearch, Color.Red); lblrecordcount.Text = string.Format("{0} : {1}", "0", Resources.DashboardText.RecordCount); lblSelectedDataCount.Text = string.Format("{0} : {1}", "0", Resources.DashboardText.SelectRecordCount); } } if (DropDownList1.SelectedValue == "1") { try { VPNsRepository vpnir = new VPNsRepository(); Session["ecutid"] = vpnir.SearchUserTypeid(txtsearch.Text.ToInt()); GridView1.DataSource = Session["ecutid"]; GridView1.DataBind(); lblrecordcount.Text = string.Format("{0} : {1}", vpnir.VPNCount().ToString(), Resources.DashboardText.RecordCount); lblSelectedDataCount.Text = string.Format("{0} : {1}", (Session["ecutid"] as DataTable).Rows.Count.ToString(), Resources.DashboardText.SelectRecordCount); } catch { PersonTools.ShowMessage(lblmessage, Resources.DashboardText.errSearch, Color.Red); lblrecordcount.Text = string.Format("{0} : {1}", "0", Resources.DashboardText.RecordCount); lblSelectedDataCount.Text = string.Format("{0} : {1}", "0", Resources.DashboardText.SelectRecordCount); } } if (DropDownList1.SelectedValue == "2") { try { VPNsRepository vpnir = new VPNsRepository(); Session["ecuid"] = vpnir.SearchUserid(txtsearch.Text.ToInt()); GridView1.DataSource = Session["ecuid"]; GridView1.DataBind(); lblrecordcount.Text = string.Format("{0} : {1}", vpnir.VPNCount().ToString(), Resources.DashboardText.RecordCount); lblSelectedDataCount.Text = string.Format("{0} : {1}", (Session["ecuid"] as DataTable).Rows.Count.ToString(), Resources.DashboardText.SelectRecordCount); } catch { PersonTools.ShowMessage(lblmessage, Resources.DashboardText.errSearch, Color.Red); lblrecordcount.Text = string.Format("{0} : {1}", "0", Resources.DashboardText.RecordCount); lblSelectedDataCount.Text = string.Format("{0} : {1}", "0", Resources.DashboardText.SelectRecordCount); } } } else { LoadvpnData(); } }
public void LoadData(string id) { try { VPNsRepository vpnir = new VPNsRepository(); // EmailContactsRepository ecrir = new EmailContactsRepository(); VVPN vpn = vpnir.FindByid(id.ToInt()); lblid.Text = id; Session["UserID"] = vpn.UserID.ToString(); Session["UserType"] = vpn.UserTypeID.ToString(); Session["DepartmentID"] = vpn.DepartmentID; lblusername.Text = vpn.Username; Lbldep.Text = vpn.DepartmentTitle; VStudentsRepository vstdir = new VStudentsRepository(); VStudent std = vstdir.FindByid(Session["UserID"].ToString().ToInt()); if (std != null) { Label7.Text = std.FirstName.ToString() + " " + std.LastName.ToString(); } else { Redirector.Goto(Redirector.PageName.errorpage); } DepartmentsRepository etr = new DepartmentsRepository(); DataTable dt = etr.GetAllDepartment(); ddldepartment.Items.Clear(); foreach (DataRow dr in dt.Rows) { ddldepartment.Items.Add(new ListItem(dr["DepartmentTitle"].ToString(), dr["DepartmentID"].ToString())); } switch ((Session["UserType"].ToString())) { case "1": { DropDownList1.SelectedValue = "1"; VStudentsRepository vstd = new VStudentsRepository(); DataTable dtstd = vstd.GetAllstd(); ddluserid.Items.Clear(); foreach (DataRow dr in dtstd.Rows) { ddluserid.Items.Add(new ListItem(dr["FirstName"].ToString() + " " + dr["LastName"].ToString(), dr["StudentID"].ToString())); } } break; case "2": { DropDownList1.SelectedValue = "2"; VLecturersRepository vlrir = new VLecturersRepository(); DataTable dtlec = vlrir.GetAllLec(); ddluserid.Items.Clear(); foreach (DataRow dr in dtlec.Rows) { ddluserid.Items.Add(new ListItem(dr["FirstName"].ToString() + " " + dr["LastName"].ToString(), dr["LecturerID"].ToString())); } } break; case "3": { DropDownList1.SelectedValue = "3"; VEmployeesRepository verir = new VEmployeesRepository(); DataTable dtemp = verir.GetAllEmp(); ddluserid.Items.Clear(); foreach (DataRow dr in dtemp.Rows) { ddluserid.Items.Add(new ListItem(dr["FirstName"].ToString() + " " + dr["LastName"].ToString(), dr["EmployeeID"].ToString())); } } break; } } catch { Redirector.Goto(Redirector.PageName.errorpage); } }