using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class fromModifyEvents : System.Web.UI.Page
{
SqlConnection sqlConn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RSIC"].ConnectionString);
SqlDataAdapter sda = null;
DataSet ds = null;
SqlCommand cmd = null;
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
FillViewEventDetails();
}
}
protected void gvViewEvents_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
pnlModifyevents.Visible = true;
Label lbl =(Label) gvViewEvents.Rows[e.RowIndex].FindControl("Label1");
string srno = Convert.ToString(lbl.Text);
Session["SrnoUp"] = srno;
string EventHeader = Convert.ToString(gvViewEvents.Rows[e.RowIndex].Cells[2].Text);
string EventDate = Convert.ToString(gvViewEvents.Rows[e.RowIndex].Cells[3].Text);
string EventsDetails = Convert.ToString(gvViewEvents.Rows[e.RowIndex].Cells[4].Text);
txtAddEvent.Text = EventHeader;
txtEventDate.Value = EventDate;
txtEventDetails.Text = EventsDetails;
}
void FillViewEventDetails()
{
sqlConn.Open();
sda = new SqlDataAdapter("Select Srno, EventHeader,EventDate,EventDetails From AddEventCalender ", sqlConn);
ds = new DataSet();
sda.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
pnlModifyevents.Visible = false;
pnlViewEvents.Visible = true;
gvViewEvents.DataSource = ds.Tables[0];
gvViewEvents.DataBind();
}
else
{
Response.Write("");
pnlModifyevents.Visible = false;
pnlViewEvents.Visible = false;
gvViewEvents.DataSource = null;
gvViewEvents.DataBind();
}
}
protected void btnEnterDetails_Click(object sender, EventArgs e)
{
sqlConn.Open();
cmd = new SqlCommand();
int intSrno = Convert.ToInt32(Session["SrnoUp"]);
cmd.CommandText = "Update AddEventCalender Set EventHeader ='" + txtAddEvent.Text + "',EventDate ='" + txtEventDate.Value + "',EventDetails='" + txtEventDetails.Text + "' Where SrNo = " + intSrno + " ";
cmd.CommandType = CommandType.Text;
cmd.Connection = sqlConn;
int j= cmd.ExecuteNonQuery();
if (j != 0)
{
Response.Write("");
pnlModifyevents.Visible = false;
sqlConn.Close();
FillViewEventDetails();
}
else
{
Response.Write("");
}
}
}