// Information om brugerne
public static List <Userlogin> GetAll()
{
using (Sv_Eksamen_Entities db = new Sv_Eksamen_Entities())
{
return(db.Userlogin.ToList());
}
}
public static bool IsInRole(int userID, Role role)
{
using (Sv_Eksamen_Entities db = new Sv_Eksamen_Entities())
{
return(db.Userlogin.ToList().Exists(i => i.UserID == userID && i.RoleID == (int)role));
}
}
// Tilføj - Ret - Slet
public static CreateStatus Insert(Userlogin model)
{
using (Sv_Eksamen_Entities db = new Sv_Eksamen_Entities())
{
// Tjek om brugernavn allerede findes
if (!db.Userlogin.ToList().Exists(i => i.LoginName.ToLower() == model.LoginName.ToLower()))
{
// Hvis denne setting er = true, hashes passwordet med MD5
if (ConfigurationManager.AppSettings["SimpleLogin_EnableMD5"] != null && ConfigurationManager.AppSettings["SimpleLogin_EnableMD5"] == "true")
{
model.Password = Generate_MD5Hash(model.Password);
}
//model.RoleID = model.RoleID;
model.RoleID = (int)Role.User;
model.Status = (int)UserStatus.Active; // Sætter status = Aktiv
db.Userlogin.Add(model);
db.SaveChanges();
return(CreateStatus.OK); // Brugeren er oprettet !
}
else
{
return(CreateStatus.UserNameExist); // Brugernavnet findes allerede !
}
}
}
public static Userlogin GetByID(int userID)
{
using (Sv_Eksamen_Entities db = new Sv_Eksamen_Entities())
{
return(db.Userlogin.FirstOrDefault(i => i.UserID == userID));
}
}
public static List <Userlogin> GetByRole(Role role)
{
using (Sv_Eksamen_Entities db = new Sv_Eksamen_Entities())
{
return(db.Userlogin.Where(i => i.RoleID == (int)role).ToList());
}
}
protected void btnSubscribe_Click(object sender, EventArgs e)
{
Tools tool = new Tools();
string subject = txtName.Text;
string body = "You are now subscribed";
string email = txtEmail.Text;
if (!string.IsNullOrEmpty(subject) && !string.IsNullOrEmpty(email) && tool.IsValidEmail(email))
{
using (Sv_Eksamen_Entities db = new Sv_Eksamen_Entities())
{
Newsletter news = new Newsletter();
news.Email = txtEmail.Text;
news.Name = txtName.Text;
db.Newsletter.Add(news);
db.SaveChanges();
string to = "*****@*****.**";
string SMTP = "10.138.22.47";
tool.SendMail(to, email, subject, body, SMTP);
txtName.Text = String.Empty;
txtEmail.Text = String.Empty;
ltStatus.Text = "You are now subscribed!";
}
}
else
{
ltStatus.Text = "Please fill out your email";
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (Sv_Eksamen_Entities db = new Sv_Eksamen_Entities())
{
RpRetailer.DataSource = db.Retailer.ToList();
RpRetailer.DataBind();
}
}
private void BindNews()
{
using (Sv_Eksamen_Entities db = new Sv_Eksamen_Entities())
{
lsNews.DataSource = db.News.OrderByDescending(x => x.NewsID).ToList();
lsNews.DataBind();
}
}
public static void Delete(int userID)
{
using (Sv_Eksamen_Entities db = new Sv_Eksamen_Entities())
{
Userlogin Item = db.Userlogin.Find(userID);
db.Userlogin.Remove(Item);
db.SaveChanges();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (Sv_Eksamen_Entities db = new Sv_Eksamen_Entities())
{
RpLatest.DataSource = db.Product.OrderByDescending(x => x.ProductID).ToList().Take(6);
RpLatest.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (Sv_Eksamen_Entities db = new Sv_Eksamen_Entities())
{
RpCollection.DataSource = db.Collection.ToList();
RpCollection.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (Sv_Eksamen_Entities db = new Sv_Eksamen_Entities())
{
lsWomen.DataSource = db.Product.OrderByDescending(x => x.ProductID).ToList().Where(x => x.GenderID == 2).ToList().Take(9);
lsWomen.DataBind();
}
}
}
private void BindCollection()
{
using (Sv_Eksamen_Entities db = new Sv_Eksamen_Entities())
{
int ID = Convert.ToInt32(Page.Request.QueryString["id"].ToString());
lblInfo.Text = db.Collection.Find(ID).CollectionName;
lsCollection.DataSource = db.Product.Where(x => x.CollectionID == ID).OrderByDescending(x => x.ProductID).ToList();
lsCollection.DataBind();
}
}
public static bool IsInRole(Role role)
{
using (Sv_Eksamen_Entities db = new Sv_Eksamen_Entities())
{
if (IsLoggedIn())
{
return(db.Userlogin.ToList().Exists(i => i.UserID == SessionGet().UserID&& i.RoleID == (int)role));
}
}
return(false);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (Sv_Eksamen_Entities db = new Sv_Eksamen_Entities())
{
int ID = Convert.ToInt32(Page.Request.QueryString["id"].ToString());
lblTopProductName.Text = db.Product.Find(ID).ProductName;
lblProductName.Text = db.Product.Find(ID).ProductName;
lblDescription.Text = db.Product.Find(ID).Description;
Image.ImageUrl = "~/UploadedImages/" + db.Product.Find(ID).Image;
lblBottomDescription.Text = db.Product.Find(ID).Description;
}
}
}
protected void btnSend_Click(object sender, EventArgs e)
{
Tools tool = new Tools();
string from = txtEmail.Text;
string subject = txtName.Text;
string email = txtEmail.Text;
string body = txtMessage.Value;
if (!string.IsNullOrEmpty(subject) && !string.IsNullOrEmpty(from) && !string.IsNullOrEmpty(body) && tool.IsValidEmail(email))
{
using (Sv_Eksamen_Entities db = new Sv_Eksamen_Entities())
{
Svendeproeve.Models.Contact contact = new Svendeproeve.Models.Contact();
contact.Name = txtName.Text;
contact.Email = txtEmail.Text;
contact.Message = txtMessage.Value;
db.Contact.Add(contact);
db.SaveChanges();
string to = "*****@*****.**";
string SMTP = "10.138.22.47";
tool.SendMail(to, from, subject, body, SMTP);
txtEmail.Text = "";
txtName.Text = "";
txtMessage.Value = "";
lblMessage.Text = "Thank you for your message !";
lblFillout.Visible = false;
lblMessage.Visible = true;
}
}
else
{
lblFillout.Text = "Please fill out all fields !";
lblMessage.Visible = false;
lblFillout.Visible = true;
}
}
public static void Update(Userlogin model)
{
using (Sv_Eksamen_Entities db = new Sv_Eksamen_Entities())
{
Userlogin Item = db.Userlogin.Find(model.UserID);
// Hvis denne setting er = true, hashes passwordet med MD5
if (ConfigurationManager.AppSettings["SimpleLogin_EnableMD5"] != null && ConfigurationManager.AppSettings["SimpleLogin_EnableMD5"] == "true")
{
Item.Password = Generate_MD5Hash(model.Password);
}
//Item.LoginName = model.LoginName;
Item.Username = model.Username;
db.SaveChanges();
}
}
private void BindSearchResults()
{
//Search
if (Request.QueryString["query"] != null)
{
string SearchWord = Server.HtmlDecode(Request.QueryString["query"]);
using (Sv_Eksamen_Entities db = new Sv_Eksamen_Entities())
{
List <Svendeproeve.Models.Product> Product = db.Product.ToList();
Product = db.Product.Where(i => i.ProductName.ToLower().Contains(SearchWord) ||
i.Description.ToLower().Contains(SearchWord) ||
i.Retailer.Name.ToLower().Contains(SearchWord)).ToList();
if (Product != null && Product.Count > 0)
{
lsSearchResults.DataSource = Product;
lsSearchResults.DataBind();
lsSearchResults.Visible = true;
}
else
{
int x = 400;
int y = 110;
Response.Write("<div style='float:left;position:relative;z-index:2;top:286px;margin-top:20px;margin-left:-90px;font-family:Arial;font-size:15px;color:#52423B" + y.ToString() + "px;left:" + x.ToString() + "px'>No match found</div>");
lsSearchResults.Visible = false;
}
}
}
else
{
Response.Redirect("~/Default.aspx");
}
}
public static LoginStatus Login(string loginName, string loginPass)
{
// Hvis denne setting er = true, hashes passwordet med MD5
if (ConfigurationManager.AppSettings["SimpleLogin_EnableMD5"] != null && ConfigurationManager.AppSettings["SimpleLogin_EnableMD5"] == "true")
{
loginPass = Generate_MD5Hash(loginPass);
}
// Åbner forbindelse til databasen
using (Sv_Eksamen_Entities db = new Sv_Eksamen_Entities())
{
Userlogin GetUser = db.Userlogin.FirstOrDefault(i => i.LoginName == loginName && i.Password == loginPass);
if (GetUser != null)
{
// Indsætter brugerne i en session & cookie
SessionSet(GetUser);
AuthCookie(GetUser);
// OK
return(LoginStatus.OK);
}
else
{
GetUser = db.Userlogin.FirstOrDefault(i => i.LoginName == loginName);
if (GetUser != null)
{
// LoginPass er forkert
return(LoginStatus.WrongPass);
}
else
{
// LoginName findes ikke
return(LoginStatus.NotFound);
}
}
}
}
