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