private void bttIssIssue_Click(object sender, EventArgs e) { int tmpID; tmpID = Convert.ToInt32(lvwIssuances.SelectedItems[0].Text); //DataSet ds = CBTransmittalRelease.GetIssueReleaseForReport(tmpID); //CPTransmittal.ShowTestIssuance(ds); CBTransmittalRelease.SetPrintDate(tmpID); LoadStatusListIssuance(); LoadStatusListForTrans(); }
private void LoadStatusListAll() { SqlDataReader dr; ListViewItem lvi; string tmpDate; lvwIssueList.Items.Clear(); dr = CBTransmittalRelease.GetListForStatus(); while (dr.Read()) { lvi = new ListViewItem(); lvi.Text = dr["ID"].ToString(); lvi.SubItems.Add(Convert.ToDateTime(dr["DateIssued"]).ToShortDateString()); lvi.SubItems.Add(dr["Number"].ToString()); lvi.SubItems.Add(dr["IssuedBy"].ToString()); lvi.SubItems.Add(dr["ReleaseFor"].ToString()); lvi.SubItems.Add(dr["DocCnt"].ToString()); tmpDate = dr["DateIssued"].ToString(); if (tmpDate.Length > 0) { lvi.SubItems.Add(Convert.ToDateTime(tmpDate).ToShortDateString()); } else { lvi.SubItems.Add(""); } lvi.SubItems.Add(dr["TransNum"].ToString()); tmpDate = dr["TransDate"].ToString(); if (tmpDate.Length > 0) { lvi.SubItems.Add(Convert.ToDateTime(tmpDate).ToShortDateString()); } else { lvi.SubItems.Add(""); } lvwIssueList.Items.Add(lvi); } dr.Close(); }
public static void PrintTransmittalRelease(int releaseID) { rprtTransmittalRelease1 rprt = new rprtTransmittalRelease1(); DataSet ds; FPreviewAR pv = new FPreviewAR(); CBProject proj = new CBProject(); //***********************************Added 9/30/2015 CBTransmittalRelease r = new CBTransmittalRelease(); r.Load(releaseID); proj.Load(r.ProjectID); pv.projNumber = proj.Number; ds = CBTransmittalRelease.GetTransmittalReleaseForReport(releaseID); rprt.DataSource = ds; rprt.DataMember = "Table"; pv.ViewReport(rprt); pv.ShowDialog(); }
private void bttIssCanc_Click(object sender, EventArgs e) { int tmpID; string desc; tmpID = Convert.ToInt32(lvwIssuances.SelectedItems[0].Text); ListViewItem lvi = lvwIssuances.SelectedItems[0]; desc = lvi.SubItems[1].Text + " - " + lvi.SubItems[2].Text + " - " + lvi.SubItems[3].Text + " - " + lvi.SubItems[4].Text; DialogResult retVal = MessageBox.Show("Are you sure that you wise to remove " + desc + " ?", "Remove Issuance", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (retVal == DialogResult.Yes) { CBTransmittalRelease.Delete(tmpID); LoadStatusListAll(); LoadStatusListIssuance(); LoadStatusListForTrans(); } }