public void FillData()
{
Web webObj = new Web();
AdminGridView.DataSource = webObj.DisplayBooks();
AdminGridView.DataBind();
}
private void txtSearch_TextChanged(object sender, EventArgs e)
{ //When searching, the text typed will search the datagridview and reflect searched users in real time
string con = ConfigurationManager.ConnectionStrings["SensorConnectionString"].ConnectionString;
string sql = "SELECT * from Users where Username like '" + txtSearch.Text + "%'";
SqlConnection conn = new SqlConnection(con);
pagingAdapter = new SqlDataAdapter(sql, con);
pagingDS = new DataSet();
conn.Open();
pagingAdapter.Fill(pagingDS, scrollVal, 5, "Users");
conn.Close();
AdminGridView.DataSource = pagingDS;
AdminGridView.DataMember = "Users";
try
{
AdminGridView.ClearSelection(); //or restore rows backcolor to default
for (int i = 0; i < (AdminGridView.Rows.Count); i++)
{
if (AdminGridView.Rows[i].Cells[1].Value.ToString().StartsWith(txtSearch.Text, true, CultureInfo.InvariantCulture))
{
AdminGridView.FirstDisplayedScrollingRowIndex = i;
AdminGridView.Rows[i].Selected = true; //It is also possible to color the row backgroud
return;
}
else
{
AdminGridView.ClearSelection();
}
}
}
catch (Exception)
{
}
}
protected void LoadData()
{
string connStr = ConfigurationManager.ConnectionStrings["RegConnectionString"].ConnectionString;
string query = @"SELECT * FROM LOGIN_DETAILS ";
SqlDataAdapter da = new SqlDataAdapter(query, connStr);
DataTable table = new DataTable();
da.Fill(table);
AdminGridView.DataSource = table;
AdminGridView.DataBind();
}
void DisplayData()
{
DataTable dt = new DataTable();
gateWay.Connection.Open();
sqlDataAdapter = new SqlDataAdapter("select Name,ContractNumber,AdminUserName, Question from Admin", gateWay.Connection);
sqlDataAdapter.Fill(dt);
AdminGridView.DataSource = dt;
AdminGridView.DataBind();
gateWay.Connection.Close();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string title = txtTitle.Text;
double price = Convert.ToDouble(txtPrice.Text);
double special = Convert.ToDouble(txtSpecial.Text);
Web webObj = new Web();
webObj.Title = title;
webObj.Price = price;
webObj.Special = special;
Response.Write("<script>alert('Book Added Successfully');</script>");
AdminGridView.DataSource = webObj.AddBookAdmin();
AdminGridView.DataBind();
}
/*
* @Method: AddAdminBtn_Click
* @Params: object sender, EventArgs e
* @Return: void
* @Description: This method will be activated on the click of submit admin button.
* A new ID will be assigned to the new admin, and password will be hashed, and
* saved in the database using SQL Data Access Layer
*/
protected void AddAdminBtn_Click(object sender, EventArgs e)
{
AdminObject admin = new AdminObject();
//Creating new unique ID to the admin object
admin.AdminID = Guid.NewGuid();
//Getting new hashed password
PasswordHasher hasher = new PasswordHasher();
string hashedPassword =
hasher.GetHashedPassword(AdminPasswordInput.Text, AdminEmailInput.Text);
//Constructing the insert query
string query = "insert into tblAdmins values('" + admin.AdminID + "','"
+ AdminNameInput.Text + "','" + AdminEmailInput.Text + "','" + hashedPassword
+ "')";
string result = dbCommander.InsertRecord(query);
if (result == "1")
{
//Success message
Response.Write("<script>alert('Admin inserted');</script>");
//Clearing all the input fields
AdminNameInput.Text = string.Empty;
AdminEmailInput.Text = string.Empty;
AdminPasswordInput.Text = string.Empty;
}
else
{
//If the user is not inserted, show that there was an error with the database
Response.Write
("<script>alert('Database error, please check your provided data to be correct');</script>");
}
//Closing connection to database
dbCommander.CloseConnection();
//Refresh the GridView
AdminGridView.DataBind();
}
private void BindGrid()
{
OracleQuery2 cc2 = new OracleQuery2();
DataTable dt = cc2.LoadAdmin();
SQLServerQuery ss = new SQLServerQuery();
string result = "";
foreach (DataRow r in dt.Rows)
{
result = result + r["EMPLOYEE_ID"].ToString() + ",";
}
result = result.TrimEnd(',');
DataTable dt_pis = ss.LoadINPIS("", result);
DataTable Final_result = new DataTable();
Final_result.Columns.Add("EMPLOYEE_ID");
Final_result.Columns.Add("FULLNAMETH");
Final_result.Columns.Add("POSNAME");
Final_result.Columns.Add("UNITNAME");
Final_result.Columns.Add("IS_ADMIN");
if (dt != null && dt_pis != null && dt.Rows.Count > 0 && dt_pis.Rows.Count > 0)
{
var results = from table1 in dt.AsEnumerable()
join table2 in dt_pis.AsEnumerable() on table1["EMPLOYEE_ID"].ToString() equals table2["P_ID"].ToString()
select new
{
EMPLOYEE_ID = table1["EMPLOYEE_ID"].ToString(),
FULLNAMETH = table2["FULLNAMETH"].ToString(),
POSNAME = table2["POSNAME"].ToString(),
unitname = table2["unitname"].ToString(),
is_admin = table1["IS_ADMIN"].ToString() == "1"?"ADMIN":"USER"
};
foreach (var item in results)
{
Final_result.Rows.Add(item.EMPLOYEE_ID, item.FULLNAMETH, item.POSNAME, item.unitname, item.is_admin);
}
}
AdminGridView.DataSource = Final_result;
AdminGridView.DataBind();
}
protected void AdminGridView_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
SqlConnection connectObj = new SqlConnection();
connectObj = WebDbConnection.GetSqlConnection();
connectObj.Open();
int id = Convert.ToInt32(AdminGridView.DataKeys[e.RowIndex].Values["boo_id"].ToString());
string deleteQuery = "delete from wms_books where boo_id=@id";
SqlCommand cmdDelete = new SqlCommand(deleteQuery, connectObj);
cmdDelete.Parameters.AddWithValue("@id", id);
SqlDataAdapter adapt = new SqlDataAdapter(cmdDelete);
DataTable dt = new DataTable();
adapt.Fill(dt);
AdminGridView.DataSource = dt;
AdminGridView.DataBind();
}
