public List <TblStyleSpecDetail> UpdateOrInsertStyleSpecDetails(List <TblStyleSpecDetail> styleSpecDetails)
{
using (var context = new WorkFlowManagerDBEntities())
{
foreach (var row in styleSpecDetails)
{
var oldRow = (from e in context.TblStyleSpecDetails
where e.Iserial == row.Iserial && e.TblStyle == row.TblStyle
select e).SingleOrDefault();
if (oldRow != null)
{
oldRow.Description = row.Description;
oldRow.TblStyleSpecTypes = row.TblStyleSpecTypes;
foreach (var attchment in row.tblStyleSpecDetailAttachments.ToList())
{
tblStyleSpecDetailAttachment newAttachment = new tblStyleSpecDetailAttachment();
newAttachment.tblStyleSpecDetails = oldRow.Iserial;
newAttachment.galaryLint = StyleSpecDetailFiles + newAttachment.galaryLint;
newAttachment.FileName = attchment.FileName;
SaveFileToPath(StyleSpecDetailFiles, attchment.ImageThumb, attchment.FileName);
context.tblStyleSpecDetailAttachments.AddObject(newAttachment);
}
context.SaveChanges();
}
else
{
TblStyleSpecDetail newRow = new TblStyleSpecDetail();
newRow.TblStyle = row.TblStyle;
newRow.Description = row.Description;
newRow.TblStyleSpecTypes = row.TblStyleSpecTypes;
context.TblStyleSpecDetails.AddObject(newRow);
context.SaveChanges();
foreach (var attchment in row.tblStyleSpecDetailAttachments.ToList())
{
tblStyleSpecDetailAttachment newAttachment = new tblStyleSpecDetailAttachment();
newAttachment.tblStyleSpecDetails = newRow.Iserial;
newAttachment.galaryLint = StyleSpecDetailFiles + newAttachment.galaryLint;
newAttachment.FileName = attchment.FileName;
context.tblStyleSpecDetailAttachments.AddObject(newAttachment);
SaveFileToPath(StyleSpecDetailFiles, attchment.ImageThumb, attchment.FileName);
context.SaveChanges();
}
}
}
int tblStyle = styleSpecDetails.ToList().FirstOrDefault().TblStyle;
var query = context.TblStyleSpecDetails.Include("tblStyleSpecDetailAttachments").Where(x => x.TblStyle == tblStyle);
return(query.ToList());
}
}
public void DeleteStyleSpecDetailRow(int TblStyleSpecDetail, int tblStyle)
{
using (var context = new WorkFlowManagerDBEntities())
{
var deletedSpecDetail = context.TblStyleSpecDetails.Where(x => x.TblStyle == tblStyle && x.Iserial == TblStyleSpecDetail);
if (deletedSpecDetail != null)
{
//Delete Attachment
var deletedAttacment = context.tblStyleSpecDetailAttachments.Where(x => x.tblStyleSpecDetails == TblStyleSpecDetail);
foreach (var item in deletedAttacment.ToList())
{
context.tblStyleSpecDetailAttachments.DeleteObject(item);
context.SaveChanges();
}
//Delete Detail
TblStyleSpecDetail q = deletedSpecDetail.FirstOrDefault();
context.TblStyleSpecDetails.DeleteObject(q);
context.SaveChanges();
}
}
}
