protected void btnSave_Click(object sender, EventArgs e)
{
try
{
string isExist = MySQLQuery.ReturnString("SELECT UserId From Donors WHERE UserId='" + txtUser.Text + "'");
if (isExist == "")
{
string gender = "Male";
if (rdFemale.Checked)
{
gender = "Female";
}
string query = "INSERT INTO donors (Name,Gender,Age,BloodGroupId, Email, Phone,Address,UserId) VALUES ('" + txtName.Text + "','" + gender + "','" + txtAge.Text + "','" + ddlBloodGroup.SelectedValue + "','" + txtEmail.Text + "','" + txtPhone.Text + "','" + txtAddress.Text + "','" + txtUser.Text + "')";
string sqlquery = "INSERT INTO user (UserName, Password, Name, Role) VALUES ('" + txtUser.Text + "','" + txtPassword.Text + "','" + txtName.Text + "','Donor')";
MySQLQuery.ExecNonQry(query);
MySQLQuery.ExecNonQry(sqlquery);
MySQLQuery.ShowMessage("Donor registration successfully:", "success", msgLabel);
ClearControls();
}
else
{
MySQLQuery.ShowMessage("User Id already exist! try another user id", "warning", msgLabel);
}
}
catch (Exception ex)
{
MySQLQuery.ShowMessage("ERROR:" + ex.ToString(), "error", msgLabel);
}
}
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();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (btnSave.Text == "Save")
{
string query = "INSERT INTO BloodGroup (BloodGroup) VALUES ('" + txtBloodGroup.Text + "')";
MySQLQuery.ExecNonQry(query);
MySQLQuery.ShowMessage("Blood Group add successfully:", "success", msgLabel);
ClearControls();
BindDonorGridView();
}
else
{
string query = "UPDATE BloodGroup SET BloodGroup='" + txtBloodGroup.Text + "' WHERE ID='" + Session["Id"] + "'";
MySQLQuery.ExecNonQry(query);
MySQLQuery.ShowMessage("Blood Group update successfully:", "success", msgLabel);
ClearControls();
BindDonorGridView();
btnSave.Text = "Save";
}
}
catch (Exception ex)
{
MySQLQuery.ShowMessage("ERROR:" + ex.ToString(), "error", msgLabel);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if ((Session["UserName"] == null) && (Session["Password"] == null))
{
//Response.Redirect("Login.aspx");
auth.Visible = false;
authLogin.Visible = true;
}
else
{
auth.Visible = true;
authLogin.Visible = false;
lblUserName.Text = MySQLQuery.ReturnString("SELECT Name FROM user Where UserName='******'");
}
if (Session["Role"] == null)
{
GetMenu("");
}
else
{
GetMenu(Session["Role"].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, BloodGroup FROM BloodGroup ORDER BY BloodGroup ASC";
DataTable dt = MySQLQuery.ReturnDataTable(query);
BloodGroupGrid.DataSource = dt;
BloodGroupGrid.DataBind();
BloodGroupGrid.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 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();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
string query = "INSERT INTO `donation`(`ddate`,Location, `units`, `detail`, `userId`) VALUES ('" + txtDate.Text + "','" + txtLocation.Text + "','" + txtUnit.Text + "','" + txtDetails.Text + "','" + Session["UserName"] + "')";
MySQLQuery.ExecNonQry(query);
MySQLQuery.ShowMessage("Save successfully:", "success", msgLabel);
ClearControls();
}
catch (Exception ex)
{
MySQLQuery.ShowMessage("ERROR:" + ex.ToString(), "error", msgLabel);
}
}
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 btnDelete_Command(object sender, CommandEventArgs e)
{
try
{
int id = Convert.ToInt32(e.CommandArgument.ToString());
string query = "DELETE FROM donors WHERE(ID = '" + id + "')";
MySQLQuery.ExecNonQry(query);
BindDonorGridView();
MySQLQuery.ShowMessage("Record Deleted ", "success", msgLabel);
}
catch (Exception ex)
{
MySQLQuery.ShowMessage("ERROR:" + ex.ToString(), "error", msgLabel);
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
string gender = "Male";
if (rdFemale.Checked)
{
gender = "Female";
}
string query = "UPDATE donors SET Name='" + txtName.Text + "',Gender='" + gender + "',Age='" + txtAge.Text + "',BloodGroupId='" + ddlBloodGroup.SelectedValue + "', Email='" + txtEmail.Text + "', Phone='" + txtPhone.Text + "',Address='" + txtAddress.Text + "' WHERE ID='" + Session["Id"] + "'";
MySQLQuery.ExecNonQry(query);
MySQLQuery.ShowMessage("Profile update successfully:", "success", msgLabel);
//ClearControls();
//btnSave.Text = "Save";
//BindDonorGridView();
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
string gender = "Male";
if (rdFemale.Checked)
{
gender = "Female";
}
if (btnSave.Text == "Add Donor")
{
string isExist = MySQLQuery.ReturnString("SELECT UserId From Donors WHERE UserId='" + txtUser.Text + "'");
if (isExist == "")
{
string query = "INSERT INTO donors (Name,Gender,Age,BloodGroupId, Email, Phone,Address,UserId) VALUES ('" + txtName.Text + "','" + gender + "','" + txtAge.Text + "','" + ddlBloodGroup.SelectedValue + "','" + txtEmail.Text + "','" + txtPhone.Text + "','" + txtAddress.Text + "','" + txtUser.Text + "')";
string sqlquery = "INSERT INTO user (UserName, Password, Name, Role) VALUES ('" + txtUser.Text + "','" + txtPassword.Text + "','" + txtName.Text + "','Donor')";
MySQLQuery.ExecNonQry(query);
MySQLQuery.ExecNonQry(sqlquery);
MySQLQuery.ShowMessage("Donor add successfully:", "success", msgLabel);
ClearControls();
LoginInfo.Visible = true;
BindDonorGridView();
}
else
{
MySQLQuery.ShowMessage("User Id already exist! try another user id", "warning", msgLabel);
}
}
else
{
//string query = "INSERT INTO donors (Name,Gender,Age,BloodGroupId, Email, Phone,Address) VALUES ('" + txtName.Text + "','" + gender + "','" + txtAge.Text + "','" + ddlBloodGroup.SelectedValue + "','" + txtEmail.Text + "','" + txtPhone.Text + "','" + txtAddress.Text + "')";
string query = "UPDATE donors SET Name='" + txtName.Text + "',Gender='" + gender + "',Age='" + txtAge.Text + "',BloodGroupId='" + ddlBloodGroup.SelectedValue + "', Email='" + txtEmail.Text + "', Phone='" + txtPhone.Text + "',Address='" + txtAddress.Text + "' WHERE ID='" + Session["Id"] + "'";
MySQLQuery.ExecNonQry(query);
MySQLQuery.ShowMessage("Donor update successfully:", "success", msgLabel);
ClearControls();
btnSave.Text = "Save";
BindDonorGridView();
}
}
catch (Exception ex)
{
MySQLQuery.ShowMessage("ERROR:" + ex.ToString(), "error", msgLabel);
}
}
public async Task RegisterUserInformation(string userNickName)
{
IGuild guild = Context.Guild;
jsonHandler.TokenName = "serverEmoji.heart.name";
jsonHandler.FilePath = "emoji.json";
MySQLQuery createQuery = new MySQLQuery();
string[] userInformation = new string[2];
try
{
userInformation = createQuery.GetUserInformationByNickName(userNickName);
var user = await guild.GetUserAsync(Context.User.Id);
if (userInformation != null && user != null)
{
await user.ModifyAsync(x =>
{
x.Nickname = $"{userInformation[0]} {userInformation[1]}";
});
await Context.Channel.SendMessageAsync($"Successfully registered {userNickName} for {Context.User.Mention}. {jsonHandler.GetJsonToken()}");
}
else
{
await Context.Channel.SendMessageAsync($"{userNickName} cannot be found.");
return;
}
}
catch (Exception ex)
{
logMessage = new LogMessage(
LogSeverity.Critical,
ex.Message,
$"Source: {ex.Source} => {ex.InnerException}"
);
return;
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
string gender = "Male";
if (rdFemale.Checked)
{
gender = "Female";
}
string query = "INSERT INTO `requestes`(`name`, `gender`, `age`, `mobile`, `email`, `bgroup`, `reqdate`, `detail`) VALUES ('" + txtName.Text + "','" + gender + "','" + txtAge.Text + "','" + txtPhone.Text + "','" + txtEmail.Text + "','" + ddlBloodGroup.SelectedValue + "','" + txtDate.Text + "','" + txtDetails.Text + "')";
MySQLQuery.ExecNonQry(query);
MySQLQuery.ShowMessage("Request Submit successfully:", "success", msgLabel);
ClearControls();
BindDonorGridView();
}
catch (Exception ex)
{
MySQLQuery.ShowMessage("ERROR:" + ex.ToString(), "error", msgLabel);
}
}
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;
}
}
private void LoadBloodGroup()
{
string query = "SELECT Id, BloodGroup FROM bloodgroup ORDER By BloodGroup ASC";
MySQLQuery.PopulateDropDown(query, ddlBloodGroup, "Id", "BloodGroup");
}
public void OnPostNext()
{
String Search_User = HttpContext.Session.GetString("Search_User");
String Exception = "";
Boolean CheckConnection = MyOwnMySQLConnectionClass.LoadConnection(ref Exception);
MySqlCommand MySQLQuery = new MySqlCommand();
MySqlDataReader RecordReader;
String Requestor_1 = "";
String Current_User = HttpContext.Session.GetString("User_Name");
String Chat_OFFSET_String = HttpContext.Session.GetString("Chat_OFFSET");
int Chat_OFFSET = int.Parse(Chat_OFFSET_String);
OtherUserList = new List <String> {
};
IDList = new List <String> {
};
if (Search_User != null)
{
if (Chat_OFFSET == 0)
{
Chat_OFFSET += 50;
}
MySQLQuery.CommandText = "SELECT `Requestor_1`,`ID` FROM `DF_Public_Key` WHERE `Requestor_1`=@Current_User AND `Status`=@Status AND `Requestor_2` LIKE '%@Search_User%' LIMIT 50 OFFSET " + Chat_OFFSET.ToString();
MySQLQuery.Parameters.Add("@Search_User", MySqlDbType.Text).Value = Search_User;
MySQLQuery.Parameters.Add("@Current_User", MySqlDbType.Text).Value = Current_User;
MySQLQuery.Parameters.Add("@Status", MySqlDbType.Text).Value = "R1 & R2 had established keys respectively";
MySQLQuery.Connection = MyOwnMySQLConnectionClass.MyMySQLConnection;
MySQLQuery.Prepare();
RecordReader = MySQLQuery.ExecuteReader();
while (RecordReader.Read())
{
Requestor_1 = RecordReader.GetValue(0).ToString();
OtherUserList.Add(Requestor_1);
IDList.Add(RecordReader.GetValue(1).ToString());
}
MyOwnMySQLConnectionClass.MyMySQLConnection.Close();
CheckConnection = MyOwnMySQLConnectionClass.LoadConnection(ref Exception);
MySQLQuery = new MySqlCommand();
MySQLQuery.CommandText = "SELECT `Requestor_2`,`ID` FROM `DF_Public_Key` WHERE `Requestor_2`=@Current_User AND `Status`=@Status AND `Requestor_1` LIKE '%@Search_User%' LIMIT 50 OFFSET " + Chat_OFFSET.ToString();
MySQLQuery.Parameters.Add("@Search_User", MySqlDbType.Text).Value = Search_User;
MySQLQuery.Parameters.Add("@Current_User", MySqlDbType.Text).Value = Current_User;
MySQLQuery.Parameters.Add("@Status", MySqlDbType.Text).Value = "R1 & R2 had established keys respectively";
MySQLQuery.Connection = MyOwnMySQLConnectionClass.MyMySQLConnection;
MySQLQuery.Prepare();
RecordReader = MySQLQuery.ExecuteReader();
while (RecordReader.Read())
{
Requestor_1 = RecordReader.GetValue(0).ToString();
OtherUserList.Add(Requestor_1);
IDList.Add(RecordReader.GetValue(1).ToString());
}
MyOwnMySQLConnectionClass.MyMySQLConnection.Close();
HttpContext.Session.SetString("Chat_OFFSET", (Chat_OFFSET + 50).ToString());
}
else
{
if (Chat_OFFSET == 0)
{
Chat_OFFSET += 50;
}
MySQLQuery.CommandText = "SELECT `Requestor_1`,`ID` FROM `DF_Public_Key` WHERE `Requestor_1`=@Current_User AND `Status`=@Status AND LIMIT 50 OFFSET " + Chat_OFFSET.ToString();
MySQLQuery.Parameters.Add("@Current_User", MySqlDbType.Text).Value = Current_User;
MySQLQuery.Parameters.Add("@Status", MySqlDbType.Text).Value = "R1 & R2 had established keys respectively";
MySQLQuery.Connection = MyOwnMySQLConnectionClass.MyMySQLConnection;
MySQLQuery.Prepare();
RecordReader = MySQLQuery.ExecuteReader();
while (RecordReader.Read())
{
Requestor_1 = RecordReader.GetValue(0).ToString();
OtherUserList.Add(Requestor_1);
IDList.Add(RecordReader.GetValue(1).ToString());
}
MyOwnMySQLConnectionClass.MyMySQLConnection.Close();
CheckConnection = MyOwnMySQLConnectionClass.LoadConnection(ref Exception);
MySQLQuery = new MySqlCommand();
MySQLQuery.CommandText = "SELECT `Requestor_2`,`ID` FROM `DF_Public_Key` WHERE `Requestor_2`=@Current_User AND `Status`=@Status LIMIT 50 OFFSET " + Chat_OFFSET.ToString();
MySQLQuery.Parameters.Add("@Current_User", MySqlDbType.Text).Value = Current_User;
MySQLQuery.Parameters.Add("@Status", MySqlDbType.Text).Value = "R1 & R2 had established keys respectively";
MySQLQuery.Connection = MyOwnMySQLConnectionClass.MyMySQLConnection;
MySQLQuery.Prepare();
RecordReader = MySQLQuery.ExecuteReader();
while (RecordReader.Read())
{
Requestor_1 = RecordReader.GetValue(0).ToString();
OtherUserList.Add(Requestor_1);
IDList.Add(RecordReader.GetValue(1).ToString());
}
MyOwnMySQLConnectionClass.MyMySQLConnection.Close();
HttpContext.Session.SetString("Chat_OFFSET", (Chat_OFFSET + 50).ToString());
}
}
