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 { }
}
}