public int SaveOptionTransactions(OptionTransaction optionTransaction, List <OptionTransaction> data, Option option)
{
int result = 0;
try
{
OptionTransactionDO optionTransactionDO = Converter.GetOptionTransactionDO(optionTransaction);
Debug.WriteLine("fetchinf data from option transaction table start");
Debug.WriteLine(DateTime.Today.TimeOfDay);
var OPTID = -1;
// Verify Data already Exist or not
OptionTransaction item = null;
item = data.Where(i =>
i.inspectionTransID == optionTransaction.inspectionTransID &&
i.SequenceID == optionTransaction.SequenceID &&
i.LevelID == optionTransaction.LevelID &&
i.SpaceID == optionTransaction.SpaceID &&
i.OptionId == optionTransaction.OptionId).FirstOrDefault();
Debug.WriteLine(DateTime.Today.TimeOfDay);
Debug.WriteLine("fetchinf data from option transaction finish");
int optID = 0;
if (item != null)
{
optionTransactionDO.ID = item.ID;
optID = item.ID;
Debug.WriteLine("fetchinf data from option transaction Update table start");
result = optionTransactionRepository.UpdateEntity(optionTransactionDO);
Debug.WriteLine("fetchinf data from option transaction table finish");
}
else
{
Debug.WriteLine("fetchinf data from option transaction table save data start");
//result = conn.Execute (query);
//Insert the new option transaction entry
result = optionTransactionRepository.SaveEntity(optionTransactionDO);
optID = optionTransactionRepository.GetEntities().LastOrDefault().ID;
}
if (optID > 0)
{
OPTID = optID;
if (option != null)
{
option.OptionTransactionID = optID;
SaveInspectionCheckList(OPTID, optionTransaction, option);
}
}
Debug.WriteLine("fetchinf data from option transaction table save data finish");
}
catch (Exception ex)
{
Debug.WriteLine("Exception Occured in SaveOptionTransactions method due to " + ex.Message);
}
return(result);
}
private async Task <object> ExecTransaction(OptionTransaction cmd)
{
var r = await _mediator.Send(cmd);
if (r.Error != null)
{
return(this.Error(r.Error));
}
return(r.Aggregate);
}
public OptionTransaction GetOptionTransaction(int OptionID)
{
OptionTransaction optionTransaction = new OptionTransaction();
try
{
OptionTransactionDO optionTransactionDO = optionTransactionRepository.GetEntity(OptionID);
if (optionTransactionDO != null)
{
optionTransaction = Converter.GetOptionTransaction(optionTransactionRepository.GetEntity(optionTransactionDO.ID));
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception Occured in GetOptionTransaction method due to " + ex.Message);
}
return(optionTransaction);
}
public static OptionTransactionDO GetOptionTransactionDO(OptionTransaction optionTransaction)
{
OptionTransactionDO optionTransactionDO = new OptionTransactionDO()
{
ID = optionTransaction.ID,
OptionId = optionTransaction.OptionId,
//OptionDesc=optionTransaction.OptionDesc,
InspectionTransID = optionTransaction.inspectionTransID,
SpaceID = optionTransaction.SpaceID,
SequenceID = optionTransaction.SequenceID,
//ProjectID=optionTransaction.ProjectID,
LevelID = optionTransaction.LevelID,
isSelected = optionTransaction.isSelected
//IsGuidedPicture=optionTransaction.IsGuidedPicture
};
return(optionTransactionDO);
}
public int DeleteOptionTransactions(OptionTransaction optionTransaction)
{
int result = 0;
try
{
// Remove Content from option transaction table
OptionTransactionDO optionTransactionDO = Converter.GetOptionTransactionDO(optionTransaction);
if (optionTransactionDO != null)
{
// Remove Image Transaction from image transaction table
result = optionTransactionRepository.DeleteEntity(optionTransactionDO.ID);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception Occured in DeleteOptionTransactions method due to " + ex.Message);
}
return(result);
}
public static OptionTransaction GetOptionTransaction(OptionTransactionDO optionTransactionDO)
{
OptionTransaction optionTransaction = new OptionTransaction()
{
ID = optionTransactionDO.ID,
OptionId = optionTransactionDO.OptionId,
//OptionDesc = optionTransactionDO.OptionDesc,
//Result = optionTransactionDO.Result,
//Comment = optionTransactionDO.comment,
inspectionTransID = optionTransactionDO.InspectionTransID,
//InspectionID = optionTransactionDO.InspectionID,
SpaceID = optionTransactionDO.SpaceID,
SequenceID = optionTransactionDO.SequenceID,
//ProjectID = optionTransactionDO.ProjectID,
LevelID = optionTransactionDO.LevelID,
isSelected = optionTransactionDO.isSelected
//IsGuidedPicture=optionTransactionDO.IsGuidedPicture
};
return(optionTransaction);
}
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);
}
}
