/// <summary>
/// Handles the selectIndexChangedEvent of the lstStores
/// Updates the store information based on the selected store
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void lstStores_SelectedIndexChanged(object sender, EventArgs e)
{
if (lstStores.SelectedItems.Count > 0)
{
int selected = Convert.ToInt32(lstStores.SelectedItems[0].Tag);
Stores str = new Stores();
str.LoadByPrimaryKey(selected);
txtStore.Text = str.StoreName;
chkStoreIsActive.Checked = str.IsColumnNull("IsActive") ? true : str.IsActive;
_storeId = str.ID;
btnStoresSave.Text = "Update";
}
}
private void btnSave_Click(object sender, EventArgs e)
{
var transfer = new Transfer();
var newreceiveDoc = new ReceiveDoc();
var receiveDoc = new ReceiveDoc();
var issuedoc = new IssueDoc();
var valid = ValidateFields();
if (valid == "true")
{
if (XtraMessageBox.Show("Are you sure you want to save this transaction?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try{
var dtRecGrid = (DataTable)receivingGrid.DataSource;
for (int i = 0; i < dtRecGrid.Rows.Count; i++)
{
transfer.AddNew();
var receiveid = Convert.ToInt32(dtRecGrid.Rows[i]["RecID"]);
transfer.ItemID = _itemID = Convert.ToInt32(dtRecGrid.Rows[i]["ID"]);
transfer.RecID = receiveid;
transfer.BatchNo = dtRecGrid.Rows[i]["Batch No"].ToString();
transfer.FromStoreID = Convert.ToInt32(lkFromStore.EditValue);
transfer.ToStoreID = Convert.ToInt32(lkToStore.EditValue);
transfer.Quantity = Convert.ToInt64(dtRecGrid.Rows[i]["Qty To Transfer"]);
transfer.RefNo = txtRefNo.Text;
transfer.UnitID = VisibilitySetting.HandleUnits == 1 ? 0 : Convert.ToInt32(dtRecGrid.Rows[i]["UnitID"]);
DateTime xx = dtRecDate.Value;
dtRecDate.CustomFormat = "MM/dd/yyyy";
new DateTime();
transfer.Date = ConvertDate.DateConverter(dtRecDate.Text);
ConvertDate.DateConverter(dtRecDate.Text);
dtRecDate.IsGregorianCurrentCalendar = true;
transfer.EurDate = dtRecDate.Value;
dtRecDate.IsGregorianCurrentCalendar = false;
transfer.TransferReason = txtTransferReason.Text;
transfer.ApprovedBy = txtApprovedBy.Text;
transfer.TransferRequestedBy = txtRequestedBy.Text;
transfer.Save();
transfer.GetTransfered(receiveid, _itemID, Convert.ToInt32(lkFromStore.EditValue));
issuedoc.AddNew();
issuedoc.StoreId = transfer.FromStoreID;
issuedoc.ItemID = transfer.ItemID;
issuedoc.Quantity = transfer.Quantity;
issuedoc.Date = transfer.Date;
issuedoc.BatchNo = transfer.BatchNo;
issuedoc.UnitID = transfer.UnitID;
issuedoc.RecievDocID = transfer.RecID;
issuedoc.IsTransfer = true;
issuedoc.RefNo = transfer.RefNo;
var allstores = new Stores();
allstores.LoadByPrimaryKey(transfer.ToStoreID);
issuedoc.ReceivingUnitID = (int) allstores.GetColumn("ReceivingUnitID");
issuedoc.Save();
receiveDoc.GetReceivedItems(receiveid,_itemID, Convert.ToInt32(lkFromStore.EditValue));
receiveDoc.QuantityLeft = receiveDoc.QuantityLeft - transfer.Quantity;
newreceiveDoc.AddNew();
newreceiveDoc.StoreID = transfer.ToStoreID;
newreceiveDoc.RefNo = transfer.RefNo;
newreceiveDoc.BatchNo = transfer.BatchNo;
newreceiveDoc.ItemID = transfer.ItemID;
newreceiveDoc.Quantity = transfer.Quantity;
newreceiveDoc.QuantityLeft = transfer.Quantity;
newreceiveDoc.NoOfPack = Convert.ToInt32(transfer.Quantity) / receiveDoc.QtyPerPack;
newreceiveDoc.QtyPerPack = receiveDoc.QtyPerPack;
newreceiveDoc.Cost = receiveDoc.Cost;
newreceiveDoc.Date = transfer.Date;
newreceiveDoc.UnitID = transfer.UnitID;
newreceiveDoc.Out = false;
newreceiveDoc.ReceivedBy = transfer.ApprovedBy;
newreceiveDoc.ExpDate = receiveDoc.ExpDate;
allstores.LoadByPrimaryKey(transfer.FromStoreID);
newreceiveDoc.SupplierID = (int) allstores.GetColumn("SupplierID");
newreceiveDoc.BoxLevel = 1;
newreceiveDoc.Save();
receiveDoc.Save();
}
XtraMessageBox.Show("Transaction Successfully Saved!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
ResetFields();
}
catch (Exception exp)
{
XtraMessageBox.Show(exp.InnerException.Message ,"Error");
}
}
}
else
{
XtraMessageBox.Show(valid, "Validation", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
}
/// <summary>
/// Saves store information
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnStoresSave_Click(object sender, EventArgs e)
{
if (txtStore.Text != "")
{
Stores str = new Stores();
if (_storeId != 0)
str.LoadByPrimaryKey(_storeId);
else
str.AddNew();
str.StoreName = txtStore.Text;
str.IsActive = chkStoreIsActive.Checked;
str.Save();
str.LoadAll();
PopulateStores(str);
ResetStores();
}
else
{
txtStore.BackColor = Color.FromArgb(251, 214, 214);
}
XtraMessageBox.Show("Store Record Updated.", "Confirmation", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
private void BinCardTransaction_Load(object sender, EventArgs e)
{
DataTable dtyears = Items.AllYears();
dtDate.Value = DateTime.Now;
dtDate.CustomFormat = "MM/dd/yyyy";
_dtCurrent = ConvertDate.DateConverter(dtDate.Text);
//CALENDAR:
foreach (DataRow drYears in dtyears.Rows)
{
if (drYears["year"] != DBNull.Value)
{
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;
var itemunit = new ItemUnit();
var allunits = itemunit.GetAllUnits();
unitBindingSource.DataSource = allunits.DefaultView;
var unitcolumn = ((GridView)gridItemsList.MainView).Columns[11];
switch (VisibilitySetting.HandleUnits)
{
case 1:
unitcolumn.Visible = false;
break;
case 2:
unitcolumn.Visible = true;
break;
default:
unitcolumn.Visible = true;
break;
}
PopulateBinCardYearCombo();
cboFiscalYear.SelectedItem = _year;
BLL.Items itm = new Items();
DataTable dtItm = itm.GetItemById(_itemId);
string itemName = dtItm.Rows[0]["ItemName"].ToString() + " - " + dtItm.Rows[0]["DosageForm"].ToString() + " - " + dtItm.Rows[0]["Strength"].ToString();
txtItemName.Text = itemName;
txtitmName.Text = itemName;
toolTip1.SetToolTip(txtitmName, itemName);
lblBUnit.Text = dtItm.Rows[0]["Unit"].ToString();
this.Text = itemName + " Detail Report";
ReceivingUnits dus = new ReceivingUnits();
DataTable dtDU = dus.GetApplicableDUs(_itemId, _storeId);
Stores stor = new Stores();
stor.LoadByPrimaryKey(_storeId);
object[] objS = { 0, stor.StoreName, "", "" };
dtDU.Rows.Add(objS);
cboDU.DataSource = dtDU;
cboDU.SelectedIndex = (cboDU.Items.Count - 1);
cboDU.Text = "Select DU";
try
{
txtFreeItem.Text = (itm.IsFree) ? "Yes" : "No";
txtRefrigerated.Text = (itm.Refrigeratored) ? "Yes" : "No";
txtPediatric.Text = (itm.Pediatric) ? "Yes" : "No";
}
catch
{
}
int du = ((cboDU.SelectedValue != null) ? Convert.ToInt32(cboDU.SelectedValue) : 0);
GenerateCharts(0);
ItemStockStatus();
//GenerateBinCard();
GenerateBinCardNew();
PopulateTransaction();
tabControl1.SelectedTabPageIndex = _tabInd;
_first = 1;
lblItemID.Text = _itemId.ToString();
PopulateLogisticSummary();
}