Gecko [ www.vsec.in ]

Name	Size	Permission
Bin	[ DIR ]	drwxrwxrwx
Images	[ DIR ]	drwxrwxrwx
css	[ DIR ]	drwxrwxrwx
js	[ DIR ]	drwxrwxrwx
scss	[ DIR ]	drwxrwxrwx
vendor	[ DIR ]	drwxrwxrwx
.mad-root	0 B	-rw-rw-rw-
AddMedia.aspx	349 B	-rw-rw-rw-
AddMedia.aspx.cs	286 B	-rw-rw-rw-
Addblog.aspx	344 B	-rw-rw-rw-
Addblog.aspx.cs	285 B	-rw-rw-rw-
Addvideo.aspx	349 B	-rw-rw-rw-
Addvideo.aspx.cs	286 B	-rw-rw-rw-
Admin.master	14.4 KB	-rw-rw-rw-
Admin.master.cs	291 B	-rw-rw-rw-
Admin_Login - Copy.aspx	4.84 KB	-rw-rw-rw-
Admin_Login.aspx	4.84 KB	-rw-rw-rw-
Admin_Login.aspx.cs	1.5 KB	-rw-rw-rw-
DashboadMain.aspx	3.13 KB	-rw-rw-rw-
DashboadMain.aspx.cs	290 B	-rw-rw-rw-
Dashboard.aspx	16.1 KB	-rw-rw-rw-
Dashboard.aspx.cs	7.9 KB	-rw-rw-rw-
Events.aspx	8.94 KB	-rw-rw-rw-
Events.aspx.cs	4.34 KB	-rw-rw-rw-
Examination.aspx	7.83 KB	-rw-rw-rw-
Examination.aspx.cs	5.45 KB	-rw-rw-rw-
Gallery.aspx	6.5 KB	-rw-rw-rw-
Gallery.aspx.cs	4.5 KB	-rw-rw-rw-
Interhousecompetition.aspx	10 KB	-rw-rw-rw-
Interhousecompetition.aspx.cs	5.15 KB	-rw-rw-rw-
Life_Insurance.png	111.09 KB	-rw-rw-rw-
Newupdate.aspx	6.26 KB	-rw-rw-rw-
Newupdate.aspx.cs	4.2 KB	-rw-rw-rw-
Photo-gallery.aspx	5.36 KB	-rw-rw-rw-
Photo-gallery.aspx.cs	2.35 KB	-rw-rw-rw-
Show-contact-data.aspx	2.85 KB	-rw-rw-rw-
Show-contact-data.aspx.cs	871 B	-rw-rw-rw-
Showallgallery.aspx	5.15 KB	-rw-rw-rw-
Showallgallery.aspx.cs	5.31 KB	-rw-rw-rw-
SpecialMoments.aspx	7.15 KB	-rw-rw-rw-
SpecialMoments.aspx.cs	5.3 KB	-rw-rw-rw-
adminer.php	465.43 KB	-rw-rw-rw-
alumni_data.aspx	7.41 KB	-rw-rw-rw-
alumni_data.aspx.cs	4.62 KB	-rw-rw-rw-
career.aspx	39.47 KB	-rw-rw-rw-
career.aspx.cs	6.3 KB	-rw-rw-rw-
career_form_data.aspx	6.4 KB	-rw-rw-rw-
career_form_data.aspx.cs	868 B	-rw-rw-rw-
contact.aspx	347 B	-rw-rw-rw-
contact.aspx.cs	285 B	-rw-rw-rw-
download.aspx	15.01 KB	-rw-rw-rw-
download.aspx.cs	5.38 KB	-rw-rw-rw-
edit-gallery.aspx	4.51 KB	-rw-rw-rw-
edit-gallery.aspx.cs	1.32 KB	-rw-rw-rw-
profilemain.aspx	7.6 KB	-rw-rw-rw-
profilemain.aspx.cs	5.58 KB	-rw-rw-rw-
pwnkit	10.99 KB	-rw-rw-rw-

