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>");
}
}