private void btnSave_Click(object sender, EventArgs e) { //ADDING DATA IN TABLE TBL_LOGSHEET_INQUIRY tbl_Inquiry = new TBL_LOGSHEET_INQUIRY(); tbl_Inquiry.LOG_DATE = Convert.ToDateTime(dtepckerDATE.Text); tbl_Inquiry.LOG_PETCNAME = cmboxPETC.Text; tbl_Inquiry.LOG_RECEIVEDVIA = txtReceivedvia.Text; tbl_Inquiry.LOG_RECEIVEDBY = txtReceivedby.Text; tbl_Inquiry.LOG_DTLINQUIRY = txtDetailsofInquiry.Text; tbl_Inquiry.LOG_TMERECEIVE = dtetimeReceived.Value; tbl_Inquiry.LOG_ACTTAKEN = txtActionTaken.Text; tbl_Inquiry.LOG_TMECMPLTED = dtetmeCompleted.Value; tbl_Inquiry.LOG_REMARKS = richtxtRemarks.Text; tbl_Inquiry.LOG_CERTIFICATE = "CERTIFICATE"; var minus = dtetimeReceived.Value - dtetmeCompleted.Value; //tbl_Inquiry.LOG_RESPONSE = minus.Duration().ToString(@"hh\:mm\:ss"); db_LogsheetUtil.TBL_LOGSHEET_INQUIRY.Add(tbl_Inquiry); dataGridView1.Update(); dataGridView1.Refresh(); db_LogsheetUtil.SaveChanges(); MessageBox.Show("Successfully Save"); cmboxPETC.Text = string.Empty; txtReceivedvia.Text = string.Empty; txtReceivedby.Text = string.Empty; txtDetailsofInquiry.Text = string.Empty; txtActionTaken.Text = string.Empty; richtxtRemarks.Text = string.Empty; refreshList(); cmboxPETC.Enabled = false; txtReceivedby.Enabled = false; txtReceivedvia.Enabled = false; txtDetailsofInquiry.Enabled = false; txtActionTaken.Enabled = false; dtepckerDATE.Enabled = false; dtetimeReceived.Enabled = false; dtepckerDATE.Enabled = false; dtetmeCompleted.Enabled = false; richtxtRemarks.Enabled = false; btnNew.Enabled = true; btnSave.Enabled = false; btnUpdate.Enabled = false; }
private void dataGridView1_MouseClick(object sender, MouseEventArgs e) { foreach (DataGridViewRow row in dataGridView1.SelectedRows) { record_id = (Int32)row.Cells["Id"].Value; dtepckerDATE.Value = Convert.ToDateTime(row.Cells["LOG_DATE"].Value.ToString()); cmboxPETC.Text = row.Cells["LOG_PETCNAME"].Value.ToString(); txtReceivedby.Text = row.Cells["LOG_RECEIVEDBY"].Value.ToString(); txtReceivedvia.Text = row.Cells["LOG_RECEIVEDVIA"].Value.ToString(); txtDetailsofInquiry.Text = row.Cells["LOG_DTLINQUIRY"].Value.ToString(); dtetimeReceived.Value = Convert.ToDateTime(row.Cells["LOG_TMERECEIVE"].Value.ToString()); txtActionTaken.Text = row.Cells["LOG_ACTTAKEN"].Value.ToString(); dtetmeCompleted.Value = Convert.ToDateTime(row.Cells["LOG_TMECMPLTED"].Value.ToString()); richtxtRemarks.Text = row.Cells["LOG_REMARKS"].Value.ToString(); TBL_LOGSHEET_INQUIRY tbl = new TBL_LOGSHEET_INQUIRY(); tbl.LOG_PETCNAME = cmboxPETC.Text; tbl.LOG_RECEIVEDVIA = txtReceivedvia.Text; tbl.LOG_RECEIVEDBY = txtReceivedby.Text; tbl.LOG_DTLINQUIRY = txtDetailsofInquiry.Text; tbl.LOG_TMERECEIVE = dtetimeReceived.Value; tbl.LOG_ACTTAKEN = txtActionTaken.Text; tbl.LOG_TMECMPLTED = dtetmeCompleted.Value; tbl.LOG_REMARKS = richtxtRemarks.Text; cmboxPETC.Enabled = true; txtReceivedby.Enabled = true; txtReceivedvia.Enabled = true; txtDetailsofInquiry.Enabled = true; txtActionTaken.Enabled = true; dtepckerDATE.Enabled = true; dtetimeReceived.Enabled = true; dtepckerDATE.Enabled = true; dtetmeCompleted.Enabled = true; richtxtRemarks.Enabled = true; btnNew.Enabled = true; btnSave.Enabled = false; btnUpdate.Enabled = true; } }
private void crystalReportViewer1_Load(object sender, EventArgs e) { TBL_LOGSHEET_INQUIRY tbl_Inquiry = new TBL_LOGSHEET_INQUIRY(); tbl_Inquiry.LOG_DATE = Convert.ToDateTime(tbl_Inquiry.LOG_DATE); }
public AddInquiryCertificate(TBL_LOGSHEET_INQUIRY tBL_LOGSHEET_INQUIRY) { // TODO: Complete member initialization //this.tBL_LOGSHEET_INQUIRY = tBL_LOGSHEET_INQUIRY; }