protected void btnNewMassor_Click(object sender, EventArgs e)
{
cArtikel newMassor = new cArtikel();
AdminDAL aDAL = new AdminDAL();
int x = 0;
int y = 0;
if (cbxMen.Checked)
{
x = 1;
}
if (cbxWomen.Checked)
{
y = 1;
}
if (tbSSN.Text.Length > 0 && tbNewBeskrivning.Text.Length > 0)
{
newMassor.namn = tbSSN.Text;
newMassor.beskrivning = tbNewBeskrivning.Text;
newMassor.pris = y;
newMassor.tid = x;
aDAL.newAnstalld(newMassor, Session["userId"].ToString());
}
}
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;
}
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;
}
protected void btnNewNyhet_Click(object sender, EventArgs e)
{
cArtikel newNyhet = new cArtikel();
AdminDAL aDAL = new AdminDAL();
if (tbNewRubrik.Text.Length > 0 && tbNewBeskrivning.Text.Length > 0 && tbNewTid.Text.Length > 0)
{
newNyhet.rubrik = tbNewRubrik.Text;
newNyhet.beskrivning = tbNewBeskrivning.Text;
newNyhet.date = DateTime.Parse(tbNewTid.Text);
aDAL.newNyhet(newNyhet, Session["userId"].ToString());
}
}
protected void btnUppdatera_Click(object sender, EventArgs e)
{
AdminDAL aDAL = new AdminDAL();
cArtikel a = new cArtikel();
a.beskrivning = tbText.Text.ToString();
a.rubrik = tbRubrik.Text.ToString();
a.id = (lblID.Text.ToString());
aDAL.updateArtikelInfo(a);
FillArtiklar();
panEditartikel.Visible = false;
}
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];
}
protected void btnNewTjanst_Click(object sender, EventArgs e)
{
cArtikel newTjanst = new cArtikel();
AdminDAL aDAL = new AdminDAL();
if (tbNewNamn.Text.Length > 0 && tbNewBeskrivning.Text.Length > 0 && tbNewPris.Text.Length > 0 && tbNewTid.Text.Length > 0)
{
newTjanst.namn = tbNewNamn.Text;
newTjanst.beskrivning = tbNewBeskrivning.Text;
newTjanst.pris = int.Parse(tbNewPris.Text);
newTjanst.tid = int.Parse(tbNewTid.Text);
aDAL.newTjanst(newTjanst, Session["userId"].ToString());
}
}
//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;
}
public cArtikel getOneTjanst(int id)
{
DataTable dt = new DataTable();
cArtikel art = new cArtikel();
//Create a connection
SqlConnection conn = new SqlConnection(connStr);
//The procedure I want to call
SqlCommand cmd = new SqlCommand("usp_getOneTjanst", conn);
//Command type I want to execute
cmd.CommandType = CommandType.StoredProcedure;
try
{
conn.Open();
cmd.Parameters.AddWithValue("@tjanstID", id);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
art.rubrik = reader["namn"].ToString();
art.beskrivning = reader["beskrivning"].ToString();
art.pris = decimal.Parse(reader["pris"].ToString());
art.tid = int.Parse(reader["tid"].ToString());
}
return(art);
}
catch
{
throw;
}
finally
{
cmd.Dispose();
conn.Close();
conn.Dispose();
}
}
public int newNyhet(cArtikel a, string userid)
{
//DataTable dt = new DataTable();
cArtikel art = new cArtikel();
//Create a connection
SqlConnection conn = new SqlConnection(connStr);
//The procedure I want to call
SqlCommand cmd = new SqlCommand("usp_ADMIN_newNyhet", conn);
//Command type I want to execute
cmd.CommandType = CommandType.StoredProcedure;
try
{
conn.Open();
cmd.Parameters.AddWithValue("@publicerad", 1);
cmd.Parameters.AddWithValue("@anstalldID", userid);
cmd.Parameters.AddWithValue("@rubrik", a.rubrik);
cmd.Parameters.AddWithValue("@beskrivning", a.beskrivning);
cmd.Parameters.AddWithValue("@publiceradDatum", a.tid);
cmd.Parameters.AddWithValue("@createdby", userid);
return(cmd.ExecuteNonQuery());
}
catch
{
throw;
}
finally
{
cmd.Dispose();
conn.Close();
conn.Dispose();
}
}
public int updateTjanstInfo(cArtikel a)
{
//DataTable dt = new DataTable();
cArtikel art = new cArtikel();
//Create a connection
SqlConnection conn = new SqlConnection(connStr);
//The procedure I want to call
SqlCommand cmd = new SqlCommand("usp_ADMIN_edit_tjanster", conn);
//Command type I want to execute
cmd.CommandType = CommandType.StoredProcedure;
try
{
conn.Open();
cmd.Parameters.AddWithValue("@tjanstID", a.id);
cmd.Parameters.AddWithValue("@namn", a.namn);
cmd.Parameters.AddWithValue("@beskrivning", a.beskrivning);
cmd.Parameters.AddWithValue("@pris", a.pris);
cmd.Parameters.AddWithValue("@tid", a.tid);
return(cmd.ExecuteNonQuery());
}
catch
{
throw;
}
finally
{
cmd.Dispose();
conn.Close();
conn.Dispose();
}
}
public int newAnstalld(cArtikel a, string userid)
{
//DataTable dt = new DataTable();
cArtikel art = new cArtikel();
//Create a connection
SqlConnection conn = new SqlConnection(connStr);
//The procedure I want to call
SqlCommand cmd = new SqlCommand("usp_ADMIN_newAnstalld", conn);
//Command type I want to execute
cmd.CommandType = CommandType.StoredProcedure;
try
{
conn.Open();
cmd.Parameters.AddWithValue("@personnummer", a.namn);
cmd.Parameters.AddWithValue("@beskrivning", a.beskrivning);
cmd.Parameters.AddWithValue("@behandlarMan", a.tid);
cmd.Parameters.AddWithValue("@behandlarKvinnor", a.pris);
cmd.Parameters.AddWithValue("@createdby", userid);
return(cmd.ExecuteNonQuery());
}
catch
{
throw;
}
finally
{
cmd.Dispose();
conn.Close();
conn.Dispose();
}
}
public int updateMassorInfo(cAnvandare a)
{
//DataTable dt = new DataTable();
cArtikel art = new cArtikel();
//Create a connection
SqlConnection conn = new SqlConnection(connStr);
//The procedure I want to call
SqlCommand cmd = new SqlCommand("usp_ADMIN_edit_anstallda", conn);
//Command type I want to execute
cmd.CommandType = CommandType.StoredProcedure;
try
{
conn.Open();
cmd.Parameters.AddWithValue("@anstalldID", a.UserId);
cmd.Parameters.AddWithValue("@fornamn", a.FirstName);
cmd.Parameters.AddWithValue("@efternamn", a.LastName);
cmd.Parameters.AddWithValue("@beskrivning", a.Password);
return(cmd.ExecuteNonQuery());
}
catch
{
throw;
}
finally
{
cmd.Dispose();
conn.Close();
conn.Dispose();
}
}
//Updaterar nyhetens
protected void button1_Click(object sender, EventArgs e)
{
BusinessDAL bd = new BusinessDAL();
cArtikel a = new cArtikel();
}
