protected void btnsave_Click(object sender, EventArgs e)
{
DateTimeFormatInfo dtfi = new DateTimeFormatInfo();
dtfi.ShortDatePattern = "dd/MM/yyyy";
dtfi.DateSeparator = "/";
con.Close();
con.Open();
string strinsert = "insert into Reception(Name,Phone,Mobile,Email,Date,Reason,Detail)Values(@Name,@Phone,@Mobile,@Email,@Date,@Reason,@Detail)";
SqlCommand cmd = new SqlCommand(strinsert, con);
cmd.Parameters.AddWithValue("Name", txtName.Text.ToString());
cmd.Parameters.AddWithValue("Phone", txtPhonecode.Text + "-" + txtPhoneNo.Text);
cmd.Parameters.AddWithValue("Mobile", txtMobile.Text.ToString());
cmd.Parameters.AddWithValue("Email", txtEmail.Text.ToString());
cmd.Parameters.AddWithValue("Date", Convert.ToDateTime(txtDate.Text.ToString(), dtfi));
cmd.Parameters.AddWithValue("Reason", Txtia.Text.ToString());
cmd.Parameters.AddWithValue("Detail", TxtComment.Text.ToString());
cmd.ExecuteNonQuery();
btnsave.Enabled = false;
lblexception.Text = "Information Saved";
grid();
GrvVisitorview.Focus();
ClearTextBoxes();
con.Close();
con.Dispose();
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Convert.ToString(Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"])) == "")
{
Response.Redirect("../Login.aspx");
}
else
{
maikal mk = new maikal();
int lvl = mk.returnlevel(Convert.ToString(Server.HtmlEncode(Request.Cookies["MyLogin"]["UID"])), Convert.ToString(Server.HtmlEncode(Request.Cookies["MyLogin"]["PWD"])));
}
if (!IsPostBack)
{
txtName.Focus();
txtDate.Text = DateTime.Now.ToString("dd/MM/yyyy");
lblGridTitle.Text = " Today Visitor List ";
SqlDataAdapter ad = new SqlDataAdapter("select Name,Phone,Mobile,Email,Reason,Detail from Reception where Date='" + DateTime.Now.Date + "' ORDER BY SN DESC", con);
DataSet ds = new DataSet();
ad.Fill(ds);
GrvVisitorview.DataSource = ds;
GrvVisitorview.DataBind();
}
}
catch (NullReferenceException ex)
{
Response.Redirect("../Login.aspx");
}
}
public void grid()
{
SqlDataAdapter ad = new SqlDataAdapter("select Name,Phone,Mobile,Email,Reason,Detail from Reception where Date='" + DateTime.Now.Date + "' ORDER BY SN DESC", con);
DataSet ds = new DataSet();
ad.Fill(ds);
GrvVisitorview.DataSource = ds;
GrvVisitorview.DataBind();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
grid();
GrvVisitorview.PageIndex = e.NewPageIndex;
GrvVisitorview.DataBind();
}
