public static Person_address FindAddressID(int ID)
{
try
{
Person_address address = db.Person_address.Single(pa => pa.Aid == ID);
return(address);
}
catch (Exception ex)
{
logger.Error(ex, "DatabaseAction.Find Null Error");
return(null);
}
}
public static Person_address AddNewContact(Person p, string hnum, string street, string city, string state, string country, string zipcode)
{
pa = new Person_address
{
houseNum = hnum,
street = street,
address_city = city,
address_state = state,
address_country = country,
zipcode = zipcode
};
pa.People.Add(p);
return(pa);
}
public static string Edit(ref int opt, Person_address address, string text)
{
switch (opt)
{
case 1:
address.houseNum = text;
return(Save());
case 2:
address.street = text;
return(Save());
case 3:
address.address_city = text;
return(Save());
case 4:
try
{
address.address_state = Enum.GetName(typeof(State), Enum.Parse(typeof(State), text));
return(Save());
}
catch (Exception ex)
{
logger.Error(ex, "DatabaseAction.Edit BadInput Error");
return("Invalid State!");
}
case 5:
try
{
address.address_country = Enum.GetName(typeof(Country), Enum.Parse(typeof(Country), text));
return(Save());
}
catch (Exception ex)
{
logger.Error(ex, "DatabaseAction.Edit BadInput Error");
return("Invalid Country!");
}
case 6:
address.zipcode = text;
return(Save());
default:
return("No Information Updated");
}
}
public static void AddToDatabase(Person_address pa)
{
db.Person_address.Add(pa);
}
public static string Del(Person_address address)
{
db.Person_address.Remove(address);
return(Save());
}
public static void UpdateOption(int up_del)
{
int opt = 0;
int id;
int updateOpt;
string updateText;
do
{
if (up_del == 1)
{
Console.WriteLine("\nUpdate:");
}
else
{
Console.WriteLine("\nDelete:");
}
Console.WriteLine("1. PERSON | 2. PHONE | 3. ADDRESS | 4.BACK");
switch (opt = ConvertCheck())
{
case 1:
Console.WriteLine("\nEnter Person ID: ");
id = ConvertCheck();
Person p = DatabaseAction.FindPersonID(id);
if (p != null && up_del == 1)
{
Console.WriteLine("Select Following Fields:");
updateOpt = PersonOpt();
updateText = Add("Text");
Console.WriteLine(DatabaseAction.Edit(ref updateOpt, p, updateText));
}
else if (p != null && up_del == 2)
{
Console.WriteLine(DatabaseAction.Del(p));
}
else if (p == null)
{
Console.WriteLine("No Records Found!");
}
break;
case 2:
Console.WriteLine("\nEnter Phone ID: ");
id = ConvertCheck();
Person_phone pp = DatabaseAction.FindPhoneID(id);
if (pp != null && up_del == 1)
{
Console.WriteLine("Select Following Fields:");
updateOpt = PhoneOpt();
updateText = Add("Text");
Console.WriteLine(DatabaseAction.Edit(ref updateOpt, pp, updateText));
}
else if (pp != null && up_del == 2)
{
Console.WriteLine(DatabaseAction.Del(pp));
}
else if (pp == null)
{
Console.WriteLine("No Records Found!");
}
break;
case 3:
Console.WriteLine("\nEnter Address ID: ");
id = ConvertCheck();
Person_address pa = DatabaseAction.FindAddressID(id);
if (pa != null && up_del == 1)
{
Console.WriteLine("Select Following Fields:");
updateOpt = AddressOpt();
updateText = Add("Text");
Console.WriteLine(DatabaseAction.Edit(ref updateOpt, pa, updateText));
}
else if (pa != null && up_del == 2)
{
Console.WriteLine(DatabaseAction.Del(pa));
}
else if (pa == null)
{
Console.WriteLine("\nNo Records Found!");
}
break;
case 4:
break;
default:
Console.WriteLine("Invalid Option!");
break;
}
} while (opt != 4);
}