public void OwnerIdentifier()
{
var data = Guid.NewGuid();
var contact = new ContactRow(data, Guid.NewGuid());
Assert.AreEqual <Guid>(data, contact.OwnerIdentifier);
}
static void Main1(string[] args)
{
var cr = new ContactRow
{
ID = Guid.NewGuid(),
OurStation = 2,
PinLat = 50.123,
PinLon = -3.456,
ReceivedReport = "59",
SentReport = "57",
TheirCall = "2E1EPQ",
TheirGroup = "group",
TheirLocation = "reading",
TheirOperator = "Tom",
UtcTime = new DateTime(2018, 10, 19, 14, 4, 1)
};
var cli = new HttpClient();
try
{
var response = cli.PostAsJsonAsync("http://localhost:55229/api/contact", cr).Result;
}
catch (Exception ex)
{
Debugger.Break();
}
}
public void AddContact(ContactRow contactRow)
{
var conn = dbService.GetOpenConnection();
conn.Execute("delete from contacts where theircall=@theircall and utctime=@utctime", contactRow);
conn.Execute("insert into contacts (id, utctime, theircall, ourstation, sentreport, receivedreport, pinlat, pinlon, theiroperator, theirgroup, theirlocation, freqMhz, mode, country) values (@id, @utctime, @theircall, @ourstation, @sentreport, @receivedreport, @pinlat, @pinlon, @theiroperator, @theirgroup, @theirlocation, @freqMhz, @mode, @country);", contactRow);
}
public ContactRow findById(int id)
{
Cw2DataSet dataSet = DataSetProvider.Instance.getDataSet();
ContactRow contactRow = dataSet.Contact.FindById(id);
return(contactRow);
}
public void Identifier()
{
var data = Guid.NewGuid();
var contact = new ContactRow(Guid.NewGuid(), data);
Assert.AreEqual <Guid>(data, contact.Identifier);
}
public void Email()
{
var data = StringHelper.ValidString();
var contact = new ContactRow(Guid.NewGuid(), Guid.NewGuid());
contact.Email = data;
Assert.AreEqual <string>(data, contact.Email);
}
public ContactRow dtoToDataSetRow(ContactDto dto, ContactRow row)
{
row.ContactName = dto.ContactName;
row.Address = dto.Address;
row.Type = dto.Type;
row.Tel = dto.Tel;
row.Email = dto.Email;
return(row);
}
public ContactRow AddContactRow(string Name, string Phone)
{
ContactRow rowContactRow = ((ContactRow)(this.NewRow()));
object[] columnValuesArray = new object[] {
Name,
Phone
};
rowContactRow.ItemArray = columnValuesArray;
this.Rows.Add(rowContactRow);
return(rowContactRow);
}
public void Convert()
{
var contact = new ContactRow(Guid.NewGuid(), Guid.NewGuid())
{
Email = StringHelper.ValidString(),
};
var converted = contact.Convert();
Assert.AreEqual <string>(contact.Email, converted.Email);
Assert.AreEqual <Guid>(contact.Identifier, converted.Identifier);
Assert.AreEqual <Guid>(contact.OwnerIdentifier, converted.Owner.Identifier);
}
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);
}
public ContactDto dataSetRowToDto(ContactRow row)
{
ContactDto dto = new ContactDto();
dto.Id = row.Id;
dto.ContactName = row.ContactName;
dto.Address = row.Address;
dto.Type = row.Tel;
dto.Email = row.Email;
dto.Type = row.Type;
dto.Status = AppConstant.DRAFT;
return(dto);
}
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);
}
public void RemoveContactRow(ContactRow row) {
this.Rows.Remove(row);
}
public void AddContactRow(ContactRow row)
{
this.Rows.Add(row);
}
public void AddContactRow(ContactRow row) {
this.Rows.Add(row);
}
public void RemoveContactRow(ContactRow row)
{
this.Rows.Remove(row);
}
public ContactRowChangeEvent(ContactRow row, global::System.Data.DataRowAction action) {
this.eventRow = row;
this.eventAction = action;
}
public ContactRowChangeEvent(ContactRow row, global::System.Data.DataRowAction action)
{
this.eventRow = row;
this.eventAction = action;
}
public MessageBccContactsRow AddMessageBccContactsRow(MessageRow parentMessageRowByFK_Message_MessageBccContacts, ContactRow parentContactRowByFK_Contact_MessageBccContacts) {
MessageBccContactsRow rowMessageBccContactsRow = ((MessageBccContactsRow)(this.NewRow()));
object[] columnValuesArray = new object[] {
null,
null};
if ((parentMessageRowByFK_Message_MessageBccContacts != null)) {
columnValuesArray[0] = parentMessageRowByFK_Message_MessageBccContacts[0];
}
if ((parentContactRowByFK_Contact_MessageBccContacts != null)) {
columnValuesArray[1] = parentContactRowByFK_Contact_MessageBccContacts[3];
}
rowMessageBccContactsRow.ItemArray = columnValuesArray;
this.Rows.Add(rowMessageBccContactsRow);
return rowMessageBccContactsRow;
}
