public long InsertRequisitions(tPartRequisition objRequisitions, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
ce.tPartRequisitions.AddObject(objRequisitions);
ce.SaveChanges();
return(objRequisitions.PRM_ID);
}
public long updateRequisitions(tPartRequisition objRequisitions, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
ce.tPartRequisitions.Attach(objRequisitions);
ce.ObjectStateManager.ChangeObjectState(objRequisitions, EntityState.Modified);
ce.SaveChanges();
return(1);
}
/// <summary>
/// GetRequisitionByID is providing List of Requisition ByID
/// </summary>
/// <returns></returns>
///
public tPartRequisition GetRequisitionByID(long RecID, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));;
tPartRequisition Requisition = new tPartRequisition();
Requisition = ce.tPartRequisitions.Where(p => p.PRM_ID == RecID).FirstOrDefault();
ce.Detach(Requisition);
return(Requisition);
}
