private void btnQCDone_Click(object sender, EventArgs e)
{
try
{
if (dgvReactions.Rows.Count > 0)
{
List <int> lstRxnIDs = GetSelectedRxnIDsFromGrid();
if (lstRxnIDs != null)
{
if (ReactionCurationDB.UpdateReactionsQCCompleteStatus(ShipmentRefID, lstRxnIDs, GlobalVariables.UR_ID))
{
//Refresh Reactions table
ReactionInfo objReactionInfo = new ReactionInfo();
objReactionInfo.ShipmentRefID = ShipmentRefID;
DataTable dtReaction = new DataTable();
ReactionCurationDB.SaveReactionInfo(DmlOperations.SELECT, objReactionInfo, out dtReaction);
DataTable dtNonQcRxns = GetQcNotCompletedReactionsFromTable(dtReaction);
if (dtNonQcRxns != null)
{
if (dtNonQcRxns.Rows.Count == 0)
{
QC_Done = true;
DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
}
else
{
BindNonQCReactionsToGrid(dtNonQcRxns);
}
}
//else
//{
// QC_Done = true;
// DialogResult = System.Windows.Forms.DialogResult.OK;
// this.Close();
//}
}
}
}
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.ToString());
}
}
private void btnCreateRxn_Click(object sender, EventArgs e)
{
try
{
DataTable dtReactions = null;
int newRxnSNo = 0;
if (cmbRxnNo.SelectedItem != null)
{
int selRxnNo = Convert.ToInt32(cmbRxnNo.Text);
newRxnSNo = rbnAfter.Checked ? selRxnNo + 1 : selRxnNo;
}
else if (ReactionsTbl.Rows.Count == 0)
{
newRxnSNo = 1;
}
if (!chkDuplicateWithRxn.Checked)//New Reaction
{
ReactionInfo rxnInfo = new ReactionInfo();
rxnInfo.ShipmentRefID = ShipmentRefID;
rxnInfo.ReactionSNo = newRxnSNo;
rxnInfo.UR_ID = GlobalVariables.UR_ID;
if (ReactionCurationDB.SaveReactionInfo(DmlOperations.INSERT, rxnInfo, out dtReactions))
{
ReactionsTbl = dtReactions;
DialogResult = System.Windows.Forms.DialogResult.OK;
var query = from r in dtReactions.AsEnumerable()
where r.Field <Int64>("REACTION_SNO") == newRxnSNo
select new
{
NewRxn_Id = r["REACTION_ID"]
};
if (query != null)
{
NewRxnID = Convert.ToInt32(query.ElementAt(0).NewRxn_Id);
NewRxnSNo = newRxnSNo;
}
DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
}
else
{
MessageBox.Show("Error in adding new reaction", GlobalVariables.MessageCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else //Duplicate Reaction
{
DialogResult diaRes = MessageBox.Show("Do you want to duplicate the reaction?", GlobalVariables.MessageCaption, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (diaRes == System.Windows.Forms.DialogResult.Yes)
{
int dupRxnID = cmbDuplicateWithRxn.SelectedItem != null?Convert.ToInt32(cmbDuplicateWithRxn.SelectedValue) : 0;
int newRxnID = ReactionCurationDB.DuplicateReactionData(ShipmentRefID, dupRxnID, newRxnSNo, GlobalVariables.UR_ID);
if (newRxnID > 0)
{
NewRxnID = newRxnID;
NewRxnSNo = newRxnSNo;
DuplicateRxn = true;
DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
}
else
{
MessageBox.Show("Error in duplicating reaction", GlobalVariables.MessageCaption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
catch (Exception ex)
{
ErrorHandling.WriteErrorLog(ex.ToString());
}
}