public static string getCategoryName(int?categoryID) { using (DataDataContext db = new DataDataContext()) { var category = db.Categories.Where(n => n.Id == categoryID).SingleOrDefault(); if (category != null) { return(category.Name); } else { return("Not Found"); } } }
public static bool checkUserExists(string UserName) { using (DataDataContext db = new DataDataContext()) { var user = db.Users.Where(n => n.Name == UserName).SingleOrDefault(); if (user != null) { return(true); } else { return(false); } } }
public static string getUserName(int?UserID) { using (DataDataContext db = new DataDataContext()) { var user = db.Users.Where(n => n.Id == UserID).FirstOrDefault(); if (user != null) { return(user.Name); } else { return("default"); } } }
public static int?getUserRole(int?UserID) { using (DataDataContext db = new DataDataContext()) { var user = db.Users.Where(n => n.Id == UserID).FirstOrDefault(); if (user != null) { return(user.Role); } else { return(null); } } }
public static int getUserID(string UserName) { using (DataDataContext db = new DataDataContext()) { var user = db.Users.Where(n => n.Name == UserName).FirstOrDefault(); if (user != null) { return(user.Id); } else { return(0); } } }
protected void lnkForgotPassword_Click(object sender, EventArgs e) { using (DataDataContext db = new DataDataContext()) { var user = db.Users.Where(n => n.Name == txtUserName.Text).SingleOrDefault(); if (user == null) { ClientScript.RegisterClientScriptBlock(this.GetType(), "User", "alert('Username incorrect!')", true); } else { user.Reset_Request = true; db.SubmitChanges(); ClientScript.RegisterClientScriptBlock(this.GetType(), "User", "alert('Request to admin have been sent!')", true); } } }
private bool AuthorisedUser(string userName, string password) { var ensdPassword = FormsAuthentication.HashPasswordForStoringInConfigFile(password, "SHA1"); using (DataDataContext db = new DataDataContext()) { var user = db.Users.Where(n => n.Name == userName && n.Password == ensdPassword && n.Active == true).SingleOrDefault(); if (user != null) { Session["LoginId"] = user.Id; return(true); } else { return(false); } } }
public void ProcessRequest(HttpContext context) { using (DataDataContext db = new DataDataContext()) { var postID = Convert.ToInt32(context.Request.QueryString["PostID"]); string Size = context.Request.QueryString["Size"].ToString().ToLower(); var post = db.Posts.Where(n => n.Id == postID).SingleOrDefault(); if (post != null) { var img = GlobalMethods.BinaryToImage(post.Image.ToArray()); var imgArray = GetBytesFromImage(generateImage(img, Size)); context.Response.ContentType = "image/jpg"; context.Response.OutputStream.Write(imgArray, 0, imgArray.Length); context.Response.Flush(); context.Response.End(); } } }