private void OnUndispatchedIssueClicked(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e) { var dr = gridUndispatchedIssuesView.GetFocusedDataRow(); _activeSTVID = Convert.ToInt32(dr["STVID"]); gridUndispatchedIssueDetails.DataSource = BLL.Issue.GetIssueDetails(_activeSTVID); User usr = new User(); //usr.LoadByPrimaryKey(NewMainWindow.UserId); usr = CurrentContext.LoggedInUser; BLL.Issue stv = new BLL.Issue(); stv.LoadByPrimaryKey(_activeSTVID); var activity = new Activity(); activity.LoadByPrimaryKey(stv.StoreID); lblMode.Text = activity.ModeName ??"-" ; lblAccount.Text = activity.AccountName ?? "-"; lblActivity.Text = activity.FullActivityName ?? "-"; lblSubAccount.Text = activity.SubAccountName ?? "-"; lblIssueStatus.Text = (string)dr["OrderStatus"] ?? "-"; lblIssueType.Text = (string) dr["OrderType"] ?? "-"; if (!stv.IsColumnNull("ReceivingUnitID")) { var institution = new Institution(); institution.LoadByPrimaryKey(stv.ReceivingUnitID); var ownership = new BLL.OwnershipType(); ownership.LoadByPrimaryKey(institution.Ownership); lblRegion.Text = institution.RegionName ?? "-"; lblZone.Text = institution.ZoneName ?? "-"; lblWoreda.Text = institution.WoredaName ?? "-"; var space = ""; int length = (institution.Name).Length; if(stv.IsColumnNull("IsReprintOf")) FacilityGroup.Text = institution.Name ?? "" +space.PadRight(180 - length) + "Invoice No: " + stv.IDPrinted.ToString("00000"); lblInstitutionType.Text = institution.InstitutionTypeName; lblOwnership.Text = ownership.Name; } else { lblRegion.Text = lblZone.Text = lblWoreda.Text = "NA"; lblInstitutionType.Text = lblOwnership.Text = "-"; FacilityGroup.Text = ""; } if (!stv.IsColumnNull("PaymentTypeID")) { var paymentType = new BLL.PaymentType(); paymentType.LoadByPrimaryKey(stv.PaymentTypeID); lblPaymentType.Text = paymentType.Name; } else { lblPaymentType.Text = "-"; } if (!stv.IsColumnNull("DocumentTypeID")) { lblDocumentedType.Text = DocumentType.GetDocumentType(stv.DocumentTypeID).Name; } else lblDocumentedType.Text = "-"; lblRequistedDate.Text = dr["VoidRequestDateTime"] == DBNull.Value ? "NA" : DateTime.Parse(dr["VoidRequestDateTime"].ToString()).ToShortDateString(); lblVoidRequestedBy.Text = dr["VoidRequestedBy"] == DBNull.Value ? "NA" : (string) dr["VoidRequestedBy"]; var user = new BLL.User(); if (dr["VoidApprovedByUserID"] != DBNull.Value) { user.LoadByPrimaryKey(Convert.ToInt32(dr["VoidApprovedByUserID"])); lblVoidConfirmedBy.Text = user.FullName; } else { lblVoidConfirmedBy.Text = "NA"; } lblVoidConfirmedDate.Text = dr["VoidApprovalDateTime"] == DBNull.Value ? "NA" : DateTime.Parse(dr["VoidApprovalDateTime"].ToString()).ToShortDateString(); stv.LoadLatestReprint(); txtIssuedBy.Text = usr.FullName ?? "-"; lblDispatchConfirmedBy.Text = usr.FullName ?? "-"; // txtSTVInvoiceNo.Text = stv.IDPrinted.ToString("00000"); lblSTVNo.Text = stv.IDPrinted.ToString("00000") ?? "-"; lblSTVDate.Text = stv.PrintedDate.ToShortDateString() ?? "-"; user.LoadByPrimaryKey(stv.UserID); lblSTVPrintedBy.Text = user.FullName ?? "-"; txtPreprintedInvoiceNo.Text = stv.IsColumnNull("PrePrintedInvoiceNo") ? "" : stv.PrePrintedInvoiceNo.ToString(); }
private void OnUndispatchedIssueClicked(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e) { var dr = gridUndispatchedIssuesView.GetFocusedDataRow(); _activeSTVID = Convert.ToInt32(dr["STVID"]); gridUndispatchedIssueDetails.DataSource = BLL.Issue.GetIssueDetails(_activeSTVID); User usr = new User(); //usr.LoadByPrimaryKey(NewMainWindow.UserId); usr = CurrentContext.LoggedInUser; BLL.Issue stv = new BLL.Issue(); stv.LoadByPrimaryKey(_activeSTVID); var activity = new Activity(); activity.LoadByPrimaryKey(stv.StoreID); lblMode.Text = activity.ModeName ?? "-"; lblAccount.Text = activity.AccountName ?? "-"; lblActivity.Text = activity.FullActivityName ?? "-"; lblSubAccount.Text = activity.SubAccountName ?? "-"; lblIssueStatus.Text = (string)dr["OrderStatus"] ?? "-"; lblIssueType.Text = (string)dr["OrderType"] ?? "-"; if (!stv.IsColumnNull("ReceivingUnitID")) { var institution = new Institution(); institution.LoadByPrimaryKey(stv.ReceivingUnitID); var ownership = new BLL.OwnershipType(); ownership.LoadByPrimaryKey(institution.Ownership); lblRegion.Text = institution.RegionName ?? "-"; lblZone.Text = institution.ZoneName ?? "-"; lblWoreda.Text = institution.WoredaName ?? "-"; var space = ""; int length = (institution.Name).Length; if (stv.IsColumnNull("IsReprintOf")) { FacilityGroup.Text = institution.Name ?? "" + space.PadRight(180 - length) + "Invoice No: " + stv.IDPrinted.ToString("00000"); } lblInstitutionType.Text = institution.InstitutionTypeName; lblOwnership.Text = ownership.Name; } else { lblRegion.Text = lblZone.Text = lblWoreda.Text = "NA"; lblInstitutionType.Text = lblOwnership.Text = "-"; FacilityGroup.Text = ""; } if (!stv.IsColumnNull("PaymentTypeID")) { var paymentType = new BLL.PaymentType(); paymentType.LoadByPrimaryKey(stv.PaymentTypeID); lblPaymentType.Text = paymentType.Name; } else { lblPaymentType.Text = "-"; } if (!stv.IsColumnNull("DocumentTypeID")) { lblDocumentedType.Text = DocumentType.GetDocumentType(stv.DocumentTypeID).Name; } else { lblDocumentedType.Text = "-"; } lblRequistedDate.Text = dr["VoidRequestDateTime"] == DBNull.Value ? "NA" : DateTime.Parse(dr["VoidRequestDateTime"].ToString()).ToShortDateString(); lblVoidRequestedBy.Text = dr["VoidRequestedBy"] == DBNull.Value ? "NA" : (string)dr["VoidRequestedBy"]; var user = new BLL.User(); if (dr["VoidApprovedByUserID"] != DBNull.Value) { user.LoadByPrimaryKey(Convert.ToInt32(dr["VoidApprovedByUserID"])); lblVoidConfirmedBy.Text = user.FullName; } else { lblVoidConfirmedBy.Text = "NA"; } lblVoidConfirmedDate.Text = dr["VoidApprovalDateTime"] == DBNull.Value ? "NA" : DateTime.Parse(dr["VoidApprovalDateTime"].ToString()).ToShortDateString(); stv.LoadLatestReprint(); txtIssuedBy.Text = usr.FullName ?? "-"; lblDispatchConfirmedBy.Text = usr.FullName ?? "-"; // txtSTVInvoiceNo.Text = stv.IDPrinted.ToString("00000"); lblSTVNo.Text = stv.IDPrinted.ToString("00000") ?? "-"; lblSTVDate.Text = stv.PrintedDate.ToShortDateString() ?? "-"; user.LoadByPrimaryKey(stv.UserID); lblSTVPrintedBy.Text = user.FullName ?? "-"; txtPreprintedInvoiceNo.Text = stv.IsColumnNull("PrePrintedInvoiceNo") ? "" : stv.PrePrintedInvoiceNo.ToString(); }