public int addDetails(bDetails details)
{
var newDetails = new billingDetail
{
OrderID = details.Order_ID,
User_ID = details.User_ID,
Name = details.Name,
Surname = details.Surname,
Email = details.Email,
Province = details.Province,
House_Adress = details.House_Adress,
Street_Adress = details.Street_Adress,
City = details.City,
ZIP = details.ZIP,
Phone = details.Phone
};
db.billingDetails.InsertOnSubmit(newDetails);
try
{
db.SubmitChanges();
return(1);
}
catch (Exception e)
{
e.GetBaseException();
return(0);
}
}
public bDetails getBillDetail(int order)
{
billingDetail detail = (from det in db.billingDetails
where det.OrderID.Equals(order)
select det).FirstOrDefault();
bDetails details = new bDetails
{
User_ID = detail.User_ID,
Order_ID = detail.OrderID,
City = detail.City,
Email = detail.Email,
House_Adress = detail.House_Adress,
Name = detail.Name,
Phone = detail.Phone,
Province = detail.Province,
Street_Adress = detail.Street_Adress,
Surname = detail.Surname,
ZIP = detail.ZIP
};
return(details);
}
