public int InsertmPrefixMaster(mPrefixMaster Pref, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
ce.mPrefixMasters.AddObject(Pref);
ce.SaveChanges();
return(1);
}
public int UpdatemPrefixMaster(mPrefixMaster UpdtPref, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
ce.mPrefixMasters.Attach(UpdtPref);
ce.ObjectStateManager.ChangeObjectState(UpdtPref, EntityState.Modified);
ce.SaveChanges();
return(1);
}
public mPrefixMaster GetPrefixMasterByID(int PrefID, string[] conn)
{
BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn));
mPrefixMaster PrID = new mPrefixMaster();
PrID = (from p in ce.mPrefixMasters
where p.PreID == PrefID
select p).FirstOrDefault();
ce.Detach(PrID);
return(PrID);
}