public List <tblTechPackDetail> GetTBLTechPackDetails(int TBLStyle, out tblTechPackHeader tblTechPackHeader) { using (var context = new WorkFlowManagerDBEntities()) { var query = context.tblTechPackDetails.Where(x => x.tblTechPackHeader1.tblStyle == TBLStyle).ToList(); if (query.Count > 0) { tblTechPackHeader = context.tblTechPackHeaders.FirstOrDefault(X => X.tblStyle == TBLStyle); } tblTechPackHeader = context.tblTechPackHeaders.Where(x => x.tblStyle == TBLStyle).FirstOrDefault(); return(query); } }
public tblTechPackHeader InsertOrUpdateTBLTechPackHeader(tblTechPackHeader newRow) { using (var context = new WorkFlowManagerDBEntities()) { var oldRow = (from e in context.tblTechPackHeaders where e.Iserial == newRow.Iserial select e).SingleOrDefault(); if (oldRow != null) { SharedOperation.GenericUpdate(oldRow, newRow, context); } else { context.tblTechPackHeaders.AddObject(newRow); } context.SaveChanges(); return(newRow); } }
public void InsertOrUpdateTBLTechPackDetail(tblTechPackHeader _techPackHeader, List <tblTechPackDetail> newTechPackDetailRows) { using (var context = new WorkFlowManagerDBEntities()) { //CheackHeader var oldtechPackHeaderRow = (from e in context.tblTechPackHeaders where e.Iserial == _techPackHeader.Iserial select e).SingleOrDefault(); if (oldtechPackHeaderRow != null) { SharedOperation.GenericUpdate(oldtechPackHeaderRow, _techPackHeader, context); context.SaveChanges(); SaveTechPackDetailRows(oldtechPackHeaderRow, newTechPackDetailRows); } else { context.tblTechPackHeaders.AddObject(_techPackHeader); context.SaveChanges(); SaveTechPackDetailRows(_techPackHeader, newTechPackDetailRows); } } }
private void SaveTechPackDetailRows(tblTechPackHeader HeaderRow, List <tblTechPackDetail> DetailsRow) { using (var context = new WorkFlowManagerDBEntities()) { try { foreach (var newRow in DetailsRow) { newRow.tblTechPackHeader = HeaderRow.Iserial; newRow.LastChangeDate = DateTime.Now; var oldRow = (from e in context.tblTechPackDetails where e.Iserial == newRow.Iserial select e).SingleOrDefault(); if (!string.IsNullOrEmpty(newRow.galaryLink)) { SaveImageToPath(newRow.galaryLink, newRow.ImageThumb); //newRow.galaryLink = "D:\\TechPackImages\\" + newRow.galaryLink; newRow.galaryLink = TechPackImagesWrite + newRow.galaryLink; } else { newRow.galaryLink = oldRow.galaryLink; } //Update if (oldRow != null) { if (string.IsNullOrEmpty(newRow.galaryLink)) { newRow.galaryLink = oldRow.galaryLink; newRow.ImageName = oldRow.ImageName; } oldRow.ImageThumb = null; newRow.ImageThumb = null; oldRow.LastChangeDate = DateTime.Now; if (oldRow.Description == newRow.Description && oldRow.galaryLink == newRow.galaryLink && oldRow.ImageName == newRow.ImageName && oldRow.tblTechPackPart == newRow.tblTechPackPart) { //Don't Log } else { SaveTBLTechPackLog(newRow); } SharedOperation.GenericUpdate(oldRow, newRow, context); context.SaveChanges(); } else { context.tblTechPackDetails.AddObject(newRow); newRow.ImageThumb = null; context.SaveChanges(); SaveTBLTechPackLog(newRow); } } } catch { } } }