~!!~

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Configuration;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data.SqlTypes;

namespace Banking_v._1._0
{
public partial class loginform : Form
{
SqlConnection connect;
int cnt = 0;
string uname;

public loginform()
{
InitializeComponent();
}

private void OpenConnection()
{
connect = new SqlConnection();
connect.ConnectionString = ConfigurationManager.AppSettings["ApplicationConnection"].ToString();
connect.Open();
}
private void loginform_Activated(object sender, System.EventArgs e)
{

}
private void btnExit_Click(object sender, EventArgs e)
{
DialogResult dlg;
dlg = MessageBox.Show(“Are you sure you want to exit?”, “Attention”, MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation);
if (dlg == DialogResult.Yes)
{
Application.Exit();
}
}

private void btnLogin_Click(object sender, EventArgs e)
{
OpenConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = connect;
cmd.CommandType = CommandType.Text;
cmd.CommandText = “SELECT * FROM TellerInfo”;

bool x = false;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
if ((reader["EmployeeID"].ToString() == txtTellerID.Text) && (reader["Password"].ToString() == txtPassword.Text))
{
this.Close();
MessageBox.Show(“Login successful.”, “Banking version 1.0″, MessageBoxButtons.OK, MessageBoxIcon.Information);
Main_Form.tellername = support.GetData(“EmployeeLastName”, “TellerInfo”, “EmployeeID”, txtTellerID.Text);
x = true;
}
}

if (x == false)
{
txtPassword.Clear();
txtTellerID.Clear();
cnt = cnt + 1;
MessageBox.Show(“Invalid Teller ID or Password”, “Warning”, MessageBoxButtons.OK, MessageBoxIcon.Warning);
if (cnt == 3)
{
MessageBox.Show(“Invalid access to Application”, “Access denied”, MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
Application.Exit();
}

}

reader.Close();

}

private void loginform_Load(object sender, EventArgs e)
{

}

private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
Password_Retrival frm = new Password_Retrival();
frm.ShowDialog();
}

}
}

Chapter 12 – Pricing and Signup

Well, this chapter is all about what the title says so. Pricing and signup? Do you ever think of why is that there are alot of people try different kinds of site even if they know there spam mails are getting full? haha. seriously, I am one of those freebie guy out there signing up for site which I never knew and trying if their product will work for me or not.

Well, FREEMIUM are now everywhere in the internet. Free at first, sign up at last. haha. After quite sometime trial version will end that you need to purchase their products to continue with their service.

That was one of the topic this chapter is giving us. the correct pricing and correct signing up. For me, if i develop softwares like they do I would give the beta version for free. and if I know what I need to look at thats the time I work on with the patch and give the patch its fee for the user. Cool isn’t it? Business is good. haha.

Another thing, correct pricing is what we need. Well, thinking off piracy in the internet why people giving a damn for this kind of work? Why authorities look for it? Well, do they know why people are supporting pirated materials? Well, for a fact that people supporting it doesn’t have moolah purchasing this gold thing offered by Music labels for their artists. If they know how to give it to the market? well, they would not have a headache until now. Good price is one thing we need to learn. How we need to price our products in order for us to market it fully and correctly.