public static XtraReport CreateCashReprintInvoiceSmaller(Order ord, DataTable dvPriced, Institution rus, BLL.PickList pl, bool deliveryNote, bool hasInsurnance, string activityName, int?_stvLogIdChosen)
{
CashInvoice_Smaller stvReport = new CashInvoice_Smaller(CurrentContext.LoggedInUserName);
PrepareTheReportCash(stvReport);
stvReport.DataSource = Order.ReorganizeDataViewForSTVPrint_Program(dvPriced.AsDataView(), ord.ID, pl.ID, CurrentContext.UserId, _stvLogIdChosen, false, true, hasInsurnance);
//stvReport.DataSource = Order.ReorganizeDataViewForSTVPrint(dvPriced.AsDataView(), ord.ID, pl.ID, NewMainWindow.UserId,null);
stvReport.From.Text = GeneralInfo.Current.HospitalName;
stvReport.To.Text = rus.Name;
stvReport.Town.Text = rus.Town;
stvReport.Woreda.Text = rus.WoredaText;
stvReport.Zone.Text = rus.ZoneText;
stvReport.Region.Text = rus.Region;
stvReport.TIN.Text = rus.TinNo;
stvReport.VAT.Text = rus.VATNo;
stvReport.License.Text = (!rus.IsColumnNull("Ownership") && rus.IsPrivatelyOwned)
? rus.LicenseNo
: (!ord.IsColumnNull("LetterNo")) ? ord.LetterNo : "";
stvReport.Program.Text = activityName;
DateTimePickerEx dtDate = new DateTimePickerEx();
dtDate.Value = DateTimeHelper.ServerDateTime;
stvReport.Date.Text = dtDate.Text;
if (deliveryNote)
{
stvReport.TopMargin.HeightF = stvReport.TopMargin.HeightF / 2;
stvReport.xrSTVOrInvoiceLabel.Text = "Delivery Note No.";
stvReport.GroupFooter1.Visible = false;
stvReport.GroupFooter2.Visible = false;
}
return(stvReport);
}
private void ReceivingUnitsDetails_Load(object sender, EventArgs e)
{
LoadReceivingUnits();
if (ID != -1)
{
lcExistingInstitutions.Visibility = LayoutVisibility.Never;
lcIsUsedInFacility.Visibility = LayoutVisibility.Always;
int selected = ID;
Institution recUnit = new Institution();
recUnit.LoadByPrimaryKey(selected);
txtReceivingUnit.Text = recUnit.IsColumnNull("Name") ? "" : recUnit.Name;;
txtReceivingUnit.Enabled = false;
txtDescription.Text = recUnit.IsColumnNull("Description") ? "" : recUnit.Description;
txtPhone.Text = recUnit.IsColumnNull("Phone") ? "" : recUnit.Phone;
if (!recUnit.IsColumnNull("Ownership"))
{
lkOwnership.EditValue = recUnit.Ownership;
}
if (!recUnit.IsColumnNull("RUType"))
{
lkRUType.EditValue = recUnit.RUType;
}
txtLicenseNo.Text = recUnit.IsColumnNull("LicenseNo") ? "" : recUnit.LicenseNo;
txtVATNo.Text = recUnit.IsColumnNull("VATNo") ? "" : recUnit.VATNo;
txtTinNo.Text = recUnit.IsColumnNull("TinNo") ? "" : recUnit.TinNo;
chkIsInstitutionUsedAtFacility.Checked = recUnit.IsColumnNull("IsUsedAtFacility") ? false : recUnit.IsUsedAtFacility;
dtRegistration.Value = recUnit.IsColumnNull("DateOfRegistration") ? DateTimeHelper.ServerDateTime : recUnit.DateOfRegistration;
if (!recUnit.IsColumnNull("Woreda"))
{
BLL.Woreda woreda = new Woreda();
woreda.LoadByPrimaryKey(recUnit.Woreda);
BLL.Zone zone = new Zone();
zone.LoadByPrimaryKey(woreda.ZoneID);
BLL.Region region = new BLL.Region();
region.LoadByPrimaryKey(zone.RegionId);
lkRegion.EditValue = region.ID;
lkZone.Properties.DataSource = BLL.Zone.GetZoneByRegion(region.ID).DefaultView;
lkZone.EditValue = zone.ID;
Woreda.GetWoredaByZone(zone.ID);
lkWoreda.Properties.DataSource = woreda.DefaultView;
lkWoreda.EditValue = recUnit.Woreda;
}
else if (!recUnit.IsColumnNull("Zone")) //We allow the Woreda to be empty so, let's check the zone now.
{
BLL.Zone zone = new Zone();
zone.LoadByPrimaryKey(recUnit.Zone);
BLL.Region region = new BLL.Region();
region.LoadByPrimaryKey(zone.RegionId);
lkRegion.EditValue = region.ID;
lkZone.Properties.DataSource = BLL.Zone.GetZoneByRegion(region.ID).DefaultView;
lkZone.EditValue = zone.ID;
}
else
{
lkRegion.EditValue = null;
lkZone.EditValue = null;
lkWoreda.EditValue = null;
}
Route r = new Route();
r.LoadAll();
lkRoute.Properties.DataSource = r.DefaultView;
lkRoute.EditValue = (recUnit.IsColumnNull("Route")) ? 0 : recUnit.Route;
receivingUnitId = recUnit.ID;
bool isItDraft = !recUnit.IsColumnNull("IsDraft") && recUnit.IsDraft &&
(BLL.Order.GetTotalForAnInstitution(recUnit.ID) == 0);
lkRegion.Enabled = isItDraft;
lkZone.Enabled = isItDraft;
lkWoreda.Enabled = isItDraft;
lkRUType.Enabled = isItDraft;
lkOwnership.Enabled = isItDraft;
txtReceivingUnit.Enabled = isItDraft;
}
else
{
lcExistingInstitutions.Visibility = LayoutVisibility.Always;
lcIsUsedInFacility.Visibility = LayoutVisibility.Never;
}
}
/// <summary>
/// Handles the FocusedRowChanged event of the gridViewReferences control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs" /> instance containing the event data.</param>
private void gridViewReferences_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
if (e != null && e.PrevFocusedRowHandle < -1)
{
return;
}
dtDate.Value = DateTimeHelper.ServerDateTime;
_reprintId = null;
DataRow dr = gridViewReferences.GetFocusedDataRow();
if (dr == null)
{
return;
}
string[] referenceNo = new string[2];
referenceNo[0] = dr["RefNo"].ToString();
if (Convert.ToBoolean(dr["isConvertedDN"]))
{
_isConvertedDn = true;
_stvLogIdChosen = (int?)dr["IsReprintOf"];
}
else if (dr != null && dr["ID"] != DBNull.Value)
{
_isConvertedDn = false;
_stvLogIdChosen = (int?)dr["ID"];
}
UpdateReprintedNumbers(dr);
// Enable and disable STV reprint
// STV SHouldn't be reprinted off a reprint.
if (dr["IsReprintOf"] != DBNull.Value && !Convert.ToBoolean(dr["isConvertedDN"]))
{
btnExport.Enabled = btnReprint.Enabled = false;
var permission = (BLL.Settings.UseNewUserManagement) ? this.HasPermission("Print") : true;
btnPrint.Enabled = permission;
_reprintId = _stvLogIdChosen;
_stvLogIdChosen = Convert.ToInt32(dr["IsReprintOf"]);
}
else if (dr["IsDeliveryNote"] != DBNull.Value && Convert.ToBoolean(dr["IsDeliveryNote"]))
{
btnExport.Enabled = false;
btnReprint.Enabled = (BLL.Settings.UseNewUserManagement) ? this.HasPermission("Re-Print") : true;
btnPrint.Enabled = false;
}
else
{
btnPrint.Enabled = this.HasPermission("Print");
btnReprint.Enabled = this.HasPermission("Re-Print");
btnExport.Enabled = this.HasPermission("Export");
}
if (_stvLogIdChosen != null)
{
Issue log = new Issue();
log.LoadByPrimaryKey(_stvLogIdChosen.Value);
Institution rus = new Institution();
IssueDoc iss = new IssueDoc();
if (!log.IsColumnNull("ReceivingUnitID"))
{
rus.LoadByPrimaryKey(log.ReceivingUnitID);
//FacilityName.Text = rus.Name;
HeaderSection.Text = rus.Name;
var activity = new Activity();
activity.LoadByPrimaryKey(log.StoreID);
lblActivity.Text = activity.Name;
lblSubAccount.Text = activity.SubAccountName;
lblMode.Text = activity.ModeName;
lblAccount.Text = activity.AccountName;
lblRegion.Text = rus.RegionName;
lblWoreda.Text = rus.WoredaName;
lblZone.Text = rus.ZoneName;
lblInstType.Text = rus.InstitutionTypeName;
var ownership = new OwnershipType();
ownership.LoadByPrimaryKey(rus.Ownership);
lblOwnership.Text = ownership.Name;
lblVoidConDate.Text = (dr["approvalDate"]) != DBNull.Value ? Convert.ToDateTime(dr["approvalDate"]).ToShortDateString(): "-";
lblIssueType.Text = (string)dr["OrderType"];
User user = new User();
if (dr["approvedBy"] != DBNull.Value)
{
user.LoadByPrimaryKey(Convert.ToInt32(dr["approvedBy"]));
lblConfirmedBy.Text = user.FullName;
}
else
{
lblConfirmedBy.Text = "-";
}
var doc = new DocumentType();
doc.LoadByPrimaryKey(log.DocumentTypeID);
lblDocType.Text = doc.Name;
lblPrintedDate.Text = log.PrintedDate.ToShortDateString();
var pt = new PaymentType();
if (!rus.IsColumnNull("PaymentTypeID"))
{
pt.LoadByPrimaryKey(rus.PaymentTypeID);
lblPaymentType.Text = pt.Name;
}
else
{
lblPaymentType.Text = "-";
}
// Show user name
user.LoadByPrimaryKey(log.UserID);
lblPrintedBy.Text = (user.FullName == "") ? user.UserName : user.FullName;
// show contact person
PickList pl = new PickList();
pl.LoadByPrimaryKey(log.PickListID);
Order order = new Order();
order.LoadByPrimaryKey(pl.OrderID);
var os = new OrderStatus();
os.LoadByPrimaryKey(order.OrderStatusID);
lblIssueStatus.Text = os.OrderStatus;
if (!order.IsColumnNull("ContactPerson"))
{
lblRecivedBy.Text = order.ContactPerson;
}
else
{
lblRecivedBy.Text = @"-";
}
lblReceivedDate.Text = order.EurDate.ToShortDateString();
}
dtDate.Value = log.PrintedDate;
//PrintedDate.Text = dtDate.Text;
lblPrintedDate.Text = dtDate.Text;
gridTransactions.DataSource = iss.GetIssueBySTV(_stvLogIdChosen.Value);
layoutUnconfirmedSTVs.Visibility = LayoutVisibility.Never;
if (BLL.Settings.ShowMissingSTVsOnIssueLog)
{
DataView view = iss.GetPossibleUnconfirmedIssues(_stvLogIdChosen.Value);
if (view.Count > 0)
{
gridUnconfirmed.DataSource = view;
layoutUnconfirmedSTVs.Visibility = LayoutVisibility.Always;
}
else
{
layoutUnconfirmedSTVs.Visibility = LayoutVisibility.Never;
}
}
}
}
/// <summary>
/// Called when [outstanding picklist selected].
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The <see cref="DevExpress.XtraGrid.Views.Grid.RowClickEventArgs" /> instance containing the event data.</param>
private void OnOutstandingPicklistSelected(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e)
{
var dr = gridOutstandingPickListView.GetFocusedDataRow();
_orderID = Convert.ToInt32(dr["ID"]);
var order = new BLL.Order();
order.LoadByPrimaryKey(_orderID);
// load payment type options
int?requestedBy = null;
var usr = new User();
lblIssueStatus.Text = (string)dr["OrderStatus"];
lblIssueTypes.Text = (string)dr["Description"];
if (!order.IsColumnNull("RequestedBy"))
{
var ins = new Institution();
requestedBy = order.RequestedBy;
lkPaymentType.Properties.DataSource = PaymentType.GetAllowedTypes(order.FromStore, requestedBy);
ins.LoadByPrimaryKey(order.RequestedBy);
try
{
lblWoreda.Text = ins.WoredaName ?? "-";
lblRegion.Text = ins.RegionName ?? "-";
lblZone.Text = ins.ZoneName ?? "-";
lblInstitutionType.Text = ins.InstitutionTypeName ?? "-";
var ownership = new BLL.OwnershipType();
if (!ins.IsColumnNull("Ownership"))
{
ownership.LoadByPrimaryKey(ins.Ownership);
lblOwnership.Text = ownership.Name;
}
}
catch (NullReferenceException ex)
{
//when transfer, institution has no woreda, zone or region, ignore the error
}
}
else
{
lblWoreda.Text = lblRegion.Text = lblZone.Text = lblInstitutionType.Text = lblOwnership.Text = "NA";
}
//usr.LoadByPrimaryKey(NewMainWindow.UserId);
usr = CurrentContext.LoggedInUser;
txtIssuedBy.Text = usr.FullName ?? "-";
PickList pl = new PickList();
_dvOutstandingPickList = pl.GetPickListDetailsForOrder(_orderID, CurrentContext.LoggedInUserName);
gridOutstandingPicklistDetail.DataSource = _dvOutstandingPickList;
if (order.FromStore != Mode.Constants.HEALTH_PROGRAM)
{
colSKUPicked.Visible = false;
}
else
{
colSKUPicked.Visible = true;
}
txtConfirmFromStore.Text = order.GetFromStore();
txtConfirmRequestedBy.Text = order.GetRequestedBy();
int length = order.GetRequestedBy().Length;
string s = "";
HeaderSection.Text = order.GetRequestedBy() + s.PadRight(150 - length) + "Order Number: " + order.RefNo;
txtConfirmOrderNumber.Text = order.RefNo;
//txtConfirmApprovedBy.Text = order.GetApprovedBy() ?? "-";
lblApprovedBy.Text = order.GetApprovedBy() ?? "-";
lkPaymentType.EditValue = order.PaymentTypeID;
// Temporarily copy the STV
txtIssueRefNo.Text = order.RefNo; //"";
lblRefNo.Text = order.RefNo ?? "-";
var paymentType = new BLL.PaymentType();
paymentType.LoadByPrimaryKey(order.PaymentTypeID);
lblPaymentType.Text = paymentType.Name ?? "-";
lblMode.Text = order.GetFromStore() ?? "-";
lblissuedDate.Text = order.Date.ToShortDateString();
lblIssuedBy.Text = order.GetFilledBy();
lblPicklistPrintedDate.Text = pl.PickedDate.ToShortDateString() != "" ? pl.PickedDate.ToShortDateString() : "-";
var us = new User();
pl.LoadByOrderID(_orderID);
if (!pl.IsColumnNull("PickedBy"))
{
us.LoadByPrimaryKey(pl.PickedBy);
lblPicklistConfirmedBy.Text = us.FullName;
}
else
{
lblPicklistConfirmedBy.Text = "-";
}
}
