protected void Button1_Click(object sender, EventArgs e)
{
if (!checkInfo())
{
return;
}
DataManagment.costumer cost = new DataManagment.costumer();
cost.ID = Int32.Parse(Label1.Text);
cost.firstName = TextBox10.Text;
cost.lastName = TextBox11.Text;
cost.email = TextBox1.Text;
cost.password = TextBox2.Text;
cost.gender = DropDownList1.SelectedItem.ToString();
try
{
cost.age = Int32.Parse(TextBox4.Text);
}
catch (Exception) { cost.age = 0; }
cost.contactNumber = TextBox5.Text;
cost.address = TextBox6.Text;
cost.carModel = TextBox7.Text;
cost.carColor = TextBox8.Text;
cost.plateNumber = TextBox9.Text;
bool result = db.addCostumer(cost);
Session["msg"] = "New costumer has been created successfully";
Response.Redirect("Success.aspx");
}
protected void Button4_Click(object sender, EventArgs e)
{
Label10.Visible = false;
DataManagment.costumer cost = new DataManagment.costumer();
cost = db.searchCostumer(TextBox1.Text);
if (cost == null)
{
Label10.Text = "Costumer not found";
Label10.Visible = true;
return;
}
DateTime today = DateTime.Today;
int appId = db.getAppointmentDate(cost.ID, today);
if (appId == 0)
{
Label10.Text = "There is no appointment for this costumer today";
Label10.Visible = true;
return;
}
Label11.Text = appId.ToString();
Label1.Text = cost.firstName;
Label2.Text = cost.lastName;
Label3.Text = cost.gender;
Label4.Text = cost.contactNumber;
Label5.Text = cost.age.ToString();
Label6.Text = cost.email;
Label7.Text = cost.carModel;
Label8.Text = cost.plateNumber;
Label9.Text = cost.address;
loadTable(appId);
}
protected void Button1_Click(object sender, EventArgs e)
{
Label1.Visible = false;
DataBase db = new DataBase();
DataManagment.costumer cost = db.searchCostumer(Session["ID"].ToString().TrimEnd());
if (!TextBox1.Text.Equals(cost.password))
{
Label1.Visible = true;
Label1.Text = "Wrong Password";
return;
}
if (TextBox2.Text.Length < 2)
{
Label1.Visible = true;
Label1.Text = "Please insert new password";
return;
}
if (!TextBox2.Text.Equals(TextBox3.Text))
{
Label1.Visible = true;
Label1.Text = "Passwords are not matched";
return;
}
cost.password = TextBox2.Text;
db.updatePass(cost);
Session["msg"] = "Your password has been updated successfully";
Response.Redirect("Success.aspx");
}
public List <DataManagment.costumer> getCostumers()
{
List <DataManagment.costumer> retVal = new List <DataManagment.costumer>();
string command = "SELECT * FROM Costumer";
SqlCommand comm = new SqlCommand(command, conn);
SqlDataReader reader;
conn.Open();
reader = comm.ExecuteReader();
while (reader.Read())
{
DataManagment.costumer temp = new DataManagment.costumer();
temp.ID = reader.GetInt32(0);
temp.firstName = reader.GetString(1);
temp.lastName = reader.GetString(2);
temp.email = reader.GetString(3);
temp.password = reader.GetString(4);
temp.gender = reader.GetString(5);
temp.age = reader.GetInt32(6);
temp.contactNumber = reader.GetString(7);
temp.address = reader.GetString(8);
temp.carModel = reader.GetString(9);
temp.carColor = reader.GetString(10);
temp.plateNumber = reader.GetString(11);
retVal.Add(temp);
}
reader.Close();
conn.Close();
return(retVal);
}
protected void Button1_Click(object sender, EventArgs e)
{
Label1.Visible = false;
string userName = TextBox1.Text;
string password = TextBox2.Text;
if (userName.Equals("admin") && password.Equals("admin"))
{
Session["ID"] = "admin";
Response.Redirect("ShopMain.aspx");
}
else
{
DataBase db = new DataBase();
DataManagment.costumer cost = new DataManagment.costumer();
cost = db.auth(userName, password);
if (cost == null)
{
Label1.Text = "Wrong user name or password";
Label1.Visible = true;
return;
}
Session["email"] = cost.email;
Session["name"] = cost.firstName + " " + cost.lastName;
Session["ID"] = cost.ID.ToString();
Response.Redirect("costumerMain.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string email = Session["email"].ToString().TrimEnd();
curUser = db.searchCostumer(email);
fillupform(curUser);
}
}
public void updatePass(DataManagment.costumer cost)
{
string command = "UPDATE Costumer SET Password='******' WHERE ID='" + cost.ID + "'";
SqlCommand comm = new SqlCommand(command, conn);
conn.Open();
comm.ExecuteNonQuery();
conn.Close();
}
public void updateProfile(DataManagment.costumer cost)
{
string command = "UPDATE Costumer SET FirstName='" + cost.firstName + "', LastName='" + cost.lastName + "',Gender='" + cost.gender + "',Age='" + cost.age + "',ContactNumber='" + cost.contactNumber + "',Address='" + cost.address + "',CarModel='" + cost.carModel + "',CarColor='" + cost.carColor + "',PlateNumber='" + cost.plateNumber + "' WHERE ID='" + cost.ID + "'";
SqlCommand comm = new SqlCommand(command, conn);
conn.Open();
comm.ExecuteNonQuery();
conn.Close();
}
public void fillupform(DataManagment.costumer user)
{
Label1.Text = user.ID.ToString();
TextBox1.Text = user.email;
TextBox10.Text = user.firstName;
TextBox11.Text = user.lastName;
DropDownList1.SelectedItem.Text = user.gender;
TextBox4.Text = user.age.ToString();
TextBox5.Text = user.contactNumber;
TextBox6.Text = user.address;
TextBox7.Text = user.carModel;
TextBox8.Text = user.carColor;
TextBox9.Text = user.plateNumber;
}
public bool addCostumer(DataManagment.costumer costumer)
{
if (!checkCostumer(costumer.email))
{
return(false);
}
string command = "INSERT INTO Costumer (FirstName,LastName,Email,Password,Gender,Age,ContactNumber,Address,CarModel,CarColor,PlateNumber) VALUES('" + costumer.firstName + "','" + costumer.lastName + "','" + costumer.email + "','" + costumer.password + "','" + costumer.gender + "','" + costumer.age + "','" + costumer.contactNumber + "','" + costumer.address + "','" + costumer.carModel + "','" + costumer.carColor + "','" + costumer.plateNumber + "')";
SqlCommand comm = new SqlCommand(command, conn);
conn.Open();
comm.ExecuteNonQuery();
conn.Close();
return(true);
}
protected void Button4_Click(object sender, EventArgs e)
{
Label8.Visible = false;
for (int i = 0; i < tasks.Count; i++)
{
TableRow row = new TableRow();
if (i % 2 != 0)
{
row.BackColor = System.Drawing.Color.FromName("#D73739");
row.ForeColor = System.Drawing.Color.White;
}
else
{
row.BackColor = System.Drawing.Color.White;
row.ForeColor = System.Drawing.Color.FromName("#D73739");
}
TableCell num = new TableCell();
TableCell ta = new TableCell();
num.HorizontalAlign = HorizontalAlign.Center;
num.Text = (i + 1).ToString();
ta.Text = tasks[i];
row.Cells.Add(num);
row.Cells.Add(ta);
Table1.Rows.Add(row);
}
if (TextBox10.Text.Length < 1)
{
Label8.Text = "Please insert data";
Label8.Visible = true;
return;
}
DataManagment.costumer cost = db.searchCostumer(TextBox10.Text);
if (cost == null)
{
Label8.Text = "Costumer not found";
Label8.Visible = true;
return;
}
Label3.Text = cost.ID.ToString();
costId = cost.ID;
Label4.Text = cost.email;
Label5.Text = cost.firstName + " " + cost.lastName;
Label6.Text = cost.carModel;
Label7.Text = cost.plateNumber;
}
protected void Button1_Click(object sender, EventArgs e)
{
if (!checkInfo())
{
return;
}
DataManagment.costumer newInfo = new DataManagment.costumer();
newInfo.ID = Int32.Parse(Label1.Text);
newInfo.email = TextBox1.Text;
newInfo.firstName = TextBox10.Text;
newInfo.lastName = TextBox11.Text;
newInfo.password = curUser.password;
newInfo.gender = DropDownList1.SelectedItem.Text;
newInfo.age = Int32.Parse(TextBox4.Text);
newInfo.contactNumber = TextBox5.Text;
newInfo.address = TextBox6.Text;
newInfo.carModel = TextBox7.Text;
newInfo.carColor = TextBox8.Text;
newInfo.plateNumber = TextBox9.Text;
db.updateProfile(newInfo);
Session["msg"] = "Your profile has been updated successfully";
Response.Redirect("Success.aspx");
}
public void loadTable()
{
DataBase db = new DataBase();
DateTime comp;
if (RadioButton1.Checked)
{
comp = DateTime.Today;
}
else if (RadioButton2.Checked)
{
comp = DateTime.Today.AddDays(7);
}
else if (RadioButton3.Checked)
{
comp = DateTime.Today.AddDays(31);
}
else
{
comp = DateTime.Today.AddYears(5);
}
DateTime today = DateTime.Today;
List <DataManagment.appontment> app = new List <DataManagment.appontment>();
app = db.getApps();
int i = 0;
foreach (DataManagment.appontment temp in app)
{
i++;
if (temp.date >= today && temp.date <= comp)
{
DataManagment.costumer cost = new DataManagment.costumer();
cost = db.searchCostumer(temp.costumerID.ToString());
TableRow row = new TableRow();
row.HorizontalAlign = HorizontalAlign.Center;
if (i % 2 == 0)
{
row.BackColor = System.Drawing.Color.FromName("#D73739");
row.ForeColor = System.Drawing.Color.White;
}
else
{
row.BackColor = System.Drawing.Color.White;
row.ForeColor = System.Drawing.Color.FromName("#D73739");
}
TableCell id = new TableCell();
id.Text = temp.ID.ToString();
TableCell date = new TableCell();
date.Text = temp.date.Year + "/" + temp.date.Month + "/" + temp.date.Day;
TableCell time = new TableCell();
time.Text = temp.time.ToString();
TableCell cn = new TableCell();
cn.Text = cost.firstName + " " + cost.lastName;
TableCell ph = new TableCell();
ph.Text = cost.contactNumber;
TableCell car = new TableCell();
car.Text = cost.carModel;
TableCell pn = new TableCell();
pn.Text = cost.plateNumber;
row.Cells.Add(id);
row.Cells.Add(date);
row.Cells.Add(time);
row.Cells.Add(cn);
row.Cells.Add(ph);
row.Cells.Add(car);
row.Cells.Add(pn);
Table1.Rows.Add(row);
}
}
}
protected void Button4_Click(object sender, EventArgs e)
{
Label3.Visible = false;
DataManagment.costumer cost = new DataManagment.costumer();
if (cost == null)
{
Label3.Visible = true;
Label3.Text = "Costumer not found";
return;
}
cost = db.searchCostumer(TextBox1.Text);
Label1.Text = cost.firstName + " " + cost.lastName;
Label2.Text = cost.contactNumber;
List <DataManagment.appontment> app = db.getAppsbyID(cost.ID);
int i = 0;
foreach (DataManagment.appontment tapp in app)
{
List <DataManagment.task> task = db.getTasks(tapp.ID);
foreach (DataManagment.task ttask in task)
{
i++;
TableRow row = new TableRow();
row.HorizontalAlign = HorizontalAlign.Center;
if (i % 2 == 0)
{
row.BackColor = System.Drawing.Color.FromName("#D73739");
row.ForeColor = System.Drawing.Color.White;
}
else
{
row.BackColor = System.Drawing.Color.White;
row.ForeColor = System.Drawing.Color.FromName("#D73739");
}
TableCell id = new TableCell();
id.Text = tapp.ID.ToString();
TableCell date = new TableCell();
date.Text = tapp.date.Year + "/" + tapp.date.Month + "/" + tapp.date.Day;
TableCell time = new TableCell();
time.Text = tapp.time.ToString();
TableCell ta = new TableCell();
ta.Text = ttask.name;
TableCell des = new TableCell();
des.Text = ttask.description;
string st = string.Empty;
if (ttask.status == 0)
{
st = "Not Done";
}
else
{
st = "Done";
}
TableCell stat = new TableCell();
stat.Text = st;
row.Cells.Add(id);
row.Cells.Add(date);
row.Cells.Add(time);
row.Cells.Add(ta);
row.Cells.Add(des);
row.Cells.Add(stat);
Table1.Rows.Add(row);
}
}
}
