/// <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 = "-";
}
private void lkForFacility_EditValueChanged(object sender, EventArgs e)
{
if (lkForFacility.EditValue == null)
return;
FacilityChanged(lkForFacility);
Institution ru = new Institution();
ru.LoadByPrimaryKey(Convert.ToInt32(lkForFacility.EditValue));
if (!ru.IsColumnNull("Woreda"))
{
BLL.Woreda woreda = new BLL.Woreda();
woreda.LoadByPrimaryKey(ru.Woreda);
BLL.Zone zone = new BLL.Zone();
zone.LoadByPrimaryKey(woreda.ZoneID);
lkRegion.EditValue = zone.RegionId;
lkZone.EditValue = zone.ID;
lkWoreda.EditValue = ru.Woreda;
}
lkOwnership.EditValue = ru.Ownership;
lkType.EditValue = ru.RUType;
//Fill facility visit history
DataRow facilityHis = BLL.Issue.GetVisitHistoryForFacility((int)lkForFacility.EditValue);
NoOfVisitLabel.Text = facilityHis != null ? Convert.ToInt32(facilityHis["VisitCount"]).ToString(CultureInfo.InvariantCulture) : "0";
LastVisitlabel.Text = facilityHis != null ? Convert.ToDateTime(facilityHis["LastVisit"]).TimeAgo() : "Never";
//Reset Requisitoin Type
if(!BLL.Settings.IsCenter && OrderID == null && Type == RequisitionType.History) lkRequisitionType_EditValueChanged(null, null);
}
private void FacilityChanged(GridLookUpEdit lkRecUnit)
{
if (lkRecUnit.EditValue != null)
{
int facilityID = Convert.ToInt32(lkRecUnit.EditValue);
Institution institution = new Institution();
institution.LoadByPrimaryKey(facilityID);
string facilityPaymentType = "";
if (!institution.IsColumnNull("PaymentTypeID"))
facilityPaymentType = PaymentType.GetPaymentTypeString(institution.PaymentTypeID);
txtVatRegistration.Text = (!institution.IsColumnNull("VATNo")) ? institution.VATNo : "";
labelControl2.Text = (!institution.IsColumnNull("VATNo")) ? institution.VATNo : "";
txtTin.Text = (!institution.IsColumnNull("TinNo")) ? institution.TinNo : "";
labelControl1.Text = (!institution.IsColumnNull("TinNo")) ? institution.TinNo : "";
txtRegistrationNo.Text = (!institution.IsColumnNull("LicenseNo")) ? institution.LicenseNo : "";
labelControl3.Text = (!institution.IsColumnNull("LicenseNo")) ? institution.LicenseNo : "";
}
}
public void EditRequisition(int orderID)
{
OrderID = orderID;
Order ord = new Order();
ord.LoadByPrimaryKey(orderID);
txtRefNo.Text = ord.RefNo;
txtLetterNumber.Text = ord.LetterNo;
labelControl4.Text = ord.RefNo;
Institution ru = new Institution();
ru.LoadByPrimaryKey(ord.RequestedBy);
if (!ru.IsColumnNull("Zone"))
{
// Just because the region Property on the Receiving Unit is not working as desired.
Zone zone = new Zone();
zone.LoadByPrimaryKey(ru.Zone);
lkRegion.EditValue = zone.RegionId;
lkZone.EditValue = ru.Zone;
}
lkForFacility.EditValue = ru.ID;
lkModes.EditValue = ord.FromStore;
lkModes_EditValueChanged(null, null);
lkPaymentType.EditValue = ord.PaymentTypeID;
txtContactPerson.EditValue = ord.ContactPerson;
BLL.OrderDetail or = new BLL.OrderDetail();
or.LoadAllByOrderID(orderID);
DataView selectables = (DataView)gridItemChoiceView.DataSource;
if (_dtSelectedTable != null)
{
_dtSelectedTable.Clear();
}
else
{
PopulateItemsList();
}
while (!or.EOF)
{
// select the items and put it in the dtselected table.
if (selectables != null)
{
DataRow[] dataRows = selectables.Table.Select(String.Format("ID = {0} and UnitID = {1}", or.ItemID, or.UnitID));
if (dataRows.Length > 0)
{
_dtSelectedTable.ImportRow(dataRows[0]);
dataRows[0]["IsSelected"] = true;
}
}
or.MoveNext();
}
_dvOrderTable = or.DefaultView;
orderGrid.DataSource = _dvOrderTable;
EnableDisableButtons();
}
/// <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;
}
}
}
}
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;
}
}