private void buttonDrugDelete_Click(object sender, EventArgs e)
{
//----------------------Delete Drug Form PharmasyTable
string drugId = textBoxDrugIdDelete.Text;
if (drugId != "")
{
//---------------------------------------Query For found Id Exist in database
string query = "Select COUNT (*) FROM PharmasyTable WHERE Id= '" + drugId + "'";
DataTable dt = new DataTable();
ClassCommon.SqlC_DAOpenFillCose(query, dt);
string truevalue = dt.Rows[0][0].ToString();
if (truevalue == "1")
{
//Database
ClassDelete.DeleteDrugItem(drugId);
MessageBox.Show("Success");
buttonShowPharmasyList_Click(sender, e);
}
else
{
MessageBox.Show("ID " + drugId + " Not Found");
}
}
else
{
MessageBox.Show("Please Fill All Field");
}
}
public void GetXmlTest()
{
string expected = @"<?xml version=""1.0"" encoding=""utf-8""?>
<function controlid=""unittest"">
<delete_class key=""C1234"" />
</function>";
Stream stream = new MemoryStream();
XmlWriterSettings xmlSettings = new XmlWriterSettings();
xmlSettings.Encoding = Encoding.UTF8;
xmlSettings.Indent = true;
xmlSettings.IndentChars = " ";
IaXmlWriter xml = new IaXmlWriter(stream, xmlSettings);
ClassDelete record = new ClassDelete("unittest");
record.ClassId = "C1234";
record.WriteXml(ref xml);
xml.Flush();
stream.Position = 0;
StreamReader reader = new StreamReader(stream);
Diff xmlDiff = DiffBuilder.Compare(expected).WithTest(reader.ReadToEnd())
.WithDifferenceEvaluator(DifferenceEvaluators.Default)
.Build();
Assert.IsFalse(xmlDiff.HasDifferences(), xmlDiff.ToString());
}
private void buttonDeleteDonorInfo_Click(object sender, EventArgs e)
{
//----------------------Delete Donor from Donor Table
string DonorMobile = textBoxDonorIDtoDelete.Text;
if (DonorMobile != "")
{
//---------------------------------------Query For found Id Exist in database
string query = "Select COUNT (*) FROM DonorTable WHERE Mobile= '" + DonorMobile + "'";
DataTable dt = new DataTable();
ClassCommon.SqlC_DAOpenFillCose(query, dt);
string truevalue = dt.Rows[0][0].ToString();
if (truevalue == "1")
{
//Database
ClassDelete.DeleteDonor(DonorMobile);
MessageBox.Show("Success");
buttonShowDonorList_Click(sender, e);
}
else
{
MessageBox.Show("ID " + DonorMobile + " Not Found");
}
}
else
{
MessageBox.Show("Please Fill Field");
}
}
/// <summary>
/// Delete specified Class
/// </summary>
/// <param name="ClassType">Type of Class</param>
/// <param name="ClassNum">Class name</param>
/// <returns>Success message or <code>null</code> on error</returns>
public ClassDeleteResponse Delete(string ClassType, string ClassNum)
{
var Delete = new ClassDelete
{
ClassType = ClassType,
ClassNum = ClassNum
};
return(_sapClass.ClassDelete(Delete));
}
public void TestManageDeleteCondition()
{
string query = @"DELETE FROM myTable WHERE id=1;";
ClassParsing myClass = new ClassParsing();
string name = "myTable";
string condition = "id=1";
ClassDelete myDeletedTable = new ClassDelete(name, condition);
Assert.AreEqual(myClass.ManageDelete(query).getCondition(), myDeletedTable.getCondition());
}
public void GetXmlTest()
{
string expected = @"<?xml version=""1.0"" encoding=""utf-8""?>
<function controlid=""unittest"">
<delete_class key=""C1234"" />
</function>";
ClassDelete record = new ClassDelete("unittest")
{
ClassId = "C1234",
};
this.CompareXml(expected, record);
}
public ClassDelete ManageDelete(string pQuery)
{
Match delete = Regex.Match(pQuery, Constants.regExDelete);
if (delete.Success)
{
;
string Table = delete.Groups[1].Value;
string Condition = delete.Groups[2].Value;
ClassDelete query = new ClassDelete(Table, Condition);
return(query);
}
return(null);
}
private void buttonDeleteAccountPermamently_Click(object sender, EventArgs e)
{
//---------------Confirmation for Delete Account Permanently
string message = "Sure To Delete Account??";
string title = "Admin Account Delete Confirmation";
MessageBoxButtons buttons = MessageBoxButtons.YesNo;
DialogResult result = MessageBox.Show(message, title, buttons);
if (result == DialogResult.Yes)
{
ClassDelete.DeleteAdminAccount(adminUsername);
MessageBox.Show("Success");
Application.Exit();
}
}
