private void submitButton_Click(object sender, EventArgs e) { ComplainInfo obj = new ComplainInfo() { cName = nameTextBox.Text, cRoll = rollTextBox.Text, cMb = mbTextbox.Text, cDate = dateTextBox.Text, complain = complainRichTextBox.Text }; if (cAllotIdTextBox.Text == "") { obj.cAllot_id = -1; } else { obj.cAllot_id = Convert.ToInt32(cAllotIdTextBox.Text); } ComplainChek ob = new ComplainChek(); ob.submitChek(obj); ComplainDataAccess dataAccess = new ComplainDataAccess(); List <ComplainInfo> complains = dataAccess.viewComplain(); complainDataGridView.AutoGenerateColumns = false; complainDataGridView.DataSource = complains; }
public void viewButton_Click(object sender, EventArgs e) { ComplainDataAccess dataAccess = new ComplainDataAccess(); List <ComplainInfo> complains = dataAccess.viewComplain(); complainDataGridView.AutoGenerateColumns = false; complainDataGridView.DataSource = complains; complainDataGridView.Columns[0].DataPropertyName = "cId"; complainDataGridView.Columns[1].DataPropertyName = "cAllot_id"; complainDataGridView.Columns[2].DataPropertyName = "cName"; complainDataGridView.Columns[3].DataPropertyName = "cRoll"; complainDataGridView.Columns[4].DataPropertyName = "cMb"; complainDataGridView.Columns[5].DataPropertyName = "cDate"; complainDataGridView.Columns[6].DataPropertyName = "complain"; }
public void submitChek(ComplainInfo obj) { if (obj.cName == "" || obj.cAllot_id == -1 || obj.cRoll == "" || obj.cMb == "" || obj.cDate == "" || obj.complain == "") { MessageBox.Show("please fill up all the require information!!!"); } else { ComplainDataAccess dataAccess = new ComplainDataAccess(); int i = dataAccess.nameRollChek(obj); if (i > 0) { dataAccess.saveComplain(obj); } else { MessageBox.Show("your allot id or name or roll don't match !!!!!"); } } }
public void deleteComplainCheck(ComplainInfo ob) { if (ob.cId == 0) { MessageBox.Show("plese click on a row ."); } else { DialogResult dr = MessageBox.Show("Are you want to delete complain ID :" + ob.cId, "continue", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) { ComplainDataAccess dObj = new ComplainDataAccess(); dObj.deleteComplain(ob); MessageBox.Show("deleted "); } else if (dr == DialogResult.No) { MessageBox.Show("not deleted."); } } }
private void deleteButton_Click(object sender, EventArgs e) { ComplainInfo ob = new ComplainInfo(); if (deleteComplainIdTextBox.Text == "") { ob.cId = 0; } else { ob.cId = Convert.ToInt32(deleteComplainIdTextBox.Text); } ComplainChek obj = new ComplainChek(); obj.deleteComplainCheck(ob); ComplainDataAccess dataAccess = new ComplainDataAccess(); List <ComplainInfo> complains = dataAccess.viewComplain(); complainDataGridView.AutoGenerateColumns = false; complainDataGridView.DataSource = complains; }