protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
int qidtosearch = int.Parse(this.TextBox1.Text.ToString());
SqlConnection conn = DB_Connect.GetConnection();
conn.Open();
string query = "SPUpdateQuotation";
SqlCommand newCmd = conn.CreateCommand();
newCmd.Connection = conn;
newCmd.Parameters.AddWithValue("@qtid", int.Parse(this.TextBox1.Text));
newCmd.Parameters.AddWithValue("@book", this.DDLBooks.SelectedValue);
newCmd.Parameters.AddWithValue("@author", this.DDLAuthors.SelectedValue);
newCmd.Parameters.AddWithValue("@pno", this.txtPNo.Text);
newCmd.Parameters.AddWithValue("@quote", this.txtQuote.Text);
// newCmd.Parameters.Add("@qidtosearch", int.Parse(this.textBox1.Text));
newCmd.CommandType = CommandType.StoredProcedure;
newCmd.CommandText = query;
newCmd.ExecuteNonQuery();
LabelUQ.Visible = true;
conn.Close();
}
catch (NullReferenceException) {}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
SqlConnection conn = DB_Connect.GetConnection();
conn.Open();
/////////////////////////////
string query = "Select * from Authors Where AuthorID=" + int.Parse(this.TextBox1.Text.ToString());
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
this.txtAID.Text = dr.GetInt32(0).ToString();
this.txtFName.Text = dr.GetString(1);
this.txtLName.Text = dr.GetString(2);
this.txtNation.Text = dr.GetString(3);
this.txtBDate.Text = dr.GetString(4);
this.txtBPlace.Text = dr.GetString(5);
this.txtTLoc.Text = dr.GetString(6);
this.txtMInf.Text = dr.GetString(7);
this.txtNotes.Text = dr.GetString(8);
}
}
else
{
LabelSA.Visible = true;
}
////////////////////////////
conn.Close();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
conn = DB_Connect.GetConnection();
conn.Open();
/*if (conn.State.ToString() == "Closed")
* {
* conn.Open();
* }*/
SqlCommand newCmd = conn.CreateCommand();
newCmd.CommandText = "SPInsertTopic";
newCmd.CommandType = CommandType.StoredProcedure;
// newCmd.Parameters.AddWithValue("@id", Convert.ToInt32(txtTID.Text));
newCmd.Parameters.AddWithValue("@name", txtTopic.Text);
newCmd.ExecuteNonQuery();
System.Threading.Thread.Sleep(3000);
LabelET.Visible = true;
/*string javaScript =
* "<script language=JavaScript>\n" +
* "alert('Record Added Succesfully!...');\n" +
* "</script>";
*
* RegisterStartupScript("btnSubmit_ClickScript", javaScript);
*/
}
catch (NullReferenceException) { }
conn.Close();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
SqlConnection conn = DB_Connect.GetConnection();
conn.Open();
/////////////////////////////
string query = "Select * from Quotations Where QuoteID=" + int.Parse(this.TextBox1.Text.ToString());
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
this.txtQID.Text = dr.GetInt32(0).ToString();
this.DDLBooks.Text = dr.GetString(1);
this.DDLAuthors.Text = dr.GetString(2);
this.txtPNo.Text = dr.GetString(3);
this.txtQuote.Text = dr.GetString(4);
}
}
else
{
LabelSQ.Visible = true;
}
////////////////////////////
conn.Close();
}
public DataTable getDataTable()
{
try
{
System.Data.DataTable aTable = new System.Data.DataTable();
conn = DB_Connect.GetConnection();
conn.Open();
SqlCommand sqlCmd = new SqlCommand("ViewQuotations", conn);
sqlCmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(sqlCmd);
da.Fill(aTable);
conn.Close();
sqlCmd.Dispose();
da.Dispose();
return(aTable);
}
catch (Exception err)
{
//TextFileWriter.WriteToLog(err.Message);
return(null);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
String bookidSearch = this.TextBox1.Text.ToString();
SqlConnection conn = DB_Connect.GetConnection();
conn.Open();
string query = "SPUpdateBook";
SqlCommand newCmd = conn.CreateCommand();
newCmd.Connection = conn;
newCmd.Parameters.AddWithValue("@bid", int.Parse(this.TextBox1.Text.ToString()));
newCmd.Parameters.AddWithValue("@title", this.txtBTitle.Text);
newCmd.Parameters.AddWithValue("@topic", this.DDLTopic.SelectedValue);
newCmd.Parameters.AddWithValue("@pname", this.txtBPName.Text);
newCmd.Parameters.AddWithValue("@ctype", this.txtBCType.Text);
newCmd.Parameters.AddWithValue("@notes", this.txtNotes.Text);
newCmd.Parameters.AddWithValue("@pprice", this.txtBPPrice.Text);
newCmd.Parameters.AddWithValue("@author", this.DDLAuthor.SelectedValue);
newCmd.Parameters.AddWithValue("@enum", this.txtBENumber.Text);
newCmd.Parameters.AddWithValue("@cyear", this.txtBCYear.Text);
newCmd.Parameters.AddWithValue("@dpur", this.txtBDPurchased.Text);
newCmd.Parameters.AddWithValue("@page", this.txtBPages.Text);
newCmd.Parameters.AddWithValue("@sno", this.txtBSNo.Text);
// newCmd.Parameters.Add("@booktitleSearch", this.textBox1.Text);
newCmd.CommandType = CommandType.StoredProcedure;
newCmd.CommandText = query;
newCmd.ExecuteNonQuery();
System.Threading.Thread.Sleep(3000);
LabelUB.Visible = true;
conn.Close();
}
catch (Exception E) {}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
// access.add_quotation(DDLBooks.SelectedValue, DDLAuthors.SelectedValue,txtPNo.Text,txtQuote.Text);
try
{
conn = DB_Connect.GetConnection();
conn.Open();
SqlCommand newCmd = conn.CreateCommand();
newCmd.CommandText = "SPInsertQuotation";
newCmd.CommandType = CommandType.StoredProcedure;
newCmd.Parameters.AddWithValue("@book", DDLBooks.SelectedValue);
newCmd.Parameters.AddWithValue("@author", DDLAuthors.SelectedValue);
newCmd.Parameters.AddWithValue("@pno", txtPNo.Text);
newCmd.Parameters.AddWithValue("@quote", txtQuote.Text);
newCmd.ExecuteNonQuery();
System.Threading.Thread.Sleep(3000);
LabelMsg.Visible = true;
/*string javaScript =
* "<script language=JavaScript>\n" +
* "alert('Record Added Succesfully!...');\n" +
* "</script>";
* RegisterStartupScript("Button1_ClickScript", javaScript);*/
}
catch (NullReferenceException) { }
conn.Close();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
conn = DB_Connect.GetConnection();
conn.Open();
SqlCommand newCmd = conn.CreateCommand();
newCmd.CommandText = "SPInsertAuthor";
newCmd.CommandType = CommandType.StoredProcedure;
// newCmd.Parameters.AddWithValue("@aid", Convert.ToInt32(aid));
newCmd.Parameters.AddWithValue("@fname", txtFName.Text);
newCmd.Parameters.AddWithValue("@lname", txtLName.Text);
newCmd.Parameters.AddWithValue("@nat", txtNation.Text);
newCmd.Parameters.AddWithValue("@bdate", txtBDate.Text);
newCmd.Parameters.AddWithValue("@bplace", txtBPlace.Text);
newCmd.Parameters.AddWithValue("@tloc", txtTLoc.Text);
newCmd.Parameters.AddWithValue("@minf", txtMInf.Text);
newCmd.Parameters.AddWithValue("@notes", txtNotes.Text);
newCmd.ExecuteNonQuery();
System.Threading.Thread.Sleep(3000);
LabelEA.Visible = true;
conn.Close();
/* string javaScript =
* "<script language=JavaScript>\n" +
* "alert('Record Added Succesfully!...');\n" +
* "</script>";
*
* RegisterStartupScript("Button1_ClickScript", javaScript);*/
}
catch (NullReferenceException) { }
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
int idtosearch = int.Parse(this.TextBox1.Text);
SqlConnection conn = DB_Connect.GetConnection();
conn.Open();
string query = "SPUpdateAuthor";
SqlCommand newCmd = conn.CreateCommand();
newCmd.Connection = conn;
newCmd.Parameters.AddWithValue("@aid", int.Parse(this.TextBox1.Text.ToString()));
newCmd.Parameters.AddWithValue("@fname", this.txtFName.Text);
newCmd.Parameters.AddWithValue("@lname", this.txtLName.Text);
newCmd.Parameters.AddWithValue("@nat", this.txtNation.Text);
newCmd.Parameters.AddWithValue("@bdate", this.txtBDate.Text);
newCmd.Parameters.AddWithValue("@bplace", this.txtBPlace.Text);
newCmd.Parameters.AddWithValue("@tloc", this.txtTLoc.Text);
newCmd.Parameters.AddWithValue("@minf", this.txtMInf.Text);
newCmd.Parameters.AddWithValue("@notes", this.txtNotes.Text);
//newCmd.Parameters.Add("@idtosearch", int.Parse(this.textBox1.Text) );
newCmd.CommandType = CommandType.StoredProcedure;
newCmd.CommandText = query;
newCmd.ExecuteNonQuery();
System.Threading.Thread.Sleep(3000);
LabelUA.Visible = true;
conn.Close();
}
catch (NullReferenceException) { }
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
int SearchID = int.Parse(this.ddlTopic.SelectedValue.ToString());
SqlConnection conn = DB_Connect.GetConnection();
conn.Open();
////////////////////////
string query = "SpTopicUpdate";
SqlCommand newCmd = conn.CreateCommand();
newCmd.Connection = conn;
newCmd.Parameters.AddWithValue("@id", int.Parse(this.ddlTopic.SelectedValue.ToString()));
newCmd.Parameters.AddWithValue("@name", this.txtTopic.Text);
// newCmd.Parameters.Add("@SearchID", int.Parse(this.textBox1.Text));
newCmd.CommandType = CommandType.StoredProcedure;
newCmd.CommandText = query;
newCmd.ExecuteNonQuery();
LabelUT.Visible = true;
//Response.Write("no of rows effected" + newCmd.ExecuteNonQuery().ToString());
conn.Close();
}
catch (NullReferenceException)
{}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
bool flag = false;
conn = DB_Connect.GetConnection();
conn.Open();
string query = "Select Count(*) from Registration where Name = '" + txtUserName.Text + "'";
SqlCommand userExist = new SqlCommand(query, conn);
int response = Convert.ToInt32(userExist.ExecuteScalar().ToString());
if (response == 1)
{
flag = true;
}
else
{
flag = false;
}
if (flag)
{
Response.Write("Already Exist");
}
else
{
flag = false;
string Query = "Insert Into Registration (Name,Gender,BirthDay,Country,Language,Email,Password,AlternateEmail,SecretQuestion,YourAnswer) Values ('" + txtUserName.Text + "','" + DDLGender.SelectedValue + "','" + txtBirthDate.Text + "','" + DDLCountry.SelectedValue + "','"
+ DDLLanguage.SelectedValue + "','" + txtEmail.Text + "','" + txtPassword.Text + "','" + txtAEmail.Text + "','" + DDLSecurityQuest.SelectedValue + "','" + txtYAns.Text + "')";
SqlCommand aCommand = new SqlCommand(Query, conn);
response = aCommand.ExecuteNonQuery();
LabelRU.Visible = true;
conn.Close();
aCommand.Dispose();
if (response == 0)
{
flag = false;
}
else
{
flag = true;
}
if (flag)
{
Response.Redirect("Login.aspx");
}
else
{
Response.Write("Wrong Something Try Again");
}
}
}
catch (Exception err)
{
Response.Write(err.Message);
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
bool flag = false;
conn = DB_Connect.GetConnection();
conn.Open();
string query = "Select Count(*) from Registration where Name = '" + txtUN.Text + "'";
SqlCommand userExist = new SqlCommand(query, conn);
int response = Convert.ToInt32(userExist.ExecuteScalar().ToString());
if (response == 1)
{
flag = true;
}
else
{
flag = false;
}
if (flag)
{
flag = false;
query = "Select Password from Registration where Name = '" + txtUN.Text + "'";
SqlCommand validatePass = new SqlCommand(query, conn);
string pass = validatePass.ExecuteScalar().ToString();
if (pass.Equals(txtPassword.Text))
{
flag = true;
}
else
{
flag = false;
}
if (flag)
{
Session["LoginName"] = txtUN.Text;
Session["Login"] = true;
Application["AliveUsers"] = Convert.ToInt64(Application["AliveUsers"]) + 1;
Response.Redirect("Default.aspx");
}
else
{
Label1.Visible = true;
Label1.Text = "Invalid Password";
//Response.Write("Invalid Password");
}
}
else
{
Label1.Visible = true;
Label1.Text = "Invalid User Name";
//Response.Write("Invalid User Name");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
conn = DB_Connect.GetConnection();
conn.Open();
}
//LoadCountry();
// Initilize the Controls from Cookies
else
{
LoadCountry();
LabelRU.Visible = false;
}
InitializeCookies();
}
protected void DDLCountry_SelectedIndexChanged(object sender, EventArgs e)
{
int countID = Convert.ToInt32(DDLCountry.SelectedItem.Value);
if (countID > 0)
{
conn = DB_Connect.GetConnection();
conn.Open();
string query = "Select * from City Where CountryID = " + countID;
SqlDataAdapter _sqlda = new SqlDataAdapter(query, conn);
DataTable dt = new DataTable();
_sqlda.Fill(dt);
DDLCity.DataSource = dt;
DDLCity.DataValueField = "CityID";
DDLCity.DataTextField = "CityName";
DDLCity.DataBind();
}
}
protected void btnDelete_Click1(object sender, EventArgs e)
{
SqlConnection conn = DB_Connect.GetConnection();
conn.Open();
string query = "SPDelBook";
SqlCommand newCmd = conn.CreateCommand();
newCmd.Connection = conn;
newCmd.Parameters.AddWithValue("@bid", this.TextBox1.Text);
newCmd.CommandType = CommandType.StoredProcedure;
newCmd.CommandText = query;
newCmd.ExecuteNonQuery();
LabelDB.Visible = true;
// MessageBox.Show("no of rows effected" + newCmd.ExecuteNonQuery());
conn.Close();
}
private void LoadCountry()
{
try
{
conn = DB_Connect.GetConnection();
conn.Open();
string query = "Select * from Country";
SqlDataAdapter _sqlda = new SqlDataAdapter(query, conn);
DataTable dt = new DataTable();
_sqlda.Fill(dt);
DDLCountry.DataSource = dt;
DDLCountry.DataValueField = "CID";
DDLCountry.DataTextField = "CountryName";
DDLCountry.DataBind();
}
catch (Exception e)
{
Response.Write("Error");
}
}
protected void btnDeleteQ_Click(object sender, EventArgs e)
{
try
{
SqlConnection conn = DB_Connect.GetConnection();
conn.Open();
string query = "SPDelQuotation";
SqlCommand newCmd = conn.CreateCommand();
newCmd.Connection = conn;
newCmd.Parameters.AddWithValue("@qtid", int.Parse(this.TextBox1.Text));
newCmd.CommandType = CommandType.StoredProcedure;
newCmd.CommandText = query;
newCmd.ExecuteNonQuery();
LabelDQ.Visible = true;
conn.Close();
}
catch (NullReferenceException) { }
}
protected void btnDelete_Click1(object sender, EventArgs e)
{
try
{
SqlConnection conn = DB_Connect.GetConnection();
conn.Open();
string query = "SPDelAuthor";
SqlCommand newCmd = conn.CreateCommand();
newCmd.Connection = conn;
newCmd.Parameters.AddWithValue("@aid", int.Parse(this.TextBox1.Text));
newCmd.CommandType = CommandType.StoredProcedure;
newCmd.CommandText = query;
newCmd.ExecuteNonQuery();
LabelDA.Visible = true;
// MessageBox.Show("no of rows effected" + newCmd.ExecuteNonQuery().ToString());
conn.Close();
}
catch (NullReferenceException) { }
}
protected void btnSearch_Click(object sender, EventArgs e)
{
SqlConnection conn = DB_Connect.GetConnection();
conn.Open();
/////////////////////////////
string query = "Select * from Books Where BookID=" + int.Parse(this.TextBox1.Text.ToString());
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataReader dr = cmd.ExecuteReader();
//if (dr.HasRows)
//{
while (dr.Read())
{
this.txtBID.Text = dr.GetInt32(0).ToString();
this.txtBTitle.Text = dr.GetString(1);
this.DDLTopic.Text = dr.GetString(2);
this.txtBPName.Text = dr.GetString(3);
this.txtBCType.Text = dr.GetString(4);
this.txtNotes.Text = dr.GetString(5);
this.txtBPPrice.Text = dr.GetString(6);
this.DDLAuthor.Text = dr.GetString(7);
this.txtBENumber.Text = dr.GetString(8);
this.txtBCYear.Text = dr.GetString(9);
this.txtBDPurchased.Text = dr.GetString(10);
int aa = dr.GetInt32(11);
this.txtBPages.Text = "" + aa;
this.txtBSNo.Text = dr.GetString(12);
}
//}
//else
// LabelSB.Visible = true;
////////////////////////////
conn.Close();
}
/* protected void DeleteTopic(object sender, GridViewDeleteEventArgs e)
* {
* try
* {
* int id = Convert.ToInt32(GridView1.Rows[e.RowIndex].Cells[2].Text);
* conn = DB_Connect.GetConnection();
* conn.Open();
* SqlCommand aCommand = new SqlCommand("SpDelTopic", conn);
* aCommand.CommandType = CommandType.StoredProcedure;
*
* aCommand.Parameters.AddWithValue("@id", id);
*
* aCommand.ExecuteNonQuery();
* Response.Write("Record Deleted Successfully");
* conn.Close();
* aCommand.Dispose();
* }
* catch (Exception err)
* {
* //TextFileWriter.WriteToLog(err.Message);
* //return null;
* }
* }*/
protected void DeleteTopic2(object sender, GridViewDeleteEventArgs e)
{
try
{
int id = Convert.ToInt32(GridView1.Rows[e.RowIndex].Cells[1].Text);
conn = DB_Connect.GetConnection();
conn.Open();
SqlCommand aCommand = new SqlCommand("SpDelTopic", conn);
aCommand.CommandType = CommandType.StoredProcedure;
aCommand.Parameters.AddWithValue("@id", id);
aCommand.ExecuteNonQuery();
Response.Write("Record Deleted Successfully");
conn.Close();
aCommand.Dispose();
}
catch (Exception err)
{
Response.Write("Error");
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
conn = DB_Connect.GetConnection();
conn.Open();
SqlCommand newCmd = conn.CreateCommand();
newCmd.CommandText = "SPInsertBook";
newCmd.CommandType = CommandType.StoredProcedure;
newCmd.Parameters.AddWithValue("@title", txtBTitle.Text);
newCmd.Parameters.AddWithValue("@topic", DDLTopic.SelectedValue);
newCmd.Parameters.AddWithValue("@pname", txtBPName.Text);
newCmd.Parameters.AddWithValue("@ctype", txtBCType.Text);
newCmd.Parameters.AddWithValue("@notes", txtNotes.Text);
newCmd.Parameters.AddWithValue("@pprice", txtBPPrice.Text);
newCmd.Parameters.AddWithValue("@author", DDLAuthor.SelectedValue);
newCmd.Parameters.AddWithValue("@enum", txtBENumber.Text);
newCmd.Parameters.AddWithValue("@cyear", txtBCYear.Text);
newCmd.Parameters.AddWithValue("@dpur", txtBDPurchased.Text);
newCmd.Parameters.AddWithValue("@page", txtBPages.Text);
newCmd.Parameters.AddWithValue("@sno", txtBSNo.Text);
newCmd.ExecuteNonQuery();
System.Threading.Thread.Sleep(3000);
LabelBooks.Visible = true;
/*string javaScript =
* "<script language=JavaScript>\n" +
* "alert('Record Added Succesfully!...');\n" +
* "</script>";
* RegisterStartupScript("Button1_ClickScript", javaScript);*/
}
catch (NullReferenceException) { }
conn.Close();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
SqlConnection conn = DB_Connect.GetConnection();
conn.Open();
/////////////////////////////
string query = "Select * from Topic Where TopicID=" + int.Parse(ddlTopic.SelectedValue.ToString());
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
this.txtTID.Text = dr.GetInt32(0).ToString();
this.txtTopic.Text = dr.GetString(1);
}
}
////////////////////////////
conn.Close();
}
