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