/// <summary>
/// The save button should be active only when the date is Sene 30 or in the month of Hamle.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void YearEndProcess_Load(object sender, EventArgs e)
{
var ethDate = new EthiopianDate.EthiopianDate();
lkCommodityTypes.Properties.DataSource = BLL.Type.GetAllTypes();
lkCommodityTypes.ItemIndex = 0;
btnSave.Enabled = false;
var unit = new ItemUnit();
var allunits = unit.GetAllUnits();
unitBindingSource.DataSource = allunits.DefaultView;
var unitcolumn = ((GridView)grdYearEnd.MainView).Columns[9];
switch (VisibilitySetting.HandleUnits)
{
case 1:
unitcolumn.Visible = false;
break;
case 2:
unitcolumn.Visible = true;
break;
default:
unitcolumn.Visible = true;
break;
}
var str = new Stores();
str.GetActiveStores();
cboStores.Properties.DataSource = str.DefaultView;
cboStores.ItemIndex = 0;
dtDate.CustomFormat = "MMMM dd, yyyy";
}
private void TransferForm_Load(object sender, EventArgs e)
{
var store = new Stores();
store.GetActiveStores();
lkFromStore.Properties.DataSource = store.DefaultView;
lkCategories.Properties.DataSource = BLL.Type.GetAllTypes();
var units = new ItemUnit();
var allunits = units.GetAllUnits();
unitBindingSource.DataSource = allunits.DefaultView;
lkToStore.Properties.DataSource = store.DefaultView;
var unitcolumn0 = ((GridView)gridItemsChoice.MainView).Columns[7];
var unitcolumn1 = ((GridView)gridItemsChoice.MainView).Columns[2];
var unitcolumn2 = ((GridView)receivingGrid.MainView).Columns[4];
switch (VisibilitySetting.HandleUnits)
{
case 1:
unitcolumn0.Visible = false;
unitcolumn1.Visible = true;
unitcolumn2.Visible = false;
break;
case 2:
unitcolumn0.Visible = true;
unitcolumn1.Visible = false;
unitcolumn2.Visible = true;
break;
default:
unitcolumn0.Visible = true;
unitcolumn1.Visible = false;
unitcolumn2.Visible = true;
break;
}
lkCategories.ItemIndex = 0;
lkFromStore.ItemIndex = 0;
var userID = MainWindow.LoggedinId;
var us = new User();
us.LoadByPrimaryKey(userID);
txtApprovedBy.Text = us.FullName;
// bind the current date as the datetime field
dtRecDate.Value = DateTime.Now;
gridItemsView.ActiveFilterString = String.Format("[ExpiryDate] > #{0}# ", DateTime.Now);
}
/// <summary>
/// Load the loookups
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ManageItems_Load(object sender, EventArgs e)
{
var unitcolumn = ((GridView)gridInventory.MainView).Columns[7];
unitcolumn.Visible = VisibilitySetting.HandleUnits != 1;
var stor = new Stores();
var unit = new ItemUnit();
var allunit = unit.GetAllUnits();
unitbindingSource.DataSource = allunit.DefaultView;
stor.GetActiveStores();
cboStores.DataSource = stor.DefaultView;
}
/// <summary>
/// Load the lookups and the tree
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void LossesAdjustment_Load(object sender, EventArgs e)
{
var UnitColumn = ((GridView)AdjustmentGrid.MainView).Columns[10];
var UnitColumn1 = ((GridView)gridItemsChoice.MainView).Columns[4];
switch (VisibilitySetting.HandleUnits)
{
case 2:
UnitColumn.Visible = true;
UnitColumn1.Visible = false;
break;
case 1:
UnitColumn.Visible = false;
UnitColumn1.Visible = true;
break;
case 3:
UnitColumn.Visible = true;
UnitColumn1.Visible = false;
break;
}
var stor = new Stores();
stor.GetActiveStores();
cboStores.Properties.DataSource = stor.DefaultView;
lkCategories.Properties.DataSource = BLL.Type.GetAllTypes();
var unit = new ItemUnit();
var allunits = unit.GetAllUnits();
unitsbindingSource.DataSource = allunits.DefaultView;
var disRes = new DisposalReasons();
var allreasons = disRes.GetAllReasons();
reasonBindingSource.DataSource = allreasons.DefaultView;
lkCategories.ItemIndex = 0;
cboStores.ItemIndex = 0;
dtAdjustDate.Value = DateTime.Now;
if (ckExpired.Checked)
{
gridItemChoiceView.ActiveFilterString = String.Format("[ExpiryDate] < #{0}# and [TypeID]={1} and [QuantityLeft] > 0", DateTime.Now, (int)lkCategories.EditValue);
}
}
private void ManageItems_Load(object sender, EventArgs e)
{
PopulateCatTree(SelectedType);
lkCommodityTypes.Properties.DataSource = BLL.Type.GetAllTypes();
lkCommodityTypes.ItemIndex = 0;
var itemunit = new ItemUnit();
var allunits = itemunit.GetAllUnits();
unitBindingSource.DataSource = allunits.DefaultView;
var stor = new Stores();
stor.GetActiveStores();
cboStores.Properties.DataSource = stor.DefaultView;
DataTable dtMonths = new DataTable();
dtMonths.Columns.Add("Value");
dtMonths.Columns.Add("Month");
dtDate.Value = DateTime.Now;
dtDate.CustomFormat = "MM/dd/yyyy";
dtCur = ConvertDate.DateConverter(dtDate.Text);
int currentMont = dtCur.Month;
int year = ((currentMont < 11) ? dtCur.Year : dtCur.Year + 1);
// this is just a try
if (currentMont >= 11)
{
currentMont -= 11;
}
var dtyears = Items.AllYears();
cboStores.ItemIndex = 0;
cboYear.Properties.DataSource = dtyears;
cboYear.EditValue = year;
if (cboYear.Properties.Columns.Count > 0)
{
cboYear.Properties.Columns[0].Alignment = DevExpress.Utils.HorzAlignment.Near;
}
IsReady = true;
PopulateGrid();
gridItemChoiceView.Columns["InternalDrugCode"].Visible = Convert.ToBoolean(chkIntDrugCode.EditValue);
}
/// <summary>
/// Populate the lookups and item lists.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ReceiveingForm_Load(object sender, EventArgs e)
{
//gridRecieveView.Columns[4].Visible = VisibilitySetting.HandleUnits;
var UnitColumn = ((GridView)receivingGrid.MainView).Columns[12];
var UnitColumn1 = ((GridView)receivingGrid.MainView).Columns[5];
var UnitColumn2 = ((GridView)gridItemsChoice.MainView).Columns[4];
var qtyperpack = ((GridView)receivingGrid.MainView).Columns[3];
var buqty = ((GridView)receivingGrid.MainView).Columns[4];
switch (VisibilitySetting.HandleUnits)
{
case 3:
UnitColumn.Visible = true;
UnitColumn1.Visible = false;
UnitColumn2.Visible = false;
qtyperpack.Visible = false;
buqty.Visible = false;
break;
case 2:
UnitColumn.Visible = true;
UnitColumn1.Visible = false;
UnitColumn2.Visible = false;
qtyperpack.Visible = false;
buqty.Visible = false;
break;
case 1:
UnitColumn.Visible = false;
UnitColumn1.Visible = true;
qtyperpack.Visible = true;
UnitColumn2.Visible = true;
buqty.Visible = true;
break;
}
var unit = new ItemUnit();
var units = unit.GetAllUnits();
UnitsbindingSource.DataSource = units.DefaultView;
((GridView)receivingGrid.MainView).Columns[13].Visible = false;
PopulateStore();
PopulateSupplier();
UserCommodityType ucs = new UserCommodityType();
DataTable dt = ucs.GetUserCommodityType(MainWindow.LoggedinId);
int[] typeid = new int[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
typeid[i] = Convert.ToInt32(dt.Rows[i]["ID"]);
}
var typeids = string.Join(",", typeid);
// Bind the grid with only active items
Items itm = new Items();
//DataTable dtItem = itm.GetAllItems(1);
// DataTable dtItem = BLL.Items.GetActiveItemsByCommodityType(0);
DataTable dtItem = BLL.Items.GetActiveItemsByCommodityTypeids(typeids);
// lkCategories.Properties.DataSource = BLL.Type.GetAllTypes();
lkCategories.Properties.DataSource = dt;
lkCategories.ItemIndex = 0;
PopulateItemList(dtItem);
selectedType = radioGroup1.EditValue.ToString();
PopulateCatTree(selectedType);
int userID = MainWindow.LoggedinId;
User us = new User();
us.LoadByPrimaryKey(userID);
txtReceivedBy.Text = us.FullName;
// bind the current date as the datetime field
dtRecDate.Value = DateTime.Now;
if (Common.IsInventoryPeriod())
{
btnSave.Enabled = false;
}
else
{
btnSave.Enabled = true;
}
}
/// <summary>
/// Populate the lookups and item lists.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ReceiveingForm_Load(object sender, EventArgs e)
{
//gridRecieveView.Columns[4].Visible = VisibilitySetting.HandleUnits;
var UnitColumn = ((GridView)receivingGrid.MainView).Columns[12];
var UnitColumn1 = ((GridView)receivingGrid.MainView).Columns[5];
var UnitColumn2 = ((GridView)gridItemsChoice.MainView).Columns[4];
var qtyperpack = ((GridView)receivingGrid.MainView).Columns[3];
var buqty = ((GridView)receivingGrid.MainView).Columns[4];
switch (VisibilitySetting.HandleUnits)
{
case 3:
UnitColumn.Visible = true;
UnitColumn1.Visible = false;
UnitColumn2.Visible = false;
qtyperpack.Visible = false;
buqty.Visible = false;
break;
case 2:
UnitColumn.Visible = true;
UnitColumn1.Visible = false;
UnitColumn2.Visible = false;
qtyperpack.Visible = false;
buqty.Visible = false;
break;
case 1:
UnitColumn.Visible = false;
UnitColumn1.Visible = true;
qtyperpack.Visible = true;
UnitColumn2.Visible = true;
buqty.Visible = true;
break;
}
var stor = new Stores();
stor.GetActiveStores();
cboStores.Properties.DataSource = stor.DefaultView;
cboStores.ItemIndex = 0;
Programs prog = new Programs();
DataTable dtProg = prog.GetSubPrograms();
cboProgram.Properties.DataSource = dtProg;
cboProgram.Properties.DisplayMember = "Name";
cboProgram.Properties.ValueMember = "ID";
var unit = new ItemUnit();
var units = unit.GetAllUnits();
UnitsbindingSource.DataSource = units.DefaultView;
Supplier sup = new Supplier();
DataTable dtSup = new DataTable();
sup.GetActiveSuppliers();
dtSup = sup.DefaultView.ToTable();
cboSuppliers.DataSource = dtSup;
cboSupplier.Properties.DataSource = sup.DefaultView;
cboSuppliers.Text = "Select Supplier";
cboSuppliers.ValueMember = "ID";
cboSuppliers.DisplayMember = "CompanyName";
// Bind the grid with only active items
Items itm = new Items();
//DataTable dtItem = itm.GetAllItems(1);
DataTable dtItem = BLL.Items.GetActiveItemsByCommodityType(0);
lkCategories.Properties.DataSource = BLL.Type.GetAllTypes();
lkCategories.ItemIndex = 0;
PopulateItemList(dtItem);
selectedType = radioGroup1.EditValue.ToString();
PopulateCatTree(selectedType);
int userID = MainWindow.LoggedinId;
User us = new User();
us.LoadByPrimaryKey(userID);
txtReceivedBy.Text = us.FullName;
// bind the current date as the datetime field
dtRecDate.Value = DateTime.Now;
}
private void LogTransfer_Load(object sender, EventArgs e)
{
var stor = new Stores();
stor.GetActiveStores();
// lkFromStore.ItemIndex = 0;
storeBindingSource.DataSource = stor.DefaultView;
var itemunit = new ItemUnit();
var units = itemunit.GetAllUnits();
unitBindingSource.DataSource = units.DefaultView;
// bind the supplier lookup for the grid.
var unitcolumn = ((GridView)gridControl1.MainView).Columns[4];
switch (VisibilitySetting.HandleUnits)
{
case 1:
unitcolumn.Visible = false;
break;
case 2:
unitcolumn.Visible = true;
break;
default:
unitcolumn.Visible = true;
break;
}
lkToStore.Properties.DataSource = stor.DefaultView;
lkToStore.ItemIndex = 0;
// bind the current dates
try
{
var dr = (DataRowView)lstTree.GetDataRecordByNode(lstTree.Nodes[0].FirstNode);
if (dr == null)
{
return;
}
var rec = new Transfer();
if (dr["ParentID"] == DBNull.Value)
{
// int yr = ((dtCurrent.Month > 10) ? dtCurrent.Year : dtCurrent.Year - 1);
var dt1 = new DateTime(Convert.ToInt32(dr["ID"]) - 1, 11, 1);
var dt2 = new DateTime(Convert.ToInt32(dr["ID"]), 11, 1);
dtRec = rec.GetTransactionByDateRange(Convert.ToInt32(lkToStore.EditValue), dt1, dt2);
lblTransferedDate.Text = dr["RefNo"].ToString();
}
else
{
dtRec = rec.GetTransactionByRefNo(dr["RefNo"].ToString(), Convert.ToInt32(lkToStore.EditValue), dr["Date"].ToString());
lblTransferedDate.Text = Convert.ToDateTime(dr["Date"]).ToString("MM dd,yyyy");
}
gridControl1.DataSource = dtRec;
}
catch (Exception ex)
{
}
}
/// <summary>
/// Loads the form and loads the lookups and the grid
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ManageItems_Load(object sender, EventArgs e)
{
CALENDAR:
PopulateCatTree(_selectedType);
Stores stor = new Stores();
stor.GetActiveStores();
cboStores.Properties.DataSource = stor.DefaultView;
lkCommodityTypes.Properties.DataSource = BLL.Type.GetAllTypes();
// lkCommodityTypes.ItemIndex = 0;
string[] arr = new string[] { "All", "Stock Out", "Below EOP", "Near EOP", "Normal", "Over Stocked" };
cboStatus.Properties.DataSource = arr;
var itemunit = new ItemUnit();
var allunits = itemunit.GetAllUnits();
unitBindingSource.DataSource = allunits.DefaultView;
var dtMonths = new DataTable();
dtMonths.Columns.Add("Value");
dtMonths.Columns.Add("Month");
dtDate.Value = DateTime.Now;
dtDate.CustomFormat = "MM/dd/yyyy";
_dtCur = ConvertDate.DateConverter(dtDate.Text);
int currentMont = _dtCur.Month;
//int year = ((currentMont < 11) ? _dtCur.Year : _dtCur.Year + 1);
int year = _dtCur.Year;
// this is just a try
//if (currentMont >= 11)
//{
// currentMont -= 11;
//}
var unitcolumn = ((GridView)gridItemsChoice.MainView).Columns[17];
switch (VisibilitySetting.HandleUnits)
{
case 1:
unitcolumn.Visible = false;
break;
case 2:
unitcolumn.Visible = true;
break;
default:
unitcolumn.Visible = true;
break;
}
DataTable dtyears = Items.AllYears();
//if (year == _dtCur.Year + 1)
//{
// object[] objYear = { year };
// dtyears.Rows.Add(objYear);
//}
cboYear.Properties.DataSource = dtyears;
cboYear.EditValue = year;
if (cboYear.Properties.Columns.Count > 0)
{
cboYear.Properties.Columns[0].Alignment = DevExpress.Utils.HorzAlignment.Near;
}
Programs prog = new Programs();
DataTable dtProg = prog.GetSubPrograms();
object[] objProg = { 0, "All Programs", "", 0, "" };
dtProg.Rows.Add(objProg);
cboSubProgram.Properties.DataSource = dtProg;
cboSubProgram.ItemIndex = -1;
cboSubProgram.Text = "Select Program";
ReceivingUnits rec = new ReceivingUnits();
DataTable drRec = rec.GetAllApplicableDU();
cboIssuedTo.Properties.DataSource = drRec;
cboIssuedTo.ItemIndex = -1;
cboIssuedTo.Text = "Select Issue Location";
this._isReady = true;
PopulateGrid();
}
private void ManageItems_Load(object sender, EventArgs e)
{
var usr = new User();
var userID = MainWindow.LoggedinId;
usr.LoadByPrimaryKey(userID);
if (usr.UserType == 1)
{
contextMenuStrip1.Enabled = false;
}
//var stor = new Stores();
//stor.GetActiveStores();
//cboStores.Properties.DataSource = stor.DefaultView;
UserStore ucs = new UserStore();
DataTable dt = ucs.GetUserStore(MainWindow.LoggedinId);
cboStores.Properties.DataSource = dt;
cboStores.ItemIndex = 0;
var sup = new Supplier();
var dtSup = sup.GetSuppliersWithTransaction();
//cboSupplier.Properties.DataSource = dtSup;
//cboSupplier.ItemIndex = -1;
//cboSupplier.Text = "Select Supplier";
var itemunit = new ItemUnit();
var units = itemunit.GetAllUnits();
unitsbindingSource.DataSource = units.DefaultView;
// bind the supplier lookup for the grid.
//lkEditSupplier.DataSource = dtSup;
var unitcolumn = ((GridView)gridReceives.MainView).Columns[14];
switch (VisibilitySetting.HandleUnits)
{
case 1:
unitcolumn.Visible = false;
break;
case 2:
unitcolumn.Visible = true;
break;
default:
unitcolumn.Visible = true;
break;
}
// bind the current dates
grdLogReceive.Columns["InternalDrugCode"].Visible = Convert.ToBoolean(chkIntDrugCode.EditValue);
try
{
var dr = (DataRowView)lstTree.GetDataRecordByNode(lstTree.Nodes[0].FirstNode);
if (dr == null)
{
return;
}
var rec = new ReceiveDoc();
var supplier = new Supplier();
if (dr["ParentID"] == DBNull.Value)
{
// int yr = ((dtCurrent.Month > 10) ? dtCurrent.Year : dtCurrent.Year - 1);
var dt1 = new DateTime(Convert.ToInt32(dr["ID"]) - 1, 11, 1);
var dt2 = new DateTime(Convert.ToInt32(dr["ID"]), 11, 1);
dtRec = rec.GetTransactionByDateRange(Convert.ToInt32(cboStores.EditValue), dt1, dt2);
lblRecDate.Text = dr["RefNo"].ToString();
}
else
{
dtRec = rec.GetTransactionByRefNo(dr["RefNo"].ToString(), Convert.ToInt32(cboStores.EditValue), dr["Date"].ToString());
lblRecDate.Text = Convert.ToDateTime(dr["Date"]).ToString("MM dd,yyyy");
}
gridReceives.DataSource = dtRec;
}
catch (Exception ex)
{
}
}
/// <summary>
/// Prepare all lookups
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ManageItems_Load(object sender, EventArgs e)
{
var stor = new Stores();
stor.GetActiveStores();
cboStores.Properties.DataSource = stor.DefaultView;
cboStores.ItemIndex = 0;
var rec = new DisposalReasons();
var dtDis = rec.GetAvailableReasons();
cboReasons.Properties.DataSource = dtDis.DefaultView;
reasonBindingSource.DataSource = dtDis.DefaultView;
// cboReasons.ItemIndex = 0;
var itemunit = new ItemUnit();
var units = itemunit.GetAllUnits();
unitbindingSource.DataSource = units.DefaultView;
var unitcolumn = ((GridView)gridAdjustments.MainView).Columns[10];
switch (VisibilitySetting.HandleUnits)
{
case 1:
unitcolumn.Visible = false;
break;
case 2:
unitcolumn.Visible = true;
break;
default:
unitcolumn.Visible = true;
break;
}
try
{
//CALENDAR:
var dtDate = new CalendarLib.DateTimePickerEx
{
CustomFormat = "MM/dd/yyyy",
Value = DateTime.Now
};
var dr = (DataRowView)lstTree.GetDataRecordByNode(lstTree.Nodes[0].FirstNode);
if (dr == null)
{
return;
}
var disp = new Disposal();
if (dr["ParentID"] == DBNull.Value)
{
var dt1 = new DateTime(Convert.ToInt32(dr["ID"]) - 1, 11, 1);
var dt2 = new DateTime(Convert.ToInt32(dr["ID"]), 11, 1);
dtRec = disp.GetTransactionByDateRange(Convert.ToInt32(cboStores.EditValue), dt1, dt2);
lblAdjDate.Text = dr["RefNo"].ToString();
}
else
{
dtRec = disp.GetDocumentByRefNo(dr["RefNo"].ToString(), Convert.ToInt32(cboStores.EditValue), dr["Date"].ToString());
lblAdjDate.Text = Convert.ToDateTime(dr["Date"]).ToString("MM dd,yyyy");
}
gridAdjustments.DataSource = dtRec;
}
catch (Exception ex)
{
}
}
/// <summary>
/// Populate the lookups
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ManageItems_Load(object sender, EventArgs e)
{
var usr = new User();
var userID = MainWindow.LoggedinId;
usr.LoadByPrimaryKey(userID);
if (usr.UserType == 1)
{
contextMenuStrip1.Enabled = false;
}
GeneralInfo gn = new GeneralInfo();
gn.LoadAll();
_priceRate = gn.IsColumnNull("PriceRate") ? 0 : Convert.ToDouble(gn.PriceRate);
_usesModel = gn.IsColumnNull("UsesModel") ? false : gn.UsesModel;
_printedby = usr.FullName;
layoutPrintModel.Visibility = _usesModel ? DevExpress.XtraLayout.Utils.LayoutVisibility.Always : DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
var rec = new ReceivingUnits();
DataTable drRec = rec.GetAllApplicableDU();
//cboIssuedTo.Properties.DataSource = drRec;
//cboIssuedTo.ItemIndex = -1;//.SelectedIndex = -1;
//cboIssuedTo.Text = @"Select Issue Location";
var itemunit = new ItemUnit();
var units = itemunit.GetAllUnits();
unitbindingSource.DataSource = units.DefaultView;
// populate the receiving unit's lookup edit
var rus = new ReceivingUnits();
rus.GetActiveDispensaries();
lkEditReceivingUnis.DataSource = rus.DefaultView;
//var stor = new Stores();
//stor.GetActiveStores();
UserStore ucs = new UserStore();
DataTable dt = ucs.GetUserStore(MainWindow.LoggedinId);
//cboStores.Properties.DataSource = stor.DefaultView;
cboStores.Properties.DataSource = dt;
cboStores.ItemIndex = 0;
var unitcolumn = ((GridView)gridIssues.MainView).Columns[12];
switch (VisibilitySetting.HandleUnits)
{
case 1:
unitcolumn.Visible = false;
break;
case 2:
unitcolumn.Visible = true;
break;
default:
unitcolumn.Visible = true;
break;
}
try
{
DataRowView dr = (DataRowView)lstTree.GetDataRecordByNode(lstTree.Nodes[0].FirstNode);
if (dr == null)
{
return;
}
//lstTransactions.Items.Clear();
IssueDoc iss = new IssueDoc();
DataTable dtRec;
if (dr["ParentID"] == DBNull.Value)
{
EthiopianDate.EthiopianDate ethiopianDate = new EthiopianDate.EthiopianDate(Convert.ToInt32(dr["ID"]), 1, 1);
dtRec = iss.GetTransactionByDateRange(Convert.ToInt32(cboStores.EditValue), ethiopianDate.StartOfFiscalYear.ToGregorianDate(), ethiopianDate.EndOfFiscalYear.ToGregorianDate());
string dateString = dr["RefNo"].ToString();
lblIssDate.Text = dateString;
}
else
{
//dtRec = iss.GetTransactionByRefNo(dr["RefNo"].ToString(), Convert.ToInt32(cboStores.EditValue), dr["Date"].ToString());
dtRec = iss.GetTransactionByRefNo(dr["RefNo"].ToString(), Convert.ToDateTime(dr["Date"]));
lblIssDate.Text = Convert.ToDateTime(dr["Date"]).ToString("MM dd,yyyy");
}
gridIssues.DataSource = dtRec;
grdLogIssue.ActiveFilterString = String.Format("Quantity<>0");
}
catch (Exception ex)
{
// do nothing
}
grdLogIssue.Columns["InternalDrugCode"].Visible = Convert.ToBoolean(chkIntDrugCode.EditValue);
}
/// <summary>
/// Populate the lookups
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ManageItems_Load(object sender, EventArgs e)
{
var rec = new ReceivingUnits();
DataTable drRec = rec.GetAllApplicableDU();
cboIssuedTo.Properties.DataSource = drRec;
cboIssuedTo.ItemIndex = -1;//.SelectedIndex = -1;
cboIssuedTo.Text = @"Select Issue Location";
var itemunit = new ItemUnit();
var units = itemunit.GetAllUnits();
unitbindingSource.DataSource = units.DefaultView;
// populate the receiving unit's lookup edit
var rus = new ReceivingUnits();
rus.GetActiveDispensaries();
lkEditReceivingUnis.DataSource = rus.DefaultView;
var stor = new Stores();
stor.GetActiveStores();
cboStores.Properties.DataSource = stor.DefaultView;
cboStores.ItemIndex = 0;
var unitcolumn = ((GridView)gridIssues.MainView).Columns[12];
switch (VisibilitySetting.HandleUnits)
{
case 1:
unitcolumn.Visible = false;
break;
case 2:
unitcolumn.Visible = true;
break;
default:
unitcolumn.Visible = true;
break;
}
try
{
DataRowView dr = (DataRowView)lstTree.GetDataRecordByNode(lstTree.Nodes[0].FirstNode);
if (dr == null)
{
return;
}
//lstTransactions.Items.Clear();
IssueDoc iss = new IssueDoc();
DataTable dtRec;
if (dr["ParentID"] == DBNull.Value)
{
EthiopianDate.EthiopianDate ethiopianDate = new EthiopianDate.EthiopianDate(Convert.ToInt32(dr["ID"]), 1, 1);
dtRec = iss.GetTransactionByDateRange(Convert.ToInt32(cboStores.EditValue), ethiopianDate.StartOfFiscalYear.ToGregorianDate(), ethiopianDate.EndOfFiscalYear.ToGregorianDate());
string dateString = dr["RefNo"].ToString();
lblIssDate.Text = dateString;
}
else
{
//dtRec = iss.GetTransactionByRefNo(dr["RefNo"].ToString(), Convert.ToInt32(cboStores.EditValue), dr["Date"].ToString());
dtRec = iss.GetTransactionByRefNo(dr["RefNo"].ToString(), Convert.ToDateTime(dr["Date"]));
lblIssDate.Text = Convert.ToDateTime(dr["Date"]).ToString("MM dd,yyyy");
}
gridIssues.DataSource = dtRec;
}
catch (Exception ex)
{
// do nothing
}
}
/// <summary>
/// Load the lookups and the tree
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void LossesAdjustment_Load(object sender, EventArgs e)
{
var UnitColumn = ((GridView)AdjustmentGrid.MainView).Columns[10];
var UnitColumn1 = ((GridView)gridItemsChoice.MainView).Columns[4];
switch (VisibilitySetting.HandleUnits)
{
case 2:
UnitColumn.Visible = true;
UnitColumn1.Visible = false;
break;
case 1:
UnitColumn.Visible = false;
UnitColumn1.Visible = true;
break;
case 3:
UnitColumn.Visible = true;
UnitColumn1.Visible = false;
break;
}
var stor = new Stores();
stor.GetActiveStores();
UserStore ust = new UserStore();
DataTable dtt = ust.GetUserStore(MainWindow.LoggedinId);
cboStores.Properties.DataSource = dtt;
// cboStores.Properties.DataSource = stor.DefaultView;
//lkCategories.Properties.DataSource = BLL.Type.GetAllTypes();
UserCommodityType ucs = new UserCommodityType();
DataTable dt = ucs.GetUserCommodityType(MainWindow.LoggedinId);
lkCategories.Properties.DataSource = dt;
var unit = new ItemUnit();
var allunits = unit.GetAllUnits();
unitsbindingSource.DataSource = allunits.DefaultView;
var disRes = new DisposalReasons();
var allreasons = disRes.GetAllReasons();
reasonBindingSource.DataSource = allreasons.DefaultView;
lkReason.Properties.DataSource = allreasons;
lkCategories.ItemIndex = 0;
cboStores.ItemIndex = 0;
dtAdjustDate.Value = DateTime.Now;
if (ckExpired.Checked)
{
gridItemChoiceView.ActiveFilterString = String.Format("[ExpiryDate] < #{0}# and [TypeID]={1} and [QuantityLeft] > 0", DateTime.Now, (int)lkCategories.EditValue);
}
if (Common.IsInventoryPeriod())
{
btnSave.Enabled = false;
}
else
{
btnSave.Enabled = true;
}
((GridView)AdjustmentGrid.MainView).Columns[11].Visible = false;
((GridView)AdjustmentGrid.MainView).Columns[12].Visible = false;
}
private void ManageItems_Load(object sender, EventArgs e)
{
PopulateCatTree(SelectedType);
var stor = new Stores();
stor.GetActiveStores();
cboStores.Properties.DataSource = stor.DefaultView;
cboStores.ItemIndex = 0;
DataTable table = BLL.Type.GetAllTypes();
DataRow row = table.NewRow();
row["ID"] = "0";
row["Name"] = "All";
table.Rows.InsertAt(row, 0);
lkCommodityTypes.Properties.DataSource = table;
lkCommodityTypes.ItemIndex = 0;
var itemunit = new ItemUnit();
var allunits = itemunit.GetAllUnits();
unitBindingSource.DataSource = allunits.DefaultView;
string[] arr = { "All",
"Stock Out",
"Below EOP",
"Near EOP",
"Normal",
"Over Stocked" };
cboStatus.Properties.DataSource = arr;
DataTable dtMonths = new DataTable();
dtMonths.Columns.Add("Value");
dtMonths.Columns.Add("Month");
dtDate.Value = DateTime.Now;
dtDate.CustomFormat = "MM/dd/yyyy";
dtCur = ConvertDate.DateConverter(dtDate.Text);
int currentMont = dtCur.Month;
int year = ((currentMont < 11) ? dtCur.Year : dtCur.Year + 1);
// this is just a try
if (currentMont >= 11)
{
currentMont -= 11;
}
var dtyears = Items.AllYears();
cboYear.Properties.DataSource = dtyears;
cboYear.EditValue = year;
if (cboYear.Properties.Columns.Count > 0)
{
cboYear.Properties.Columns[0].Alignment = DevExpress.Utils.HorzAlignment.Near;
}
var prog = new Programs();
var dtProg = new DataTable();
dtProg = prog.GetSubPrograms();
object[] objProg = { 0, "All Programs", "", 0, "" };
dtProg.Rows.Add(objProg);
cboSubProgram.Properties.DataSource = dtProg;
cboSubProgram.ItemIndex = -1;
cboSubProgram.Text = "Select Program";
var rec = new ReceivingUnits();
var drRec = rec.GetAllApplicableDU();
cboIssuedTo.Properties.DataSource = drRec;
cboIssuedTo.ItemIndex = -1;
cboIssuedTo.Text = "Select Issue Location";
IsReady = true;
var unitcolumn = ((GridView)gridItemsChoice.MainView).Columns[15];
switch (VisibilitySetting.HandleUnits)
{
case 1:
unitcolumn.Visible = false;
break;
case 2:
unitcolumn.Visible = true;
break;
default:
unitcolumn.Visible = true;
break;
}
PopulateGrid();
if (filter == "Stock Out")
{
ckExclude.Visible = true;
}
else if (filter == "Over Stocked")
{
gridItemChoiceView.Columns.RemoveAt(14);//remove DOS column
ckExclude.Hide();
ckExclude.Enabled = false;
}
}
