Final Exam PROG 32356 You are allowed to use any materials including slides, books, assignments/programs created by you or the solutions provided by the professor, MSDN Documentation, Internet. a)...

BhumiFinalExam/BhumiFinalExam/App.config







BhumiFinalExam/BhumiFinalExam/BhumiFinalExam.csproj



Debug
AnyCPU
{A5B49B47-2BCC-4B62-B309-D368A562B13F}
Exe
BhumiFinalExam
BhumiFinalExam
v4.7.2
512
true
true


AnyCPU
true
full
false
bin\Debug\
DEBUG;TRACE
prompt
4


AnyCPU
pdbonly
true
bin\Release\
TRACE
prompt
4




















BhumiFinalExam/BhumiFinalExam/Program.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
namespace BhumiFinalExam
{
class Program
{
static void Main(string[] args)
{
string username = LoginPage();
AccessLoginPage(username);

}
public static void AccessLoginPage(string username)
{
if (username != "" && username != null)
{
Console.WriteLine("You are successfully login.");
Console.Clear();
if (username != "" || username != null)
OptionPage(username);
}
else
{
Console.Clear();
Console.WriteLine("Login is Failed!");
MenuLoginFail();
}
}
public static string LoginPage()
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["connString"].ConnectionString);
con.Open();
SqlCommand cmd;
DataTable dt = new DataTable();
Console.WriteLine("Welcome to Bhumi's Application. Please enter the credentials to log in.");
Console.WriteLine("Enter Username");
string username = Console.ReadLine();
Console.WriteLine("Enter Password");
string password = Console.ReadLine();
if (username == "" || password == "")
{
Console.WriteLine("Either username or password is blank.");
return username;
}
else
{
cmd = new SqlCommand("select * from Customer_Detail where CustUserName='" + username + "' and CustPassword='" + password + "'");
cmd.Connection = con;
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
da.Fill(dt);
}
con.Close();
if ((dt.Rows.Count > 0))
return username;
else
return null;
}
}
private static bool MenuLoginFail()
{
Console.WriteLine("1) Try Again");
Console.WriteLine("2) Sign Up");
Console.WriteLine("3) Exit");
Console.WriteLine("\r\nWrite your option: ");
switch (Console.ReadLine())
{
case "1":
Console.Clear();
string username = LoginPage();
AccessLoginPage(username);
return true;
case "2":
Console.Clear();
SignUp();
return true;
case "3":
return false;
default:
return true;
}

}
private static bool OptionMenu(string userName)
{
Console.WriteLine("1) Edit Customer Profile");
Console.WriteLine("2) Buy Products");
Console.WriteLine("3) Exit Application");
Console.WriteLine("\r\nWrite your option: ");
switch (Console.ReadLine())
{
case "1":
Console.Clear();
EditCustomerProfile(userName);
return true;
case "2":
Console.Clear();
BuyProducts(userName);
return true;
case "3":
return false;
default:
return true;
}

}
public static void SignUp()
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["connString"].ConnectionString);
con.Open();
SqlCommand cmd;
Console.WriteLine("New to Bhumi's Application. Please enter your details to Sign Up.");
Console.WriteLine("Enter Customer Name");
string custName = Console.ReadLine();
Console.WriteLine("Enter City");
string city = Console.ReadLine();
Console.WriteLine("Enter Credit Limit");
string creditLimit = Console.ReadLine();
if (custName == "" || city == "" || creditLimit == "")
{
Console.WriteLine("Enter value for all the fields");
SignUp();
}
else
{
bool IsCreditLimitValid = validateCreditLimit(creditLimit);
bool IsCustomerNameUnique = validateCustomerName(con, custName);
if (IsCreditLimitValid && IsCustomerNameUnique)
{
Int32 number;
Int32.TryParse(creditLimit, out number);
cmd = new SqlCommand("Insert into Customer (CustName, City, CreditLimit) Values('" + custName + "','" + city + "'," + number + ")", con);
cmd.ExecuteNonQuery();

//Insert password as reverse of username.
string password = ReverseString(custName);
//Insert data into Customer_Detail Table.
cmd = new SqlCommand("Insert into Customer_Detail (CustUserName, CustPassword) Values('" + custName + "','" + password + "')", con);
cmd.ExecuteNonQuery();
Console.Clear();
Console.WriteLine("Data Inserted Successfully!");
Console.WriteLine("Now login again!");
string username = LoginPage();
AccessLoginPage(username);
}
else
{
if (!IsCreditLimitValid)
{
validateCreditLimit(creditLimit);
}
if (!IsCustomerNameUnique)
{
Console.WriteLine("Enter unique customer name");
Console.Clear();
...