private void cboStores_EditValueChanged(object sender, EventArgs e)
{
if (cboStores.EditValue == null)
{
return;
}
var iss = new IssueDoc();
// var dtRec = iss.GetDistinctIssueDocments(Convert.ToInt32(cboStores.EditValue));
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);
var dtRec = iss.GetDistinctIssueDocmentsUsers(Convert.ToInt32(cboStores.EditValue), typeids);
lstTree.DataSource = dtRec;
DateTime dt1 = EthiopianDate.EthiopianDate.Now.StartOfFiscalYear.ToGregorianDate();
DateTime dt2 = DateTime.Now;
dtRec = iss.GetTransactionByDateRange(Convert.ToInt32(cboStores.EditValue), dt1, dt2);
lblIssDate.Text = @"Current Year";
gridIssues.DataSource = dtRec;
}
/// <summary>
/// Save user information
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSave_Click(object sender, EventArgs e)
{
if (txtConfirm.Text == txtPassword.Text)
{
User us = new User();
if (_userId != 0)
{
us.LoadByPrimaryKey(_userId);
}
else
{
us.AddNew();
us.UserName = txtUsername.Text;
us.Password = txtPassword.Text;
}
us.FullName = txtFullName.Text;
us.Address = txtAddress.Text;
us.Mobile = txtMobile.Text;
us.Active = ckActive.Checked;
us.UserType = Convert.ToInt32(cboUserType.SelectedValue);
us.Save();
string selectedCommodity = cbCommodity.EditValue.ToString();
string[] comArr = selectedCommodity.Split(',');
UserCommodityType uc = new UserCommodityType();
uc.DeleteAllTypeForUser(us.ID);
foreach (var t in comArr)
{
uc.AddNew();
uc.TypeID = Convert.ToInt16(t);
uc.UserID = us.ID;
uc.Save();
}
string selectedStore = cbStore.EditValue.ToString();
string[] storeArr = selectedStore.Split(',');
UserStore ustr = new UserStore();
ustr.DeleteAllTStoreForUser(us.ID);
if (selectedStore != "")
{
foreach (var t in storeArr)
{
ustr.AddNew();
ustr.StoreID = Convert.ToInt16(t);
ustr.UserID = us.ID;
ustr.Save();
}
}
XtraMessageBox.Show("successfully Saved", "Success");
PopulateUser();
}
else
{
XtraMessageBox.Show("Password doesnt match!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <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();
UserCommodityType ucs = new UserCommodityType();
DataTable dt = ucs.GetUserCommodityType(MainWindow.LoggedinId);
lkCommodityTypes.Properties.DataSource = dt;
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();
UserStore us = new UserStore();
DataTable dtt = us.GetUserStore(MainWindow.LoggedinId);
//cboStores.Properties.DataSource = str.DefaultView;
cboStores.Properties.DataSource = dtt;
cboStores.ItemIndex = 0;
dtDate.CustomFormat = "MMMM dd, yyyy";
}
private void cboStores_EditValueChanged(object sender, EventArgs e)
{
if (cboStores.EditValue == null)
{
return;
}
var rec = new ReceiveDoc();
// dtRec = rec.GetDistinctRecDocments(Convert.ToInt32(cboStores.EditValue));
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);
dtRec = rec.GetDistinctRecDocmentbyUsers(Convert.ToInt32(cboStores.EditValue), typeids);
PopulateDocuments(dtRec);
}
/// <summary>
/// Update the form based on the selected user
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void lstUsers_SelectedIndexChanged(object sender, EventArgs e)
{
if (lstUsers.SelectedItems.Count > 0)
{
int selected = Convert.ToInt32(lstUsers.SelectedItems[0].Tag);
User us = new User();
us.LoadByPrimaryKey(selected);
txtFullName.Text = us.FullName;
txtAddress.Text = us.Address;
txtMobile.Text = us.Mobile;
ckActive.Checked = us.Active;
cboUserType.SelectedValue = us.UserType.ToString();
_userId = us.ID;
grpLoginInfo.Enabled = false;
BLL.Type ucType = new BLL.Type();
ucType.LoadAll();
UserCommodityType usc = new UserCommodityType();
DataTable comUser = usc.GetUserCommodityType(_userId);
cbCommodity.Properties.DataSource = ucType.DefaultView.ToTable();
cbCommodity.Properties.DisplayMember = "Name";
cbCommodity.Properties.ValueMember = "ID";
string[] arr = new string[comUser.DefaultView.ToTable().Rows.Count];
int index = 0;
foreach (DataRow dr in comUser.DefaultView.ToTable().Rows)
{
arr[index] = Convert.ToString(dr["ID"]);
index++;
}
char separator = cbCommodity.Properties.SeparatorChar;
string result = string.Empty;
foreach (var element in arr)
{
result += element + separator;
}
cbCommodity.SetEditValue(result);
UserStore ust = new UserStore();
DataTable storeUser = ust.GetUserStore(_userId);
Stores stuser = new Stores();
stuser.LoadAll();
cbStore.Properties.DataSource = stuser.DefaultView;
cbStore.Properties.DisplayMember = "StoreName";
cbStore.Properties.ValueMember = "ID";
string[] arrst = new string[storeUser.DefaultView.ToTable().Rows.Count];
int rowindex = 0;
foreach (DataRow drs in storeUser.DefaultView.ToTable().Rows)
{
arrst[rowindex] = Convert.ToString(drs["ID"]);
rowindex++;
}
char separatorst = cbStore.Properties.SeparatorChar;
string resultst = string.Empty;
foreach (var element in arrst)
{
resultst += element + separatorst;
}
cbStore.SetEditValue(resultst);
}
}
/// <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;
}
}
private void TransferForm_Load(object sender, EventArgs e)
{
var store = new Stores();
// store.GetActiveStores();
//lkFromStore.Properties.DataSource = store.DefaultView;
UserStore ust = new UserStore();
DataTable dtt = ust.GetUserStore(MainWindow.LoggedinId);
lkFromStore.Properties.DataSource = dtt;
UserCommodityType ucs = new UserCommodityType();
DataTable dt = ucs.GetUserCommodityType(MainWindow.LoggedinId);
lkCategories.Properties.DataSource = dt;
// lkCategories.Properties.DataSource = BLL.Type.GetAllTypes();
var units = new ItemUnit();
var allunits = units.GetAllUnits();
unitBindingSource.DataSource = allunits.DefaultView;
lkToStore.Properties.DataSource = dtt;
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;
}
if (Common.IsInventoryPeriod())
{
btnSave.Enabled = false;
}
else
{
btnSave.Enabled = true;
}
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);
if (Common.IsInventoryPeriod())
{
btnSave.Enabled = false;
}
else
{
btnSave.Enabled = true;
}
}
/// <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;
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;
}
}
