private void MIeditHeader_Click(object sender, EventArgs e)
{
if (dgvHeaders.SelectedRows.Count > 0)
{
int HeaderId = Convert.ToInt32(dgvHeaders.SelectedRows[0].Cells["HeaderId"].Value.ToString());
FIHeader selectedHeader = Audit_Headers.Where(i => i.Id == HeaderId).First();
//Audit selectedAudit = auditList.Where(i => i.Id == selAuditId).First();
FIHeaderEdit frmHeaderEdit = new FIHeaderEdit(glAudit, selectedHeader);
frmHeaderEdit.ShowDialog();
if (frmHeaderEdit.success)
{
Audit_Headers = SelectHeaders(glAudit.Id);
if (AdminAccess == false)
{
Audit_Headers = Audit_Headers.Where(i => i.IsDeleted == false).ToList();
}
FillHeadersDataGridView(dgvHeaders, Audit_Headers);
}
}
}
public FIDetailEdit(FIHeader fiHeader, FIDetail fIDetail) //update
{
InitializeComponent();
Init();
ArrangeHeaderFields(fiHeader);
isInsert = false;
currentHeader = fiHeader;
txtDescription.Text = fIDetail.Description;
txtActionReq.Text = fIDetail.ActionReq;
txtActionCode.Text = fIDetail.ActionCode;
dtpActionDate.Value = fIDetail.ActionDt;
fIDetail.Owners = fIDetail.getOwners(fIDetail.Id, fIDetail.RevNo);
foreach (Users thisOwner in fIDetail.Owners)
{
dgvOwners.Rows.Add(new object[] { thisOwner.Id, thisOwner.FullName, thisOwner.RoleName });
}
oldFIDetailRecord = fIDetail;
}
private void MIeditDetail_Click(object sender, EventArgs e)
{
if (dgvDetails.SelectedRows.Count > 0)
{
int DetailId = Convert.ToInt32(dgvDetails.SelectedRows[0].Cells["DetailId"].Value.ToString());
FIDetail selectedDetail = Header_Details.Where(i => i.Id == DetailId).First();
int HeaderId = Convert.ToInt32(dgvHeaders.SelectedRows[0].Cells["HeaderId"].Value.ToString());
FIHeader selectedHeader = Audit_Headers.Where(i => i.Id == HeaderId).First();
FIDetailEdit frmDetailEdit = new FIDetailEdit(selectedHeader, selectedDetail);
frmDetailEdit.ShowDialog();
if (frmDetailEdit.success)
{
Header_Details = SelectDetails(selectedHeader.Id);
if (AdminAccess == false)
{
Header_Details = Header_Details.Where(i => i.IsDeleted == false).ToList();
}
FillDetailsDataGridView(dgvDetails, Header_Details);
}
}
}
public FIDetail_Revisions(Audit givenAudit, FIHeader givenHeader, int detailId)
{
InitializeComponent();
glAudit = givenAudit;
glHeader = givenHeader;
DetailRevList = SelectDetailsRev(detailId);
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtHeaderTitle.Text.Trim() == "")
{
MessageBox.Show("Please insert a Title!");
return;
}
if (cbCategory.Text.Trim() == "")
{
MessageBox.Show("Please choose a Category!");
return;
}
newFIHeaderRecord = new FIHeader()
{
Id = oldFIHeaderRecord.Id,
Title = txtHeaderTitle.Text,
FICategory = InsertNewAudit.getComboboxItem <FICategory>(cbCategory),
FICategoryId = InsertNewAudit.getComboboxItem <FICategory>(cbCategory).Id,
AuditId = currentAudit.Id
};
if (isInsert) //insert
{
if (InsertIntoTable_FIHeader(newFIHeaderRecord))
{
MessageBox.Show("New F/I Header inserted successfully!");
success = true;
Close();
}
else
{
MessageBox.Show("The New F/I Header has not been inserted!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else //update
{
if (FIHeader.isEqual(oldFIHeaderRecord, newFIHeaderRecord) == false)
{
if (UpdateTable_Headers(newFIHeaderRecord))
{
success = true;
MessageBox.Show("Header updated successfully!");
Close();
}
else
{
MessageBox.Show("The F/I Header has not been updated!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
Close();
}
}
}
public FIDetailEdit(FIHeader fiHeader) //insert
{
InitializeComponent();
Init();
ArrangeHeaderFields(fiHeader);
isInsert = true;
currentHeader = fiHeader;
}
private void MIDetailRevisions_Click(object sender, EventArgs e)
{
if (dgvDetails.SelectedRows.Count > 0)
{
int HeaderId = Convert.ToInt32(dgvHeaders.SelectedRows[0].Cells["HeaderId"].Value.ToString());
FIHeader selectedHeader = Audit_Headers.Where(i => i.Id == HeaderId).First();
int DetailId = Convert.ToInt32(dgvDetails.SelectedRows[0].Cells["DetailId"].Value.ToString());
FIDetail selectedDetail = Header_Details.Where(i => i.Id == DetailId).First();
FIDetail_Revisions frmFIDetailRev = new FIDetail_Revisions(glAudit, selectedHeader, selectedDetail.Id);
frmFIDetailRev.ShowDialog();
}
}
public FIHeaderEdit(Audit audit, FIHeader fiHeader) //Update
{
InitializeComponent();
ArrangeAuditFields(audit);
Init();
isInsert = false;
currentAudit = audit;
txtHeaderTitle.Text = fiHeader.Title;
cbCategory.SelectedIndex = cbCategory.FindStringExact(fiHeader.FICategory.Name);
oldFIHeaderRecord = fiHeader;
}
public static void FillHeadersDataGridView(DataGridView dgv, FIHeader Header)
{
dgv.Rows.Clear();
List <dgvDictionary> dgvDictList = new List <dgvDictionary>();
dgvDictList.Add(new dgvDictionary()
{
dbfield = Header.Id, dgvColumnHeader = "HeaderId"
});
dgvDictList.Add(new dgvDictionary()
{
dbfield = Header.Title, dgvColumnHeader = "HeaderTitle"
});
dgvDictList.Add(new dgvDictionary()
{
dbfield = Header.FICategory.Name, dgvColumnHeader = "HeaderCategory"
});
dgvDictList.Add(new dgvDictionary()
{
dbfield = Header.UpdUser.FullName, dgvColumnHeader = "HeaderUpdUser"
});
dgvDictList.Add(new dgvDictionary()
{
dbfield = Header.UpdDt.ToString("dd.MM.yyyy HH:mm:ss"), dgvColumnHeader = "HeaderUpdDt"
});
dgvDictList.Add(new dgvDictionary()
{
dbfield = Header.IsDeleted, dgvColumnHeader = "HeaderIsDeleted"
});
object[] obj = new object[dgv.Columns.Count];
for (int i = 0; i < dgv.Columns.Count; i++)
{
obj[i] = dgvDictList.Where(z => z.dgvColumnHeader == dgv.Columns[i].Name).First().dbfield;
}
dgv.Rows.Add(obj);
dgv.ClearSelection();
}
private bool UpdateTable_Headers(FIHeader header)
{
bool ret = false;
SqlConnection sqlConn = new SqlConnection(SqlDBInfo.connectionString);
string InsSt = "UPDATE [dbo].[FIHeader] SET [Title] = encryptByPassPhrase(@passPhrase, convert(varchar(500), @Title)), [FICategoryId] = @FICategoryId, [UpdUserId] = @UpdUserId, " +
"[UpdDt] = getDate() " +
"WHERE id=@id";
try
{
sqlConn.Open();
SqlCommand cmd = new SqlCommand(InsSt, sqlConn);
cmd.Parameters.AddWithValue("@passPhrase", SqlDBInfo.passPhrase);
cmd.Parameters.AddWithValue("@id", header.Id);
cmd.Parameters.AddWithValue("@FICategoryId", header.FICategoryId);
cmd.Parameters.AddWithValue("@Title", header.Title);
cmd.Parameters.AddWithValue("@UpdUserId", UserInfo.userDetails.Id);
cmd.CommandType = CommandType.Text;
int rowsAffected = cmd.ExecuteNonQuery();
if (rowsAffected > 0)
{
ret = true;
}
}
catch (Exception ex)
{
MessageBox.Show("The following error occurred: " + ex.Message);
}
sqlConn.Close();
return(ret);
}
private bool InsertIntoTable_FIHeader(FIHeader fiHeader) //INSERT [dbo].[FIHeader]
{
bool ret = false;
SqlConnection sqlConn = new SqlConnection(SqlDBInfo.connectionString);
string InsSt = "INSERT INTO [dbo].[FIHeader] ([AuditId],[Title],[FICategoryId] ,[InsUserId], [InsDt],[UpdUserId], [UpdDt]) VALUES " +
"(@AuditId,encryptByPassPhrase(@passPhrase, convert(varchar(500), @Title)), " +
"@FICategoryId, @InsUserId, getDate(), @InsUserId, getDate() ) ";
try
{
sqlConn.Open();
SqlCommand cmd = new SqlCommand(InsSt, sqlConn);
cmd.Parameters.AddWithValue("@passPhrase", SqlDBInfo.passPhrase);
cmd.Parameters.AddWithValue("@AuditId", fiHeader.AuditId);
cmd.Parameters.AddWithValue("@Title", fiHeader.Title);
cmd.Parameters.AddWithValue("@FICategoryId", fiHeader.FICategoryId);
cmd.Parameters.AddWithValue("@InsUserId", UserInfo.userDetails.Id);
cmd.CommandType = CommandType.Text;
int rowsAffected = cmd.ExecuteNonQuery();
if (rowsAffected > 0)
{
ret = true;
}
}
catch (Exception ex)
{
MessageBox.Show("The following error occurred: " + ex.Message);
}
sqlConn.Close();
return(ret);
}
private void ArrangeHeaderFields(FIHeader selectedHeader)
{
txtHeaderTitle.Text = selectedHeader.Title;
txtCategory.Text = selectedHeader.FICategory.Name;
}
