/// <summary>
/// Open the detailed information for an item when the user double clicks on the grid.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void gridItemsChoice_DoubleClick(object sender, EventArgs e)
{
DataRow dr = gridItemChoiceView.GetFocusedDataRow();
if (dr == null)
{
return;
}
int itemId = Convert.ToInt32(dr["ID"]);
dtDate.Value = DateTime.Now;
dtDate.CustomFormat = "MM/dd/yyyy";
_dtCur = ConvertDate.DateConverter(dtDate.Text);
int month = _dtCur.Month;
//int year = (month < 11) ? Convert.ToInt32(cboYear.EditValue) : Convert.ToInt32(cboYear.EditValue);
int year = Convert.ToInt32(cboYear.EditValue);
EthiopianDate.EthiopianDate ethioDate = new EthiopianDate.EthiopianDate(year, month, 30);
//ItemDetailReport con = new ItemDetailReport(itemId, Convert.ToInt32(cboStores.EditValue), year, 0);
ItemDetailReport con = new ItemDetailReport(itemId, Convert.ToInt32(cboStores.EditValue), year, 0);//ethioDate.FiscalYear
con.ShowDialog();
}
private void gridView1_DoubleClick(object sender, EventArgs e)
{
DataRow dr = gridView1.GetFocusedDataRow();
if (dr == null)
{
return;
}
int tranId = Convert.ToInt32(dr["ID"]);
ReceiveDoc rec = new ReceiveDoc();
rec.LoadByPrimaryKey(tranId);
_dtDate.Value = DateTime.Now;
_dtDate.CustomFormat = "MM/dd/yyyy";
IssueDoc iss = new IssueDoc();
iss.GetIssueByBatchAndId(rec.ItemID, rec.BatchNo, rec.ID);
DateTime dtCurrent = ConvertDate.DateConverter(_dtDate.Text);
if ((rec.Date.Year != dtCurrent.Year && rec.Date.Month < 11) || (iss.RowCount != 0))
{
//XtraMessageBox.Show("Unable to edit, This Transaction has been processed. Try Loss and Adjustment.", "Unable to Edit", MessageBoxButtons.OK, MessageBoxIcon.Stop);
EditReceive edRec = new EditReceive(tranId, true);
MainWindow.ShowForms(edRec);
}
else
{
EditReceive edRec = new EditReceive(tranId, false);
MainWindow.ShowForms(edRec);
}
}
private void lstTree_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
{
var dtDate = new CalendarLib.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 rec = new Transfer();
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 = 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;
}
private void gridItemListView_DoubleClick(object sender, EventArgs e)
{
GridView view = sender as GridView;
if (view == null)
{
return;
}
DataRow dr = view.GetFocusedDataRow();
if (dr == null)
{
return;
}
dtDate.Value = DateTime.Now;
dtDate.CustomFormat = "MM/dd/yyyy";
DateTime dtCur = ConvertDate.DateConverter(dtDate.Text);
int month = dtCur.Month;
int year = (month < 11) ? dtCur.Year : dtCur.Year + 1;
int itemId = Convert.ToInt32(dr["ID"]);
//ItemDetailReport con = new ItemDetailReport(itemId, Convert.ToInt32(cboStores.EditValue), year, 0);
//con.ShowDialog();
}
private void GeneralReport_Load(object sender, EventArgs e)
{
Stores stor = new Stores();
DataTable dtStor = stor.GetActiveStores();
DataRow rowStore = dtStor.NewRow();
rowStore["ID"] = "0";
rowStore["StoreName"] = "All Stores";
dtStor.Rows.InsertAt(rowStore, 0);
cboStores.Properties.DataSource = dtStor;
cboStores.ItemIndex = 0;
dtDate.Value = DateTime.Now;
dtDate.CustomFormat = "MM/dd/yyyy";
dtCurrent = ConvertDate.DateConverter(dtDate.Text);
DataView dv = Items.AllFiscalYears().DefaultView;
dv.Sort = "year desc";
DataTable sortedDT = dv.ToTable();
cboYear.Properties.DataSource = sortedDT;
// cboYear.Properties.DataSource = Items.AllYears();
// cboYear.EditValue = dtCurrent.Year;
cboYear.ItemIndex = 0;
GeneratCostChartForAllStores();
}
private void lstTree_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
{
CalendarLib.DateTimePickerEx dtDate = new CalendarLib.DateTimePickerEx
{
CustomFormat = "MM/dd/yyyy",
Value = DateTime.Now
};
DateTime dtCurrent = ConvertDate.DateConverter(dtDate.Text);
DataRowView dr = (DataRowView)lstTree.GetDataRecordByNode(lstTree.FocusedNode);
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;
}
private void LstTreeFocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
{
DateTime dt1 = new DateTime();
DateTime dt2 = new DateTime();
CalendarLib.DateTimePickerEx dtDate = new CalendarLib.DateTimePickerEx();
dtDate.CustomFormat = "MM/dd/yyyy";
dtDate.Value = DateTimeHelper.ServerDateTime;
DateTime dtCurrent = ConvertDate.DateConverter(dtDate.Text);
DataRowView dr = (DataRowView)lstTree.GetDataRecordByNode(lstTree.FocusedNode);
if (dr != null)
{
LossAndAdjustment disp = new LossAndAdjustment();
DataTable dtRec = new DataTable();
if (dr["ParentID"] == DBNull.Value)
{
int yr = ((dtCurrent.Month > 10) ? dtCurrent.Year : dtCurrent.Year - 1);
dt1 = new DateTime(Convert.ToInt32(dr["ID"]) - 1, 11, 1);
dt2 = new DateTime(Convert.ToInt32(dr["ID"]), 11, 1);
dtRec = disp.GetTransactionByDateRange(Convert.ToInt32(lkActivity.EditValue), dt1, dt2);
string dateString = dr["RefNo"].ToString();
lblAdjDate.Text = dateString;
}
else
{
dtRec = disp.GetDocumentByRefNo(dr["RefNo"].ToString(), Convert.ToInt32(lkActivity.EditValue), dr["Date"].ToString());
lblAdjDate.Text = Convert.ToDateTime(dr["Date"]).ToString("MM dd,yyyy");
}
gridAdjustments.DataSource = dtRec;
}
}
private void GeneralReport_Load(object sender, EventArgs e)
{
Activity stor = new Activity();
stor.LoadAll();
DataTable dtStor = stor.DefaultView.ToTable();
object[] obj = { 0, 1, "All" };
//if(stor.RowCount > 1)
//dtStor.Rows.Add(obj);
cboStores.DataSource = dtStor;
//if (stor.RowCount > 1)
// cboStores.SelectedValue = 0;
dtDate.Value = DateTimeHelper.ServerDateTime;
dtDate.CustomFormat = "MM/dd/yyyy";
dtCurrent = ConvertDate.DateConverter(dtDate.Text);
curMont = dtCurrent.Month;
curYear = dtCurrent.Year;
Item itm = new Item();
DataTable dtyears = itm.AllYears();
foreach (DataRow drYears in dtyears.Rows)
{
int yr = Convert.ToInt32(drYears["year"]);
cboYear.Items.Add(yr);
}
cboYear.SelectedItem = dtCurrent.Year;
}
/// <summary>
/// Gets the balance of all items
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void bw_DoWork(object sender, DoWorkEventArgs e)
{
var bal = new Balance();
int[] arr = (int[])e.Argument;
int storeId = arr[0], month = arr[1]; // year = arr[2], quarter = arr[3];
dtFrom.CustomFormat = "MM/dd/yyyy";
DateTime dt1 = ConvertDate.DateConverter(dtFrom.Text);
dtTo.CustomFormat = "MM/dd/yyyy";
DateTime dt2 = ConvertDate.DateConverter(dtTo.Text);
//string dRange = "From " + dtFrom.Text + " to " + dtTo.Text;
//layoutControlGroup3.Text = "Cost Report " + dRange;
if (dt1 == dt2)
{
dt1 = ((dt1.Month == 11 || dt1.Month == 12)? new DateTime(dt1.Year, 11, 1) : new DateTime(dt1.Year - 1, 11, 1));
//dRange = "For Year " + dt1.Year.ToString();
}
var dtBal = bal.TransactionReport(storeId, dt1, dt2, _selectedType, bw);
selecteddate = dt1;
e.Result = dtBal;
//txtFromDate.Text = dt1.ToShortDateString();
}
private void ManageSaveButton()
{
dtDate.Value = DateTime.Now;
DateTime dtCurent;
dtDate.CustomFormat = "MM/dd/yyyy";
dtCurent = ConvertDate.DateConverter(dtDate.Text);
if ((dtCurent.Month == 10 && dtCurent.Day == 30) || dtCurent.Month == 11)
{
if (grdYearEnd.DataSource != null)
{
DataTable yearEndTable = (DataTable)grdYearEnd.DataSource;
if (yearEndTable.Rows.Count > 0)
{
btnSave.Enabled = true;
}
else
{
btnSave.Enabled = false;
}
}
else
{
btnSave.Enabled = false;
}
}
else
{
btnSave.Enabled = false;
}
}
private void dtTo_ValueChanged(object sender, EventArgs e)
{
if (_isReady)
{
ReceiveDoc rec = new ReceiveDoc();
dtFrom.CustomFormat = "MM/dd/yyyy";
dtTo.CustomFormat = "MM/dd/yyyy";
DateTime dteFrom = new DateTime();
DateTime dteTo = new DateTime();
dteFrom = ConvertDate.DateConverter(dtFrom.Text);
dteTo = ConvertDate.DateConverter(dtTo.Text);
DataTable dtRec = new DataTable();
if (dteFrom < dteTo)
{
dtRec = rec.GetTransactionByDateRange(Convert.ToInt32(cboStores.EditValue), dteFrom, dteTo);
}
else
{
dtRec = rec.GetAllTransaction(Convert.ToInt32(cboStores.EditValue));
}
PopulateTransactions(dtRec);
}
}
private void ManageItems_Load(object sender, EventArgs e)
{
lkCommodityTypes.Properties.DataSource = BLL.Type.GetAllTypes();
lkCommodityTypes.ItemIndex = 0;
PopulateCatTree();
Stores stor = new Stores();
stor.GetActiveStores();
cboStores.DataSource = stor.DefaultView;
dtDate.Value = DateTime.Now;
dtDate.CustomFormat = "MM/dd/yyyy";
dtCurrent = ConvertDate.DateConverter(dtDate.Text);
Programs prog = new Programs();
DataTable dtProg = new DataTable();
dtProg = prog.GetSubPrograms();
object[] objProg = { 0, "All Programs", "", 0, "" };
dtProg.Rows.Add(objProg);
cboSubProgram.DataSource = dtProg;
cboSubProgram.SelectedIndex = -1;
cboSubProgram.Text = "Select Program";
ReceivingUnits rec = new ReceivingUnits();
DataTable drRec = rec.GetAllApplicableDU();
cboIssuedTo.DataSource = drRec;
cboIssuedTo.SelectedIndex = -1;
cboIssuedTo.Text = "Select Issue Location";
int month = dtCurrent.Month;
int year = ((dtCurrent.Month < 11) ? dtCurrent.Year : dtCurrent.Year + 1);
DataTable dtyears = Items.AllYears();
foreach (DataRow drYears in dtyears.Rows)
{
int yr = Convert.ToInt32(drYears["year"]);
cboYear.Items.Add(yr);
}
bool added = true;
for (int x = 0; x < cboYear.Items.Count; x++)//to check if the current year is included or not
{
if (Convert.ToInt64(cboYear.Items[x]) == year)
{
added = false;
break;
}
}
if (added)
{
cboYear.Items.Add(year);
}
cboYear.SelectedItem = year;
}
private void LoadInventoryItems()
{
dtDate.Value = DateTime.Now;
DateTime dtCurent;
dtDate.CustomFormat = "MM/dd/yyyy";
dtCurent = ConvertDate.DateConverter(dtDate.Text);
int year = dtCurent.Year;
var itm = new Items();
DataTable dtItm;
switch (VisibilitySetting.HandleUnits)
{
case 1:
if (ckExclude != null && (ckExclude.Checked))
{
dtItm = itm.ExcludeNeverReceivedItems(Convert.ToInt32(cboStores.EditValue),
Convert.ToInt32(lkCommodityTypes.EditValue));
}
else
{
dtItm = itm.GetAllItems(1, Convert.ToInt32(lkCommodityTypes.EditValue));
}
PopulateItemList(dtItm, year);
dtDate.CustomFormat = "MMMM dd, yyyy";
break;
case 2:
if (ckExclude == null || (!ckExclude.Checked))
{
dtItm = itm.ExcludeNeverReceivedItemsForHandlingUnit(Convert.ToInt32(cboStores.EditValue),
Convert.ToInt32(lkCommodityTypes.EditValue));
}
else
{
dtItm = itm.GetAllItems(1, Convert.ToInt32(lkCommodityTypes.EditValue));
}
PopulateItemList(dtItm, year);
dtDate.CustomFormat = "MMMM dd, yyyy";
break;
case 3:
if (ckExclude == null || (!ckExclude.Checked))
{
dtItm = itm.ExcludeNeverReceivedItemsForHandlingUnit(Convert.ToInt32(cboStores.EditValue), Convert.ToInt32(lkCommodityTypes.EditValue));
}
else
{
dtItm = itm.GetAllItems(1, Convert.ToInt32(lkCommodityTypes.EditValue));
}
PopulateItemList(dtItm, year);
dtDate.CustomFormat = "MMMM dd, yyyy";
break;
}
}
/// <summary>
/// Validates user input and returns "true" when valid and the error message when invalid.
/// </summary>
/// <returns></returns>
private string ValidateFields()
{
//dtRecDate.Value = DateTime.Now;
DateTime dtCurent = new DateTime();
dtRecDate.CustomFormat = "MM/dd/yyyy";
dtCurent = ConvertDate.DateConverter(dtRecDate.Text);
string valid = "true";
if (Convert.ToDateTime(dtRecDate.Value) > DateTime.Now)
{
valid = "You cannot pick a Date in a future!";
return(valid);
}
if (!dxValidationProvider1.Validate())
{
valid = "Please correct the highlighted filed!";
}
Items itm = new Items();
for (int i = 0; i < gridRecieveView.DataRowCount; i++)
{
DataRow dr = gridRecieveView.GetDataRow(i);
dr.ClearErrors();
if (dr["Pack Qty"] == null || dr["Pack Qty"].ToString() == "" || Convert.ToInt64(dr["Pack Qty"]) == 0)
{
dr.SetColumnError("Pack Qty", "This field cannot be left blank.");
valid = "Please fill the requested feild!";
}
itm.LoadByPrimaryKey(Convert.ToInt32(dtRecGrid.Rows[i]["ID"]));
if (!itm.IsColumnNull("NeedExpiryBatch"))
{
if (itm.NeedExpiryBatch)
{
if (dr["Expiry Date"].ToString() == "")
{
dr.SetColumnError("Expiry Date", "This field cannot be left blank.");
valid = "Please fill the requested feild!";
}
if (dr["Batch No"].ToString() == "")
{
dr.SetColumnError("Batch No", "This field cannot be left blank.");
valid = "Please fill the requested feild!";
}
}
}
}
return(valid);
}
public void PopulateItemList(DataTable dtItem)
{
progressBar1.Visible = true;
progressBar1.Minimum = 1;
progressBar1.Value = 1;
progressBar1.Maximum = dtItem.Rows.Count;
lstItem.Items.Clear();
int col = 0;
int count = 1;
int storeId = (cboStores.SelectedValue != null) ? Convert.ToInt32(cboStores.SelectedValue) : 1;
dtDate.Value = DateTime.Now;
dtDate.CustomFormat = "MM/dd/yyyy";
DateTime dtCurrent = new DateTime();
dtCurrent = ConvertDate.DateConverter(dtDate.Text);
IssueDoc issues = new IssueDoc();
foreach (DataRow dr in dtItem.Rows)
{
string itemName = dr["ItemName"].ToString() + " - " + dr["DosageForm"].ToString() + " - " + dr["Strength"].ToString();
Int64[] obj = new Int64[recId.Length];
int itemId = Convert.ToInt32(dr["ID"]);
string[] str = new string[recId.Length + 2];
str[0] = count.ToString();
str[1] = itemName;
for (int j = 0; j < recId.Length; j++)
{
obj[j] = issues.GetIssuedQuantityByReceivingUnit(itemId, storeId, recId[j], dtCurrent.Year);
str[j + 2] = (obj[j] != 0)?obj[j].ToString("#,###"): "0";
}
ListViewItem listItem = new ListViewItem(str);
listItem.ToolTipText = itemName;
listItem.Tag = dr["ID"];
if (col != 0)
{
listItem.BackColor = Color.FromArgb(233, 247, 248);
col = 0;
}
else
{
col++;
}
lstItem.Items.Add(listItem);
count++;
progressBar1.PerformStep();
}
progressBar1.Visible = false;
}
private void GeneralReport_Load(object sender, EventArgs e)
{
Activity stor = new Activity();
stor.LoadAll();
DataTable dtStor = stor.DefaultView.ToTable();
cboStores.DataSource = dtStor;
dtDate.Value = DateTimeHelper.ServerDateTime;
dtDate.CustomFormat = "MM/dd/yyyy";
ConvertDate.DateConverter(dtDate.Text);
}
private void toolStripMenuItem2_Click(object sender, EventArgs e)
{
var us = new User();
var userID = MainWindow.LoggedinId;
us.LoadByPrimaryKey(userID);
var dr = grdLogReceive.GetFocusedDataRow();
if (dr == null)
{
return;
}
int tranId = Convert.ToInt32(dr["ID"]);
var rec = new ReceiveDoc();
rec.LoadByPrimaryKey(tranId);
var iss = new IssueDoc();
iss.GetIssueByBatchAndId(rec.ItemID, rec.BatchNo, rec.ID);
_dtDate.CustomFormat = "MM/dd/yyyy";
DateTime dtCurrent = ConvertDate.DateConverter(_dtDate.Text);
if ((rec.Date.Year != dtCurrent.Year && rec.Date.Month < 11) || (iss.RowCount != 0))
{
XtraMessageBox.Show("Unable to Delete, This Transaction has been processed. Try Loss and Adjustment.",
"Unable to Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
}
else
{
if (
XtraMessageBox.Show(
"Are You Sure, You want to delete this Transaction? You will not be able to restore this data.",
"Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
//AddDeletedRecieveDoc(rec);
rec.MarkAsDeleted();
rec.Save();
_dtDate.Value = DateTime.Now;
_dtDate.CustomFormat = "MM/dd/yyyy";
dtCurrent = ConvertDate.DateConverter(_dtDate.Text);
int yr = ((dtCurrent.Month > 10) ? dtCurrent.Year : dtCurrent.Year - 1);
DateTime dt1 = new DateTime(yr, 11, 1);
DateTime dt2 = new DateTime(dtCurrent.Year, dtCurrent.Month, dtCurrent.Day);
DataTable dtRec = rec.GetTransactionByDateRange(Convert.ToInt32(cboStores.EditValue), dt1, dt2);
gridReceives.DataSource = dtRec;
}
}
}
private void GeneralReport_Load(object sender, EventArgs e)
{
Stores stor = new Stores();
stor.GetActiveStores();
DataTable dtStor = stor.DefaultView.ToTable();
DataRow rowStore = dtStor.NewRow();
rowStore["ID"] = "0";
rowStore["StoreName"] = "All Stores";
dtStor.Rows.InsertAt(rowStore, 0);
cboStores.Properties.DataSource = dtStor;
if (stor.RowCount > 1)
{
cboStores.ItemIndex = 0;
}
var type = new BLL.Type();
DataTable alltypes = type.GetAllCategory();
DataRow row = alltypes.NewRow();
row["ID"] = "0";
row["Name"] = "All Categories";
alltypes.Rows.InsertAt(row, 0);
lkCategory.Properties.DataSource = alltypes;
lkCategory.Properties.DisplayMember = "Name";
lkCategory.Properties.ValueMember = "ID";
lkCategory.ItemIndex = 0;
dtDate.Value = DateTime.Now;
dtDate.CustomFormat = "MM/dd/yyyy";
dtCurrent = ConvertDate.DateConverter(dtDate.Text);
curMont = dtCurrent.Month;
curYear = dtCurrent.Year;
//cboYear.Properties.DataSource = Items.AllYears();
//cboYear.EditValue = dtCurrent.Year;
DataView dv = Items.AllFiscalYears().DefaultView;
dv.Sort = "year desc";
DataTable sortedDT = dv.ToTable();
cboYear.Properties.DataSource = sortedDT;
cboYear.ItemIndex = 0;
if (cboYear.Properties.Columns.Count > 0)
{
cboYear.Properties.Columns[0].Alignment = DevExpress.Utils.HorzAlignment.Near;
}
}
private string ValidateFields()
{
dtRecDate.Value = DateTime.Now;
DateTime dtCurent = new DateTime();
dtRecDate.CustomFormat = "MM/dd/yyyy";
dtCurent = ConvertDate.DateConverter(dtRecDate.Text);
string valid = "true";
if (Convert.ToDateTime(dtRecDate.Value) > DateTime.Now)
{
valid = "You cannot pick a Date in a future!";
return(valid);
}
if (lkFromStore != null && Convert.ToInt32(lkFromStore.EditValue) == Convert.ToInt32(lkToStore.EditValue))
{
valid = "You cannot transfer an item to the same store.";
return(valid);
}
if (!dxValidationProvider1.Validate())
{
valid = "Please correct the highlighted filed!";
}
var itm = new Items();
for (int i = 0; i < gridRecieveView.DataRowCount; i++)
{
DataRow dr = gridRecieveView.GetDataRow(i);
dr.ClearErrors();
if (dr["Qty To Transfer"] == null || dr["Qty To Transfer"].ToString() == "" || Convert.ToInt64(dr["Qty To Transfer"]) == 0)
{
dr.SetColumnError("Qty To Transfer", "This field cannot be left blank.");
valid = "Please fill the requested feild!";
}
if (Convert.ToInt32(dr["Qty To Transfer"]) > Convert.ToInt32(dr["BU Qty"]))
{
dr.SetColumnError("Qty To Transfer", "Qty To Transfer should be less than BU Qty(Remaining).");
valid = "Qty To Transfer should be less than BU Qty(Remaining)";
}
itm.LoadByPrimaryKey(Convert.ToInt32(_dtRecGrid.Rows[i]["ID"]));
}
return(valid);
}
private void cboYear_SelectedValueChanged(object sender, EventArgs e)
{
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 currentYear = dtCur.Year;
if (currentMont >= 11)
{
currentYear++;
currentMont -= 10;
}
else
{
currentMont += 2;
}
int[] val = { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 };
string[] mon = { "Hamle", "Nehase", "Meskerem", "Tikemt", "Hedar", "Tahsas", "Tir", "Yekatit", "Megabit", "Miziya", "Genbot", "Sene" };
int i = 0; //currentMont;
if (Convert.ToInt32(cboYear.EditValue) == currentYear)
{
for (i = 0; i < val.Length; i++)
{
if (val[i] == currentMont)
{
break;
}
}
}
else
{
i = val.Length - 1;
}
for (int j = i; j >= 0; j--)
{
object[] obj = { val[j], mon[j] };
dtMonths.Rows.Add(obj);
}
cboMonth.Properties.DataSource = dtMonths;
cboMonth.ItemIndex = 0;
//cboMonth_SelectedValueChanged(null, null);
PopulateGrid();
}
/// <summary>
/// Load the dropdowns and the category tree
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ManageItems_Load(object sender, EventArgs e)
{
PopulateCatTree(_selectedType);
var type = new BLL.Type();
var alltypes = type.GetAllCategory();
DataRow row = alltypes.NewRow();
row["ID"] = "0";
row["Name"] = "All";
alltypes.Rows.InsertAt(row, 0);
lkCategory.Properties.DataSource = alltypes;
lkCategory.Properties.DisplayMember = "Name";
lkCategory.Properties.ValueMember = "ID";
lkCategory.ItemIndex = 0;
var stor = new Stores();
stor.GetActiveStores();
cboStores.DataSource = stor.DefaultView;
dtDate.Value = DateTime.Now;
dtDate.CustomFormat = "MM/dd/yyyy";
_dtCur = ConvertDate.DateConverter(dtDate.Text);
dtTo.Value = DateTime.Now;
// int yearFrom = ((_dtCur.Month == 11 && _dtCur.Month == 12) ? _dtCur.Year : _dtCur.Year - 1 );
int currYear = (EthiopianDate.EthiopianDate.Now.Month < 11) ? EthiopianDate.EthiopianDate.Now.Year - 1 : EthiopianDate.EthiopianDate.Now.Year;
dtFrom.Value = EthiopianDate.EthiopianDate.EthiopianToGregorian(String.Format("{0}/{1}/{2}", 1, 11, currYear));
dtFrom.CustomFormat = "MM/dd/yyyy";
DateTime dt1 = ConvertDate.DateConverter(dtFrom.Text);
dtTo.CustomFormat = "MM/dd/yyyy";
DateTime dt2 = ConvertDate.DateConverter(dtTo.Text);
//string dRange = "From " + dtFrom.Text + " to " + dtTo.Text;
//layoutControlGroup3.Text = "Cost Report " + dRange;
if (dt1 == dt2)
{
dt1 = ((dt1.Month == 11 || dt1.Month == 12) ? new DateTime(dt1.Year, 11, 1) : new DateTime(dt1.Year - 1, 11, 1));
//dRange = "For Year " + dt1.Year.ToString();
}
this._isReady = true;
txtFromDate.Text = dt1.ToShortDateString();
PopulateItemList();
}
/// <summary>
/// Populates the list of items in the gridItemsList
/// </summary>
private void PopulateItemList()
{
Balance bal = new Balance();
int storeId = (cboStores.SelectedValue != null) ? Convert.ToInt32(cboStores.SelectedValue) : 1;
dtDate.Value = DateTime.Now;
dtDate.CustomFormat = "MM/dd/yyyy";
DateTime dtCurrent = ConvertDate.DateConverter(dtDate.Text);
gridItemsList.DataSource = bal.BalanceAllItems(storeId, dtCurrent.Year, dtCurrent.Month, _selectedType);
if (ckExclude.Checked)
{
gridItemListView.ActiveFilterString = "[Received] != '0'";
}
}
private void lstItem_MouseDoubleClick(object sender, MouseEventArgs e)
{
if (lstItem.SelectedItems[0].Tag != null)
{
dtDate.Value = DateTime.Now;
dtDate.CustomFormat = "MM/dd/yyyy";
DateTime dtCur = ConvertDate.DateConverter(dtDate.Text);
int month = dtCur.Month;
int year = (cboYear.SelectedItem != null) ? Convert.ToInt32(cboYear.SelectedItem) : dtCur.Year;
int itemId = Convert.ToInt32(lstItem.SelectedItems[0].Tag);
ItemDetailReport con = new ItemDetailReport(itemId, Convert.ToInt32(cboStores.SelectedValue), year, 2);
con.ShowDialog();
}
}
private void dtTo_ValueChanged(object sender, EventArgs e)
{
//CALENDAR:
Disposal adj = new Disposal();
DataTable dtRec;
dtFrom.CustomFormat = "MM/dd/yyyy";
dtTo.CustomFormat = "MM/dd/yyyy";
DateTime dteFrom = ConvertDate.DateConverter(dtFrom.Text);
DateTime dteTo = ConvertDate.DateConverter(dtTo.Text);
dtRec = dteFrom < dteTo?adj.GetTransactionByDateRange(Convert.ToInt32(cboStores.EditValue), dteFrom, dteTo) : adj.GetAllTransaction(Convert.ToInt32(cboStores.EditValue));
gridAdjustments.DataSource = dtRec;
}
/// <summary>
/// Loads the lookups and the category tree
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ManageItems_Load(object sender, EventArgs e)
{
PopulateCatTree(_selectedType);
var rec = new DisposalReasons();
var dtDis = rec.GetAvailableReasons();
//object[] objRec = { 0, "All Reasons", "" };
//dtDis.Rows.Add(objRec);
cboReasons.Properties.DataSource = dtDis;
cboReasons.Properties.DisplayMember = "Reason";
cboReasons.Properties.ValueMember = "ID";
// cboReasons.ItemIndex = 0;
//cboStores.ItemIndex = 0;
dtDate.Value = DateTime.Now;
dtDate.CustomFormat = "MM/dd/yyyy";
DateTime dtCur = ConvertDate.DateConverter(dtDate.Text);
int month = dtCur.Month;
int year;
if (month < 11)
{
year = dtCur.Year;
}
else
{
year = dtCur.Year + 1;
}
DataTable dtyears = Items.AllYears();
cmbYear.Properties.DataSource = dtyears;
cmbYear.EditValue = year;
if (cmbYear.Properties.Columns.Count > 0)
{
cmbYear.Properties.Columns[0].Alignment = DevExpress.Utils.HorzAlignment.Near;
}
//cmbYear.EditValue
var stor = new Stores();
stor.GetActiveStores();
cboStores.Properties.DataSource = stor.DefaultView;
cboStores.ItemIndex = 0;
lkCommodityTypes.Properties.DataSource = BLL.Type.GetAllTypes();
lkCommodityTypes.ItemIndex = 0;
}
/// <summary>
/// Opens the detailed item report for the chosen item
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void gridItemListView_DoubleClick(object sender, EventArgs e)
{
var view = sender as GridView;
DataRow dr = view.GetFocusedDataRow();
if (view != null && VisibilitySetting.HandleUnits == 1)
{
if (dr != null)
{
dtDate.Value = DateTime.Now;
dtDate.CustomFormat = "MM/dd/yyyy";
DateTime dtCur = ConvertDate.DateConverter(dtDate.Text);
var month = dtCur.Month;
var year = (month < 11) ? dtCur.Year : dtCur.Year + 1;
var itemId = Convert.ToInt32(dr["ID"]);
var con = new ItemDetailReport(itemId, Convert.ToInt32(cboStores.SelectedValue), year, 0);
con.ShowDialog();
}
}
else if (view != null && VisibilitySetting.HandleUnits == 2)
{
if (dr != null)
{
dtDate.Value = DateTime.Now;
dtDate.CustomFormat = "MM/dd/yyyy";
DateTime dtCur = ConvertDate.DateConverter(dtDate.Text);
var month = dtCur.Month;
var year = (month < 11) ? dtCur.Year : dtCur.Year + 1;
var itemId = Convert.ToInt32(dr["ID"]);
var con = new ItemDetailReport(itemId, Convert.ToInt32(cboStores.SelectedValue), year, 0, Convert.ToInt32(dr["ID"]));
con.ShowDialog();
}
}
else if (view != null && VisibilitySetting.HandleUnits == 3)
{
if (dr != null)
{
dtDate.Value = DateTime.Now;
dtDate.CustomFormat = "MM/dd/yyyy";
DateTime dtCur = ConvertDate.DateConverter(dtDate.Text);
var month = dtCur.Month;
var year = (month < 11) ? dtCur.Year : dtCur.Year + 1;
var itemId = Convert.ToInt32(dr["ID"]);
var con = new ItemDetailReport(itemId, Convert.ToInt32(cboStores.SelectedValue), year, 0, Convert.ToInt32(dr["ID"]));
con.ShowDialog();
}
}
}
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>
/// Open the detailed information for an item when the user double clicks on the grid.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void gridItemsChoice_DoubleClick(object sender, EventArgs e)
{
DataRow dr = gridItemChoiceView.GetFocusedDataRow();
if (dr == null)
{
return;
}
int itemId = Convert.ToInt32(dr["ID"]);
dtDate.Value = DateTime.Now;
dtDate.CustomFormat = "MM/dd/yyyy";
_dtCur = ConvertDate.DateConverter(dtDate.Text);
int month = Convert.ToInt32(cboMonth.EditValue);
//int year = (month < 11) ? Convert.ToInt32(cboYear.EditValue) : Convert.ToInt32(cboYear.EditValue);
int year = Convert.ToInt32(cboYear.EditValue);
var ethioDate = new EthiopianDate.EthiopianDate(year, month, 30);
switch (VisibilitySetting.HandleUnits)
{
case 2:
{
unitID = Convert.ToInt32(dr["UnitID"]);
var con1 = new ItemDetailReport(itemId, Convert.ToInt32(cboStores.EditValue), year, 0, unitID); //ethioDate.FiscalYear
con1.ShowDialog();
}
break;
case 3:
{
unitID = Convert.ToInt32(dr["UnitID"]);
var con1 = new ItemDetailReport(itemId, Convert.ToInt32(cboStores.EditValue), year, 0, unitID); //ethioDate.FiscalYear
con1.ShowDialog();
}
break;
default:
{
//ItemDetailReport con = new ItemDetailReport(itemId, Convert.ToInt32(cboStores.EditValue), year, 0);
ItemDetailReport con = new ItemDetailReport(itemId, Convert.ToInt32(cboStores.EditValue), year, 0);
//ethioDate.FiscalYear
con.ShowDialog();
}
break;
}
}
private void detailToolStripMenuItem_Click(object sender, EventArgs e)
{
GridView view = sender as GridView;
DataRow dr = view.GetFocusedDataRow();
if (dr != null)
{
dtRecDate.Value = DateTime.Now;
dtRecDate.CustomFormat = "MM/dd/yyyy";
DateTime dtCur = ConvertDate.DateConverter(dtRecDate.Text);
int year = ((dtCur.Month < 11) ? dtCur.Year : dtCur.Year + 1);
dtRecDate.CustomFormat = "MMM dd,yyyy";
int itemId = Convert.ToInt32(dr["ID"]);
ItemDetailReport con = new ItemDetailReport(itemId, Convert.ToInt32(cboStores.EditValue), year, 0);
con.ShowDialog();
}
}
private void dtFrom_ValueChanged(object sender, EventArgs e)
{
if (cboStores.SelectedValue != null)//&& cboYear.SelectedValue != null)
{
dtFrom.CustomFormat = "MM/dd/yyyy";
DateTime dt1 = ConvertDate.DateConverter(dtFrom.Text);
PopulateItemList();
if (dt1.Year >= 2010)
{
SetColumnIndex(true);
}
else
{
SetColumnIndex(false);
}
}
}