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()); }