How Can I Insert New Data To Two Table At A Time ?

Question

3.00/5 (1 vote)

See more:

The two table i am talking abour linked by there ID which is Order.Order_ID and Order_Item.Order_ID

i try to do many solution in the internet and it not seem to work. my code just insert all the data i

need into that two table but ! Order_Item.Order_ID is still null. can anyone help please.

PS. the Order.Order_ID is identity specification so it will get the id only when the data is insert.

Here is MY Code

C#

private void addReceiptCommandClick(object obj)
        {

            Order neworder = new Order();

            neworder.A_ID = admin_Name.A_ID;
            neworder.O_Date = o_Date;
            neworder.Order_ShowName = order_ShowID;
            neworder.Order_Price = order_NetPrice;
            neworder.O_Status = Status.StatusX;
            Context.Add(neworder);
            //selectedsupplier = Context.Suppliers.Where(S => S.Sup_Name == sup_Name).FirstOrDefault();
            neworder.Sup_ID = s_Name.Sup_ID;
            Context.Add(neworder);
            //Context.SaveChanges();
            foreach (Order_Item item in Order_Item)
            {
                
                item.O_ID = neworder.Order_ID;
                selectedproduct = Context.Products.Where(Pro => Pro.P_ShowID == item.P_Code).FirstOrDefault();
                Lot_Stock newlot = new Lot_Stock();
                newlot.Lot_Name = item.Lot_Code;
                newlot.Price = item.Price;
                newlot.Date = o_Date;
                newlot.Quantity = item.Quantity;
                neworder.Order_Items.Add(item);
                
               //newdetail.Order_ID = neworder.Order_ID;
            }
            Context.SaveChanges();
        }

Posted 13-Sep-14 5:09am

Real_Criffer

Updated 13-Sep-14 9:09am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

mhegazy94 · Accepted Answer · 2014-09-14T01:39:00

Consider that you make item.O_ID = neworder.Order_ID which has no value assinged ,
if neworder.Order_ID is Identity you have to get it before assigning it's value to OrderItem

private void addReceiptCommandClick(object obj)
{

Order neworder = new Order();
neworder.Order_ID = Context.Order.Max().ID+1; // will get the value if column is not identity
neworder.A_ID = admin_Name.A_ID;
neworder.O_Date = o_Date;
neworder.Order_ShowName = order_ShowID;
neworder.Order_Price = order_NetPrice;
neworder.O_Status = Status.StatusX;
Context.Add(neworder);
//selectedsupplier = Context.Suppliers.Where(S => S.Sup_Name == sup_Name).FirstOrDefault();
neworder.Sup_ID = s_Name.Sup_ID;
Context.Add(neworder);
//Context.SaveChanges();
foreach (Order_Item item in Order_Item)
{

item.O_ID = neworder.Order_ID;
selectedproduct = Context.Products.Where(Pro => Pro.P_ShowID == item.P_Code).FirstOrDefault();
Lot_Stock newlot = new Lot_Stock();
newlot.Lot_Name = item.Lot_Code;
newlot.Price = item.Price;
newlot.Date = o_Date;
newlot.Quantity = item.Quantity;
neworder.Order_Items.Add(item);

//newdetail.Order_ID = neworder.Order_ID;
}
Context.SaveChanges();
}