Save (Insert) record in Parent and Child tables in ASP.Net using Entity Framework

ramco191...

SOLVED CLOSED ACTIVE ANSWERED
User: ramco1917
Posted: on Sep 09, 2022 03:19 AM
Forum: Entity Framework
Answer: 1
Views: 3549

In below code i am saving Data in Master table first & then Lines table. I want that Data should get saved simultaneously in both tables.

If error is encountered at any stage then Data should Rollback in both tables.

protected void btnSubmit_Click(object sender, EventArgs e) 
{ 
    string Id = (sender as Button).ID; 
    try 
    { 
        BALTrainingHeader bALTrainingHeader = new BALTrainingHeader();
 
        DateTime? dtFrom = null; 
        DateTime? dtTo = null; 
        if (hdfID.Value == "0") 
        { 
            if (txtdtFrom.Text.Trim() != "") 
            { 
                DateTime PMDate2 = DateTime.ParseExact(txtdtFrom.Text, "dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture); 
                dtFrom = Convert.ToDateTime(PMDate2.ToString("yyyy-MM-dd")); 
            } 
 
            if (txtdtTo.Text.Trim() != "") 
            { 
                DateTime PMDate2 = DateTime.ParseExact(txtdtTo.Text, "dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture); 
                dtTo = Convert.ToDateTime(PMDate2.ToString("yyyy-MM-dd")); 
            }
 
            if (dtTo < dtFrom) 
            { 
                ShowMessage("Error", "Date To should be greather than or equal to Date From, Please Try Again", "error"); 
                return; 
            }
            DateTime StartTime = DateTime.Now; 
            String frTime = ddlTimeFrom.SelectedItem.Value; 
            var frts = TimeSpan.Parse(frTime); 
            String toTime = ddlTimeTo.SelectedItem.Value; 
            var tots = TimeSpan.Parse(toTime);
 
            if (dtTo == dtFrom) 
            { 
                if (tots <= frts) 
                { 
                    ShowMessage("Error", "To Time should be greather than From Time", "error"); 
                    return; 
                } 
            }
 
            TrainingHeader Result = bALTrainingHeader.GetRecordDetails(Convert.ToInt32(hdfTrainingId.Value)); 
            Result.TrainingTypeID = Convert.ToInt32(ddlTrainingType.SelectedItem.Value); 
            Result.TrainingModuleID = Convert.ToInt32(ddlTrainingModule.SelectedItem.Value); 
            Result.FromDate = dtFrom; 
            Result.FromTime = frts; 
            Result.ToDate = dtTo; 
            Result.ToTime = tots; 
            Result.UserRemarks = txtRemarks.Text; 
            if (Id == "btnSubmit") 
            { 
                Result.TrainingStatus = "Open"; 
            } 
            else 
            { 
                Result.TrainingStatus = "Drafted"; 
            }
 
            Result.Deleted = false; 
            Result.ModifiedOn = Utility.CurrentDateTime(); 
            int Res = bALTrainingHeader.UpdateRecord(Result); 
            if (Res != 0) 
            { 
                bALTrainingHeader.DeleteRecordParticipants(Convert.ToInt32(hdfTrainingId.Value)); 
                if (lstUsers.Items.Count > 0) 
                { 
                    for (int i = 0; i < lstUsers.Items.Count; i++) 
                    { 
                        if (lstUsers.Items[i].Selected) 
                        { 
                            TrainingParticipant objLine = new TrainingParticipant(); 
                            objLine.TrainingID = Convert.ToInt32(hdfTrainingId.Value); 
                            objLine.ParticipantID = Convert.ToInt32(lstUsers.Items[i].Value); 
                            objLine.TrainingParticipantType = ddlWhom.SelectedItem.Value; 
                            objLine.Deleted = false; 
                            objLine.EntryDate = Utility.CurrentDateTime(); 
                            int objResult = bALTrainingHeader.AddRecordParticipant(objLine);
                        } 
                    } 
                    ShowMessageWithRedirect("", "Record Saved Successfully", "success", "DraftedTrainingList"); 
                } 
            } 
        }
    } 
    catch (Exception ex) 
    { 
        Utility.SaveErrorLog(ex.Message, System.IO.Path.GetFileName(Request.Path), System.Reflection.MethodBase.GetCurrentMethod().Name, hdfEmpNumber.Value); 
        ShowMessage("Oops...", ex.Message, "error"); 
    } 
}

Thanks

Download FREE API for Word, Excel and PDF in ASP.Net

KasimA

0 2

Reply
ANSWER
User: KasimA
Replied: on Sep 12, 2022 08:26 AM
Modified: on Sep 13, 2022 01:05 AM
Report

Hi ramco1917,

Please refer below sample.

Database

I have made use of the following table Customers with the schema as follows.

I have already inserted few records in the table.

You can download the database table SQL by clicking the download link below.

Download SQL file

HTML

Name:<br />
<asp:TextBox ID="txtName" runat="server"></asp:TextBox><br /><br />
Country:<br />
<asp:TextBox ID="txtCountry" runat="server"></asp:TextBox><br /><br />
Status:<br />
<asp:DropDownList ID="ddlStatus" runat="server">
    <asp:ListItem Text="Select Status" />
    <asp:ListItem Text="P" Value="P" />
    <asp:ListItem Text="A" Value="A" />
</asp:DropDownList><br /><br />
Remark:<br />
<asp:TextBox ID="txtRemark" runat="server"></asp:TextBox><br /><br />
<asp:Button ID="btnSubmit" runat="server" Text="Submit" OnClick="Insert" />

Namespaces

using System.Data.Common;

VB.Net

Imports System.Data.Common

Code

C#

protected void Insert(object sender, EventArgs e)
{
    AjaxSamplesEntities entity = new AjaxSamplesEntities();
    entity.Connection.Open();
    using (DbTransaction transaction = entity.Connection.BeginTransaction())
    {
        try
        {
            Customer customer = new Customer { Name = txtName.Text, Country = txtCountry.Text };

            entity.Customers.AddObject(customer);
            entity.SaveChanges();

            Teacher teacher = new Teacher
            {
                CustomerID = customer.CustomerId,
                Status = ddlStatus.SelectedItem.Value,
                Remark = txtRemark.Text
            };
            entity.Teachers.AddObject(teacher);
            entity.SaveChanges();
            transaction.Commit();
        }
        catch (Exception ex)
        {
            transaction.Rollback();
        }
    }
}

VB.Net

Protected Sub Insert(ByVal sender As Object, ByVal e As EventArgs)
    Dim entity As AjaxSamplesEntities = New AjaxSamplesEntities()
    entity.Connection.Open()
    Using transaction As DbTransaction = entity.Connection.BeginTransaction()
        Try
            Dim customer As Customer = New Customer With {
                .Name = txtName.Text,
                .Country = txtCountry.Text
            }
            entity.Customers.AddObject(customer)
            entity.SaveChanges()
            Dim teacher As Teacher = New Teacher With {
                .CustomerID = customer.CustomerId,
                .Status = ddlStatus.SelectedItem.Value,
                .Remark = txtRemark.Text
            }
            entity.Teachers.AddObject(teacher)
            entity.SaveChanges()
            transaction.Commit()
        Catch ex As Exception
            transaction.Rollback()
        End Try
    End Using
End Sub

Screenshot

Output

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Save (Insert) record in Parent and Child tables in ASP.Net using Entity Framework

C#

Company

Explore

Follow us

Contact Us