protected void btnreg_Click(object sender, EventArgs e)
{
string adhar = txtadhar.Text;
string name = txtname.Text;
string user = txtuser.Text;
string pwd = txtpwd.Text;
string add = txtadd.Text;
string dis = txtdist.Text;
string pin = txtpin.Text;
string ph = txtph.Text;
string email = txtemail.Text;
qry = "insert into registration values('" + adhar + "','" + name + "','" + add + "','" + ph + "','" + email + "','" + dis + "','" + pin + "')";
//Response.Write(qry);
obj = new ForController();
obj.controllerNonQuery(qry);
qry = "insert into login values(null,'" + user + "','" + pwd + "',2)";
obj = new ForController();
obj.controllerNonQuery(qry);
lblmsg.Text = "Sucessfully Register";
txtname.Text = "";
txtuser.Text = "";
txtpwd.Text = "";
txtadd.Text = "";
txtph.Text = "";
txtemail.Text = "";
txtadhar.Text = "";
txtdist.Text = "";
txtpin.Text = "";
}
protected void btnlogin_Click(object sender, EventArgs e)
{
string user = txtuser.Text;
string pwd = txtpwd.Text;
qry = "select user_id,role from login where user_id='" + user + "' and password= '******'";
obj = new ForController();
dt = obj.ControllerGetData(qry);
Session["user_id"] = user;
if (dt.Rows.Count > 0)
{
string ses = dt.Rows[0][0].ToString();
string role = dt.Rows[0][1].ToString();
int roll = Convert.ToInt32(role);
if (roll == 1)
{
Response.Redirect("AdminHome.aspx");
}
else if (roll == 2)
{
Response.Redirect("UserVideoView.aspx");
}
}
else
{
lblmsg.Text = "Login error";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string qry = "select * from fun";
ForController obj = new ForController();
DataTable data = obj.ControllerGetData(qry);
GridView1.DataSource = data;
GridView1.DataBind();
}
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
string fname = ddlpgm.SelectedItem.Text;
string pgm = txtpgm.Text;
string id = ddlpgm.SelectedItem.Value;
//string lng=txtlng.Text;
string rdate = txtrdate.Text;
//string ln = txtleng.Text;
string hour = ddlhour.SelectedItem.Text;
string min = ddlmin.SelectedItem.Text;
string sec = ddlsec.SelectedItem.Text;
string time = hour + ":" + min + ":" + sec;
string fPath = "";
int st = 0;
string fp = DateTime.Now.Ticks.ToString() + System.IO.Path.GetExtension(FileUpLoad1.FileName);
if (FileUpLoad1.HasFile)
{
st = 1;
fPath = "video/" + fp;
FileUpLoad1.SaveAs(Server.MapPath("~/video/" + fp));
lblmsg.Text = "File Uploaded: " + FileUpLoad1.FileName;
}
else
{
lblmsg.Text = "No File Uploaded.";
}
if (st == 1)
{
qry = "insert into fun values(null,'" + fname + "','" + pgm + "','" + id + "','" + time + "','" + fPath + "','" + rdate + "')";
obj = new ForController();
obj.controllerNonQuery(qry);
lblmsg.Text = "Sucessfully uploaded...";
}
txtpgm.Text = "";
txtrdate.Text = "";
ddlpgm.SelectedIndex = -1;
ddlhour.SelectedIndex = -1;
ddlmin.SelectedIndex = -1;
ddlsec.SelectedIndex = -1;
}
protected void Page_Load(object sender, EventArgs e)
{
string id = Session["fun_id"].ToString();
string q = "SELECT * FROM fun f where fun_id=" + id;
DataTable dt = new DataTable();
dt = new ForController().ControllerGetData(q);
foreach (DataRow row in dt.Rows)
{
lbllng.Text = row["file_name"].ToString();
lblname.Text = row["program_name"].ToString();
lblrdate.Text = row["releaseDate"].ToString();
lbllen.Text = row["length"].ToString();
video.Attributes["src"] = row["file_path"].ToString();
}
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
string fid = e.CommandArgument.ToString();
string btn = ((LinkButton)e.CommandSource).Text;
if (btn.Equals("Edit"))
{
Session["id"] = fid;
Response.Redirect("AdminEditViewFun.aspx");
}
else
{
string qry = "delete from fun where fun_id=" + Convert.ToInt32(fid) + " ";
ForController obj = new ForController();
obj.controllerNonQuery(qry);
lblmsg.Text = "Record Deleted successfully.";
string qry1 = "select * from fun";
ForController obj1 = new ForController();
DataTable data = obj1.ControllerGetData(qry1);
GridView1.DataSource = data;
GridView1.DataBind();
}
}