public static string Edit(ref int opt, Person_phone phone, string text)
{
switch (opt)
{
case 1:
try
{
phone.countryCode = (int)Enum.Parse(typeof(Country), text);
return(Save());
}
catch (Exception ex)
{
logger.Error(ex, "DatabaseAction.Edit BadInput Error");
return("Invalid Country!");
}
case 2:
phone.areaCode = text;
return(Save());
case 3:
phone.number = text;
return(Save());
case 4:
phone.ext = text;
return(Save());
default:
return("No Information Updated");
}
}
public static Person_phone AddNewContact(Person p, int countrycode, string areacode, string number, string ext)
{
pp = new Person_phone
{
Person = p,
countryCode = countrycode,
areaCode = areacode,
number = number,
ext = ext
};
return(pp);
}
public static Person_phone FindPhoneID(int ID)
{
try
{
Person_phone phone = db.Person_phone.Single(pp => pp.PHid == ID);
return(phone);
}
catch (Exception ex)
{
logger.Error(ex, "DatabaseAction.Find Null Error");
return(null);
}
}
public static void AddToDatabase(Person_phone pp)
{
db.Person_phone.Add(pp);
}
public static string Del(Person_phone phone)
{
db.Person_phone.Remove(phone);
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);
}
