/// <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)
{
}
}
private void lstTree_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
{
var dtDate = new DateTimePickerEx
{
CustomFormat = "MM/dd/yyyy",
Value = DateTime.Now
};
DateTime dtCurrent = ConvertDate.DateConverter(dtDate.Text);
var dr = (DataRowView)lstTree.GetDataRecordByNode(lstTree.FocusedNode);
if (dr == null) return;
var adj = new Disposal();
DataTable dtRec;
if (dr["ParentID"] == DBNull.Value)
{
int yr = ((dtCurrent.Month > 10) ? dtCurrent.Year : dtCurrent.Year - 1);
DateTime dt1 = new DateTime(Convert.ToInt32(dr["ID"]) - 1, 11, 1);
DateTime dt2 = new DateTime(Convert.ToInt32(dr["ID"]), 11, 1);
dtRec = adj.GetTransactionByDateRange(Convert.ToInt32(cboStores.EditValue), dt1, dt2);
lblAdjDate.Text = dr["RefNo"].ToString();
}
else
{
dtRec = adj.GetDocumentByRefNo(dr["RefNo"].ToString(), Convert.ToInt32(cboStores.EditValue), dr["Date"].ToString());
lblAdjDate.Text = Convert.ToDateTime(dr["Date"]).ToString("MM dd,yyyy");
}
gridAdjustments.DataSource = dtRec;
}
