コード例 #1
0
ファイル: DbMethods.cs プロジェクト: praneethgotti/Blackstone
        public Venture GetVenture(int ventureId)
        {
            Venture v = new Venture();

            DBConnect objdb = new DBConnect();
            objCommand.CommandType = CommandType.StoredProcedure;
            objCommand.CommandText = "GetVentureById";
            objCommand.Parameters.Clear();

            SqlParameter inputParameter = new SqlParameter("@ventureId", ventureId);
            inputParameter.Direction = ParameterDirection.Input;
            inputParameter.SqlDbType = SqlDbType.Int;
            objCommand.Parameters.Add(inputParameter);

            DataSet results = objdb.GetDataSetUsingCmdObj(objCommand);

            v.ventureID = (int) results.Tables[0].Rows[0][0];
            v.name = (string) results.Tables[0].Rows[0][1];
            v.description = (string) results.Tables[0].Rows[0][2];
            v.aboutUs = (string) results.Tables[0].Rows[0][3];
            v.contactEmail = (string) results.Tables[0].Rows[0][4];
            v.contactPhoneNumber = (string) results.Tables[0].Rows[0][5];
            v.contactLinkedIn = (string) results.Tables[0].Rows[0][6];
            v.Picture = (byte[]) results.Tables[0].Rows[0][7];
            v.primaryContactEmail = (string) results.Tables[0].Rows[0][8];
            v.isActive = (bool) results.Tables[0].Rows[0][9];
            v.lastUpdateDate = (DateTime) results.Tables[0].Rows[0][10];
            v.lastUpdateUser = (string) results.Tables[0].Rows[0][11];

            return v;
        }
コード例 #2
0
        protected void gvDeleteSkills_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            ventureObj = (Venture)Session["ventureObj"];
            if (e.CommandName == "gvCommandDelete")
            {
                int         index       = Convert.ToInt32(e.CommandArgument);
                GridViewRow selectedRow = gvDeleteSkills.Rows[index];
                string      s           = selectedRow.Cells[0].Text; //get skill name from selected row to be deleted.
                int         count       = 0;                         //test counter if no matches were found in forEach loop

                foreach (Tuple <int, String> skill in ventureObj.AllVentureSkills)
                {
                    if (skill.Item2.Equals(s, StringComparison.OrdinalIgnoreCase))
                    {
                        count++;//found something
                        int result = DbMethodsObj.DeleteVentureSkill(ventureObj.ventureID, skill.Item1);
                        if (result != -1)
                        {
                            lblGvDeleteTest.Text = "Skill has been deleted.";
                        }
                        else
                        {
                            lblGvDeleteTest.Text = "Unable to restore file. DataBase error. Please try again.";
                        }
                    }
                }
                if (count == 0)
                {
                    lblGvDeleteTest.Text = "could not find skill name in local DataSet. :(";
                }
            }//end Delete Skill Row Command
            sm.storeVentureDataInSession(ventureObj.ventureID);//now get the whole expert object
            ventureObj = (Venture)Session["ventureObj"];
            FillControls();
        }//end click event
コード例 #3
0
        protected void btnSubmitStaticMember_Click(object sender, EventArgs e)
        {
            ventureObj = (Venture)Session["ventureObj"];
            if (valid.IsBlank(txtFirstName.Text) || valid.IsBlank(txtLastName.Text) || valid.IsBlank(txtRole.Text))
            {
                lblStaticRequired.Visible = true;
            }
            else
            {
                string   firstName        = txtFirstName.Text;
                string   lastName         = txtLastName.Text;
                string   role             = txtRole.Text;
                DateTime lastUpdateDate   = DateTime.Now;
                Expert   expertProfileObj = (CapstoneBlackstone.Expert)Session["expertProfileObj"];
                string   lastUpdateUser   = expertProfileObj.lastName + ", " + expertProfileObj.firstName;

                DbMethodsObj.CreateStaticMember(ventureObj.ventureID, firstName, lastName, role, lastUpdateDate, lastUpdateUser);
                txtRole.Text      = "";
                txtFirstName.Text = "";
                txtLastName.Text  = "";
                sm.storeVentureDataInSession(ventureObj.ventureID);
                ventureObj = (Venture)Session["ventureObj"];
                FillControls();
            }
        }
