private void EditIssue_Load(object sender, EventArgs e)
{
Stores str = new Stores();
str.LoadAll();
cboStores.DataSource = str.DefaultView;
ReceivingUnits rUnit = new ReceivingUnits();
rUnit.GetActiveDispensaries();
cboReceivingUnit.DataSource = rUnit.DefaultView;
if (_tranId != 0)
{
IssueDoc iss = new IssueDoc();
Items itm = new Items();
iss.LoadByPrimaryKey(_tranId);
DataTable dtItm = itm.GetItemById(iss.ItemID);
string itemName = dtItm.Rows[0]["ItemName"].ToString() + " - " + dtItm.Rows[0]["DosageForm"].ToString() + " - " + dtItm.Rows[0]["Strength"].ToString();
txtRefNo.Text = iss.RefNo;
txtBatchNo.Text = iss.BatchNo;
try
{
txtPack.Text = iss.NoOfPack.ToString();
txtQtyPack.Text = iss.QtyPerPack.ToString();
txtPrice.Text = (iss.Cost * iss.QtyPerPack).ToString();
}
catch
{
txtPack.Text = "0";
txtQtyPack.Text = "0";
txtPrice.Text = (iss.Cost * 1).ToString();
}
txtQuantity.Text = iss.Quantity.ToString();
DateTime dtDate = Convert.ToDateTime(iss.Date.ToString("MM/dd/yyyy"));
txtDate.Text = dtDate.ToShortDateString();
//dtIssDate.Value = DateTime.Now;
//dtIssDate.CustomFormat = "MM/dd/yyyy";
//DateTime dtCurrent = Convert.ToDateTime(dtIssDate.Text);
//long tic = (DateTime.Now.Ticks - dtCurrent.Ticks);
//DateTime dtIssG = dtDate.AddTicks(tic);
//dtIssDate.Value = dtIssG;
cboStores.SelectedValue = iss.StoreId;
cboReceivingUnit.SelectedValue = iss.ReceivingUnitID;
txtItemName.Text = itemName;
txtReceivedBy.Text = iss.IssuedBy;
txtRemark.Text = iss.Remark;
}
}
/// <summary>
/// Populates the fields based on the supplied itemID or categoryID
/// </summary>
private void PopulateFields()
{
if (_itemId == 0)
return;
Items itm = new Items();
DataTable dtItem = itm.GetItemById(_itemId);
txtItemName.Text = dtItem.Rows[0]["ItemName"].ToString() + " - " + dtItem.Rows[0]["DosageForm"].ToString() + " - " + dtItem.Rows[0]["Strength"].ToString();
ckExculed.Checked =itm.IsInHospitalList;
chkNeedExpiryBatch.Checked = itm.NeedExpiryBatch;
txtText.Text = itm.StockCodeDACA ?? string.Empty;
txtQuantityPerPack.Text = itm.Cost ?? string.Empty;
try
{
if (dtItem.Rows[0]["ABC"].ToString() == "A")
rdA.Checked = true;
else if (dtItem.Rows[0]["ABC"].ToString() == "B")
rdB.Checked = true;
else if (dtItem.Rows[0]["ABC"].ToString() == "C")
rdC.Checked = true;
}
catch { }
try
{
if (dtItem.Rows[0]["VEN"].ToString() == "V")
rdV.Checked = true;
else if (dtItem.Rows[0]["VEN"].ToString() == "E")
rdE.Checked = true;
else if (dtItem.Rows[0]["VEN"].ToString() == "N")
rdN.Checked = true;
}
catch { }
//ItemShelf itmShelf = new ItemShelf();
//DataTable dtSlf = itmShelf.GetLocationByItem(itm.ID);
//lstBinLocation.DataSource = dtSlf;
var unit = new ItemUnit();
var itemunits= unit.LoadFromSQl(_itemId);
itemunitbindingSource.DataSource = itemunits;
if (VisibilitySetting.HandleUnits == 2)
{
listBox1.Visible = true;
}
else if(VisibilitySetting.HandleUnits == 3)
{
listBox1.Visible = true;
}
else if(VisibilitySetting.HandleUnits == 1)
{
listBox1.Hide();
}
Supplier sup = new Supplier();
sup.GetActiveSuppliers();
ItemSupplier itmSup = new ItemSupplier();
itm.GetItemsBySupplier(_itemId);
foreach (DataRowView dv in sup.DefaultView)
{
bool check = false;
check = itmSup.CheckIfExist(_itemId, Convert.ToInt32(dv["ID"]));
object obj = dv["CompanyName"];
lstSuppliers.Items.Add(obj, check);
}
Programs prog = new Programs();
prog.GetSubPrograms();
ProgramProduct progItem = new ProgramProduct();
lstPrograms.Items.Clear();
foreach (DataRowView dv in prog.DefaultView)
{
bool check = false;
check = progItem.CheckIfExists(_itemId, Convert.ToInt32(dv["ID"]));
lstPrograms.Items.Add(dv["Name"], check);
}
ReceivingUnits dus = new ReceivingUnits();
dus.GetActiveDispensaries();
lstDUs.Items.Clear();
DUsItemList duItem = new DUsItemList();
foreach (DataRowView drDus in dus.DefaultView)
{
bool check = false;
check = duItem.CheckIfExsits(_itemId, Convert.ToInt32(drDus["ID"]));
lstDUs.Items.Add(drDus["Name"], check);
}
}
private void ManageItems_Load(object sender, EventArgs e)
{
lkCommodityTypes.Properties.DataSource = BLL.Type.GetAllTypes();
lkCommodityTypes.ItemIndex = 0;
PopulateCatTree();
ReceivingUnits recUnits = new ReceivingUnits();
recUnits.GetActiveDispensaries();
recId = new int[recUnits.RowCount];
int i = 0;
if (lstItem.Columns.Count <= 2)
{
foreach (DataRowView dv in recUnits.DefaultView)
{
lstItem.Columns.Add(dv["Name"].ToString());
recId[i] = Convert.ToInt32(dv["ID"]);
i++;
}
}
Stores stor = new Stores();
stor.GetActiveStores();
cboStores.DataSource = stor.DefaultView;
}
/// <summary>
/// Populates the grid based on the selection.
/// </summary>
private void PopulateGridList()
{
if (issueGrid.DataSource != null)
{
var dt = new DataTable();
issueGrid.DataSource = dt;
_dtRecGrid.Rows.Clear();
_dtRecGrid.Columns.Clear();
}
var itm = new Items();
var itmB = new Items();
var bal = new Balance();
_tabPage = 1;
tabControl1.SelectedTabPageIndex = 1;
if (_dtRecGrid.Columns.Count == 0)
{
string[] str = { "ID", "Stock Code", "Item Name", "Unit", "Store SOH", "Dispatchable", "MR Issue Qty",
"DU Remaining SOH", "DU AMC", "Recommended Qty", "Pack Qty", "Qty Per Pack",
"Requested Qty", "MR DU SOH","UnitID"};
foreach (string col in str)
{
_dtRecGrid.Columns.Add(col);
}
}
int count = 1;
Int64 quantity = 0;
dtIssueDate.Value = DateTime.Now;
dtIssueDate.CustomFormat = "MM/dd/yyyy";
var dtCurrent = ConvertDate.DateConverter(dtIssueDate.Text);
if (_dtSelectedTable != null)
foreach (DataRow lst in _dtSelectedTable.Rows)//(ListViewItem lst in lstItem.Items)
{
var itmID = Convert.ToInt32(lst["ID"]);
var dtExp = itm.GetExpiredItemsByID(Convert.ToInt32(cboStores.EditValue), itmID);
var dtItm = itm.GetItemById(itmID);
Int64 expAmount = 0;
foreach (DataRow dr in dtExp.Rows)
{
expAmount = itmB.GetExpiredQtyItemsByID(Convert.ToInt32(dr["ID"]), Convert.ToInt32(cboStores.EditValue));
quantity = Convert.ToInt64(dr["Quantity"]) - expAmount;//+ adjQuant - issuedQuant - lostQuant
}
Int64 soh = 0;
Int64 dispatchable = Convert.ToInt64(lst["Dispatchable"]);
object[] obj;
string itemName = lst["FullItemName"].ToString();
switch (VisibilitySetting.HandleUnits)
{
case 1:
soh = bal.GetSOH(itmID, Convert.ToInt32(cboStores.EditValue), dtCurrent.Month, dtCurrent.Year);
obj = new object[] {itmID.ToString(), dtItm.Rows[0]["StockCode"].ToString(), itemName, dtItm.Rows[0]["Unit"].ToString(),
soh, dispatchable, 0, 0, 0, 0, 0, 0, 0, 0, 0};
break;
case 2:
soh = bal.GetSOHByUnit(itmID, Convert.ToInt32(cboStores.EditValue), dtCurrent.Month, dtCurrent.Year, Convert.ToInt32(lst["UnitID"]));
obj = new object[]{ itmID.ToString(), dtItm.Rows[0]["StockCode"].ToString(),
itemName, dtItm.Rows[0]["Unit"].ToString(),
soh, dispatchable, 0, 0, 0, 0, 0, 0, 0, 0, Convert.ToInt32(lst["UnitID"])};
break;
default:
soh = bal.GetSOHByUnit(itmID, Convert.ToInt32(cboStores.EditValue), dtCurrent.Month, dtCurrent.Year, Convert.ToInt32(lst["UnitID"]));
obj = new object[]{ itmID.ToString(), dtItm.Rows[0]["StockCode"].ToString(),
itemName, dtItm.Rows[0]["Unit"].ToString(),
soh, dispatchable, 0, 0, 0, 0, 0, 0, 0, 0, Convert.ToInt32(lst["UnitID"])};
break;
}
//if (expAmount < soh && quantity < soh || dispatchable > 0)
//{
// _dtRecGrid.Rows.Add(obj);
// count++;
//}
if (expAmount < soh && dispatchable > 0)
{
_dtRecGrid.Rows.Add(obj);
count++;
}
else if(soh >0 && dispatchable==0)
{
XtraMessageBox.Show(String.Format("{0} Is Expired!", itemName), "Warning", MessageBoxButtons.OK, MessageBoxIcon.Stop);
ResetValues();
tabControl1.TabIndex = 0;
break;
}
else if (soh == 0)
{
XtraMessageBox.Show(String.Format("{0} is stocked out!", itemName), "Warning", MessageBoxButtons.OK, MessageBoxIcon.Stop);
break;
}
else if (expAmount == soh && expAmount != 0)
{
XtraMessageBox.Show(String.Format("{0} Is Expired!",itemName), "Warning", MessageBoxButtons.OK, MessageBoxIcon.Stop);
ResetValues();
tabControl1.TabIndex = 0;
break;
}
else if( dispatchable>0 )
{
_dtRecGrid.Rows.Add(obj);
count++;
}
else
{
ResetValues();
XtraMessageBox.Show("You are trying to issue an Expired item!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Stop);
tabControl1.TabIndex = 0;
break;
}
}
issueGrid.DataSource = _dtRecGrid;
cboStoreConf.EditValue = cboStores.EditValue;
dtIssueDate.CustomFormat = "MMM dd,yyyy";
var recUnit = new ReceivingUnits();
recUnit.GetActiveDispensaries();
cboReceivingUnits.Properties.DataSource = recUnit.DefaultView;
cboReceivingUnits.Properties.DisplayMember = "Name";
cboReceivingUnits.Properties.ValueMember = "ID";
}
/// <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
}
}