public ContactRow findById(int id)
{
Cw2DataSet dataSet = DataSetProvider.Instance.getDataSet();
ContactRow contactRow = dataSet.Contact.FindById(id);
return(contactRow);
}
public TransactionRow findById(int id)
{
Cw2DataSet dataSet = DataSetProvider.Instance.getDataSet();
TransactionRow transactionRow = dataSet.Transaction.FindById(id);
TransactionDto dto = new TransactionDto();
return(transactionRow);
}
public CW2Response <ContactDto> saveDraft(ContactDto dto)
{
CW2Response <ContactDto> response = new CW2Response <ContactDto>();
try
{
Cw2DataSet dataSet = DataSetProvider.Instance.getDataSet();
ContactRow contactRow = null;
if (dto.DbEntityId == 0) //Entity not saved to database.
{
if (dto.Id != 0) //Update
{
contactRow = ContactDataSetDao.Instance.findById(dto.Id);
ContactTransformer.Instance.dtoToDataSetRow(dto, contactRow);
}
else //create
{
contactRow = dataSet.Contact.NewContactRow();
ContactTransformer.Instance.dtoToDataSetRow(dto, contactRow);
dataSet.Contact.AddContactRow(contactRow);
}
}
else
{
//Edit contact from the database. Local copy has been removed
//need to create a new local copy.
contactRow = dataSet.Contact.NewContactRow();
ContactTransformer.Instance.dtoToDataSetRow(dto, contactRow);
dataSet.Contact.AddContactRow(contactRow);
}
dataSet.AcceptChanges();
DataSetProvider.Instance.writeDataSet();
response.dto = ContactTransformer.Instance.dataSetRowToDto(contactRow);
response.Status = AppConstant.SUCCESS;
response.Message = "Contact local copy saved successfully";
}
catch (Exception e)
{
response.Status = AppConstant.ERROR;
response.Message = "DB Error : Unable to persist contact draft";
Console.WriteLine(e.StackTrace);
}
return(response);
}
private CW2Response <TransactionDto> saveDraft(TransactionDto dto)
{
CW2Response <TransactionDto> response = new CW2Response <TransactionDto>();
try
{
Cw2DataSet dataSet = DataSetProvider.Instance.getDataSet();
TransactionRow transactionRow = null;
if (dto.DbEntityId == 0) //Entity not saved to database.
{
if (dto.Id != 0) //Update
{
transactionRow = TransactionDataSetDao.Instance.findById(dto.Id);
TransactionTransformer.Instance.dtoToDataSetRow(dto, transactionRow);
}
else //create
{
transactionRow = dataSet.Transaction.NewTransactionRow();
TransactionTransformer.Instance.dtoToDataSetRow(dto, transactionRow);
dataSet.Transaction.AddTransactionRow(transactionRow);
}
}
else
{
//Edit transaction from the database. Local copy has been removed
//need to create a new local copy.
transactionRow = dataSet.Transaction.NewTransactionRow();
TransactionTransformer.Instance.dtoToDataSetRow(dto, transactionRow);
dataSet.Transaction.AddTransactionRow(transactionRow);
}
dataSet.AcceptChanges();
DataSetProvider.Instance.writeDataSet();
response.dto = TransactionTransformer.Instance.dataSetRowToDto(transactionRow);
response.Status = AppConstant.SUCCESS;
response.Message = "Transaction local copy saved successfully";
}
catch (Exception e)
{
response.Status = AppConstant.ERROR;
response.Message = "DB Error : Unable to persist transaction draft";
Console.WriteLine(e.StackTrace);
}
return(response);
}
public CW2Response <ContactDto> removeDraft(int id)
{
CW2Response <ContactDto> response = new CW2Response <ContactDto>();
try
{
Cw2DataSet dataSet = DataSetProvider.Instance.getDataSet();
ContactRow contactRow = dataSet.Contact.FindById(id);
contactRow.Delete();
dataSet.AcceptChanges();
DataSetProvider.Instance.writeDataSet();
response.Status = AppConstant.SUCCESS;
response.Message = "Contact Draft Remove Successfully";
}
catch (Exception e)
{
response.Status = AppConstant.ERROR;
response.Message = "Transaction Draft Remove Failed";
Console.WriteLine(e.StackTrace);
}
return(response);
}
private DataSetProvider()
{
dataSet = new Cw2DataSet();
}
