Example #1
0
    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);
        }
    }
Example #2
0
    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();
        }
    }