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); } }
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 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); } }
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); } }
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); } }