public void UpdateMOHeaderTag(MOTag MT)
{
MOTagHeader _MOTagHeader = new MOTagHeader();
_MOTagHeader = MOTag2Entity(MT);
_moTagHeaderLogic.Update(_MOTagHeader);
}
public int CreateMOHeaderTag(MOTag MT)
{
Ticket _ticket = new Ticket();
MOTagHeader _moTagHeader = new MOTagHeader();
cat_TicketType cat = (cat_TicketType)_cat_TicketTypeLogic.ReadbyName(new cat_TicketType("MOTagHeader")).Result;
int counter = GetLastCounter();
_ticket.cat_TicketTypeKey = cat.id;
_ticket.InventoryEventKey = ActiveEventId;
_ticket.TicketCounter = counter + 1;
//_ticket.TicketCounter = MT.Counter;
_moTagHeader.Planner = MT.Planner;
_moTagHeader.MO = MT.MO;
_moTagHeader.MO_Ln = MT.MO_Ln;
_moTagHeader.MO_Status = MT.MO_Status;
_moTagHeader.Order_Qty = MT.Order_Qty;
_moTagHeader.Recv_Qty = MT.Recv_Qty;
_moTagHeader.LineType = MT.LineType;
_moTagHeader.FG_Qty_in_WIP = 0;
_moTagHeader.Parent_Item_NO = MT.Parent_Item_NO;
_moTagHeader.Parent_Item_Desc = MT.Parent_Item_Desc;
_moTagHeader.Parent_ItemRef1 = MT.Parent_ItemRef1;
_ticket.MOTagHeaders.Add(_moTagHeader);
_ticket = (Ticket)(_ticketLogic.Create(_ticket).Result as Ticket);
return(_ticket.TicketCounter);
}
/// <summary>
/// Converts a MOTag to a EF MOTagHeader Enttity
/// </summary>
/// <param name="MOT"></param>
/// <returns></returns>
private MOTagHeader MOTag2Entity(MOTag MOT)
{
Ticket T = new Ticket();
T = (Ticket)_ticketLogic.ReadbyId(MOT.TicketID).Result;
MOTagHeader _MOtag = new MOTagHeader();
_MOtag.Ticket = T;
_MOtag.Ticket.TicketCounter = MOT.Counter;
_MOtag.Planner = MOT.Planner;
_MOtag.MO = MOT.MO;
_MOtag.MO_Ln = MOT.MO_Ln;
_MOtag.MO_Status = MOT.MO_Status;
_MOtag.LineType = MOT.LineType;
_MOtag.Order_Qty = (int)MOT.Order_Qty;
_MOtag.Recv_Qty = (int)MOT.Recv_Qty;
_MOtag.FG_Qty_in_WIP = MOT.FGinWip;
_MOtag.Parent_Item_NO = MOT.Parent_Item_NO;
_MOtag.Parent_Item_Desc = MOT.Parent_Item_Desc;
_MOtag.Parent_ItemRef1 = MOT.Parent_ItemRef1;
_MOtag.CountedDate = MOT.CountedDate;
_MOtag.CounterInitials = MOT.CounterInitials;
_MOtag.TicketKey = MOT.TicketID;
_MOtag.MOTagHeaderKey = MOT.MOTagID;
return(_MOtag);
}
/// <summary>
/// Converts a MOTagHeader enttity from EF to a MOTag
/// </summary>
/// <param name="MOT"></param>
/// <returns></returns>
private MOTag Entity2MOTag(MOTagHeader MOT)
{
MOTag _MOtag = new MOTag();
Ticket _t = (Ticket)_ticketLogic.ReadbyId(MOT.TicketKey).Result;
_MOtag.Counter = _t.TicketCounter;
_MOtag.Planner = MOT.Planner;
_MOtag.MO = MOT.MO;
_MOtag.MO_Ln = MOT.MO_Ln;
_MOtag.MO_Status = MOT.MO_Status;
_MOtag.LineType = MOT.LineType;
_MOtag.Order_Qty = (int)MOT.Order_Qty;
_MOtag.Recv_Qty = (int)MOT.Recv_Qty;
_MOtag.FGinWip = (int)MOT.FG_Qty_in_WIP;
_MOtag.Parent_Item_NO = MOT.Parent_Item_NO;
_MOtag.Parent_Item_Desc = MOT.Parent_Item_Desc;
_MOtag.Parent_ItemRef1 = MOT.Parent_ItemRef1;
_MOtag.CountedDate = MOT.CountedDate;
_MOtag.CounterInitials = MOT.CounterInitials;
_MOtag.MOTagID = MOT.MOTagHeaderKey;
_MOtag.TicketID = MOT.TicketKey;
return(_MOtag);
}
public DataTable MOTagHeaders2Table()
{
DataTable _MTDT = new DataTable();
//-----------HEADER--------------------//
_MTDT.Columns.Add("Counter", typeof(int));
_MTDT.Columns.Add("Planner", typeof(string));
_MTDT.Columns.Add("MO", typeof(string));
_MTDT.Columns.Add("MO_Ln", typeof(string));
_MTDT.Columns.Add("MO_Status", typeof(string));
_MTDT.Columns.Add("Order_Qty", typeof(int));
_MTDT.Columns.Add("Recv_Qty", typeof(int));
_MTDT.Columns.Add("LineType", typeof(string));
_MTDT.Columns.Add("FGinWip", typeof(int));
//-----------TITTLE--------------------//
_MTDT.Columns.Add("Parent_Item_NO", typeof(string));
_MTDT.Columns.Add("Parent_Item_Desc", typeof(string));
_MTDT.Columns.Add("Parent_ItemRef1", typeof(string));
//-----------FOOTER--------------------//
_MTDT.Columns.Add("CounterInitials", typeof(string));
_MTDT.Columns.Add("CountedDate", typeof(DateTime));
//-----------Keys----------------------//
_MTDT.Columns.Add("MOTagKey", typeof(int));
_MTDT.Columns.Add("TicketID", typeof(int));
List <MOTagHeader> _MOList = _moTagHeaderLogic.ReadAll();
MOTag _MT = new MOTag();
for (int i = 0; i < _MOList.Count; i++)
{
_MT = Entity2MOTag(_MOList[i]);
_MTDT.Rows.Add(_MT.Counter
, _MT.Planner
, _MT.MO
, _MT.MO_Ln
, _MT.MO_Status
, _MT.Order_Qty
, _MT.Recv_Qty
, _MT.LineType
, _MT.FGinWip
, _MT.Parent_Item_NO
, _MT.Parent_Item_Desc
, _MT.Parent_Item_NO
, _MT.CounterInitials
, _MT.CountedDate
, _MT.MOTagID
, _MT.TicketID);
}
return(_MTDT);
}
public MOTag LoadMOHeaderTag(int Counter)
{
MOTag _MOTag = new MOTag();
MOTagHeader _MOTagHeader = new MOTagHeader();
Ticket _Ticket = new Ticket();
_Ticket = (Ticket)_ticketLogic.ReadbyName(Counter, ActiveEventId).Result;
//List< MOTagHeader> _MOTags= _Ticket.MOTagHeaders;
_MOTagHeader.Ticket = _Ticket;
_MOTagHeader = (MOTagHeader)_moTagHeaderLogic.ReadByCounter(Counter, ActiveEventId).Result;
_MOTag = Entity2MOTag(_MOTagHeader);
return(_MOTag);
}
public static MOTag DataRow2MOTag(DataRow r)
{
MOTag _MOtag = new MOTag();
//_MOtag.Counter = Convert.ToInt32(r["Counter"].ToString());
_MOtag.Planner = r["Planner"].ToString();
_MOtag.MO = r["MONumber"].ToString();
_MOtag.MO_Ln = r["MOLineNumberString"].ToString();
_MOtag.MO_Status = r["MOLineStatus"].ToString();
_MOtag.LineType = r["MOLineType"].ToString();
_MOtag.Order_Qty = Convert.ToInt32(r["ItemOrderedQuantity"].ToString());
_MOtag.Recv_Qty = Convert.ToInt32(r["ReceiptQuantity"].ToString());
_MOtag.Parent_Item_NO = r["ItemNumber"].ToString();
_MOtag.Parent_Item_Desc = r["ItemDescription"].ToString();
_MOtag.Parent_ItemRef1 = r["ItemReference1"].ToString();
return(_MOtag);
}
