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); }