public static SponsorContact GetSponsorByContactCode(string contactCode)
{
SponsorContact result = new SponsorContact();
try
{
using (SqlConnection connection = new SqlConnection(CONNECTION_STRING))
{
connection.Open();
using (SqlCommand command = new SqlCommand(ContactInfoByContactCode, connection))
{
command.CommandType = CommandType.Text;
command.Parameters.Add("@ContactCode", SqlDbType.NVarChar).Value = contactCode;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
result = CreateNewSponsor(reader);
}
}
}
}
catch (SqlException sqlEx)
{
ErrorHandler.CreateLogFile(ErrorFormName, "GetSponsorByContactCode", sqlEx);
}
return(result);
}
int IComparer.Compare(Object x, Object y)
{
SponsorContact sponsorA = (SponsorContact)x;
SponsorContact sponsorB = (SponsorContact)y;
return(String.Compare(sponsorA.ContactName, sponsorB.ContactName));
}
//THIS IS MY NEW VERSION SINCE UGH
public static IList GetSponsors(string sponsorName)
{
IList results = new ArrayList();
sponsorName += "%";
try
{
using (SqlConnection connection = new SqlConnection(CONNECTION_STRING))
{
connection.Open();
using (SqlCommand command = new SqlCommand(GetAllSponsors, connection))
{
command.CommandType = CommandType.Text;
command.Parameters.Add("@SponsorName", SqlDbType.NVarChar).Value = sponsorName;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
SponsorContact sponsor = CreateNewSponsorNoContact(reader);
results.Add(sponsor);
}
}
}
}
catch (SqlException sqlEx)
{
ErrorHandler.CreateLogFile(ErrorFormName, "GetSponsorContacts", sqlEx);
}
return(results);
}
public void WordProtocol_Create_Test()
{
bool result = true;
try
{
ProtocolRequest request = new ProtocolRequest();
SponsorContact contact = new SponsorContact();
contact.SponsorName = "ABC";
contact.Address = "123 Street";
contact.City = "XYZ";
contact.State = "Alpha";
contact.ZipCode = "12345";
string protocolNumber = "P15-1000-00A";
request.SetContact(contact);
string sourceFile = @"C:\Users\BMcCulley\Documents\TestResources\ProtocolsManager\
ASTM-Hemolysis Complete.docx";
string destinationFile = @"C:\Users\BMcCulley\Documents\TestResources\ProtocolsManager\Dest\
ASTM-Hemolysis Complete.docx";
WordProtocol protocol = new WordProtocol(request, protocolNumber);
protocol.Create(sourceFile, destinationFile);
}
catch (Exception ex)
{
result = false;
Debug.WriteLine(ex.ToString());
}
Assert.AreEqual <bool>(true, result);
}
public void LoadView(ProtocolRequest protocolRequest)
{
this.request = protocolRequest;
this.contact = protocolRequest.Contact;
this.requestFormController.LoadView(this.request);
this.RefreshTemplateListView();
}
private static SponsorContact CreateNewSponsorNoContact(SqlDataReader reader)
{
SponsorContact sponsor = new SponsorContact();
sponsor.ContactCode = "0";
sponsor.SponsorCode = reader[0].ToString().Trim();
Debug.WriteLine(sponsor.SponsorCode);
sponsor.SponsorName = reader[2].ToString().Trim();
sponsor.Address = reader[4].ToString().Trim();
sponsor.City = reader[5].ToString().Trim();
sponsor.State = reader[6].ToString().Trim();
sponsor.ZipCode = reader[7].ToString().Trim();
sponsor.PhoneNumber = reader[9].ToString().Trim();
sponsor.FaxNumber = reader[10].ToString().Trim();
return(sponsor);
}
private static SponsorContact CreateNewSponsor(SqlDataReader reader)
{
SponsorContact sponsor = new SponsorContact();
sponsor.SponsorCode = reader[0].ToString().Trim();
sponsor.ContactCode = reader[1].ToString().Trim();
sponsor.SponsorName = reader[2].ToString().Trim();
sponsor.ContactName = reader[3].ToString().Trim();
sponsor.Address = reader[4].ToString().Trim();
sponsor.City = reader[5].ToString().Trim();
sponsor.State = reader[6].ToString().Trim();
sponsor.ZipCode = reader[7].ToString().Trim();
sponsor.PhoneNumber = reader[9].ToString().Trim();
sponsor.FaxNumber = reader[10].ToString().Trim();
sponsor.Email = reader[11].ToString().Trim();
return(sponsor);
}
