private void BTNPRINT_Click(object sender, EventArgs e)
{
RPT.FRM_REPORTS frm = new RPT.FRM_REPORTS();
RPT.RPT_REQUEST rpt = new RPT.RPT_REQUEST();
rpt.SetParameterValue("@Req_ID", CLASS_REQUEST.max_id());
frm.crystalReportViewer1.ReportSource = rpt;
frm.ShowDialog();
}
private void BTNSAVEDATA_Click(object sender, EventArgs e)
{
//try
//{
DataTable dtreqdet = new DataTable();
dtreqdet.Columns.Add("P_ID");
dtreqdet.Columns.Add("QTY");
dtreqdet.Columns.Add("P_Price");
foreach (DataGridViewRow dr in dataGridView1.Rows)
{
dtreqdet.Rows.Add(dr.Cells[0].Value, dr.Cells[4].Value, dr.Cells[3].Value);
}
DataTable dtexpired = new DataTable();
dtexpired.Columns.Add("ex_date");
dtexpired.Columns.Add("P_Id");
dtexpired.Columns.Add("QTY");
foreach (DataGridViewRow dr in dataGridView1.Rows)
{
object expired;
//MessageBox.Show(dr.Cells[2].Value.ToString());
if (dr.Cells[2].Value.ToString() == "")
{
expired = null;
}
else
{
expired = DateTime.Parse(dr.Cells[2].Value.ToString());
}
dtexpired.Rows.Add(expired, dr.Cells[0].Value, dr.Cells[4].Value);
}
CLASS_REQUEST.SP_Request_Insert(ReqDate.Value.Date, TXTTOTAL.Text, int.Parse(TXTSU_ID.Text),
TXT_BUYERNAME.Text, dtreqdet, dtexpired);
MessageBox.Show("success");
BTNPRINT.Enabled = BTNBUYPROCESS.Enabled = true;
//}
// catch (Exception ex)
// { MessageBox.Show(ex.Message); }
}
private void FRM_REQUEST_MANAGEMENT_Load(object sender, EventArgs e)
{
grid_request.DataSource = CLASS_REQUEST.sp_request_Display();
}
