Inserting Header and Detail Values using c#

Hi all,

I've been developing a system for only 2 years. In other words, I'm still learning until now. One of the applications that I developed involves inserting header and details. My way of doing it is not the best one but I was able to do the task. However, there are times that the header fails to insert to DB but the details succeeded and vice versa. Below are my code snippet and I wish someone can share their ideas on how to make it in such a way that if the header fails, then the details value should not insert to DB and vice versa.

try
{
//for enrollment header
header.SchoolYear = ddlSchoolYear.SelectedItem.Text;
header.EnrollmentID = lblEnrollmentID.Text;
header.StudentID = lblStudentID.Text;
header.GradeLvl = ddlGradeLvl.SelectedItem.Text;
header.EnrollmentFees = Convert.ToDouble(lblTotalFees.Text);
header.Discount = Convert.ToDouble(txtDiscount.Text);
header.PaymentTerms = Convert.ToInt32(ddlTermPayment.SelectedValue);
header.SchoolCode = lblSchoolCode.Text;
header.UserLogs = lblUsername.Text;
insert.InsertEnrollmentHeader(header);
//for enrollment charges
#region ----charges
foreach (GridViewRow row in gvCharges.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
CheckBox Charges = (CheckBox)row.FindControl("cbCharges");
if (Charges != null && Charges.Checked)
{
Label lblChargesID = (Label)row.FindControl("lblChargesID");
charges.ChargesID = Convert.ToInt32(lblChargesID.Text);
charges.EnrollmentID = lblEnrollmentID.Text;
count = insert.InsertEnrollmentCharges(charges);
}
}
}

Thanks in advance.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suraj Kumar8y ago
Accepted answer
Thanks for the help... i found my solution .... i'm using this code and it is working for me !!!!

Hello,

You can check like after insert

int success = insert.InsertEnrollmentHeader(header);

Then for details entry after successfull header entry

if (EnrollmentID >= 1)
{

//Write code below for charges logic
// for enrollment charges
#region ----charges

}

Also make sure in details table the there is a foreign key for header so it will not allow to insert blank or null id.

Thanks
Jes Sie8y ago
Thanks Suraj, I will try this one.