private void button2_Click(object sender, EventArgs e)
{
List <TBL_LOGSHEET_INQUIRY> list = new List <TBL_LOGSHEET_INQUIRY>();
List <AddInquiryCetificateClass> listo = new List <AddInquiryCetificateClass>();
using (var db = new PETC_LogsheetEntities())
{
list = db.TBL_LOGSHEET_INQUIRY.ToList();
foreach (var item in list)
{
AddInquiryCetificateClass tbl = new AddInquiryCetificateClass();
tbl.LOG_DATE = Convert.ToDateTime(item.LOG_DATE);
tbl.LOG_PETCNAME = item.LOG_PETCNAME;
tbl.LOG_RECEIVEDVIA = item.LOG_RECEIVEDVIA;
tbl.LOG_RECEIVEDBY = item.LOG_DTLINQUIRY;
tbl.LOG_DATE = Convert.ToDateTime(item.LOG_DATE);
tbl.LOG_DTLINQUIRY = item.LOG_DTLINQUIRY;
tbl.LOG_ACTTAKEN = item.LOG_ACTTAKEN;
tbl.LOG_TMECMPLTED = Convert.ToDateTime(item.LOG_TMECMPLTED);
tbl.LOG_REMARKS = item.LOG_REMARKS;
var resp = item.LOG_DATE.Value - item.LOG_TMECMPLTED.Value;
tbl.LOG_RESPONSE = Convert.ToString(resp.Duration());
listo.Add(tbl);
}
}
CrystalReport1 rpt = new CrystalReport1();
rpt.SetDataSource(listo);
crystalReportViewer1.ReportSource = rpt;
}
public void refreshList()
{
db_LogsheetUtil = new PETC_LogsheetEntities();
dataGridView1.DataSource = db_LogsheetUtil.TBL_LOGSHEET_INQUIRY.ToList();
//dtaGridMenu.Columns["ID"].DisplayIndex = 0;
dataGridView1.Columns["LOG_DATE"].DefaultCellStyle.Format = "yy/MM/dd";
dataGridView1.Columns["LOG_PETCCODE"].Visible = false;
//dtaGridMenu.Columns["LOG_PETCNAME"].DisplayIndex = 2;
//dtaGridMenu.Columns["LOG_RECEIVEDVIA"].DisplayIndex = 3;
//dtaGridMenu.Columns["LOG_RECEIVEDBY"].DisplayIndex = 4;
dataGridView1.Columns["LOG_TMERECEIVE"].DefaultCellStyle.Format = "HH:mm";
//dtaGridMenu.Columns["LOG_DTLINQUIRY"].DisplayIndex = 6;
dataGridView1.Columns["LOG_TMECMPLTED"].DefaultCellStyle.Format = "HH:mm";
//dtaGridMenu.Columns["LOG_ACTTAKEN"].DisplayIndex = 8;
//dtaGridMenu.Columns["LOG_REMARKS"].DisplayIndex = 9;
dataGridView1.Columns["LOG_RESPONSE"].DefaultCellStyle.Format = "HH:mm";
dataGridView1.Columns["LOG_ENCODED"].Visible = false;
dataGridView1.Columns["LOG_DATELOG"].Visible = false;
dataGridView1.Columns["LOG_REGISTRYCODE"].Visible = false;
dataGridView1.Columns["LOG_CERTIFICATE"].Visible = false;
dataGridView1.Columns["LOG_DATE"].HeaderText = "DATE";
//dtaGridMenu.Columns["LOG_PETCCODE"].HeaderText = "PETC CODE";
dataGridView1.Columns["LOG_PETCNAME"].HeaderText = "PETC NAME";
dataGridView1.Columns["LOG_RECEIVEDVIA"].HeaderText = "RECEIVE VIA";
dataGridView1.Columns["LOG_RECEIVEDBY"].HeaderText = "RECEIVE BY";
dataGridView1.Columns["LOG_DATE"].HeaderText = "TIME RECEIVE";
dataGridView1.Columns["LOG_DTLINQUIRY"].HeaderText = "DETAIL INQUIRY";
dataGridView1.Columns["LOG_TMECMPLTED"].HeaderText = "TIME COMPLETED";
dataGridView1.Columns["LOG_ACTTAKEN"].HeaderText = "ACTION TAKEN";
dataGridView1.Columns["LOG_REMARKS"].HeaderText = "REMARKS";
dataGridView1.Columns["LOG_RESPONSE"].HeaderText = "RESPONSE TIME";
}
private void AddInquiryCertificate_Load(object sender, EventArgs e)
{
//VIEWING DATA IN DATAGRID
db_LogsheetUtil = new PETC_LogsheetEntities();
dataGridView1.DataSource = db_LogsheetUtil.TBL_LOGSHEET_INQUIRY.ToList();
dataGridView1.Columns["LOG_DATE"].DefaultCellStyle.Format = "yy/MM/dd";
dataGridView1.Columns["LOG_PETCCODE"].Visible = false;
dataGridView1.Columns["LOG_TMERECEIVE"].DefaultCellStyle.Format = "HH:mm";
dataGridView1.Columns["LOG_TMECMPLTED"].DefaultCellStyle.Format = "HH:mm";
dataGridView1.Columns["LOG_RESPONSE"].DefaultCellStyle.Format = "HH:mm";
dataGridView1.Columns["LOG_ENCODED"].Visible = false;
dataGridView1.Columns["LOG_DATELOG"].Visible = false;
dataGridView1.Columns["LOG_REGISTRYCODE"].Visible = false;
dataGridView1.Columns["LOG_CERTIFICATE"].Visible = false;
dataGridView1.Columns["LOG_DATE"].HeaderText = "DATE";
dataGridView1.Columns["LOG_PETCNAME"].HeaderText = "PETC NAME";
dataGridView1.Columns["LOG_RECEIVEDVIA"].HeaderText = "RECEIVE VIA";
dataGridView1.Columns["LOG_RECEIVEDBY"].HeaderText = "RECEIVE BY";
dataGridView1.Columns["LOG_DATE"].HeaderText = "TIME RECEIVE";
dataGridView1.Columns["LOG_DTLINQUIRY"].HeaderText = "DETAIL INQUIRY";
dataGridView1.Columns["LOG_TMECMPLTED"].HeaderText = "TIME COMPLETED";
dataGridView1.Columns["LOG_ACTTAKEN"].HeaderText = "ACTION TAKEN";
dataGridView1.Columns["LOG_REMARKS"].HeaderText = "REMARKS";
dataGridView1.Columns["LOG_RESPONSE"].HeaderText = "RESPONSE TIME";
cmboxPETC.Text = string.Empty;
txtReceivedvia.Text = string.Empty;
txtReceivedby.Text = string.Empty;
txtDetailsofInquiry.Text = string.Empty;
txtActionTaken.Text = string.Empty;
richtxtRemarks.Text = string.Empty;
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;
btnSave.Enabled = false;
btnUpdate.Enabled = false;
}