private void FCustomerMsg_Load(object sender, EventArgs e)
{
toolTip1.SetToolTip(this.pictureBox1, "請拖放圖片至此");
//var get_AuthorityID = (from n in DE.Member_Table
// where n.MemberID == member_id
// select n.AuthorityID).FirstOrDefault();
//m_AuthorityID = (int)get_AuthorityID;
if (m_AuthorityID < 3)
{
textBox2.Visible = false;
label2.Visible = false;
pictureBox2.Visible = false;
button2.Visible = false;
label4.Visible = false;
var q2 = from n in DE.Feedback_Table
where n.MemberID == member_id
select new { n.Feedback_Category_Table.FeedbackCategory,
n.Contents,
n.FeedbackContent,
n.Feedback_Progress_Table.ProgressContent,
n.FeedbackDate,
n.Picture };
dataGridView1.DataSource = q2.ToList();
label3.Text = Viewbag.member.MemberName;
}
else
{
label1.Visible = false;
pictureBox1.Visible = false;
textBox1.Visible = false;
listBox1.Visible = false;
button1.Visible = false;
label3.Visible = false;
var q2 = new CCustomerMsg().get_Feedback_process(4);
dataGridView1.DataSource = q2.ToList();
dataGridView1.Columns[9].Visible = false;
dataGridView1.Columns[10].Visible = false;
dataGridView1.Columns[11].Visible = false;
label4.Text = Viewbag.member.MemberName;
}
comboBox1.DataSource = new CCustomerMsg().get_Feedback_Category().ToList();
var q1 = new CCustomerMsg().get_Feedback_msg(member_id);
foreach (var item in q1)
{
listBox1.Items.Add(item);
}
}
private void button2_Click(object sender, EventArgs e)
{
int current_index = (int)(dataGridView1.CurrentRow.Cells[0].Value);
var q = (from n in DE.Feedback_Table
where n.FeedbackID == current_index
select n).FirstOrDefault();
q.FeedbackContent = textBox2.Text;
q.ProgressID = 3;
q.FeedbackDate = DateTime.Now;
DE.SaveChanges();
var q2 = new CCustomerMsg().get_Feedback_process(4);
dataGridView1.DataSource = q2.ToList();
dataGridView1.Columns[9].Visible = false;
dataGridView1.Columns[10].Visible = false;
dataGridView1.Columns[11].Visible = false;
textBox2.Text = "";
}
