Example #1
0
        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);
        }
Example #2
0
        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));
        }
Example #3
0
        /// <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);
        }