protected void btnNext_Click(object sender, EventArgs e) { //Iterate outer GridView Rows ... foreach (GridViewRow row in grdCat.Rows) { if (row.RowType == DataControlRowType.DataRow) { // ... to Find the Inner GridView GridView grdSkills = (GridView)row.FindControl("grdSkill"); //Iterate inner GridView ... if (grdSkills != null) { foreach (GridViewRow grow in grdSkills.Rows) { if (grow.RowType == DataControlRowType.DataRow) { //... to Find CheckBoxes CheckBox ckbSkills = (CheckBox)grow.FindControl("ckbSkill"); if (ckbSkills != null) { if (ckbSkills.Checked) { var dataKey = grdSkills.DataKeys[grow.RowIndex]; if (dataKey != null) { string sid = dataKey.Value.ToString(); SqlDataAdapter d = new SqlDataAdapter("", connection); DataTable t = new DataTable(); d.SelectCommand.CommandText = "SELECT * FROM MembersSkills WHERE Member_ID=@mid AND Skill_ID=@sid"; d.SelectCommand.Parameters.AddWithValue("@mid", Session["Mid"]); d.SelectCommand.Parameters.AddWithValue("@sid", sid); d.Fill(t); if (t.Rows.Count == 0) { d.SelectCommand.Parameters.Clear(); SqlCommand cmd = new SqlCommand("INSERT INTO MembersSkills(Member_ID,Skill_ID,Date) VALUES(@mid,@sid,@date)", connection); cmd.Parameters.AddWithValue("@mid", Session["Mid"]); cmd.Parameters.AddWithValue("@sid", sid); cmd.Parameters.AddWithValue("@date", PersianDateConverter.GetDate()); connection.Open(); cmd.ExecuteNonQuery(); connection.Close(); } } } } } } } } } Response.Redirect("SkillVal.aspx"); }
//Click Event > Add New Member if the Validations are Valid protected void btnAdd_Click(object sender, EventArgs e) { if (Page.IsValid) { string gender = (rdbmale.Checked) ? "مرد" : "زن"; //Insertion New Member Into Members Table SqlCommand cmd = new SqlCommand("", connection); cmd.CommandText = "INSERT INTO Members(ID,FirstName,LastName,Email,PhoneNumber,Gender,Image,Fielde_ID,Date,IsCompeleted) " + " VALUES(@id,@fn,@ls,@em,@phn,@g,@img,@fid,@date,@isCompeleted)"; cmd.Parameters.AddWithValue("@id", txtStdentID.Text); cmd.Parameters.AddWithValue("@fn", txtFirstName.Text); cmd.Parameters.AddWithValue("@ls", txtLastName.Text); cmd.Parameters.AddWithValue("@em", txtEmail.Text); cmd.Parameters.AddWithValue("@phn", txtPhoneNumber.Text); cmd.Parameters.AddWithValue("@g", gender); cmd.Parameters.AddWithValue("@img", "~/MyFiles/user.png"); cmd.Parameters.AddWithValue("@fid", ddlField.SelectedValue); cmd.Parameters.AddWithValue("@date", PersianDateConverter.GetDate()); cmd.Parameters.AddWithValue("@isCompeleted", "false"); connection.Open(); cmd.ExecuteNonQuery(); connection.Close(); cmd.Parameters.Clear(); //Insertion new Member AS an User into Users Table SqlDataAdapter da = new SqlDataAdapter("", connection); DataTable dt = new DataTable(); da.SelectCommand.CommandText = "SELECT * FROM MemberList WHERE Mid = @mid"; da.SelectCommand.Parameters.AddWithValue("@mid", txtStdentID.Text); da.Fill(dt); cmd.CommandText = "INSERT INTO Users(Member_ID,Password,Type_ID) VALUES(@Mid,@pass,@type)"; cmd.Parameters.AddWithValue("@Mid", txtStdentID.Text); cmd.Parameters.AddWithValue("@pass", MakePass(txtStdentID.Text, txtPhoneNumber.Text, txtEmail.Text).ToUpper()); cmd.Parameters.AddWithValue("@type", db.SelectQueryFillDataTable("SELECT * FROM Rols WHERE Type = N'User'", 0, "ID").ToString()); connection.Open(); cmd.ExecuteNonQuery(); connection.Close(); SendMail(txtEmail.Text.ToLower(), txtStdentID.Text, MakePass(txtStdentID.Text, txtPhoneNumber.Text, txtEmail.Text).ToUpper()); //Alert 'Add Succesfully' string gen = (gender == "مرد") ? "آقای" : "خانم"; Response.Write("<script>alert('" + gen + " " + "" + txtFirstName.Text + " " + "" + txtLastName.Text + " باموفقیت افزوده شد.');</script>"); ClearForm(); } }
protected void btnEdit_Click(object sender, EventArgs e) { SqlDataAdapter da = new SqlDataAdapter("", connection); DataTable dt = new DataTable(); SqlCommand cmd = new SqlCommand("", connection); cmd.CommandText = "INSERT INTO Skills(Title,Description,Cat_ID,Req) VALUES(@tl,@des,@cat,@req)"; cmd.Parameters.AddWithValue("@tl", txtTitle.Text); cmd.Parameters.AddWithValue("@des", txtDescription.Text); cmd.Parameters.AddWithValue("@cat", ddlSkillCat.SelectedValue); cmd.Parameters.AddWithValue("@req", Request.QueryString["srid"]); connection.Open(); cmd.ExecuteNonQuery(); connection.Close(); cmd.Parameters.Clear(); cmd.CommandText = "INSERT INTO MembersSkills(Member_ID,Skill_ID,Date) VALUES(@mid,@sid,@date)"; da.SelectCommand.CommandText = "SELECT * FROM SkillRequest WHERE ID = @srid"; da.SelectCommand.Parameters.AddWithValue("@srid", Request.QueryString["srid"]); da.Fill(dt); cmd.Parameters.AddWithValue("@mid", dt.Rows[0]["Member_ID"]); da.SelectCommand.Parameters.Clear(); dt.Clear(); da.SelectCommand.CommandText = "SELECT * FROM Skills WHERE Req = @req"; da.SelectCommand.Parameters.AddWithValue("@req", Request.QueryString["srid"]); da.Fill(dt); cmd.Parameters.AddWithValue("@sid", dt.Rows[0]["ID"]); da.SelectCommand.Parameters.Clear(); dt.Clear(); //cmd.Parameters.AddWithValue("@val", ); cmd.Parameters.AddWithValue("@date", PersianDateConverter.GetDate()); connection.Open(); cmd.ExecuteNonQuery(); connection.Close(); cmd.Parameters.Clear(); da.SelectCommand.Parameters.Clear(); dt.Clear(); cmd.CommandText = "DELETE FROM SkillRequest WHERE ID=@id"; cmd.Parameters.AddWithValue("@id", Request.QueryString["srid"]); connection.Open(); cmd.ExecuteNonQuery(); connection.Close(); Response.Redirect("SkillRequests.aspx"); }
protected void btnSuggest_Click(object sender, EventArgs e) { if (!(string.IsNullOrEmpty(txtTitle.Text) || string.IsNullOrWhiteSpace(txtTitle.Text))) { SqlDataAdapter da = new SqlDataAdapter("", connection); DataTable dt = new DataTable(); DataTable dl = new DataTable(); SqlCommand cmd = new SqlCommand("", connection); da.SelectCommand.CommandText = "SELECT * FROM Skills WHERE Title=@tl"; da.SelectCommand.Parameters.AddWithValue("@tl", txtTitle.Text); da.Fill(dt); da.SelectCommand.Parameters.Clear(); da.SelectCommand.CommandText = "SELECT * FROM SkillRequest WHERE Title=@title AND Member_ID=@mid"; da.SelectCommand.Parameters.AddWithValue("@title", txtTitle.Text); da.SelectCommand.Parameters.AddWithValue("@mid", Session["Mid"]); da.Fill(dl); if (dt.Rows.Count != 0) { Response.Write("<script>alert('دانشی که پیشنهاد کردهاید در لیست موجود است');</script>"); } if (dl.Rows.Count != 0) { Response.Write("<script>alert('شما قبلاً این دانش را ثبت کردهاید');</script>"); } else { cmd.CommandText = "INSERT INTO SkillRequest(Title,Member_ID,Description,Date) VALUES(@ttl,@mid2,@des,@date)"; cmd.Parameters.AddWithValue("@ttl", txtTitle.Text); cmd.Parameters.AddWithValue("@mid2", Session["Mid"]); cmd.Parameters.AddWithValue("@des", txtDescription.Text); cmd.Parameters.AddWithValue("@date", PersianDateConverter.GetDate()); connection.Open(); cmd.ExecuteNonQuery(); connection.Close(); } } else { Response.Write("<script>alert('دانش پیشنهادی افزوده نشد.فیلد خالی است');</script>"); } }