public static Orders InsertUpdate(HAYDENContext context, Orders iOrders)
{
var ExternalContext = false;
if (context == null)
{
context = new HAYDENContext();
}
else
{
ExternalContext = true;
}
Orders item = null;
if (iOrders.OrdersId <= 0)
{
item = new Orders();
}
else
{
item = GetById(context, iOrders.OrdersId);
}
if (item != null)
{
item.OrdersId = iOrders.OrdersId;
item.OrderNoInternal = iOrders.OrderNoInternal;
item.OrderNoCustomer = iOrders.OrderNoCustomer;
item.OrderDate = iOrders.OrderDate;
item.CustomerId = iOrders.CustomerId;
item.RequiredDate = iOrders.RequiredDate;
item.ShippedDate = iOrders.ShippedDate;
item.OrderStatus = iOrders.OrderStatus;
item.Comment = iOrders.Comment;
if (iOrders.OrdersId <= 0)
{
context.Orders.Add(item);
}
if (!ExternalContext)
{
context.SaveChanges();
}
return(item);
}
return(null);
}
public static OrdersDetails InsertUpdate(HAYDENContext context, OrdersDetails iOrdersDetail)
{
var ExternalContext = false;
if (context == null)
{
context = new HAYDENContext();
}
else
{
ExternalContext = true;
}
OrdersDetails item = null;
if (iOrdersDetail.OrdersDetailsId <= 0)
{
item = new OrdersDetails();
}
else
{
item = GetById(context, iOrdersDetail.OrdersDetailsId);
}
if (item != null)
{
item.OrdersDetailsId = iOrdersDetail.OrdersDetailsId;
item.OrdersId = iOrdersDetail.OrdersId;
item.ProductsId = iOrdersDetail.ProductsId;
item.MaterialCode = iOrdersDetail.MaterialCode;
item.Size = iOrdersDetail.Size;
item.Qtyrequested = iOrdersDetail.Qtyrequested;
item.Qtyshipped = iOrdersDetail.Qtyshipped;
item.Comment = iOrdersDetail.Comment;
if (iOrdersDetail.OrdersDetailsId <= 0)
{
context.OrdersDetails.Add(item);
}
if (!ExternalContext)
{
context.SaveChanges();
}
return(item);
}
return(null);
}
public static IQueryable <Customers> Get(HAYDENContext context, int custIdno)
{
if (context == null)
{
context = new HAYDENContext();
}
var item = (from i in context.Customers
select i);
if (custIdno > 0)
{
item = item.Where(i => i.CustIdno == custIdno);
}
return(item);
}
public static IQueryable <Login> Get(HAYDENContext context, int loginID)
{
if (context == null)
{
context = new HAYDENContext();
}
var item = (from i in context.Login
select i);
if (loginID > 0)
{
item = item.Where(i => i.LoginId == loginID);
}
return(item);
}
public static IQueryable <OrdersDetails> Get(HAYDENContext context, int ordersDetailsId)
{
if (context == null)
{
context = new HAYDENContext();
}
var item = (from i in context.OrdersDetails
select i);
if (ordersDetailsId > 0)
{
item = item.Where(i => i.OrdersDetailsId == ordersDetailsId);
}
return(item);
}
public static IQueryable <MetalMarket> Get(HAYDENContext context, int metalMarketId)
{
if (context == null)
{
context = new HAYDENContext();
}
var item = (from i in context.MetalMarket
select i);
if (metalMarketId > 0)
{
item = item.Where(i => i.MetalMarketId == metalMarketId);
}
return(item);
}
public static OrdersDetailsRgw InsertUpdate(HAYDENContext context, OrdersDetailsRgw iOrdersDetailRgw)
{
var ExternalContext = false;
if (context == null)
{
context = new HAYDENContext();
}
else
{
ExternalContext = true;
}
OrdersDetailsRgw item = null;
if (iOrdersDetailRgw.OrdersDetailsRgwid <= 0)
{
item = new OrdersDetailsRgw();
}
else
{
item = GetById(context, iOrdersDetailRgw.OrdersDetailsRgwid);
}
if (item != null)
{
item.OrdersDetailsRgwid = iOrdersDetailRgw.OrdersDetailsRgwid;
item.OrderDetailsId = iOrdersDetailRgw.OrderDetailsId;
item.OrderCode = iOrdersDetailRgw.OrderCode;
item.MoldCode = iOrdersDetailRgw.MoldCode;
item.RivaCode = iOrdersDetailRgw.RivaCode;
item.ResizeWax = iOrdersDetailRgw.ResizeWax;
if (iOrdersDetailRgw.OrdersDetailsRgwid <= 0)
{
context.OrdersDetailsRgw.Add(item);
}
if (!ExternalContext)
{
context.SaveChanges();
}
return(item);
}
return(null);
}
public static IQueryable <MaterialCodes> Get(HAYDENContext context, int materialCodeId)
{
if (context == null)
{
context = new HAYDENContext();
}
var item = (from i in context.MaterialCodes
select i);
if (materialCodeId > 0)
{
item = item.Where(i => i.MaterialCodeId == materialCodeId);
}
return(item);
}
public static IQueryable <GemInventory> Get(HAYDENContext context, int gemId)
{
if (context == null)
{
context = new HAYDENContext();
}
var item = (from i in context.GemInventory
select i);
if (gemId > 0)
{
item = item.Where(i => i.GemId == gemId);
}
return(item);
}
public static List <OrdersDetails> GetAll(HAYDENContext context)
{
return(Get(context, 0).ToList());
}
public static Login GetById(HAYDENContext context, int loginID)
{
return(Get(context, loginID).FirstOrDefault());
}
public static List <Login> GetAll(HAYDENContext context)
{
return(Get(context, 0).ToList());
}
public static List <Customers> GetAll(HAYDENContext context)
{
return(Get(context, 0).ToList());
}
public static List <GemInventory> GetAll(HAYDENContext context)
{
return(Get(context, 0).ToList());
}
public static MaterialCodes GetById(HAYDENContext context, int materialCodeId)
{
return(Get(context, materialCodeId).FirstOrDefault());
}
public static List <MaterialCodes> GetAll(HAYDENContext context)
{
return(Get(context, 0).ToList());
}
public static MetalMarket GetById(HAYDENContext context, int metalMarketId)
{
return(Get(context, metalMarketId).FirstOrDefault());
}
public static List <MetalMarket> GetAll(HAYDENContext context)
{
return(Get(context, 0).ToList());
}
public static OrdersDetails GetById(HAYDENContext context, int ordersDetailsId)
{
return(Get(context, ordersDetailsId).FirstOrDefault());
}
public static Customers GetById(HAYDENContext context, int custIdno)
{
return(Get(context, custIdno).FirstOrDefault());
}
public static GemInventory GetById(HAYDENContext context, int gemID)
{
return(Get(context, gemID).FirstOrDefault());
}
