//Returnerar tiden för den valda tjänsten
private int tjanstTid()
{
BusinessDAL bDal = new BusinessDAL();
int tid = bDal.getTjanstTid(tjanstID());
return(tid);
}
//Hämtar användarens info och skriver ut den
private void GetUserData()
{
BusinessDAL bDAL = new BusinessDAL();
anvandare user = new anvandare();
user = bDAL.getUserData(Session["userid"].ToString());
tbxFornamn.Text = user.FirstName;
tbxEfternamn.Text = user.LastName;
tbxMail.Text = user.Epost;
tbxSSN.Text = user.ssn;
if (user.faktura == "False")
{
cbxFaktura.Checked = false;
}
else
{
cbxFaktura.Checked = true;
}
if (user.newsletter == "False")
{
cbxNewsLetter.Checked = false;
}
else
{
cbxNewsLetter.Checked = true;
}
}
protected DataTable oldorders()
{
BusinessDAL bDal = new BusinessDAL();
DataTable dt = new DataTable();
dt = bDal.getOldUserOrders(Session["userid"].ToString());
foreach (DataColumn dc in dt.Columns)
{
dc.ReadOnly = false;
}
foreach (DataRow dr in dt.Rows)
{
if (dr["startTid"].ToString().Length == 4)
{
dr["startTid"] += "0";
}
if (dr["slutTid"].ToString().Length == 4)
{
dr["slutTid"] += "0";
}
}
return(dt);
}
//Hämtar ut bokningen du precis gjorde på boka.aspx
protected DataTable order()
{
BusinessDAL bDal = new BusinessDAL();
DataTable dt = new DataTable();
string price = "";
dt = bDal.getOrder(Session["orderID"].ToString());
Session.Remove("orderID");
foreach (DataColumn dc in dt.Columns)
{
dc.ReadOnly = false;
}
foreach (DataRow dr in dt.Rows)
{
if (dr["startTid"].ToString().Length == 4)
{
dr["startTid"] += "0";
}
if (dr["slutTid"].ToString().Length == 4)
{
dr["slutTid"] += "0";
}
if (dr["pris"].ToString() != "0")
{
price = dr["pris"].ToString();
}
}
litPrice.Text += price;
return(dt);
}
//Hämtar tjänstinfo
private DataTable massorList()
{
BusinessDAL bDal = new BusinessDAL();
DataTable dt = new DataTable();
dt = bDal.getMassorInfo();
return(dt);
}
//Hämtar alla schemaevent, bokningar och tillgängliga tider
private DataTable calenderEvents(DateTime start, int week)
{
BusinessDAL bDal = new BusinessDAL();
DataTable dt = new DataTable();
dt = bDal.getSchedule(week, anstalldID());
return(dt);
}
private DataTable nyheterList()
{
BusinessDAL bDal = new BusinessDAL();
DataTable dt = new DataTable();
dt = bDal.getNyheterInfo();
return(dt);
}
//Hämtar artikeln om tjänster
private void GetOneArtikel()
{
BusinessDAL bDAL = new BusinessDAL();
artikel art = new artikel();
art = bDAL.getArtikelInfo(1);
lblRubrik.Text = art.rubrik;
litBeskrivning.Text = art.beskrivning;
}
//Hämtar annonserna
private DataTable annonserList()
{
BusinessDAL bDal = new BusinessDAL();
DataTable dt = new DataTable();
dt = bDal.getAnnonsorInfo();
return(dt);
}
private DataTable calenderEvents(DateTime start, int week)
{
BusinessDAL bDal = new BusinessDAL();
DataTable dt = new DataTable();
dt = bDal.getSchedule(week, Session["userId"].ToString());
return(dt);
}
protected void btnNewTime_Click(object sender, EventArgs e)
{
DateTime result;
BusinessDAL bDAL = new BusinessDAL();
if (DateTime.TryParse(tbNewTime_slutTid.Text, out result) && DateTime.TryParse(tbNewTime_startTid.Text, out result))
{
bDAL.newSchemaTid(Session["userid"].ToString(), DateTime.Parse(tbNewTime_startTid.Text), DateTime.Parse(tbNewTime_slutTid.Text));
}
FillCalender();
}
protected void repNyheter_ItemCommand(object source, RepeaterCommandEventArgs e)
{
lblID.Text = e.CommandArgument.ToString();
panEditNyhet.Visible = true;
// populera nyheten
BusinessDAL bDAL = new BusinessDAL();
cArtikel art = bDAL.getOneNyhet(int.Parse(lblID.Text));
tbRubrik.Text = art.rubrik;
tbText.Text = art.beskrivning;
}
//Bekräftar bokningen så att den syns på scheman och liknande
protected void btnBekrafta_Click(object sender, EventArgs e)
{
BusinessDAL bDAL = new BusinessDAL();
foreach (RepeaterItem rptI in rptOrder.Items)
{
HiddenField hf = (HiddenField)rptI.FindControl("hfOrderID");
bDAL.updateOrderStatusID(20, hf.Value);
}
Response.Redirect("min_profil.aspx");
}
protected void repMassorer_ItemCommand(object source, RepeaterCommandEventArgs e)
{
lblID.Text = e.CommandArgument.ToString();
panEditMassor.Visible = true;
// populera nyheten
BusinessDAL bDAL = new BusinessDAL();
cAnvandare art = bDAL.getOneMassor(lblID.Text);
tbForNamn.Text = art.FirstName;
tbEfterNamn.Text = art.LastName;
tbBeskrivning.Text = art.ssn;
}
protected void btnUppdatera_Click(object sender, EventArgs e)
{
BusinessDAL bd = new BusinessDAL();
cArtikel a = new cArtikel();
a.rubrik = tbRubrik.Text.ToString();
a.beskrivning = tbText.Text.ToString();
a.id = (lblID.Text.ToString());
bd.updateNyhetInfo(a);
FillNyheter();
panEditNyhet.Visible = false;
}
protected void repArtiklar_ItemCommand(object source, RepeaterCommandEventArgs e)
{
lblID.Text = e.CommandArgument.ToString();
panEditartikel.Visible = true;
//Hämta data från tabellen Artikel med id = e.CommandArgument.ToString();
//Fyll tectboxarna med data frå proceduren
BusinessDAL bDAL = new BusinessDAL();
cArtikel art = bDAL.getArtikelInfo(int.Parse(lblID.Text));
tbRubrik.Text = art.rubrik;
tbText.Text = art.beskrivning;
}
//Byter lösenord för den givna användaren
protected void btnBytLosen_Click(object sender, EventArgs e)
{
BusinessDAL bd = new BusinessDAL();
anvandare anv = new anvandare();
string newPassword;
anv.Epost = tbEpost.Text.ToString();
anv.Password = tbpw.Text.ToString();
newPassword = bd.RestorePassword(anv);
Response.Redirect("login.aspx");
}
protected void repTjanster_ItemCommand(object source, RepeaterCommandEventArgs e)
{
lblID.Text = e.CommandArgument.ToString();
panEditTjanst.Visible = true;
// populera nyheten
BusinessDAL bDAL = new BusinessDAL();
cArtikel art = bDAL.getOneTjanst(int.Parse(lblID.Text));
tbNamn.Text = art.rubrik;
tbBeskrivning.Text = art.beskrivning;
tbPris.Text = art.pris.ToString();
tbTid.Text = art.tid.ToString();
tbPris.Text = tbPris.Text.ToString().Split(',')[0];
}
//Hämtar artikeln om massörer
protected void btnUppdatera_Click(object sender, EventArgs e)
{
BusinessDAL bd = new BusinessDAL();
cAnvandare a = new cAnvandare();
a.FirstName = tbForNamn.Text.ToString();
a.LastName = tbEfterNamn.Text.ToString();
a.Password = tbBeskrivning.Text.ToString();
a.UserId = (lblID.Text.ToString());
bd.updateMassorInfo(a);
FillMassorer();
panEditMassor.Visible = false;
}
//Avbokar de markerade ordrarna
protected void btnAvboka_Click(object sender, EventArgs e)
{
int x = 40;
BusinessDAL bDAL = new BusinessDAL();
foreach (RepeaterItem rptI in rptBokningar.Items)
{
CheckBox cbx = (CheckBox)rptI.FindControl("cbxAvboka");
HiddenField hf = (HiddenField)rptI.FindControl("hfOrderID");
if (cbx.Checked)
{
bDAL.updateOrderStatusID(x, hf.Value);
}
}
FillOrdrar();
}
//Lägger in en ny användare i databasen ifall allt går igenom validering
protected void btnRegistrera_Click(object sender, EventArgs e)
{
string newUserId;
BusinessDAL bd = new BusinessDAL();
anvandare anv = new anvandare();
anv.FirstName = tb_FaMname.Text.ToString();
anv.LastName = tb_lname.Text.ToString();
anv.Epost = tb_email.Text.ToString();
anv.ssn = tb_ssn.Text.ToString();
anv.Password = tb_pw.Text.ToString();
anv.newsletter = cb_newsletter.Text.ToString();
if (cvPassword.IsValid && cb_avtal.Checked)
{
newUserId = bd.CreateUser(anv);
Response.Redirect("login.aspx");
}
}
//Hämtar tjänstinfo
private DataTable tjanstList()
{
BusinessDAL bDal = new BusinessDAL();
DataTable dt = bDal.getTjanstInfo();
foreach (DataColumn dc in dt.Columns)
{
dc.ReadOnly = false;
}
foreach (DataRow dr in dt.Rows)
{
string[] prisparts = dr["pris"].ToString().Split(',');
dr["pris"] = prisparts[0];
}
return(dt);
}
//Hämtar artikeln om tjänster
protected void btnUppdatera_Click(object sender, EventArgs e)
{
BusinessDAL bd = new BusinessDAL();
cArtikel a = new cArtikel();
a.namn = tbNamn.Text.ToString();
a.beskrivning = tbBeskrivning.Text.ToString();
a.id = (lblID.Text.ToString());
a.pris = Convert.ToDecimal(tbPris.Text);
a.tid = Convert.ToInt16(tbTid.Text);
bd.updateTjanstInfo(a);
FillTjanster();
panEditTjanst.Visible = false;
}
protected void btnSaveInfo_Click(object sender, EventArgs e)
{
btnEditinfo.Visible = true;
btnCancelEdit.Visible = false;
btnSaveinfo.Visible = false;
tbxFornamn.Enabled = false;
tbxEfternamn.Enabled = false;
tbxMail.Enabled = false;
tbxSSN.Enabled = false;
cbxFaktura.Enabled = false;
cbxNewsLetter.Enabled = false;
BusinessDAL bDAL = new BusinessDAL();
anvandare updatedUser = new anvandare();
updatedUser.Epost = tbxMail.Text;
updatedUser.FirstName = tbxFornamn.Text;
updatedUser.LastName = tbxEfternamn.Text;
updatedUser.ssn = tbxSSN.Text;
if (cbxNewsLetter.Checked)
{
updatedUser.newsletter = "1";
}
else
{
updatedUser.newsletter = "0";
}
if (cbxFaktura.Checked)
{
updatedUser.faktura = "1";
}
else
{
updatedUser.faktura = "0";
}
bDAL.updateUserInfo(updatedUser, Session["userid"].ToString());
GetUserData();
}
protected void Login1_Authenticate(object sender, AuthenticateEventArgs e)
{
BusinessDAL bd = new BusinessDAL();
cAnvandare a = new cAnvandare();
string sUserId = "";
a.Epost = Login1.UserName.ToString();
a.Password = Login1.Password.ToString();
sUserId = bd.LogIn(a);
if (sUserId.Length > 1)
{
Session.Add("userId", sUserId);
e.Authenticated = true;
Response.Redirect("Nyheter.aspx");
}
else
{
e.Authenticated = false;
Response.Redirect("Default.aspx");
Page.Controls.Add(new LiteralControl("<p>New<br />Line</p>"));
}
}
//Hämtar tjänstinfo
private DataTable tjanstList()
{
BusinessDAL bDal = new BusinessDAL();
return(bDal.getTjanstInfo());
}
//Hämtar massörinfo
private DataTable massorList()
{
BusinessDAL bDal = new BusinessDAL();
return(bDal.getMassorInfo());
}
//Lägger in din order och skickar dig till bekrafta_bokning.aspx
protected void btnBekrafta(object sender, EventArgs e)
{
if (Session.Count != 0)
{
BusinessDAL bDal = new BusinessDAL();
order newOrder = new order();
string day = ddlDay.SelectedValue;
string input = tbTime.Text.ToString();
string[] splitTime = input.Split(':');
DateTime starttime = DateTimeExtensions.FirstDateOfWeekISO8601(int.Parse(hfYear.Value), int.Parse(hfWeek.Value));
if (day.ToLower() == "tuesday")
{
starttime = starttime.AddDays(1);
}
else if (day.ToLower() == "wednesday")
{
starttime = starttime.AddDays(2);
}
else if (day.ToLower() == "thursday")
{
starttime = starttime.AddDays(3);
}
else if (day.ToLower() == "friday")
{
starttime = starttime.AddDays(4);
}
else if (day.ToLower() == "saturday")
{
starttime = starttime.AddDays(5);
}
starttime = starttime.AddHours(int.Parse(splitTime[0]));
starttime = starttime.AddMinutes(int.Parse(splitTime[1]));
newOrder.orderStatusID = 10;
newOrder.anstalldID = anstalldID();
newOrder.personID = Session["userid"].ToString();
newOrder.tjanstID = tjanstID();
newOrder.startTid = starttime;
newOrder.slutTid = starttime.AddMinutes(tjanstTid() - 1);
string orderid = bDal.newOrder(newOrder).ToString();
if (orderid != "0")
{
Session.Add("orderID", orderid);
Response.Redirect("bekrafta_bokning.aspx");
litErrMsg.Visible = false;
}
else
{
litErrMsg.Visible = true;
}
}
else
{
Response.Redirect("login.aspx");
}
}
//Updaterar nyhetens
protected void button1_Click(object sender, EventArgs e)
{
BusinessDAL bd = new BusinessDAL();
cArtikel a = new cArtikel();
}
