public long InsertMaterialIssue(tMIN objMaterialIssue, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
ce.tMINs.AddObject(objMaterialIssue);
ce.SaveChanges();
return(objMaterialIssue.MIN_ID);
}
public long updateMaterialIssue(tMIN objMaterialIssue, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
ce.tMINs.Attach(objMaterialIssue);
ce.ObjectStateManager.ChangeObjectState(objMaterialIssue, EntityState.Modified);
ce.SaveChanges();
return(1);
}
/// <summary>
/// GetRequisitionByID is providing List of Material Issue ByID
/// </summary>
/// <returns></returns>
///
public tMIN GetMaterialIssueByID(long RecID, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
tMIN Issue = new tMIN();
Issue = ce.tMINs.Where(p => p.MIN_ID == RecID).FirstOrDefault();
ce.Detach(Issue);
return(Issue);
}