コード例 #4
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Session["Authenticated"] == null)
            {
                Response.Redirect("default.aspx");
            }
            else if (Request.QueryString["name"] == null)
            {
                Response.Redirect("Search.aspx");
            }
            else
            {
                string  ventureName = Request.QueryString["name"];
                int     vId         = Convert.ToInt32(dbm.GetVentureID(ventureName));
                Venture v           = dbm.GetVenture(vId);

                h2VentureName.InnerText     = v.name;
                spVentureContact.InnerText  = v.contactEmail;
                pAboutUs.InnerText          = v.aboutUs;
                imgLogo.ImageUrl            = d.ConvertToImage(v.Picture);
                h3VentureDesc.InnerText     = v.description;
                spVenturePhone.InnerText    = v.contactPhoneNumber;
                spVentureLinkedIn.InnerText = v.contactLinkedIn;
                lblPrimaryContactEmail.Text = v.primaryContactEmail;

                //put venture data into session
                sm.storeVentureDataInSession(vId);
                ventureObj = (Venture)Session["ventureObj"];
                //Bind Repeaters
                this.rptMembersAndRoles.DataSource = ventureObj.memberNameAndRoleList;
                this.rptMembersAndRoles.DataBind();
                this.rptStaticMembersAndRoles.DataSource = ventureObj.staticMembersList;
                this.rptStaticMembersAndRoles.DataBind();
                this.rptVentureSkills.DataSource = ventureObj.AllVentureSkills;
                this.rptVentureSkills.DataBind();

                //Make sure only members of a venture are able to edit this particular venture
                Expert    expertProfileObj = sm.getAllTheExpertInfo((string)Session["TU_ID"]);
                string    user_name        = expertProfileObj.username;
                DataTable usernamesTable   = dbm.GetUsernamesForVenture(vId).Tables[0];
                int       isMember         = 0;
                for (int i = 0; i < usernamesTable.Rows.Count && isMember == 0; i++)
                {
                    if (usernamesTable.Rows[i][0].ToString() == user_name)
                    {
                        isMember            = 1;
                        editVenture.Visible = true;
                    }
                }//End of Restricting Edit Venture
            }
        }
コード例 #5
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (Session["Authenticated"] == null)
     {
         Response.Redirect("default.aspx");
     }
     else if (!IsPostBack)
     {
         string ventureName = Session["currentVentureName"].ToString();
         int    ventureID   = Convert.ToInt32(DbMethodsObj.GetVentureID(ventureName));
         sm.storeVentureDataInSession(ventureID);
         ventureObj = (Venture)Session["ventureObj"];
         FillControls();
     }
 }
コード例 #6
0
ファイル: DbMethods.cs プロジェクト: praneethgotti/Blackstone
 private List<Param> BuildUpdateVentureParams(Venture v)
  {
       List<Param> p = new List<Param>();
      p.Add(new Param("@Name", v.name, SqlDbType.VarChar));
      p.Add(new Param("@Description", v.description, SqlDbType.VarChar));
      p.Add(new Param("@AboutUs", v.aboutUs, SqlDbType.VarChar));
      p.Add(new Param("@ContactEmail", v.contactEmail, SqlDbType.VarChar));
      p.Add(new Param("@ContactPhoneNumber", v.contactPhoneNumber, SqlDbType.VarChar));
      p.Add(new Param("@ContactLinkedIn", v.contactLinkedIn, SqlDbType.VarChar));
      p.Add(new Param("@PrimaryContactEmail", v.primaryContactEmail, SqlDbType.VarChar));
      p.Add(new Param("@LastUpdateDate", v.lastUpdateDate, SqlDbType.DateTime));
      p.Add(new Param("@LastUpdateUser", v.lastUpdateUser, SqlDbType.VarChar));
      p.Add(new Param("@VentureID", v.ventureID, SqlDbType.Int));
      p.Add(new Param("@Picture", v.Picture, SqlDbType.VarBinary));
      return p;
  }
