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