public static OptionImage GetOptionImage(OptionTransactionImageDO optionTransactionImageDO)
{
OptionImage optionImage = new OptionImage()
{
ID = optionTransactionImageDO.ID,
Image = optionTransactionImageDO.ItemImage,
OptionTransID = optionTransactionImageDO.OptionTransactionID
};
return(optionImage);
}
//OptionImage Converter
public static OptionTransactionImageDO GetOptionTransactionImageDO(OptionImage optionImage)
{
OptionTransactionImageDO optionTransactionImageDO = new OptionTransactionImageDO()
{
ID = optionImage.ID,
ItemImage = optionImage.Image,
OptionTransactionID = optionImage.OptionTransID
};
return(optionTransactionImageDO);
}
public int DeleteOptionImagesForSync(SQLiteConnection conn,int OptionTransactionID)
{
int result = 0;
try
{
result = OptionTransactionImageDO.DeleteOptionImagesSync(conn,OptionTransactionID);
}
catch (Exception ex)
{
Debug.WriteLine("Exception Occured in DeleteSpaceOption method due to " + ex.Message);
}
return result;
}
public int DeleteOptionImage(OptionImage optionImage)
{
int result = 0;
try{
OptionTransactionImageDO optionTransactionImageDO = Converter.GetOptionTransactionImageDO(optionImage);
result = optionTransactionRepository.DeleteEntity(optionTransactionImageDO.ID);
}
catch (Exception ex)
{
Debug.WriteLine("Exception Occured in DeleteSpaceOption method due to " + ex.Message);
}
return result;
}
public OptionImage GetOptionImage(int optionImageID)
{
OptionImage optionImage = new OptionImage();
try
{
OptionTransactionImageDO optionTransactionImageDO = optionTransactionRepository.GetEntity(optionImageID);
if (optionTransactionImageDO != null)
optionImage = Converter.GetOptionImage(optionTransactionImageDO);
}
catch (Exception ex)
{
Debug.WriteLine("Exception Occured in GetCheckList method due to " + ex.Message);
}
return optionImage;
}
public int DeleteInspectionTransactionNotSync(Inspection inspection)
{
int inspectionTransactionResult = 0;
try
{
IEnumerable <InspectionTransactionDO> inspections = inspectionTransactionRepository.GetEntities();
InspectionTransactionDO inspectionTransactionDO = inspections.FirstOrDefault(ins => ins.InspectionID == inspection.inspectionID && ins.ProjectID == inspection.projectID);
inspectionTransactionResult = inspectionTransactionRepository.DeleteEntity(inspectionTransactionDO.ID);
LocationImageDo.DeleteImage(conn, inspectionTransactionDO.ID);
DocumentDO.DeleteDocument(conn, inspection.inspectionID, inspection.projectID);
PunchListDO.DeletePunchList(conn, inspection.inspectionID, inspection.projectID);
PunchListImageDO.DeletePunchListImageList(conn, inspection.ID);
ReportDO.DeleteReports(conn, inspection.ID);
using (var optService = new OptionTransactionService(conn))
{
var optIds = optService.GetOptionTransactionsForInspection(inspection.ID).Select(s => s.ID);
OptionTransactionDO.DeleteInspectionOptions(conn, inspection.ID);
if (optIds != null && optIds.Count() > 0)
{
foreach (var optID in optIds)
{
var chkTransIDs = CheckListTransactionDO.GetCheckListTransaction(conn, optID).Select(s => s.ID);
CheckListTransactionDO.DeletecheckList(conn, optID);
OptionTransactionImageDO.DeleteOptionImagesSync(conn, optID);
if (chkTransIDs != null && chkTransIDs.Count() > 0)
{
foreach (var chkId in chkTransIDs)
{
GuildedPhotoDO.DeleteGuidedImageList(conn, chkId);
}
}
}
}
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception Occured in DeleteInspectionTransaction method due to " + ex.Message);
}
return(inspectionTransactionResult);
}
public void SaveInspectionCheckList(int OPTID, OptionTransaction optionTransaction, Option option)
{
try
{
CheckListTransactionDO checkListTxnDO = new CheckListTransactionDO();
OptionTransactionImageRepository optionTransImageRepository = new OptionTransactionImageRepository(conn);
PunchListImageRepository punchListRepository = new PunchListImageRepository(conn);
PunchListImage punchImages;
bool PunchListItems = false;
if (optionTransaction != null)
{
if (optionTransaction.checkListTransaction != null && optionTransaction.checkListTransaction.Count > 0)
{
foreach (var checkListItem in optionTransaction.checkListTransaction)
{
checkListItem.OptionTransactionID = OPTID;
CheckListTransactionDO checkLists = CheckListTransactionDO.GetCheckListTransactionID(conn, OPTID, checkListItem.CheckListID).FirstOrDefault();
checkListTxnDO = Converter.GetCheckListTransactionDO(checkListItem);
if (checkLists != null)
{
if (checkLists.ID > 0)
{
CheckList chkItem = option.checkListItems.Find(i => i.ID == checkListTxnDO.CheckListID);
checkListTxnDO.ID = checkLists.ID;
checkListTransactionRepository.UpdateEntity(checkListTxnDO);
checkListItem.ID = checkListTxnDO.ID;
if (chkItem != null)
{
chkItem.CheckListTransID = checkListItem.ID;
}
}
else
{
CheckList chkItem = option.checkListItems.Find(i => i.ID == checkListTxnDO.CheckListID);
checkListTransactionRepository.SaveEntity(checkListTxnDO);
checkListItem.ID = checkListTransactionRepository.GetEntities().LastOrDefault().ID;
if (chkItem != null)
{
chkItem.CheckListTransID = checkListItem.ID;
}
}
}
else
{
CheckList chkItem = option.checkListItems.Find(i => i.ID == checkListTxnDO.CheckListID);
checkListTransactionRepository.SaveEntity(checkListTxnDO);
checkListItem.ID = checkListTransactionRepository.GetEntities().LastOrDefault().ID;
if (chkItem != null)
{
chkItem.CheckListTransID = checkListItem.ID;
}
}
if (checkListItem.itemType == ItemType.GuidedPicture)
{
GuildedPhotoDO.DeleteGuidedImageList(conn, checkListItem.ID);
if (checkListItem.GuidedPictures != null && checkListItem.GuidedPictures.Count > 0)
{
foreach (var img in checkListItem.GuidedPictures)
{
GuildedPhotoDO.InsertGuidedImage(conn, checkListItem.ID, img);
}
}
continue;
}
if (checkListItem.PunchID > 0 && checkListItem.itemType == ItemType.PunchList)
{
PunchListItems = true;
punchImages = new PunchListImage();
PunchListImageDO.DeletePunchImageList(conn, checkListItem.PunchID);
if (checkListItem.GuidedPictures != null && checkListItem.GuidedPictures.Count > 0)
{
foreach (var img in checkListItem.GuidedPictures)
{
if (img != null)
{
punchImages.Image = img;
}
else
{
punchImages.Image = null;
}
punchImages.PunchID = checkListItem.PunchID;
punchImages.inspectionTransID = optionTransaction.inspectionTransID;
PunchListImageDO punchListDO = Converter.GetPunchListImageDO(punchImages);
punchListRepository.SaveEntity(punchListDO);
}
}
}
}
}
OptionTransactionImageDO.DeleteOptionImagesSync(conn, OPTID);
if (optionTransaction.photos != null && optionTransaction.photos.Count > 0)
{
foreach (var optionimage in optionTransaction.photos)
{
optionimage.OptionTransID = OPTID;
OptionTransactionImageDO optTransDO = Converter.GetOptionTransactionImageDO(optionimage);
int Result = optionTransImageRepository.SaveEntity(optTransDO);
}
}
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception occured in method SaveInspectionCheckList" + ex.Message);
}
}