コード例 #7
0
        }//end click event

        protected void btnSubmitExpert_Click(object sender, EventArgs e)
        {
            lblMemberRequired.Visible   = false;
            lblEmailNotInSystem.Visible = false;
            int count = Convert.ToInt32(DbMethodsObj.CheckIfExpertEmailExists(txtExpertEmail.Text));

            ventureObj = (Venture)Session["ventureObj"];
            if (valid.IsBlank(txtExpertEmail.Text) || valid.IsBlank(txtExpertRole.Text))
            {
                lblMemberRequired.Visible = true;
            }
            else if (count < 1)
            {
                lblEmailNotInSystem.Visible = true;
            }
            else
            {
                string   email            = txtExpertEmail.Text;
                string   TUID             = DbMethodsObj.GetExpertTUID(email).ToString();
                string   role             = txtExpertRole.Text;
                DateTime lastUpdateDate   = DateTime.Now;
                Expert   expertProfileObj = (CapstoneBlackstone.Expert)Session["expertProfileObj"];
                string   lastUpdateUser   = expertProfileObj.lastName + ", " + expertProfileObj.firstName;

                DataSet ventureMember = new DataSet();
                ventureMember = DbMethodsObj.CheckIfVentureMemberExists(ventureObj.ventureID, TUID);

                if (ventureMember.Tables[0].Rows.Count != 0)
                {
                    DbMethodsObj.ReactivateVentureMember(TUID, ventureObj.ventureID, role);
                    txtExpertEmail.Text = "";
                    txtExpertRole.Text  = "";
                    sm.storeVentureDataInSession(ventureObj.ventureID);
                    ventureObj = (Venture)Session["ventureObj"];
                    FillControls();
                }
                else
                {
                    DbMethodsObj.CreateVentureMember(TUID, ventureObj.ventureID, role, lastUpdateDate, lastUpdateUser);
                    txtExpertEmail.Text = "";
                    txtExpertRole.Text  = "";
                    sm.storeVentureDataInSession(ventureObj.ventureID);
                    ventureObj = (Venture)Session["ventureObj"];
                    FillControls();
                }
            }
        }
コード例 #8
0
        protected void btnRemoveStaticMember_Click(object sender, EventArgs e)
        {
            ventureObj = (Venture)Session["ventureObj"];
            for (int row = 0; row < gvStaticMembers.Rows.Count; row++)
            {
                CheckBox CBox;
                CBox = (CheckBox)gvStaticMembers.Rows[row].FindControl("chkSelect");

                if (CBox.Checked)
                {
                    int staticMemberID = Convert.ToInt32(gvStaticMembers.DataKeys[row].Values[0]);
                    DbMethodsObj.DeactivateStaticMemberByID(staticMemberID);
                }
            }
            sm.storeVentureDataInSession(ventureObj.ventureID);
            ventureObj = (Venture)Session["ventureObj"];
            FillControls();
        }
コード例 #9
0
        protected void btnRemoveExpert_Click(object sender, EventArgs e)
        {
            ventureObj = (Venture)Session["ventureObj"];
            for (int row = 0; row < gvVentureMembers.Rows.Count; row++)
            {
                CheckBox CBox;
                CBox = (CheckBox)gvVentureMembers.Rows[row].FindControl("chkSelect");

                if (CBox.Checked)
                {
                    string tuid = DbMethodsObj.GetTUIDByUsername(gvVentureMembers.Rows[row].Cells[1].Text);
                    DbMethodsObj.DeactivateVentureMember(ventureObj.ventureID, tuid);
                }
            }
            sm.storeVentureDataInSession(ventureObj.ventureID);
            ventureObj = (Venture)Session["ventureObj"];
            FillControls();
        }
