public int UpdatetTargetPlan(tTargetPlan updatetarget, string[] conn) { BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); db.tTargetPlans.Attach(updatetarget); db.ObjectStateManager.ChangeObjectState(updatetarget, EntityState.Modified); db.SaveChanges(); return(1); }
public int InserttTargetPlan(tTargetPlan target, string[] conn) { BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); //db.tDiscountHeads.AddObject(disc); db.AddTotTargetPlans(target); db.SaveChanges(); return(Convert.ToInt32(target.ID)); }
/// <summary> /// GetDiscountListByID is providing List of DiscountList By ID for Edit mode /// </summary> /// <returns></returns> /// public tTargetPlan GetTargetListByID(int targetId, string[] conn) { BISPL_CRMDBEntities db = new BISPL_CRMDBEntities(svr.GetEntityConnection(conn)); tTargetPlan TargetID = new tTargetPlan(); TargetID = (from p in db.tTargetPlans where p.ID == targetId select p).FirstOrDefault(); db.Detach(TargetID); return(TargetID); }