private void EditMode(string id)
{
string query = "SELECT `ID`, `Name`, `Email`, Age, Gender,`Phone`, `Address`,`EntryDate`, `BloodGroupId` FROM `donors` WHERE ID='" + id + "'";
DataTable dt = MySQLQuery.ReturnDataTable(query);
if (dt.Rows.Count > 0)
{
txtName.Text = dt.Rows[0]["Name"].ToString();
LoadBloodGroup();
if (dt.Rows[0]["Gender"].ToString() == "Male")
{
rdMail.Checked = true;
rdFemale.Checked = false;
}
else
{
rdMail.Checked = false;
rdFemale.Checked = true;
}
LoginInfo.Visible = false;
ddlBloodGroup.SelectedValue = dt.Rows[0]["BloodGroupId"].ToString();
txtAge.Text = dt.Rows[0]["Age"].ToString();
txtName.Text = dt.Rows[0]["Name"].ToString();
txtEmail.Text = dt.Rows[0]["Email"].ToString();
txtPhone.Text = dt.Rows[0]["Phone"].ToString();
txtAddress.Text = dt.Rows[0]["Address"].ToString();
btnSave.Text = "Update";
msgLabel.Text = "Edit Mode Activated!";
msgLabel.Attributes.Add("class", "info");
Session["Id"] = id;
}
}
private void EditMode(string id)
{
string query = "SELECT `ID`, `Name`, `Email`, Age, Gender,`Phone`, `Address`,`EntryDate`, `BloodGroupId` FROM `donors` WHERE UserId='" + id + "'";
DataTable dt = MySQLQuery.ReturnDataTable(query);
if (dt.Rows.Count > 0)
{
txtName.Text = dt.Rows[0]["Name"].ToString();
LoadBloodGroup();
if (dt.Rows[0]["Gender"].ToString() == "Male")
{
rdMail.Checked = true;
rdFemale.Checked = false;
}
else
{
rdMail.Checked = false;
rdFemale.Checked = true;
}
ddlBloodGroup.SelectedValue = dt.Rows[0]["BloodGroupId"].ToString();
txtAge.Text = dt.Rows[0]["Age"].ToString();
txtName.Text = dt.Rows[0]["Name"].ToString();
txtEmail.Text = dt.Rows[0]["Email"].ToString();
txtPhone.Text = dt.Rows[0]["Phone"].ToString();
txtAddress.Text = dt.Rows[0]["Address"].ToString();
Session["Id"] = dt.Rows[0]["ID"].ToString();
}
}
private void BindDonorGridView()
{
string query = "SELECT `req_id`, `name`, `gender`, `age`, `mobile`, `email`, `reqdate`, `detail`,(SELECT BloodGroup FROM bloodgroup WHERE Id=bgroup) AS BloodGroup FROM requestes Order By req_id DESC";
DataTable dt = MySQLQuery.ReturnDataTable(query);
bloodRequestGrid.DataSource = dt;
bloodRequestGrid.DataBind();
bloodRequestGrid.EmptyDataText = "No Data found!";
}
private void BindDonorGridView()
{
string query = "SELECT ID, Name, Email,Age, Gender, Phone, Address, EntryDate,(SELECT BloodGroup FROM bloodgroup WHERE Id=BloodGroupId) AS BloodGroup FROM donors Order By ID DESC";
DataTable dt = MySQLQuery.ReturnDataTable(query);
donorGrid.DataSource = dt;
donorGrid.DataBind();
donorGrid.EmptyDataText = "No Data found!";
}
private void BindDonorGridView()
{
string query = "SELECT `donation_id`, `ddate`, `units`,Location, `detail`, `userId` FROM `donation` WHERE UserID='" + Session["UserName"] + "'";
DataTable dt = MySQLQuery.ReturnDataTable(query);
donationGrid.DataSource = dt;
donationGrid.DataBind();
donationGrid.EmptyDataText = "No Data found!";
}
private void BindDonorGridView()
{
string query = "SELECT ID, BloodGroup FROM BloodGroup ORDER BY BloodGroup ASC";
DataTable dt = MySQLQuery.ReturnDataTable(query);
BloodGroupGrid.DataSource = dt;
BloodGroupGrid.DataBind();
BloodGroupGrid.EmptyDataText = "No Data found!";
}
private void BindDonor()
{
string sql = "";
if (ddlBloodGroup.SelectedValue != "0")
{
sql = "WHERE BloodGroupId='" + ddlBloodGroup.SelectedValue + "'";
}
string query = "SELECT ID, Name, Email,Age, Gender, Phone, Address, EntryDate,(SELECT BloodGroup FROM bloodgroup WHERE Id=BloodGroupId) AS BloodGroup FROM donors " + sql + " Order By ID DESC";
DataTable dt = MySQLQuery.ReturnDataTable(query);
Repeater1.DataSource = dt;
Repeater1.DataBind();
}
private void EditMode(string id)
{
string query = "SELECT `ID`, `BloodGroup` FROM `BloodGroup` WHERE ID='" + id + "'";
DataTable dt = MySQLQuery.ReturnDataTable(query);
if (dt.Rows.Count > 0)
{
txtBloodGroup.Text = dt.Rows[0]["BloodGroup"].ToString();
btnSave.Text = "Update";
msgLabel.Text = "Edit Mode Activated!";
msgLabel.Attributes.Add("class", "info");
Session["Id"] = id;
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
string query = "SELECT UserName,Password,Role FROM user Where UserName='******' AND Password='******'";
DataTable dt = MySQLQuery.ReturnDataTable(query);
if (dt.Rows.Count > 0)
{
foreach (DataRow item in dt.Rows)
{
Session["UserName"] = item["UserName"];
Session["Password"] = item["Password"];
Session["Role"] = item["Role"];
if ((Session["UserName"] != null) && (Session["Password"] != null))
{
Response.Redirect("Default.aspx");
}
}
}
else
{
FailureText.Text = "UserName or Password Invalid!";
ErrorMessage.Visible = true;
}
}