コード例 #10
0
        }//end btnSearchExperts_Click

        public List <ExpertSearchObj> getVentureSkillDuplicatesAndData(List <ExpertSearchObj> expertSkillSearch)
        {
            List <ExpertSearchObj> distinctVentureIds = new List <ExpertSearchObj>(); //distinct ventures with all their skills

            var temp = expertSkillSearch.Select(o => o.VentureID).Distinct();         //get all unique tuids

            foreach (var i in temp)
            {//add unique tuids to a new list
                distinctVentureIds.Add(new ExpertSearchObj {
                    VentureID = i
                });                                                          //only contains venture names
            }

            foreach (ExpertSearchObj dvid in distinctVentureIds)
            {                                                                                                                                                          //get all duplicates on put them into distinct objects
                var newList = (from n in expertSkillSearch where n.VentureID == dvid.VentureID select new { n.SkillName, n.VentureID, n.Name, n.Picture }).Distinct(); //get all data

                //add venture data to each object
                Venture currentVenture = DbMethods.GetVenture(dvid.VentureID);//get that venture's data and load that into it's object
                dvid.VentureID   = currentVenture.ventureID;
                dvid.Name        = currentVenture.name;
                dvid.VentureDesc = currentVenture.description;
                if (currentVenture.Picture != null)
                {
                    dvid.image = d.ConvertToImage((byte[])currentVenture.Picture);//returns string url
                }
                else
                {//in case expert's profile pic is null
                    byte[]               imageBytes;
                    MemoryStream         ms  = new MemoryStream();
                    System.Drawing.Image img = System.Drawing.Image.FromFile("Images/TUOwls_logo.png");
                    img.Save(ms, System.Drawing.Imaging.ImageFormat.Png);
                    imageBytes = ms.ToArray();
                    dvid.image = d.ConvertToImage(imageBytes);
                }
                //dvid.SkillName = currentVenture.skillName;
                foreach (var j in newList)
                {    //add all skillNames associated with the distinct tuid into its SkillName list in VentureSearch obj
                    dvid.AllVentureSkills.Add(j.ToString());
                }
            }//end getting distinct ventures and adding data
            return(distinctVentureIds);
        }
コード例 #11
0
ファイル: DbMethods.cs プロジェクト: praneethgotti/Blackstone
        public int UpdateVenture(Venture v)
        {
            DBConnect objDB = new DBConnect();
            objCommand.CommandType = System.Data.CommandType.StoredProcedure;
            objCommand.CommandText = "UpdateVenture";
            objCommand.Parameters.Clear();

            List<Param> p = BuildUpdateVentureParams(v);

            foreach (Param param in p)
            {
                SqlParameter inputParameter = new SqlParameter(param.Name, param.Val);
                inputParameter.Direction = ParameterDirection.Input;
                inputParameter.SqlDbType = param.Type;
                objCommand.Parameters.Add(inputParameter);
            }

            int results = objDB.DoUpdateUsingCmdObj(objCommand);

            return results;
        }
