public class WebtoCaseWorkflow 
{
 //This Class will take the information passed in by the web to case form, and basically copy it into
 //the proper fields on the case. Also, it will update contact information if the contact already exists,
 //or create a contact if they do not. 
 
 //Information expected to be passed: Web_First_Name__c, Web_Last_Name__c, SuppliedEmail, SuppliedPhone, CID__c
 //along with the regular case information, eg. subject and description.
 
 //This trigger should not run if the source is Phone, or Email, only if the case is coming from the web.

 public static void QueryAndUpdateCase(Case[] caseitem)
 {
  string AccountIsValid = 'undefined';
  //With the CID passed from the web form, let's try to find the matching account in SF
  for (Case c:caseitem)
  {
   //Make sure this case is coming from the web form before doing anything else.
   if(c.Origin == 'Web')
   {
    //Search for any accounts with the same CID as the one passed in.
             Account[] AccountResult = [SELECT CID__c, Name, Id FROM Account WHERE CID__c = :c.CID__c];
    
      //If we find a match on the CID (which we should, every time)
      //Set the account info for this case.
      
         if(AccountResult.size() > 0)
      {  
     c.AccountId = AccountResult[0].Id;
     AccountIsValid = 'yes';
      }
      
      if(AccountResult.size() < 0)
      {  
     // some kind of error handling should go here. Without a proper account
     // linking we won't be able to add a contact.
     AccountIsValid = 'no';
      }
  
    //Now with the account linked up, let's deal with the contact portion.
 
    //Query for a contact with the same email as the one provided, since email has to be unique.
             Contact[] ContactResult = [SELECT Name, Id, Phone, FirstName, LastName FROM Contact WHERE email = :c.SuppliedEmail];
    
     
     //----------------------------------Found a Contact Match----------------------------------// 
         if(ContactResult.size() > 0)
      {  
       
       //Update the contact record with the information they give us, 
       //since they are giving us updated info, might as well use it.
       for (Contact q:ContactResult)
       {
      q.Phone = c.SuppliedPhone;
      q.FirstName = c.Web_First_Name__c;
      q.LastName = c.Web_Last_Name__c;
     }
     
     //Set the ID of the contact as the one retreived from the query. With just the ID
     //Salesforce can query the contact record and fetch the name, phone number, and email.
     c.ContactId = ContactResult[0].Id;
      }
      
      //--------------------------------Did not find a Contact Match-------------------------//
      if(ContactResult.size() < 1)
      {
       //If the CID they gave was valid, and can be hooked to an account, link the contact
       //to that account as well.
       if(AccountIsValid == 'yes')
       {
        //If the contact does not exist, let's make it using the info provided from the form.
        Contact ContactMake = new Contact(FirstName=c.Web_First_Name__c, LastName=c.Web_Last_Name__c, Email=c.SuppliedEmail, Phone=c.SuppliedPhone, AccountId=AccountResult[0].Id); insert ContactMake;
         CONTACT[] getContactId = [SELECT Id FROM Contact WHERE Email = :c.SuppliedEmail];
         c.ContactId = getContactId[0].Id;
       }
       
       //If the CID they gave us was not valid, and did match to an account, create the contact,
       //but don't attempt to link it to an account since we don't know what account they belong to!
       if(AccountIsValid == 'no')
       {
        //If the contact does not exist, let's make it using the info provided from the form.
        Contact ContactMake = new Contact(FirstName=c.Web_First_Name__c, LastName=c.Web_Last_Name__c, Email=c.SuppliedEmail, Phone=c.SuppliedPhone); insert ContactMake;
         CONTACT[] getContactId = [SELECT Id FROM Contact WHERE Email = :c.SuppliedEmail];
         c.ContactId = getContactId[0].Id;
       }
        
      }
      
      //Okay I think we are done. We have now update the case with both account and contact information
      //that we received from the web form. Hopefully it didn't blow up and die.
   } 
  }
 }
 
 public static testMethod void QueryAndUpdateCaseTest()
 {
   //Create an account and retreive account #
   Account AccountMake = new Account(Name='test123'); insert AccountMake; 
   ACCOUNT[] getAccountId = [SELECT Id FROM Account WHERE name = 'test123'];
   
   //Create a contact that belongs to the account we just made, and retreive the ID
   Contact ContactMake = new Contact(LastName='testJohnson', FirstName='test', Email='frank@frank.com', AccountId=getAccountId[0].Id); insert ContactMake;
   CONTACT[] getContactId = [SELECT Id, FirstName, LastName FROM Contact WHERE LastName = 'testJohnson'];
   
   //Create a case that belongs to the contact we just made, then fetch it's ID.
   Case CaseMake = new Case(ContactId=getContactId[0].Id, Status='open', Problem__c='Other', Origin='Web', Subject='testcase21313213', description='test case of joy', PETE_ID__c='ADY2342342', SuppliedPhone='(345)-352-6244', SuppliedEmail='frank@frank.com', CID__c='141231', SuppliedName='Frank Johnson', SuppliedCompany='test123' ); insert CaseMake;
   CASE[] getCaseId = [SELECT Id, Origin, SuppliedPhone, SuppliedEmail, Web_First_Name__c, Web_Last_Name__c, SuppliedCompany, CID__c  FROM Case WHERE Subject = 'testcase21313213'];

   //Call the main script that autofills those boxes, and pass the array returned from the above query.
    WebtoCaseWorkflow.QueryAndUpdateCase(getCaseId);
    
    //Create an account and retreive account #
   Account AccountMake1 = new Account(Name='test134523'); insert AccountMake1; 
   ACCOUNT[] getAccountId1 = [SELECT Id FROM Account WHERE name = 'test123'];
   
   //Create a contact that belongs to the account we just made, and retreive the ID
   Contact ContactMake1 = new Contact(LastName='testJo634hnson', FirstName='tes634t', Email='4535frank@frank.com', AccountId=getAccountId[0].Id); insert ContactMake1;
   CONTACT[] getContactId1 = [SELECT Id, FirstName, LastName FROM Contact WHERE LastName = 'testJohnson'];
   
   //Create a case that belongs to the contact we just made, then fetch it's ID.
   Case CaseMake1 = new Case(ContactId=getContactId[0].Id, Status='open', Problem__c='Other', Origin='Web', Subject='testcase21313213', description='test case of joy', PETE_ID__c='ADY2342342', SuppliedPhone='(345)-352-6244', SuppliedEmail='frank@fr435ank.com', CID__c='141231', SuppliedName='Frank Johnson', SuppliedCompany='test123' ); insert CaseMake1;
   CASE[] getCaseId1 = [SELECT Id, Origin, SuppliedPhone, SuppliedEmail, Web_First_Name__c, Web_Last_Name__c, SuppliedCompany, CID__c  FROM Case WHERE Subject = 'testcase21313213'];

   //Call the main script that autofills those boxes, and pass the array returned from the above query.
    WebtoCaseWorkflow.QueryAndUpdateCase(getCaseId1);

 }
}