public int SaveSpaceTransactions(SpaceTransaction spaceTransaction, List <SpaceTransaction> data, Space space)
{
int result = 0;
try {
SpaceTransactionDO spaceTransactionDO = Converter.GetSpaceTransactionDO(spaceTransaction);
Debug.WriteLine("fetchinf data from Space transaction table start");
Debug.WriteLine(DateTime.Today.TimeOfDay);
var SPACEID = -1;
// Verify Data already Exist or not
SpaceTransaction item = null;
item = data.Where(i =>
i.SpaceID == spaceTransaction.SpaceID &&
i.LevelID == spaceTransaction.LevelID &&
i.SeqID == spaceTransaction.SeqID
).FirstOrDefault();
Debug.WriteLine(DateTime.Today.TimeOfDay);
Debug.WriteLine("fetchinf data from Space transaction finish");
int ID = 0;
int SpaceID = 0;
if (item != null)
{
spaceTransactionDO.ID = item.ID;
ID = item.ID;
SpaceID = (item.SpaceID.HasValue) ? item.SpaceID.Value : -1;
Debug.WriteLine("fetchinf data from Space transaction Update table start");
result = spaceTransactionRepository.UpdateEntity(spaceTransactionDO);
Debug.WriteLine("fetchinf data from Space transaction table finish");
}
else
{
Debug.WriteLine("fetchinf data from Space transaction table save data start");
//result = conn.Execute (query);
//Insert the new option transaction entry
result = spaceTransactionRepository.SaveEntity(spaceTransactionDO);
ID = spaceTransactionRepository.GetEntities().LastOrDefault().ID;
SpaceID = spaceTransactionRepository.GetEntities().LastOrDefault().SpaceID.Value;
}
if (ID > 0)
{
SPACEID = ID;
}
Debug.WriteLine("fetchinf data from Space transaction table save data finish");
} catch (Exception ex) {
Debug.WriteLine("Exception Occured in SaveSpaceTransactions method due to " + ex.Message);
}
return(result);
}
public static SpaceTransactionDO GetSpaceTransactionDO(SpaceTransaction spaceTransaction)
{
SpaceTransactionDO spaceTransactionDO = new SpaceTransactionDO()
{
ID = spaceTransaction.ID,
SpaceID = spaceTransaction.SpaceID,
isSelected = spaceTransaction.isSelected,
SeqID = spaceTransaction.SeqID,
LevelID = spaceTransaction.LevelID,
InspectionTransID = spaceTransaction.InspectionTransID
};
return(spaceTransactionDO);
}
public static SpaceTransaction GetSpaceTransaction(SpaceTransactionDO spaceTransactionDO)
{
SpaceTransaction spaceTransaction = new SpaceTransaction()
{
ID = spaceTransactionDO.ID,
SpaceID = spaceTransactionDO.SpaceID,
isSelected = spaceTransactionDO.isSelected,
SeqID = spaceTransactionDO.SeqID,
LevelID = spaceTransactionDO.LevelID,
InspectionTransID = spaceTransactionDO.InspectionTransID
};
return(spaceTransaction);
}
public SpaceTransaction GetSpaceTransaction(int SpaceID)
{
SpaceTransaction spaceTransaction = new SpaceTransaction();
try {
SpaceTransactionDO spaceTransactionDO = spaceTransactionRepository.GetEntity(SpaceID);
if (spaceTransactionDO != null)
{
spaceTransaction = Converter.GetSpaceTransaction(spaceTransactionRepository.GetEntity(spaceTransactionDO.ID));
}
} catch (Exception ex) {
Debug.WriteLine("Exception Occured in GetSpaceTransaction method due to " + ex.Message);
}
return(spaceTransaction);
}
public int DeleteSpaceTransactions(SpaceTransaction spaceTransaction)
{
int result = 0;
try
{
// Remove Content from option transaction table
SpaceTransactionDO spaceTransactionDO = Converter.GetSpaceTransactionDO(spaceTransaction);
// Remove Image Transaction from image transaction table
result = spaceTransactionRepository.DeleteEntity(spaceTransactionDO.ID);
}
catch (Exception ex)
{
Debug.WriteLine("Exception Occured in DeleteSpaceTransactions method due to " + ex.Message);
}
return(result);
}