コード例 #12
0
        protected void btnCreateVenture_Click(object sender, EventArgs e)
        {
            lblEmailsMust.Visible   = false;
            lblRequired.Visible     = false;
            lblPicCheckSize.Visible = false;
            lblPicCheckType.Visible = false;
            string fileExtension = Path.GetExtension(FileUpload1.PostedFile.FileName); //uploaded file extension
            int    iFileSize     = FileUpload1.PostedFile.ContentLength;               //uploaded file size
            int    count         = Convert.ToInt32(db.CheckIfVentureNameExists(txtVentureName.Text));

            if (valid.IsBlank(txtVentureName.Text) || valid.IsBlank(txtPrimaryContactEmail.Text) || valid.IsBlank(txtEmail.Text) || valid.IsBlank(txtDescription.Text))
            {
                lblRequired.Visible = true;
            }
            else if (count >= 1)
            {
                lblVentureNameCheck.Visible = true;
            }
            else if (FileUpload1.FileContent == null && FileUpload1.HasFile == false)
            {//no pic detected in control
            }
            else if (valid.TestForLegalImageTypes(fileExtension) == false)
            {//fail
                lblPicCheckType.Visible = true;
                lblPicCheckType.Text    = fileExtension + " file extension is not allowed. Please use .png, .gif, .jpg, .jpeg, .pdf, .pcd, .fpx, .tif instead";
            }
            else if (iFileSize >= 90000)
            {//fail
                lblPicCheckSize.Visible = true;
                lblPicCheckSize.Text    = "Your file size is " + iFileSize + " bytes. Please reduce the size to less than 90 KB (9000 bytes).";
            }
            else
            {
                MemoryStream ms  = new MemoryStream();
                var          img = System.Drawing.Image.FromStream(FileUpload1.FileContent);
                img.Save(ms, System.Drawing.Imaging.ImageFormat.Png);
                byte[] imageBytes = ms.ToArray();
                Session["venture-pic-upload"] = imageBytes;

                Venture venture = new Venture
                {
                    name                = txtVentureName.Text,
                    description         = txtDescription.Text,
                    aboutUs             = aboutUs.Text,
                    contactEmail        = txtEmail.Text,
                    contactPhoneNumber  = txtPhoneNumber.Text,
                    contactLinkedIn     = txtLinkedIn.Text,
                    Picture             = (byte[])Session["venture-pic-upload"],
                    primaryContactEmail = txtPrimaryContactEmail.Text,
                    isActive            = true,
                    lastUpdateDate      = DateTime.Now,
                    lastUpdateUser      = txtVentureName.Text
                };
                //create new venture

                int result = db.CreateVenture(venture);

                //add venture info to session
                int ventureID = Convert.ToInt32(db.GetVentureID(venture.name));
                sessionObj.storeVentureDataInSession(ventureID);

                //add current user as a venture member
                string   role             = "Founder";
                Expert   expertProfileObj = (CapstoneBlackstone.Expert)Session["expertProfileObj"];
                string   lastUpdateUser   = expertProfileObj.lastName + ", " + expertProfileObj.firstName;
                DateTime lastUpdateDate   = DateTime.Now;
                string   TUID             = expertProfileObj.tuID;
                db.CreateVentureMember(TUID, ventureID, role, lastUpdateDate, lastUpdateUser);

                //redirect to venture page
                Response.Redirect("VenturePage.aspx?name=" + venture.name);
            }
        }
コード例 #13
0
        protected void btnEditVenture_Click(object sender, EventArgs e)
        {
            lblPicCheckType.Visible = false;
            lblPicCheckSize.Visible = false;
            ventureObj                  = (Venture)Session["ventureObj"];
            lblRequired.Visible         = false;
            lblVentureNameCheck.Visible = false;
            int count = Convert.ToInt32(DbMethodsObj.CheckIfVentureNameExists(txtVentureName.Text));

            if (valid.IsBlank(txtVentureName.Text) || valid.IsBlank(txtPrimaryEmail.Text) || valid.IsBlank(txtEmail.Text) || valid.IsBlank(txtDescription.Text))
            {
                lblRequired.Visible = true;
            }
            else if (count >= 1 && txtVentureName.Text != ventureObj.name)
            {
                lblVentureNameCheck.Visible = true;
            }
            else
            {
                Venture v = new Venture();

                v.ventureID           = Convert.ToInt32(DbMethodsObj.GetVentureID(ventureObj.name));
                v.name                = txtVentureName.Text;
                v.description         = txtDescription.Text;
                v.aboutUs             = txtAboutUs.Text;
                v.contactEmail        = txtEmail.Text;
                v.contactPhoneNumber  = txtPhoneNumber.Text;
                v.contactLinkedIn     = txtLinkedIn.Text;
                v.primaryContactEmail = txtPrimaryEmail.Text;
                v.lastUpdateDate      = DateTime.Now;
                Expert expertProfileObj = (CapstoneBlackstone.Expert)Session["expertProfileObj"];
                v.lastUpdateUser = expertProfileObj.lastName + ", " + expertProfileObj.firstName;

                if (FileUpload1.HasFile)
                {
                    string fileExtension = Path.GetExtension(FileUpload1.PostedFile.FileName); //uploaded file extension
                    int    iFileSize     = FileUpload1.PostedFile.ContentLength;               //uploaded file size
                    if (valid.TestForLegalImageTypes(fileExtension) == false)
                    {                                                                          //fail
                        lblPicCheckType.Visible = true;
                        lblPicCheckType.Text    = fileExtension + " file extension is not allowed. Please use .png, .gif, .jpg, .jpeg, .pdf, .pcd, .fpx, .tif instead";
                    }
                    else if (iFileSize >= 90000)
                    {//fail
                        lblPicCheckSize.Visible = true;
                        lblPicCheckSize.Text    = "Your file size is " + iFileSize + " bytes. Please reduce the size to less than 90 KB (90000 bytes).";
                    }
                    else
                    {
                        MemoryStream ms  = new MemoryStream();
                        var          img = System.Drawing.Image.FromStream(FileUpload1.FileContent);
                        img.Save(ms, System.Drawing.Imaging.ImageFormat.Png);
                        v.Picture = ms.ToArray();
                        int result = DbMethodsObj.UpdateVenture(v);
                        Response.Redirect("VenturePage.aspx?name=" + ventureObj.name);
                    }
                }
                else
                {
                    v.Picture = ventureObj.Picture;
                    int result = DbMethodsObj.UpdateVenture(v);
                    Response.Redirect("VenturePage.aspx?name=" + ventureObj.name);
                }
            }
        }//end edit venture click event
