protected void Page_Load(object sender, EventArgs e)
{
if (Request.Cookies["Login"] != null)
{
if (Request.Cookies["Login"]["admin"] == "0")
{
Response.Redirect("~/customer/Customer.aspx");
}
}
else
{
Response.Redirect("~/Validator.aspx");
}
string SearchQry = "select Complain_No from FEEDBACK";
DataSet sds = BLogic.ReturnDataSet(SearchQry);
if (sds.Tables[0].Rows.Count > 0)
{
Label2.Visible = false;
}
else
{
Label2.Visible = true;
Label2.Text = "No Feedback Found!!!";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Cookies["Login"] != null)
{
if (Request.Cookies["Login"]["admin"] == "0")
{
Response.Redirect("~/customer/Customer.aspx");
}
}
else
{
Response.Redirect("~/Validator.aspx");
}
if (Request.QueryString["bookid"] != null)
{
string searchCustId = "select Cust_Member_Id from BOOKING_DETAILS where Booking_Id=" + Request.QueryString["bookid"] + "";
DataSet cid = BLogic.ReturnDataSet(searchCustId);
string searchEmail = "select Email from CLIENT_REGISTRATION_DETAILS where Cust_Member_Id=" + cid.Tables[0].Rows[0][0].ToString() + "";
DataSet email = BLogic.ReturnDataSet(searchEmail);
TextBoxTo.Text = email.Tables[0].Rows[0][0].ToString();
TextBoxSubject.Text = "Confirmation mail from DE LUXE BANQUET HALL for Booking ID " + Request.QueryString["bookid"];
TextBoxBody.Text = "Your Booking is Sucessful against your payment. ";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Cookies["Login"] == null)
{
Response.Redirect("~/Validator.aspx");
}
if (Request.QueryString["bookid"] == null)
{
Response.Redirect("~/customer/ViewMyBooking.aspx");
}
//Booking Id
Label2.Text = Request.QueryString["bookid"];
//Geting Data
string selectQry = "select Hall_Name, Area, Date, Purpose, Amount, Trans_Id, Status from BOOKING_DETAILS where Booking_Id=" + Label2.Text + " ";
DataSet bookingDetails = BLogic.ReturnDataSet(selectQry);
Label3.Text = bookingDetails.Tables[0].Rows[0][0].ToString();
Label4.Text = bookingDetails.Tables[0].Rows[0][1].ToString();
Label5.Text = bookingDetails.Tables[0].Rows[0][2].ToString();
Label6.Text = bookingDetails.Tables[0].Rows[0][3].ToString();
Label7.Text = bookingDetails.Tables[0].Rows[0][4].ToString();
Label8.Text = bookingDetails.Tables[0].Rows[0][5].ToString();
Label9.Text = bookingDetails.Tables[0].Rows[0][6].ToString();
if (Label9.Text == "Canceled")
{
Button1.Visible = false;
Label10.Text = "Booking is already Canceled!!!";
}
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
string getBookingDetailsQry = "select Booking_Id, Hall_Name, Area, Date, Amount from BOOKING_DETAILS where Cust_Member_Id='" + Request.Cookies["Login"]["profileid"] + "' and Status='" + "Booked" + "' ";
BLogic.FillGrid(getBookingDetailsQry, GridView1);
}
public void CustomerFinder(BLogic BL)
{
Console.Clear();
Console.WriteLine("What Would you like to Search by?");
Console.WriteLine("[0] Customer Id");
Console.WriteLine("[1] Customer Name");
Console.WriteLine("[2] Back");
while (true)
{
switch (Console.ReadLine())
{
case "1":
Console.WriteLine("Enter in the Customer Name: ");
try{
BL.FindUser(Console.ReadLine());
}catch {
Console.WriteLine("unable to Find Customer");
}
Console.WriteLine("");
Console.WriteLine("Press any Key to Continue");
string hold = Console.ReadLine();
Start(BL);
break;
case "0":
Console.WriteLine("Enter in the Customer Id: ");
string input = Console.ReadLine();
if (Int32.TryParse(input, out int id))
{
try{
BL.FindUser(id);
}catch (Exception e) {
if (e.Message != null)
{
Console.WriteLine(e.Message);
}
Console.WriteLine("Unable to Retrieve Data");
}
}
else
{
Console.WriteLine("Invalid Input");
}
Console.WriteLine("");
Console.WriteLine("Press any Key to Continue");
string hol = Console.ReadLine();
Start(BL);
break;
case "2":
Start(BL);
break;
default:
Console.WriteLine("Invalid Input");
break;
}
}
}
public void OrderFinder(BLogic BL)
{
Console.Clear();
Console.WriteLine("Enter the Order Id");
if (Int32.TryParse(Console.ReadLine(), out int id))
{
try{
BL.CheckOrder(id);
}catch (Exception e) {
if (e.Message != null)
{
Console.WriteLine(e.Message);
}
Console.WriteLine("Unable to Retrieve Data");
}
}
else
{
Console.WriteLine("Input Must be a Number");
}
Console.WriteLine("");
Console.WriteLine("Press any Key to Continue");
string hold = Console.ReadLine();
Start(BL);
}
public void Start(BLogic BL)
{
Console.Clear();
Console.WriteLine("[0] Search for Location");
Console.WriteLine("[1] Add a Location");
Console.WriteLine("[2] Back");
string input = Console.ReadLine();
switch (input)
{
case "0":
LocationSearch(BL);
break;
case "1":
AddLocation(BL);
break;
case "2":
new ManagerMainMenu().Start(BL);
break;
default:
this.Start(BL);
break;
}
}
public void AddLocation(BLogic BL)
{
Console.WriteLine("Enter the Name of the New Location: ");
string locationName = Console.ReadLine();
Console.WriteLine("");
Console.WriteLine("Enter the Address of the New Location: ");
string locationAddress = Console.ReadLine();
try{
BL.AddLocation(locationName, locationAddress);
Console.WriteLine("New Store Added");
}catch (Exception e) {
if (e != null)
{
Console.WriteLine(e.Message);
}
Console.WriteLine("Unable to Add New Location");
}
Console.WriteLine("Press any Key to Continue");
string input = Console.ReadLine();
Start(BL);
}
protected void Button6_Click(object sender, EventArgs e)
{
string authQry = "select * from CLIENT_REGISTRATION_DETAILS where Login_Name='" + TextBoxLogUser.Text + "' and Password= '******'";
DataSet ds = BLogic.ReturnDataSet(authQry);
if (ds.Tables[0].Rows.Count > 0)
{
HttpCookie ht = new HttpCookie("Login");
ht.Values.Add("profileid", ds.Tables[0].Rows[0][0].ToString());
ht.Values.Add("username", ds.Tables[0].Rows[0][1].ToString());
ht.Values.Add("name", ds.Tables[0].Rows[0][3].ToString());
ht.Values.Add("admin", ds.Tables[0].Rows[0][15].ToString());
if (CheckBoxRem.Checked)
{
ht.Expires = DateTime.Now.AddDays(20);
}
Response.Cookies.Add(ht);
if (ds.Tables[0].Rows[0][15].ToString() == "1")
{
Response.Redirect("admin/Admin.aspx");
}
else
{
Response.Redirect("customer/Customer.aspx");
}
}
else
{
Label3.Text = "Invalid Username & Password";
}
}
public void Start(BLogic BL)
{
Console.Clear();
Console.WriteLine("[0] View Inventory");
Console.WriteLine("[1] Add Inventory");
Console.WriteLine("[2] View Transcations");
Console.WriteLine("[3] Back");
string input = Console.ReadLine();
switch (input)
{
case "0":
ViewInventory(BL);
break;
case "1":
AddInventory(BL);
break;
case "2":
ViewTransactions(BL);
break;
case "3":
new StoreMenu().Start(BL);
break;
default:
Console.WriteLine("invalid input");
this.Start(BL);
break;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
//insert payment details
string insertQry = "insert into PAYMENT values(" + TextBox2.Text + ",'" + DropDownList1.SelectedItem.Text + "'," + TextBox1.Text + ",'" + Label3.Text + "'," + Label2.Text + "," + Label7.Text + "," + Label8.Text + ")";
string res = BLogic.ExecuteQuery(insertQry).ToString();
//Getting Transaction Id
string transQry = "select Trans_Id from PAYMENT where Booking_Id= " + Label8.Text + " ";
DataSet transDs = BLogic.ReturnDataSet(transQry);
//update booking database
string updateQry = "update BOOKING_DETAILS set Amount='" + Label7.Text + "', Trans_Id='" + transDs.Tables[0].Rows[0][0].ToString() + "' where Booking_Id='" + Label8.Text + "'";
BLogic.ExecuteQuery(updateQry);
//Creating Cookie for Transaction Id
HttpCookie ht = new HttpCookie("Payment");
ht.Values.Add("transid", transDs.Tables[0].Rows[0][0].ToString());
ht.Values.Add("bookid", Label8.Text);
Response.Cookies.Add(ht);
//Redirect
Response.Redirect("~/customer/PaymentHold.aspx?authcode=" + 1);
}
public UserForm(User user, BLogic logic)
{
InitializeComponent();
Text = "Редактировать пользователя";
tbFirstName.Text = user.FirstName;
tbLastName.Text = user.LastName;
ctlBirthDate.Text = user.BirthDate.ToShortDateString();
UserAwards = user.UserAwards;
Awards = logic.GetAllAwards();
int currentIndex = 0;
foreach (var award in Awards)
{
ctlAwards.Items.Add(award.Title);
if (UserAwards != null)
{
foreach (var userAward in UserAwards)
{
if (award.ID == userAward.ID)
{
ctlAwards.SetItemChecked(currentIndex, true);
}
}
currentIndex++;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Cookies["Login"] != null)
{
if (Request.Cookies["Login"]["admin"] == "0")
{
Response.Redirect("~/customer/Customer.aspx");
}
}
else
{
Response.Redirect("~/Validator.aspx");
}
string SearchQry = "select Hall_Code from BANQUET_HALL_Master";
DataSet sds = BLogic.ReturnDataSet(SearchQry);
if (sds.Tables[0].Rows.Count > 0)
{
Label3.Visible = false;
}
else
{
Label3.Visible = true;
Label3.Text = "No Hall Found!!!";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Cookies["Login"] == null)
{
Response.Redirect("~/Validator.aspx");
}
string SearchQry = "select Booking_Id, Hall_Name, Area, Date, Amount from BOOKING_DETAILS where Cust_Member_Id='" + Request.Cookies["Login"]["profileid"] + "'and Status='" + "Booked" + "' ";
DataSet sds = BLogic.ReturnDataSet(SearchQry);
if (sds.Tables[0].Rows.Count > 0)
{
if (!IsPostBack)
{
string getBookingDetailsQry = "select Booking_Id, Hall_Name, Area, Date, Amount from BOOKING_DETAILS where Cust_Member_Id='" + Request.Cookies["Login"]["profileid"] + "'and Status='" + "Booked" + "' ";
BLogic.FillGrid(getBookingDetailsQry, GridView1);
}
}
else
{
Label2.Visible = true;
GridView1.Visible = false;
Label2.Text = "No Active Booking Order Found!!!";
}
}
public void SetupForm(BLogic BL, string cardNum)
{
this.BL = BL;
this.cardNum = cardNum;
UserInterfaceHelper.CenterWindow(this);
UserInterfaceHelper.VisibleForms.Add(this);
}
protected void Button1_Click(object sender, EventArgs e)
{
if (txt_acc_no.Text == "")
{
Label1.Text = "Enter Account Number";
}
else
{
int acno = Convert.ToInt32(txt_acc_no.Text);
DataSet ds1 = (DataSet)BLogic.AccountInfo(acno);
if (ds1.Tables[0].Rows.Count > 0)
{
DataRow dr = ds1.Tables[0].Rows[0];
txt_Cust_Name.Text = dr["CustName"].ToString();
txt_Acc_type.Text = dr["AcntTypeName"].ToString();
txt_Bal.Text = dr["Balance"].ToString();
}
else
{
Label1.Text = "No Record Found At Account Number " + acno;
}
}
}
public void CheckAdminAndPass(string email, string password, BLogic BL)
{
bool admin = false;
if (email == "*****@*****.**" && password == "fishTaco")
{
admin = true;
}
if (admin)
{
try
{
new ManagerMainMenu().Start(BL);
}
catch {
System.Console.WriteLine("oh no error creating a manager");
}
}
else
{
try
{
new CustMainMenu().Start(BL);
} catch {
System.Console.WriteLine("oh no unable to create customer account");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Cookies["Login"] != null)
{
if (Request.Cookies["Login"]["admin"] == "0")
{
Response.Redirect("~/customer/Customer.aspx");
}
}
else
{
Response.Redirect("~/Validator.aspx");
}
string SearchQry = "select Booking_Id from BOOKING_DETAILS";
DataSet s1ds = BLogic.ReturnDataSet(SearchQry);
if (s1ds.Tables[0].Rows.Count > 0)
{
Label2.Visible = false;
}
else
{
Label2.Visible = true;
Label2.Text = "No Bookings Found!!!";
}
}
protected void Button2_Click(object sender, EventArgs e)
{
string updateQry = "update CLIENT_REGISTRATION_DETAILS set Password='******', Cus_Name='" + TextBoxFullName.Text + "', Address='" + TextBoxAddress.Text + "', City='" + TextBoxCity.Text + "', State='" + DropDownListState.Text + "', Pin=" + TextBoxPin.Text + ", Email='" + TextBoxEmail.Text + "', Dob='" + TextBoxDOB.Text + "', Occupation='" + DropDownListOccupation.Text + "', Phone_Office=" + TextBoxOfficePhone.Text + ", Mobile_No=" + TextBoxMobile.Text + ", Account_No=" + TextBoxAccountNumber.Text + " where Cust_Member_Id=" + Request.Cookies["Login"]["profileid"] + " ";
int res = BLogic.ExecuteQuery(updateQry);
if (res > 0)
{
Label16.Text = "Profile Update Sucessful!";
}
else
{
Label16.Text = "Profile is not updated.";
}
if (FileUploadImage.HasFile)
{
if (FileUploadImage.PostedFile.ContentType == "image/jpeg")
{
string path = Server.MapPath("~/customer/profileimage");
string destination = path + "/" + Request.Cookies["Login"]["profileid"] + ".jpg";
FileUploadImage.PostedFile.SaveAs(destination);
}
}
Response.Redirect("~/customer/Customer.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Cookies["Login"] == null)
{
Response.Redirect("~/Validator.aspx");
}
String profileQry = "select * from CLIENT_REGISTRATION_DETAILS where Cust_Member_Id='" + Request.Cookies["Login"]["profileid"] + "'";
DataSet pds = BLogic.ReturnDataSet(profileQry);
Label1.Text = pds.Tables[0].Rows[0][0].ToString();
Label2.Text = pds.Tables[0].Rows[0][1].ToString();
Label3.Text = pds.Tables[0].Rows[0][2].ToString();
Label4.Text = pds.Tables[0].Rows[0][3].ToString();
Label5.Text = pds.Tables[0].Rows[0][4].ToString();
Label6.Text = pds.Tables[0].Rows[0][5].ToString();
Label7.Text = pds.Tables[0].Rows[0][6].ToString();
Label8.Text = pds.Tables[0].Rows[0][7].ToString();
Label9.Text = pds.Tables[0].Rows[0][8].ToString();
Label10.Text = pds.Tables[0].Rows[0][9].ToString();
Label11.Text = pds.Tables[0].Rows[0][10].ToString();
Label12.Text = pds.Tables[0].Rows[0][11].ToString();
Label13.Text = pds.Tables[0].Rows[0][12].ToString();
Label14.Text = pds.Tables[0].Rows[0][13].ToString();
Label15.Text = pds.Tables[0].Rows[0][14].ToString();
Image2.ImageUrl = "~/customer/profileimage/" + Request.Cookies["Login"]["profileid"] + ".jpg";
}
public static void Main(string[] args)
{
int number = 3258;
OutInConsole.Print(ALogic.GetSumOfDigits(number));
OutInConsole.Print(ALogic.GetLength(number));
OutInConsole.Print($"Number: {number}\tAmount of numbers: {ALogic.AmountElement(number)}");
OutInConsole.Print(BLogic.HasMoreEven(number));
OutInConsole.Print(BLogic.HasOneEven(number));
OutInConsole.Print($"Number: {number}\tAnswer: {BLogic.IsDominatedByOddOrEvenNumbers(number)}");
OutInConsole.Print(CLogic.IsDecreasingSequence(number));
OutInConsole.Print(CLogic.IsDecreasingSequence(951));
OutInConsole.Print(CLogic.ReverseNumber(number));
OutInConsole.Print($"Number: {number}\tAnswer: {(number == 0) || (CLogic.CheckingForPalindrome(number, 0)) == number}");
OutInConsole.Print(DLogic.FindMaxDigit(number));
OutInConsole.Print(DLogic.IsPrime(4));
OutInConsole.Print(DLogic.IsPrime(3));
OutInConsole.Print($"Number: {number}\tAmount of numbers: {DLogic.Element(number)}");
OutInConsole.Print(ELogic.DegreeOfThree(18));
OutInConsole.Print(ELogic.DegreeOfThree(27));
OutInConsole.Print(ELogic.DegreeOfTwo(27));
OutInConsole.Print(ELogic.DegreeOfTwo(64));
OutInConsole.Print(ELogic.GetTriboncchiWithIndex(8));
OutInConsole.Print($"Number: {number}\tAnswer: {ELogic.NumberFibonacci(number, 1, 0)}");
}
public void AskForLogin(BLogic BL)
{
Console.Clear();
Console.WriteLine("Sign in or Create a new account: ");
Console.WriteLine("[0] Sign In");
Console.WriteLine("[1] Create New Account");
Console.WriteLine("[2] Exit");
while (true)
{
string input = Console.ReadLine();
switch (input)
{
case "0":
UserLogin(BL);
break;
case "1":
NewUserLogin(BL);
break;
case "2":
Console.Clear();
System.Environment.Exit(0);
break;
default:
Console.WriteLine("Invalid Input");
break;
}
}
}
public void Register(TCPOS.FrontEnd.BusinessLogic.BLogic BL, PluginManager PM)
{
this.BL = BL;
PM.OnBeforeKeyPress += PM_OnBeforeKeyPress;
PM.OnProcessUnknownIniParameter += PM_OnProcessUnknownIniParameter;
PM.OnBeforeCloseTransaction += PM_OnBeforeCloseTransaction;
PM.OnBeforeCalculateTransTotal += new BeforeCalculateTransTotalEvent(PM_OnBeforeCalculateTransTotal);
}
public void SetupForm(BLogic BL)
{
this.BL = BL;
UserInterfaceHelper.CenterWindow(this);
UserInterfaceHelper.VisibleForms.Add(this);
// Colores --> Verde: #2a9800 - Rojo: #d74a2b - Naranja: #ffa909
cancelar.BackColor = ColorTranslator.FromHtml("#d74a2b");
}
public void Purchase(BLogic BL, int productId)
{
int orderAmount;
int available = BL.CheckItemAmount1(productId);
double price = BL.GetProductPrice(productId);
while (true)
{
Console.Clear();
Console.WriteLine(available + " available");
Console.WriteLine("How Much You Wan?");
try{
orderAmount = Int32.Parse(Console.ReadLine());
if (orderAmount > available)
{
throw new Exception("You Order Mo Than We Got");
}
break;
} catch (Exception e) {
Console.WriteLine(e.Message);
Console.WriteLine("Invalid Input");
}
}
Console.WriteLine("That'll be " + (price * orderAmount));
Console.WriteLine("Would you like to Purchase?");
Console.WriteLine("[0] Yes");
Console.WriteLine("[1] No");
while (true)
{
switch (Console.ReadLine())
{
case "0":
try{
BL.MakePurchase(productId, orderAmount);
Console.WriteLine("Your Order is Complete");
OrderOnline(BL);
} catch (Exception e) {
if (e.Message != null)
{
Console.WriteLine(e.Message);
}
Console.WriteLine("Order Failed");
}
break;
case "1":
Console.WriteLine("Order Canceled");
OrderOnline(BL);
break;
default:
Console.WriteLine("Invalid Input");
break;
}
}
}
public void SetupForm(BLogic BL)
{
this.BL = BL;
//this.variableTID = variableTID;
UserInterfaceHelper.CenterWindow(this);
UserInterfaceHelper.VisibleForms.Add(this);
txtMonto.Text = SafeConvert.ToString(BL.CurrentTransaction.FoodToPay());
}
public void SetupForm(BLogic BL)
{
this.BL = BL;
UserInterfaceHelper.TranslateForm(this);
UserInterfaceHelper.CenterWindow(this);
UserInterfaceHelper.VisibleForms.Add(this);
DataTable bancos = BL.DB.ExecuteDataTable("SELECT id, description FROM bes_banks WHERE status=0 ORDER BY description");
int contador = bancos.Rows.Count;
var dataSource = new List <TestObject>();
foreach (DataRow banco in bancos.Rows)
{
String description = banco["description"].ToString();
int id = SafeConvert.ToInt32(banco["id"]);
dataSource.Add(new TestObject()
{
Name = description, Value = id
});
}
this.x_banco_cheque.DataSource = dataSource;
this.x_banco_cheque.DisplayMember = "Name";
this.x_banco_cheque.ValueMember = "Value";
this.x_banco_cheque.DropDownStyle = ComboBoxStyle.DropDownList;
// Dia
for (int i = 1; i <= 31; i++)
{
x_dia_cheque.Items.Add(i.ToString());
}
// Mes
for (int i = 1; i <= 12; i++)
{
x_mes_cheque.Items.Add(i.ToString());
}
// Año
for (int i = 2016; i <= 2018; i++)
{
x_anio_cheque.Items.Add(i.ToString());
}
// Colores --> Verde: #2a9800 - Rojo: #d74a2b - Naranja: #ffa909
aceptar.BackColor = ColorTranslator.FromHtml("#2a9800");
cancelar.BackColor = ColorTranslator.FromHtml("#d74a2b");
// Valores de Prueba por Defecto
x_numero_cheque.Text = "0987654";
//x_tasas_interes.Text = "2";
rut_cheque.Text = "12345678A";
x_nombre_completo_cheque.Text = "Domingo José Ilarreta Heydras";
x_dia_cheque.Text = DateTime.Now.ToString("dd");
x_mes_cheque.Text = DateTime.Now.ToString("MM");
x_anio_cheque.Text = DateTime.Now.ToString("yyyy");
nro_cta_corriente.Text = "09876543";
x_cod_auth_cheque.Text = "098768000000";
x_monto.Text = BL.CurrentTransaction.FoodToPay().ToString();
}
public ActionResult AddUser(User details)
{
//string result = _objIBLLReg.addRecord(details);
//return Json(result, JsonRequestBehavior.AllowGet);
BLogic obj = new BLogic();
string result = obj.addRecord(details);
return(Json(result, JsonRequestBehavior.AllowGet));
}
public void Register(BLogic BL, PluginManager PM)
{
this.BL = BL;
PM.OnBeforeKeyPress += PM_OnBeforeKeyPress;
PM.OnDataAvailable += PM_OnDataAvailable;
//PM.OnBeforeKeyPress += new KeyPressEvent(PM_OnBeforeKeyPress); // Otra Forma simiLar a "PM.OnBeforeKeyPress += PM_OnBeforeKeyPress;"
PM.OnSerializeToDbTransItemInElement += PM_OnSerializeToDbTransItemInElement;
PM.OnBeforeCloseTransaction += PM_OnBeforeCloseTransaction;
}
public UserForm(BLogic logic)
{
InitializeComponent();
Text = "Добавить пользователя";
Awards = logic.GetAllAwards();
foreach (var award in Awards)
{
ctlAwards.Items.Add(award.Title);
}
}
