private void BindingItem(DataListItemEventArgs e)
{
DataRowView dr = (DataRowView)e.Item.DataItem;
string q_sbj_id = DataTypeUtility.GetValue(dr["Q_SBJ_ID"]);
string q_sbj_name = DataTypeUtility.GetValue(dr["Q_SBJ_NAME"]);
string q_sbj_define = DataTypeUtility.GetValue(dr["Q_SBJ_DEFINE"]);
double weight = DataTypeUtility.GetToDouble(dr["WEIGHT"]);
quizWeight.Columns.Add(q_sbj_id, typeof(double));
if (quizWeight.Rows.Count == 0)
{
quizWeight.Rows.Add(weight / 100);
}
else
{
quizWeight.Rows[0][q_sbj_id] = weight / 100;
}
Literal ltrSbjName = e.Item.FindControl("ltrLevelSbjName") as Literal;
Literal ltrSbjDefine = e.Item.FindControl("ltrLevelSbjDefine") as Literal;
RadioButtonList rBtnList = e.Item.FindControl("rBtnList") as RadioButtonList;
TextBox txtValue = e.Item.FindControl("txtLevelValue") as TextBox;
HiddenField hdfSubItmYN = e.Item.FindControl("tmpSubItmYN") as HiddenField;
Literal ltrPointData = e.Item.FindControl("ltrLevelPointData") as Literal;
DataList dtList = e.Item.FindControl("DataList3") as DataList;
HtmlTableCell tdHeader = e.Item.FindControl("tdHeader") as HtmlTableCell;
HtmlTableCell tdContent = null;
if (dtList == null)
{
tdContent = e.Item.FindControl("tdContent") as HtmlTableCell;
}
else
{
tdContent = dtList.FindControl("tdContent") as HtmlTableCell;
}
TextBoxCommon.SetOnlyPercent(txtValue);
ltrSbjName.Text = q_sbj_name;
ltrSbjDefine.Text = q_sbj_define;
Biz_QuestionItems questionItems = new Biz_QuestionItems();
DataSet ds = questionItems.GetQuestionItem("", q_sbj_id, Q_OBJ_ID);
SUBJECT_ITEM_YN = ds.Tables[0].Rows[0]["SUBJECT_ITEM_YN"].ToString();
hdfSubItmYN.Value = SUBJECT_ITEM_YN;
if (ds.Tables[0].Rows.Count == 0)
{
rBtnList.Visible = false;
txtValue.Visible = false;
txtValue.Width = Unit.Percentage(100);
}
else if (SUBJECT_ITEM_YN == "1")
{
rBtnList.Visible = false;
txtValue.Visible = true;
txtValue.Width = Unit.Percentage(100);
Biz_Prj_QuestionData questionDatas = new Biz_Prj_QuestionData(COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID
, EST_DEPT_ID
, EST_EMP_ID
, PRJ_REF_ID
, q_sbj_id);
txtValueText = questionDatas.Text_Value;
txtValue.Text = txtValueText;
}
else
{
rBtnList.Visible = true;
txtValue.Visible = false;
// 만약 질의항목에 설명을 표시할 경우
if (_q_item_desc_use_yn.Equals("Y"))
{
rBtnList.RepeatLayout = RepeatLayout.Table;
rBtnList.DataTextField = "Q_ITEM_DESC";
tdHeader.Style.Add("width", "260px");
if (tdContent != null)
{
tdContent.Style.Add("width", "262px");
}
}
rBtnList.DataSource = ds;
rBtnList.DataBind();
if (READ_ONLY_YN.Equals("N"))
{
//Biz_Prj_QuestionData questionDatas = new Biz_Prj_QuestionData(COMP_ID
// , EST_ID
// , ESTTERM_REF_ID
// , ESTTERM_SUB_ID
// , ESTTERM_STEP_ID
// , EST_DEPT_ID
// , EST_EMP_ID
// , PRJ_REF_ID
// , q_sbj_id);
//// 데이타 바인딩
//WebUtility.FindByValueRadioButtonList(rBtnList, questionDatas.Q_Itm_ID);
Biz_Prj_QuestionData questionDatas = new Biz_Prj_QuestionData(COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID
, EST_DEPT_ID
, EST_EMP_ID
, TGT_EMP_ID
, PRJ_REF_ID
, q_sbj_id);
// 데이타 바인딩
WebUtility.FindByValueRadioButtonList(rBtnList, questionDatas.Q_Itm_ID);
groupNumber += questionDatas.Point;
if (questionDatas.Point.Equals(0))
{
noneSelectCount = noneSelectCount + 1;
}
if (questionDatas.Point > 0)
{
ltrPointData.Text = "<font color=#BF0000>" + DataTypeUtility.GetToInt32_String(questionDatas.Point, "##.#0") + "</font>점";
//TOTALPOINT += questionDatas.Point * weight;
}
//----------------- 라디오버튼 유효성 검사 시작 -------------------
string clientIDs = "";
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (i != 0)
{
clientIDs += ";";
}
clientIDs += rBtnList.ClientID + "_" + i.ToString();
}
VALID_SCRIPT += string.Format("if(ValidQuestion('{0}', '{1}') == false) return false;", dr["Q_SBJ_NAME"], clientIDs);
//----------------- 라디오버튼 유효성 검사 끝 -------------------
}
}
}
protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
{
HiddenField c = (HiddenField)e.Item.FindControl("hfRoleName");
HtmlGenericControl div = (HtmlGenericControl)e.Item.FindControl("cddSection");
//string txt = Value;
//string query = $"Select Candidate_Name, RoleName from Candidate where RoleName= '{c.Value}' AND (RoleStatus = 'Active') ";
string query = $"SELECT DISTINCT c.Candidate_Name, c.RoleID, c.RoleImages, c.ManifestoName, p.PollID, p.PollRole, p.PollQuestion, p.PollName FROM tblPoll AS p INNER JOIN Candidate AS c ON p.RoleID = c.RoleID ";
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["smartElectorConnectionString"].ConnectionString))
{
SqlCommand com = new SqlCommand(query, con);
try
{
con.Open();
DataTable dtblCandidates = new DataTable();
SqlDataAdapter sqlDA = new SqlDataAdapter(query, con);
sqlDA.Fill(dtblCandidates);
DataList dt = DataList1;
//Repeater rp = dt.FindControl("ProductsByCategoryList") as Repeater
FormView FV = dt.FindControl("FVCandidateList") as FormView;
if (dtblCandidates.Rows.Count > 0)
{
dt.DataSource = dtblCandidates;
dt.DataBind();
}
//var reader = com.ExecuteReader();
//if (reader.HasRows)
//{
// List<User> listusers = new List<User>();
// string html = "<div>";
// while (reader.Read())
// {
// RadioButton u = new RadioButton();
// Dictionary<string, string> listCandidatename = new Dictionary<string, string>();
// for (int i = 0; reader.Read(); i++)
// {
// listCandidatename[reader.GetString(1)] = reader.GetValue(1).ToString();
// }
// html += "<Label> " + reader.GetString(0) + @" </Label>";
// //html += @"<asp:RadioButtonList ID='rbInsertVote' runat='server' DataSourceID='SqlDataSource1' DataTextField='Candidate_Name' DataValueField='Candidate_Name'>
// // <asp:ListItem></asp:ListItem>
// //</asp:RadioButtonList>";
// u.Text = reader["Candidate_Name"].ToString();
// Controls.Add(u);
// }
// html += "<div>";
// div.InnerHtml = html;
//}
con.Close();
}
catch (Exception ex)
{
}
}
}
private void BindingItem_P(DataListItemEventArgs e)
{
DataRowView dr = (DataRowView)e.Item.DataItem;
string q_sbj_id = DataTypeUtility.GetValue(dr["Q_SBJ_ID"]);
string q_sbj_name = DataTypeUtility.GetValue(dr["Q_SBJ_NAME"]);
string q_sbj_define = DataTypeUtility.GetValue(dr["Q_SBJ_DEFINE"]);
double weight = DataTypeUtility.GetToDouble(dr["WEIGHT"]);
Literal ltrSbjName = e.Item.FindControl("ltrLevelSbjName") as Literal;
Literal ltrSbjDefine = e.Item.FindControl("ltrLevelSbjDefine") as Literal;
RadioButtonList rBtnList = e.Item.FindControl("rBtnList") as RadioButtonList;
TextBox txtValue = e.Item.FindControl("txtLevelValue") as TextBox;
Literal ltrPointData = e.Item.FindControl("ltrLevelPointData") as Literal;
DataList dtList = e.Item.FindControl("DataList3") as DataList;
HtmlTableRow trTextValue = e.Item.FindControl("trTextValue") as HtmlTableRow;
HtmlTableCell tdHeader = null;
HtmlTableCell tdContent = null;
if (dtList == null)
{
//tdHeader = Page.FindControl("tdHeader") as HtmlTableCell;
tdContent = e.Item.FindControl("tdContent") as HtmlTableCell;
}
else
{
//tdHeader = e.Item.FindControl("tdHeader") as HtmlTableCell;
tdContent = dtList.FindControl("tdContent") as HtmlTableCell;
}
//TextBoxCommon.SetOnlyInteger(txtValue);
ltrSbjName.Text = q_sbj_name;
ltrSbjDefine.Text = q_sbj_define;
Biz_QuestionItems questionItems = new Biz_QuestionItems();
DataSet ds = questionItems.GetQuestionItem("", q_sbj_id, Q_OBJ_ID);
if (ds.Tables[0].Rows.Count == 0)
{
rBtnList.Visible = false;
txtValue.Visible = false;
txtValue.Width = Unit.Percentage(100);
}
else if (ds.Tables[0].Rows[0]["SUBJECT_ITEM_YN"].ToString() == "1")
{
rBtnList.Visible = false;
txtValue.Visible = true;
txtValue.Width = Unit.Percentage(100);
}
else
{
rBtnList.Visible = true;
// 만약 질의항목에 설명을 표시할 경우
if (_q_item_desc_use_yn.Equals("Y"))
{
rBtnList.RepeatLayout = RepeatLayout.Table;
rBtnList.DataTextField = "Q_ITEM_DESC";
//tdHeader.Style.Add("width", "260px");
if (tdContent != null)
{
tdContent.Style.Add("width", "262px");
}
}
// 만약 피드백을 적용할 경우
if (_feedback_yn.Equals("Y"))
{
if (EST_TGT_TYPE.Equals("TGT"))
{
txtValue.ReadOnly = true;
rBtnList.Enabled = false;
}
trTextValue.Visible = true;
}
rBtnList.DataSource = ds;
rBtnList.DataBind();
Biz_QuestionDatas questionDatas = new Biz_QuestionDatas(COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, this.IESTTERM_STEP_PREVIOUS_SELECT
, 0
, 0
, TGT_DEPT_ID
, TGT_EMP_ID
, q_sbj_id);
// 데이타 바인딩
WebUtility.FindByValueRadioButtonList(rBtnList, questionDatas.Q_Itm_ID);
if (questionDatas.Point > 0)
{
ltrPointData.Text = "<font color=#BF0000>" + DataTypeUtility.GetToInt32_String(questionDatas.Point, "##.#0") + "</font>점";
}
//----------------- 라디오버튼 유효성 검사 시작 -------------------
string clientIDs = "";
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (i != 0)
{
clientIDs += ";";
}
clientIDs += rBtnList.ClientID + "_" + i.ToString();
}
VALID_SCRIPT += string.Format("if(ValidQuestion('{0}', '{1}') == false) return false;", dr["Q_SBJ_NAME"], clientIDs);
//----------------- 라디오버튼 유효성 검사 끝 -------------------
}
}
protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
{
MembershipUser currentUser = Membership.GetUser();
Guid currentUserId = (Guid)currentUser.ProviderUserKey;
DataList lv = (DataList)source;
String req_from = lv.DataKeys[e.Item.ItemIndex].ToString();
Label lblNotify = lv.FindControl("LabelNotify") as Label;
if (e.CommandName == "CommandAccept")
{
string connectionString =
ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString;
string updateSql = "UPDATE FriendRequests SET Request_status = @Request_status WHERE Request_to = @Request_to";
try
{
using (SqlConnection myConnection = new SqlConnection(connectionString))
{
myConnection.Open();
SqlCommand myCommand = new SqlCommand(updateSql, myConnection);
myCommand.Parameters.AddWithValue("@Request_to", currentUserId);
myCommand.Parameters.AddWithValue("@Request_status", 1);
myCommand.ExecuteNonQuery();
myConnection.Close();
}
}
catch { }
System.Data.SqlClient.SqlDataReader rdr = null;
System.Data.SqlClient.SqlConnection conn = null;
System.Data.SqlClient.SqlCommand sqlcmd = null;
try
{
string connectionString3 = System.Configuration.ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString;
conn = new System.Data.SqlClient.SqlConnection(connectionString3);
sqlcmd = new System.Data.SqlClient.SqlCommand("select * from [FriendsList] where my_id='" + currentUserId + "'", conn);
conn.Open();
rdr = sqlcmd.ExecuteReader();
if (rdr.HasRows)
{
while (rdr.Read())
{
String frd_id = rdr["friend_id"].ToString();
String my_id = rdr["my_id"].ToString();
if (frd_id == req_from && my_id == currentUserId.ToString())
{
lblNotify.Visible = true;
break;
}
else
{
string connectionString4 =
ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString;
string insertSql = "INSERT INTO FriendsList(friend_id, my_id) VALUES(@friend_id, @my_id)";
using (SqlConnection myConnection = new SqlConnection(connectionString4))
{
myConnection.Open();
SqlCommand myCommand = new SqlCommand(insertSql, myConnection);
myCommand.Parameters.AddWithValue("@friend_id", req_from);
myCommand.Parameters.AddWithValue("@my_id", currentUserId);
myCommand.ExecuteNonQuery();
myConnection.Close();
}
using (SqlConnection myConnection = new SqlConnection(connectionString4))
{
myConnection.Open();
SqlCommand myCommand = new SqlCommand(insertSql, myConnection);
myCommand.Parameters.AddWithValue("@friend_id", currentUserId);
myCommand.Parameters.AddWithValue("@my_id", req_from);
myCommand.ExecuteNonQuery();
myConnection.Close();
}
}
}
}
else
{
string connectionString5 =
ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString;
string insertSql = "INSERT INTO FriendsList(friend_id, my_id) VALUES(@friend_id, @my_id)";
using (SqlConnection myConnection = new SqlConnection(connectionString5))
{
myConnection.Open();
SqlCommand myCommand = new SqlCommand(insertSql, myConnection);
myCommand.Parameters.AddWithValue("@friend_id", req_from);
myCommand.Parameters.AddWithValue("@my_id", currentUserId);
myCommand.ExecuteNonQuery();
myConnection.Close();
}
using (SqlConnection myConnection = new SqlConnection(connectionString5))
{
myConnection.Open();
SqlCommand myCommand = new SqlCommand(insertSql, myConnection);
myCommand.Parameters.AddWithValue("@friend_id", currentUserId);
myCommand.Parameters.AddWithValue("@my_id", req_from);
myCommand.ExecuteNonQuery();
myConnection.Close();
}
}
if (rdr != null)
{
rdr.Close();
}
}
catch (Exception ex)
{
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
if (e.CommandName == "CommandReject")
{
string connectionString =
ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString;
string updateSql = "UPDATE FriendRequests SET Request_status = @Request_status WHERE Request_to = @Request_to";
try
{
using (SqlConnection myConnection = new SqlConnection(connectionString))
{
myConnection.Open();
SqlCommand myCommand = new SqlCommand(updateSql, myConnection);
myCommand.Parameters.AddWithValue("@Request_to", currentUserId);
myCommand.Parameters.AddWithValue("@Request_status", 2);
myCommand.ExecuteNonQuery();
myConnection.Close();
}
}
catch { }
}
this.DataBind();
}
