/// <summary> /// Delete a row of adjustmen /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void DeleteToolStripMenuItem_Click(object sender, EventArgs e) { var us = new User(); var userID = MainWindow.LoggedinId; us.LoadByPrimaryKey(userID); var dataRow = gridView1.GetFocusedDataRow(); if (dataRow == null) { return; } if (us.UserName != "admin") { XtraMessageBox.Show("You don't have the privilege to update reference number!", "Caution"); return; } //get the primary key of the row var ID = Convert.ToInt32(dataRow["ID"]); var disposal = new Disposal(); var receiveDoc = new ReceiveDoc(); //Retrieve the adjustment with the value of the primary key(id) disposal.LoadByPrimaryKey(ID); int recieveID = disposal.RecID; receiveDoc.LoadByPrimaryKey(recieveID); if (XtraMessageBox.Show("Are You Sure, You want to delete this?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { //check for losss if (disposal.Losses) //it was loss { receiveDoc.LoadByPrimaryKey(recieveID); var s = receiveDoc.Quantity; receiveDoc.Quantity = receiveDoc.Quantity + disposal.Quantity; receiveDoc.QuantityLeft = receiveDoc.QuantityLeft + disposal.Quantity; if (receiveDoc.Out) { receiveDoc.Out = false; } disposal.Quantity = 0; } else // it was adjustment { receiveDoc.LoadByPrimaryKey(recieveID); var s = receiveDoc.Quantity; receiveDoc.Quantity = receiveDoc.Quantity - disposal.Quantity; receiveDoc.QuantityLeft = receiveDoc.QuantityLeft - disposal.Quantity; if (receiveDoc.Quantity == 0) { receiveDoc.Out = true; } disposal.Quantity = 0; } // proceed deletion and make the necessary changes on the database tables. DisposalDelete ddel; AddDeletedDisposal(disposal, out ddel); receiveDoc.Save(); disposal.MarkAsDeleted(); disposal.Save(); //Repopulate the grid DataTable dtRec; dtFrom.CustomFormat = "MM/dd/yyyy"; dtTo.CustomFormat = "MM/dd/yyyy"; DateTime from = ConvertDate.DateConverter(dtFrom.Text); DateTime to = ConvertDate.DateConverter(dtTo.Text); dtRec = disposal.GetTransactionByDateRange(Convert.ToInt32(cboStores.EditValue), from, to); gridAdjustments.DataSource = dtRec; } }