public mTitle GetTitleByTitleID(long TitleId, string[] conn) { BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); mTitle TitleResult = new mTitle(); TitleResult = (from p in db.mTitles where p.ID == TitleId select p).FirstOrDefault(); return(TitleResult); }
public int InsertIntomTitle(mTitle objmTitle, string state, string[] conn) { BISPL_CRMDBEntities ce = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); if (state == "AddNew") { ce.mTitles.AddObject(objmTitle); ce.SaveChanges(); } else if (state == "Edit") { ce.mTitles.Attach(objmTitle); ce.ObjectStateManager.ChangeObjectState(objmTitle, EntityState.Modified); ce.SaveChanges(); } return(Convert.ToInt32(objmTitle.ID)); }