public FCustomerMsg() { InitializeComponent(); pictureBox1 = new CCustomerMsg().setPicturebox(pictureBox1); pictureBox2 = new CCustomerMsg().setPicturebox(pictureBox2); member_id = Viewbag.member.MemberID; m_AuthorityID = Viewbag.member.AuthorityID; }
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 button1_Click(object sender, EventArgs e) { Feedback_Table ft = new Feedback_Table(); ft.FeedbackCategoryID = comboBox1.SelectedIndex + 1; ft.MemberID = member_id; ft.Contents = textBox1.Text; ft.ProgressID = 1; ft.FeedbackDate = DateTime.Today; if (pictureBox1.Image != null) { byte[] bytes; System.IO.MemoryStream ms = new System.IO.MemoryStream(); pictureBox1.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg); bytes = ms.GetBuffer(); ft.Picture = bytes; } DE.Feedback_Table.Add(ft); DE.SaveChanges(); listBox1.Items.Clear(); var q1 = new CCustomerMsg().get_Feedback_msg(member_id); foreach (var item in q1) { listBox1.Items.Add(item); } textBox1.Text = ""; pictureBox1.Image = null; 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(); }
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 = ""; }