public int InsertKitMaster(KitISBN kitIsbndata)
        {
            if (kitIsbndata.Id == 0)
            {
                _KitISBNRepository.Insert(kitIsbndata);
            }
            else
            {
                List <KitProductLink> dataList = _KitProductLinkRepository.Table.Where(i => i.KitId == kitIsbndata.Id && i.Deactivate == "N").ToList();

                foreach (KitProductLink list in dataList)
                {
                    list.Deactivate     = "Y";
                    list.DeactivateBy   = kitIsbndata.EnteredBy;
                    list.DeactivateDate = DateTime.Now;
                    _KitProductLinkRepository.Update(list);
                    //_KitProductLinkRepository.Delete(list);
                }

                //foreach (KitProductLink list in kitIsbndata.KitProductLink)
                //{
                //    list.Deactivate = "N";
                //    list.EnteredBy = kitIsbndata.EnteredBy;
                //    list.EntryDate = DateTime.Now;
                //    list.KitId = kitIsbndata.Id;
                //    _KitProductLinkRepository.Insert(list);
                //}

                _KitISBNRepository.Update(kitIsbndata);
            }
            return(kitIsbndata.Id);
        }
        //Add by Ankush 20/06/2016
        public string DuplicityKitISBNCheck(KitISBN kitIsbndata)
        {
            var mstr_returnmsg = "notexist";
            var dupes          = _KitISBNRepository.Table.Where(x => x.ISBN == kitIsbndata.ISBN && x.ISBN != null && x.Deactivate == "N" &&
                                                                (kitIsbndata.Id != 0 ? x.Id : 0) != (kitIsbndata.Id != 0 ? kitIsbndata.Id : 1)).FirstOrDefault();

            if (dupes != null)
            {
                mstr_returnmsg = "duplicateISBN";
            }

            return(mstr_returnmsg);
        }
        public int DeleteKitMaster(KitISBN kitIsbndata)
        {
            List <KitProductLink> dataList = _KitProductLinkRepository.Table.Where(i => i.KitId == kitIsbndata.Id && i.Deactivate == "N").ToList();

            foreach (KitProductLink list in dataList)
            {
                list.Deactivate     = "Y";
                list.DeactivateBy   = kitIsbndata.EnteredBy;
                list.DeactivateDate = DateTime.Now;
                _KitProductLinkRepository.Update(list);
                //_KitProductLinkRepository.Delete(list);
            }

            kitIsbndata.Deactivate     = "Y";
            kitIsbndata.DeactivateBy   = kitIsbndata.EnteredBy;
            kitIsbndata.DeactivateDate = DateTime.Now;
            _KitISBNRepository.Update(kitIsbndata);

            return(kitIsbndata.Id);
        }
 public KitISBN GetKitISBNById(KitISBN kitISBN)
 {
     return(_KitISBNRepository.Table.Where(x => x.Id == kitISBN.Id && x.Deactivate == "N").FirstOrDefault());
 }