Code Editor : Dashboard.aspx.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web.Configuration;
using System.Drawing;
using System.Xml.Linq;
//using System.Net.Mime.MediaTypeNames;

public partial class Admin_Dashboard : System.Web.UI.Page
{
    dbconnection con = new dbconnection();
    SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["myconnection"].ConnectionString);
   
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Bind();
        }
    }

private void Bind()
    {
        SqlCommand cmd = new SqlCommand("select * from addgallery", conn);
        SqlDataAdapter da = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();
        da.Fill(ds, "addgallery");

gv1.DataSource = ds;
        gv1.DataBind();
    }
    protected void btnSaveFile_Click(object sender, EventArgs e)
    {
        using (conn)
        {
            string events = Events.Text;
            string date = TxtDob.Text;

conn.Open();
            SqlTransaction sqlTran = conn.BeginTransaction();
            SqlCommand cmd = conn.CreateCommand();
            cmd.Transaction = sqlTran;

string Path1 = FuImage.HasFiles ? FuImage.FileName : " ";
            string Path2 = FuImage1.HasFiles ? FuImage1.FileName : " ";
            string Path3 = FuImage2.HasFiles ? FuImage2.FileName : " ";
            string Path4 = FuImage3.HasFiles ? FuImage3.FileName : " ";
            string Path5 = FuImage4.HasFiles ? FuImage4.FileName : " ";
            string Path6 = FuImage5.HasFiles ? FuImage5.FileName : " ";
            string Path7 = FuImage6.HasFiles ? FuImage6.FileName : " ";

cmd.CommandText = @"Insert Into addgallery(events, eventsdate, photo, photo1, photo2, photo3, photo4, photo5, photo6) 
                            Values (@events, @date, @p1, @p2, @p3, @p4, @p5, @p6, @p7)";

cmd.Parameters.AddWithValue("@events", events);
            cmd.Parameters.AddWithValue("@date", date);
            cmd.Parameters.AddWithValue("@p1", Path1);
            cmd.Parameters.AddWithValue("@p2", Path2);
            cmd.Parameters.AddWithValue("@p3", Path3);
            cmd.Parameters.AddWithValue("@p4", Path4);
            cmd.Parameters.AddWithValue("@p5", Path5);
            cmd.Parameters.AddWithValue("@p6", Path6);
            cmd.Parameters.AddWithValue("@p7", Path7);

cmd.ExecuteNonQuery();
            sqlTran.Commit();

// Save files if present
            if (FuImage.HasFiles)
                FuImage.SaveAs(Server.MapPath("~/Admin/images/Gallery/") + Path1);

if (FuImage1.HasFiles)
                FuImage1.SaveAs(Server.MapPath("~/Admin/images/Gallery/") + Path2);

if (FuImage2.HasFiles)
                FuImage2.SaveAs(Server.MapPath("~/Admin/images/Gallery/") + Path3);

if (FuImage3.HasFiles)
                FuImage3.SaveAs(Server.MapPath("~/Admin/images/Gallery/") + Path4);

if (FuImage4.HasFiles)
                FuImage4.SaveAs(Server.MapPath("~/Admin/images/Gallery/") + Path5);

if (FuImage5.HasFiles)
                FuImage5.SaveAs(Server.MapPath("~/Admin/images/Gallery/") + Path6);

if (FuImage6.HasFiles)
                FuImage6.SaveAs(Server.MapPath("~/Admin/images/Gallery/") + Path7);

// Show alert once and redirect
            string script = "alert('Details added successfully'); window.location='Dashboard.aspx';";
            ClientScript.RegisterStartupScript(this.GetType(), "SuccessMessage", script, true);
        }
    }