コード例 #14
0
        protected void BtnSubmitNewSkill_Click(object sender, EventArgs e)
        {
            Debug.WriteLine("Entering BtnSubmitNewSkill_Click");
            ventureObj = (Venture)Session["ventureObj"];
            int test = 0;
            int result;

            if (string.IsNullOrWhiteSpace(txtAddNewSkill.Text) == false)
            {
                //search expert's skillset to see if the skill added already exsists
                //search all skill to see if the skill added exsists
                //if not to both, add a new skill
                foreach (Tuple <int, String> skill in ventureObj.AllVentureSkills)//test if skill added is already in Expert's Skill Set
                {
                    if (skill.Item2.Equals(txtAddNewSkill.Text, StringComparison.OrdinalIgnoreCase))
                    {
                        test = -1;
                        break;
                    }
                }
                if (test != -1)
                {
                    List <Skills> allSkills = DbMethodsObj.GetSkills();
                    foreach (Skills skill in allSkills)//handle adding the skill
                    {
                        if (skill.SkillName.Equals(txtAddNewSkill.Text, StringComparison.OrdinalIgnoreCase))
                        {
                            result = DbMethodsObj.AddSkillToVenture(ventureObj.ventureID, skill.SkillID);//adding excisting skill to expert
                            if (result != -1)
                            {
                                lblAddSkillTest.Text = "Success! New Skill was added to Skills and Expert_Skills Tables.";
                                test = -2;
                                break;
                            }
                            else
                            {
                                lblAddSkillTest.Text = "Error: Process did not execute successfully. :(";
                            }
                            break;
                        }
                    }
                    if (test != -2)
                    {
                        result = DbMethodsObj.AddNewSkillToVenture(ventureObj.ventureID, txtAddNewSkill.Text);//adding brandnew skill
                        if (result != -1)
                        {
                            lblAddSkillTest.Text = "Success! A New Skill was added to the Ventures wanted Skills.";
                        }
                        else
                        {
                            lblAddSkillTest.Text = "Error: Process did not execute successfully. :(";
                        }
                    }
                    sm.storeVentureDataInSession(ventureObj.ventureID);//now get the whole expert object
                    ventureObj = (Venture)Session["ventureObj"];
                    FillControls();
                }
                else
                {
                    lblAddSkillTest.Text = "Cannot add this skill. you already have this skill in your skill set.";
                }
            }//end if statement for textBoxes
            else
            {
                lblAddSkillTest.Text = "Error: Invalid input.";
            }
        }