private void loadAllItemsToView()
{
try {
addStockTransfer.grid_itemFinder.IsEnabled = false;
addStockTransfer.button_saveTransfer.IsEnabled = false;
addStockTransfer.button_addItem.IsEnabled = false;
addStockTransfer.dataGrid.IsEnabled = false;
StockTransfer stockTransfer = getStockTransferById(addStockTransfer.SelectedStockTransferID);
if (stockTransfer != null)
{
addStockTransfer.comboBox_from_selectStock.SelectedValue = stockTransfer.FromLocationId;
addStockTransfer.comboBox_to_selectStock.SelectedValue = stockTransfer.ToLocationId;
addStockTransfer.datePicker_date_selectStock.SelectedDate = stockTransfer.Date;
addStockTransfer.textBox_carrierName_selectStock.Text = stockTransfer.Carrier;
addStockTransfer.textBox_details_selectStock.Text = stockTransfer.Details;
StockTransferItem sti = new StockTransferItem();
sti.StockTransferId = stockTransfer.Id;
List <StockTransferItem> list = getTransferItem(sti);
foreach (StockTransferItem stockTransferItem in list)
{
Item item = itemManagerImpl.getItemById(stockTransferItem.ItemId);
addStockTransfer.DataTable.Rows.Add(stockTransferItem.Id, item.Name + " (" + companyManagerImpl.getCompanyNameById(item.CompanyId) + ")", stockTransferItem.Quantity);
}
}
} catch (Exception) {
}
}
internal int InsertTransferItems(StockTransferItem item, IDbConnection connection, IDbTransaction txn)
{
try
{
string query = @"INSERT INTO StockTransferItem
(
StockTransferId,
ItemId,
Quantity,
isActive
)
VALUES
(
@StockTransferId,
@ItemId,
@Quantity,
1
);
SELECT CAST(SCOPE_IDENTITY() AS INT)";
return(connection.Query <int>(query, item, txn).First());
}
catch (Exception)
{
throw;
}
}
public List <StockTransferItem> TransferItemsGrid()
{
var TransferItems = new List <StockTransferItem>();
var b = new StockTransferItem();
TransferItems.Add(b);
return(TransferItems);
}
public void SaveStockTransfer(RequisitionDTO entry)
{
StockTransfer st = new StockTransfer();
st.No = entry.No;
st.Date = entry.RequisitionDate;
if (entry.CompanyTo == 0)
{
int vehicleId = vehicleRepo.GetIdByPlateNo(entry.UnitPlateNo);
st.CompanyTo = veAssignRepo.GetIdByVehicleId(vehicleId);
}
else
{
st.CompanyTo = entry.CompanyTo;
}
st.JobOrderNo = entry.JobOrderNo;
st.UnitPlateNo = entry.UnitPlateNo;
st.JobOrderDate = entry.JobOrderDate;
st.OdometerReading = entry.OdometerReading; //Get from session
st.DriverName = entry.DriverName; //Get from session
st.ReportedBy = entry.ReportedBy; //Get from session
st.CheckedBy = entry.CheckedBy; //Get from session
st.ApprovedBy = Common.GetCurrentUser.GeneralManagerId; //Get from session
st.CompanyId = Sessions.CompanyId.Value;
List <StockTransferItem> lstStItem = new List <StockTransferItem>();
foreach (RequisitionDTO.Item item in entry.Items)
{
StockTransferItem stItem = new StockTransferItem
{
StockTransferId = st.Id,
ItemId = item.ItemId,
Quantity = item.Quantity,
SerialNo = item.SerialNo,
Type = item.Type,
QuantityReturn = item.QuantityReturn,
SerialNoReturn = item.SerialNoReturn
};
lstStItem.Add(stItem);
}
st.StockTransferItems = lstStItem;
stRepo.Save(st);
}
public ActionResult RenderEditorRow(int itemId)
{
StockTransferItem stItem = new StockTransferItem
{
Item = itemRepo.GetById(itemId),
ItemId = itemId
};
StockTransferItemVM vm = new StockTransferItemVM
{
StockTransferItem = stItem,
CompanyId = Sessions.CompanyId.Value
};
return(PartialView("_EditorRow", vm));
}
internal bool saveTransfer()
{
bool b = false;
try {
bool isOkay = true;
if (addStockTransfer.textBox_carrierName_selectStock.IsNull())
{
addStockTransfer.textBox_carrierName_selectStock.ErrorMode(true);
isOkay = false;
}
if (addStockTransfer.datePicker_date_selectStock.SelectedDate == null)
{
addStockTransfer.datePicker_date_selectStock.ErrorMode(true);
isOkay = false;
}
if (Convert.ToInt32(addStockTransfer.comboBox_to_selectStock.SelectedValue) <= 0)
{
addStockTransfer.comboBox_to_selectStock.ErrorMode(true);
isOkay = false;
}
if (Convert.ToInt32(addStockTransfer.comboBox_from_selectStock.SelectedValue) <= 0)
{
addStockTransfer.comboBox_from_selectStock.ErrorMode(true);
isOkay = false;
}
if (Convert.ToInt32(addStockTransfer.comboBox_to_selectStock.SelectedValue) == Convert.ToInt32(addStockTransfer.comboBox_from_selectStock.SelectedValue))
{
addStockTransfer.comboBox_from_selectStock.ErrorMode(true);
addStockTransfer.comboBox_to_selectStock.ErrorMode(true);
isOkay = false;
}
if (isOkay)
{
if (addStockTransfer.DataTable.Rows.Count > 0)
{
StockTransfer stockTransfer = new StockTransfer();
stockTransfer.FromLocationId = Convert.ToInt32(addStockTransfer.comboBox_from_selectStock.SelectedValue);
stockTransfer.ToLocationId = Convert.ToInt32(addStockTransfer.comboBox_to_selectStock.SelectedValue);
stockTransfer.Date = Convert.ToDateTime(addStockTransfer.datePicker_date_selectStock.SelectedDate);
stockTransfer.Carrier = addStockTransfer.textBox_carrierName_selectStock.TrimedText;
stockTransfer.Details = addStockTransfer.textBox_details_selectStock.Text;
CommonMethods.setCDMDForAdd(stockTransfer);
int stockTransferId = addTransfer(stockTransfer);
StockTransferItem stockTransferItem = null;
StockItem stockItemFrom = null;
StockItem stockItemTo = null;
foreach (DataRow row in addStockTransfer.DataTable.Rows)
{
stockTransferItem = new StockTransferItem();
stockTransferItem.StockTransferId = stockTransferId;
stockTransferItem.ItemId = Convert.ToInt32(row["ID"]);
stockTransferItem.Quantity = Convert.ToDouble(row["Quantity"]);
CommonMethods.setCDMDForAdd(stockTransferItem);
stockItemFrom = stockManagerImpl.getStockItemByStockLocationIdAndItemId(Convert.ToInt32(addStockTransfer.comboBox_from_selectStock.SelectedValue), Convert.ToInt32(row["ID"]));
stockItemTo = stockManagerImpl.getStockItemByStockLocationIdAndItemId(Convert.ToInt32(addStockTransfer.comboBox_to_selectStock.SelectedValue), Convert.ToInt32(row["ID"]));
stockItemFrom.Quantity -= stockTransferItem.Quantity;
stockItemTo.Quantity += stockTransferItem.Quantity;
addTransferItem(stockTransferItem);
stockManagerImpl.updStockItem(stockItemFrom);
stockManagerImpl.updStockItem(stockItemTo);
}
b = true;
}
else
{
ShowMessage.error(Common.Messages.Error.Error012);
}
}
} catch (Exception) {
}
return(b);
}