protected void gv1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        gv1.EditIndex = e.NewEditIndex;
        Bind();
    }
    protected void gv1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {

int index = e.RowIndex;

GridViewRow row = (GridViewRow)gv1.Rows[index];

Label eid = (Label)row.FindControl("lbleid");

TextBox name = (TextBox)row.FindControl("txtCom");
        TextBox eventdate = (TextBox)row.FindControl("inputDate");
        FileUpload fu = (FileUpload)row.FindControl("fu1");
        FileUpload fu1 = (FileUpload)row.FindControl("fu2");
        FileUpload fu2 = (FileUpload)row.FindControl("fu3");
        FileUpload fu3 = (FileUpload)row.FindControl("fu4");
        FileUpload fu4 = (FileUpload)row.FindControl("fu5");
        FileUpload fu5 = (FileUpload)row.FindControl("fu6");
        FileUpload fu6 = (FileUpload)row.FindControl("fu7");

if (fu.HasFile)
        {

string file = System.IO.Path.Combine(Server.MapPath("~/Admin/images/Gallery/"), fu.FileName);
            fu.SaveAs(file);

if (fu1.HasFile)
            {

string file1 = System.IO.Path.Combine(Server.MapPath("~/Admin/images/Gallery/"), fu1.FileName);
                fu1.SaveAs(file1);
            }

if (fu2.HasFile)
            {

string file2 = System.IO.Path.Combine(Server.MapPath("~/Admin/images/Gallery/"), fu2.FileName);
                fu.SaveAs(file2);
            }

if (fu3.HasFile)
            {

string file3 = System.IO.Path.Combine(Server.MapPath("~/Admin/images/Gallery/"), fu3.FileName);
                fu.SaveAs(file3);
            }
            if (fu4.HasFile)
            {

string file4 = System.IO.Path.Combine(Server.MapPath("~/Admin/images/Gallery/"), fu4.FileName);
                fu4.SaveAs(file4);
            }

if (fu5.HasFile)
            {

string file5 = System.IO.Path.Combine(Server.MapPath("~/Admin/images/Gallery/"), fu5.FileName);
                fu5.SaveAs(file5);
            }

if (fu6.HasFile)
            {

string file6 = System.IO.Path.Combine(Server.MapPath("~/Admin/images/Gallery/"), fu6.FileName);
                fu6.SaveAs(file6);
            }

SqlCommand cmd = new SqlCommand("update addgallery set photo = '" + fu.FileName + "',photo1='" + fu1.FileName + "',photo2='" + fu2.FileName + "',photo3='" + fu3.FileName + "',photo4='" + fu4.FileName + "',photo5='" + fu5.FileName + "',photo6='" + fu6.FileName + "' where id=" + Convert.ToInt32(eid.Text) + "", conn);
            conn.Open();
            int res = cmd.ExecuteNonQuery();
            conn.Close();
        }

SqlCommand cmd1 = new SqlCommand("update addgallery set events = '" + name.Text + "',eventsdate='" + eventdate.Text + "' where id=" + Convert.ToInt32(eid.Text) + "", conn);

conn.Open();
        int res1 = cmd1.ExecuteNonQuery();
        conn.Close();

if (res1 == 1)
        {
            Response.Write("<script>alert('Updation done!')</script>");
        }
        gv1.EditIndex = -1;
        Bind();
    }

protected void gv1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        gv1.EditIndex = -1;
        Bind();
    }

protected void gv1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        int index = e.RowIndex;

GridViewRow row = (GridViewRow)gv1.Rows[index];

Label eid = (Label)row.FindControl("lbleid");

SqlCommand cmd = new SqlCommand("delete from addgallery where id=" + Convert.ToInt32(eid.Text) + "", conn);
        conn.Open();
        int res = cmd.ExecuteNonQuery();
        conn.Close();

if (res == 1)
        {
            Response.Write("<script>alert('Deletion done!')</script>");
        }
        Bind();
    }
    protected void gv1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        gv1.PageIndex = e.NewPageIndex;
        Bind();
    }
}

${this.title}

Code Editor : Dashboard.aspx.cs