private void removeNegatives_Click(object sender, EventArgs e) { if (DialogResult.Yes == XtraMessageBox.Show("Are you sure you would like to remove the -ve items", "Confirmation", MessageBoxButtons.YesNo)) { Stores strs = new Stores(); strs.LoadAll(); string message = ""; while (!strs.EOF) { Balance balance = new Balance(); DataTable dtbl = balance.GetSOH(strs.ID, 3, 2003); var x = from y in dtbl.AsEnumerable() where Convert.ToDouble(y["SOH"]) < 0 select y; ABC abc = new ABC(); foreach (var b in x) { abc.LoadQuery(string.Format("delete from Disposal where ItemID = {0} and StoreID = {1}", b["ID"], strs.ID)); abc.LoadQuery(string.Format("delete from YearEnd where ItemID = {0} and StoreID = {1}", b["ID"], strs.ID)); abc.LoadQuery(string.Format("delete from IssueDoc where ItemID = {0} and StoreID = {1}", b["ID"], strs.ID)); abc.LoadQuery(string.Format("delete from ReceiveDoc where ItemID = {0} and StoreID = {1}", b["ID"], strs.ID)); } message += string.Format("{0} Items to be deleted from {1} \n", x.Count(), strs.StoreName); strs.MoveNext(); } XtraMessageBox.Show(message); } }
private void btnReset_Click(object sender, EventArgs e) { if (XtraMessageBox.Show(String.Format("Are you sure you want to remove {0}", lkItems.Text), "Confirmation", MessageBoxButtons.YesNo) == DialogResult.Yes) { ABC abc = new ABC(); int storeID = Convert.ToInt32(lkStores.EditValue); int itemID = Convert.ToInt32(lkItems.EditValue); abc.LoadQuery(string.Format("delete from Disposal where ItemID = {0} and StoreID = {1}", itemID, storeID)); abc.LoadQuery(string.Format("delete from YearEnd where ItemID = {0} and StoreID = {1}", itemID, storeID)); abc.LoadQuery(string.Format("delete from IssueDoc where ItemID = {0} and StoreID = {1}", itemID, storeID)); abc.LoadQuery(string.Format("delete from ReceiveDoc where ItemID = {0} and StoreID = {1}", itemID, storeID)); XtraMessageBox.Show("The Item Has been removed!"); lkStores_EditValueChanged(null, null); } }