public QCReportDetails Get(long ID)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@TestDetailsID", ID)
};
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_QCReportDetails_ID", paramList);
QCReportDetails obj = new QCReportDetails();
if (dt.Rows.Count > 0)
{
obj.Acceptence = Convert.ToBoolean(dt.Rows[0]["Acceptence"]);
obj.Comment = Convert.ToString(dt.Rows[0]["Comment"]);
obj.MaterialCode = Convert.ToString(dt.Rows[0]["MaterialCode"]);
obj.QCReportID = Convert.ToInt64(dt.Rows[0]["QCReportID"]);
obj.Result = Convert.ToString(dt.Rows[0]["Result"]);
obj.TestDetailsID = Convert.ToInt64(dt.Rows[0]["TestDetailsID"]);
obj.TestParameterID = Convert.ToInt64(dt.Rows[0]["TestParameterID"]);
}
return(obj);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
private void gvTest_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
try
{
long ID = Convert.ToInt64(gvTest.Rows[e.RowIndex].Cells["colTestDetailsID"].Value);
if (ID > 0)
{
objQCReportDetails = objQCReportDetails_DL.Get(ID);
if (objQCReportDetails != null)
{
cbAccept.Checked = objQCReportDetails.Acceptence;
txtComment.Text = objQCReportDetails.Comment;
cmbMaterial.SelectedValue = objQCReportDetails.MaterialCode;
cmbParameter.SelectedValue = objQCReportDetails.TestParameterID;
txtResult.Text = objQCReportDetails.Result;
txtTestID.Text = objQCReportDetails.TestDetailsID.ToString();
btnDelete.Enabled = true;
}
}
}
catch (Exception)
{
MessageBox.Show(this, "Erro occured while selecting Test Details", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
private void ClearDetails()
{
cbAccept.Checked = true;
txtComment.Text = "";
cmbMaterial.SelectedIndex = 0;
cmbParameter.SelectedIndex = 0;
txtResult.Text = "";
txtTestID.Text = "[Auto]";
objQCReportDetails = null;
btnDelete.Enabled = false;
bindDetails.DataSource = objQCReportDetails_DL.GetView(objQCReport.QCReportID);
}
private void btnSaveTest_Click(object sender, EventArgs e)
{
try
{
if (objQCReport != null)
{
if (objQCReportDetails == null)
{
objQCReportDetails = new QCReportDetails();
}
objQCReportDetails.Acceptence = cbAccept.Checked;
objQCReportDetails.Comment = txtComment.Text;
if (cmbMaterial.SelectedValue != null)
{
objQCReportDetails.MaterialCode = cmbMaterial.SelectedValue.ToString();
}
else
{
objQCReportDetails.MaterialCode = "No";
}
objQCReportDetails.QCReportID = objQCReport.QCReportID;
objQCReportDetails.Result = txtResult.Text;
objQCReportDetails.TestParameterID = Convert.ToInt64(cmbParameter.SelectedValue);
long ID = objQCReportDetails_DL.Add(objQCReportDetails);
if (ID > 0)
{
ClearDetails();
}
}
}
catch (Exception)
{
MessageBox.Show(this, "Error occured while saving details", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public long Add(QCReportDetails obj)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@QCReportID", obj.QCReportID),
new SqlParameter("@TestParameterID", obj.TestParameterID),
new SqlParameter("@Result", obj.Result),
new SqlParameter("@MaterialCode", obj.MaterialCode),
new SqlParameter("@Comment", obj.Comment),
new SqlParameter("@Acceptence", obj.Acceptence),
new SqlParameter("@outParam", SqlDbType.Int)
{
Direction = ParameterDirection.Output
}
};
return(Execute.RunSP_RowsEffected(Connection, "SPADD_QCReportDetails_Update", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}