protected int getUserFromSession(string username) { using (var db = new DataClassesPhotogenicDataContext()) { var q = (from p in db.Users where p.Username == username select p.UserId).SingleOrDefault(); return(q); } }
protected void BtnSubmitPhotoBucketForReview_Click(object sender, EventArgs e) { string strFilethumbnailname, strthumbMessage, strFileZipname, strZipMessage; var sessionUsername = Session["userLogin"].ToString(); int session_userid = getUserFromSession(sessionUsername); var thumbnailfileId = Guid.NewGuid().ToString().Replace("-", ""); var ZipfileId = Guid.NewGuid().ToString().Replace("-", ""); strFilethumbnailname = FileUploadPBThumbnail.PostedFile.FileName.ToString(); var filethumbnailpath = "~/Photographer/Thumbnail/" + thumbnailfileId; strthumbMessage = uploadThumbnail(strFilethumbnailname, ConfigurationManager.AppSettings["folderPaththumbnail"], thumbnailfileId); strFileZipname = FileUploadPBZip.PostedFile.FileName.ToString(); var fileZippath = "~/Photographer/Zip/" + ZipfileId; strZipMessage = uploadZip(strFileZipname, ConfigurationManager.AppSettings["folderPathzip"], ZipfileId); string status_ = "Active"; using (var db = new DataClassesPhotogenicDataContext()) { PhotoBucket pb = new PhotoBucket { PBName = TxtPBName.Text, PBDescription = TxtPBDescription.Text, Price = Convert.ToInt32(TxtPBPrice.Text), PBDate = TxtPBDate.Text, Status = status_, CatId = Convert.ToInt32(DropDownListCatPBDisplay.Text), PBId = session_userid, PBZipName = strFileZipname, PBThumbName = strFilethumbnailname, PBZipPath = FileUploadPBZip.ToString(), PBThumbPath = FileUploadPBThumbnail.ToString() }; db.PhotoBuckets.InsertOnSubmit(pb); db.SubmitChanges(); } }