public IList <INVTransactionEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression)
{
IList <INVTransactionEntity> iNVTransactionEntityList = new List <INVTransactionEntity>();
try
{
if (pageSize == -1)
{
pageSize = 1000000000;
}
if (String.IsNullOrEmpty(sortExpression))
{
sortExpression = INVTransactionEntity.FLD_NAME_TransactionID + " " + SQLConstants.SORT_ORDER_DESCENDING;
}
startRowIndex = Convert.ToInt32(startRowIndex / pageSize) + 1;
iNVTransactionEntityList = FCCINVTransaction.GetFacadeCreate().GetIL(startRowIndex, pageSize, sortExpression, null, DatabaseOperationType.LoadPagedWithSortExpression);
if (iNVTransactionEntityList != null && iNVTransactionEntityList.Count > 0)
{
totalRowCount = iNVTransactionEntityList[0].TotalRowCount;
}
}
catch (Exception ex)
{
}
return(iNVTransactionEntityList ?? new List <INVTransactionEntity>());
}
protected void lvINVTransaction_ItemCommand(object sender, ListViewCommandEventArgs e)
{
Int64 TransactionID;
Int64.TryParse(e.CommandArgument.ToString(), out TransactionID);
if (TransactionID > 0)
{
if (string.Equals(e.CommandName, "EditItem"))
{
_TransactionID = TransactionID;
PrepareEditView();
}
else if (string.Equals(e.CommandName, "DeleteItem"))
{
try
{
Int64 result = -1;
String fe = SqlExpressionBuilder.PrepareFilterExpression(INVTransactionEntity.FLD_NAME_TransactionID, TransactionID.ToString(), SQLMatchType.Equal);
INVTransactionEntity iNVTransactionEntity = new INVTransactionEntity();
result = FCCINVTransaction.GetFacadeCreate().Delete(iNVTransactionEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No);
if (result == 0)
{
_TransactionID = 0;
_INVTransactionEntity = new INVTransactionEntity();
PrepareInitialView();
BindINVTransactionList();
MiscUtil.ShowMessage(lblMessage, "I NVTransaction has been successfully deleted.", true);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to delete I NVTransaction.", true);
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
}
public IList <INVTransactionEntity> GetData()
{
IList <INVTransactionEntity> iNVTransactionEntityList = new List <INVTransactionEntity>();
try
{
iNVTransactionEntityList = FCCINVTransaction.GetFacadeCreate().GetIL(null, null, null, null, DatabaseOperationType.Load);
if (iNVTransactionEntityList != null && iNVTransactionEntityList.Count > 0)
{
totalRowCount = iNVTransactionEntityList[0].TotalRowCount;
}
}
catch (Exception ex)
{
}
return(iNVTransactionEntityList ?? new List <INVTransactionEntity>());
}
public static Boolean RemoveItemsFromStoreUnit(Int64 itemID, Int64 brandID, Int64 regionID, Int64 countryID, String batchNumber, Int64 transactionQty, String iPAddress, Int64 employeeID, Decimal unitPrice, String requisitionNumber, String wordOrderNumber, String mRRNumber, String billNumber, Int64?projectID, Int64 storeID, Int64 storeUnitID, Boolean isTransfer)
{
Boolean result = false;
try
{
#region Tran
INVTransactionEntity ent = new INVTransactionEntity();
ent.ItemID = itemID;
ent.BrandID = brandID;
ent.RegionID = regionID;
ent.CountryID = countryID;
ent.BatchNumber = batchNumber;
ent.TransactionQty = transactionQty;
ent.TransactionDate = DateTime.Now;
ent.TransactionDirection = false;
ent.IPAddress = iPAddress;
ent.EmployeeID = employeeID;
ent.UnitPrice = unitPrice;
ent.RequisitionNumber = requisitionNumber;
ent.WordOrderNumber = wordOrderNumber;
ent.MRRNumber = mRRNumber;
ent.BillNumber = billNumber;
ent.IsTransfer = isTransfer;
ent.ProjectID = projectID;
ent.StoreID = storeID;
ent.StoreUnitID = storeUnitID;
FCCINVTransaction.GetFacadeCreate().Add(ent, DatabaseOperationType.Add, TransactionRequired.No);
#endregion
#region Unit Item
String fe11 = SqlExpressionBuilder.PrepareFilterExpression(INVStoreUnitItemEntity.FLD_NAME_ItemID, itemID.ToString(), SQLMatchType.Equal);
String fe12 = SqlExpressionBuilder.PrepareFilterExpression(INVStoreUnitItemEntity.FLD_NAME_StoreUnitID, storeUnitID.ToString(), SQLMatchType.Equal);
String fe1 = SqlExpressionBuilder.PrepareFilterExpression(fe11, SQLJoinType.AND, fe12);
IList <INVStoreUnitItemEntity> lst1 = FCCINVStoreUnitItem.GetFacadeCreate().GetIL(null, null, String.Empty, fe1, DatabaseOperationType.LoadWithFilterExpression);
if (lst1 != null && lst1.Count > 0)
{
INVStoreUnitItemEntity ent1 = lst1[0];
//Rayan vaiya recommand to do this
//if (ent1.UnitCurrentStock - transactionQty > 0) ent1.UnitCurrentStock -= transactionQty;
//else
//{
// return false;
//}
//This code skipped by rayan vaiya over phone - 22-Jul-13
ent1.UnitCurrentStock -= transactionQty;
String fe_up1 = SqlExpressionBuilder.PrepareFilterExpression(INVStoreUnitItemEntity.FLD_NAME_StoreUnitItemID, ent1.StoreUnitItemID.ToString(), SQLMatchType.Equal);
FCCINVStoreUnitItem.GetFacadeCreate().Update(ent1, fe_up1, DatabaseOperationType.Update, TransactionRequired.No);
}
else
{
INVStoreUnitItemEntity ent1 = new INVStoreUnitItemEntity();
ent1.StoreUnitID = storeUnitID;
ent1.ItemID = itemID;
ent1.BrandID = brandID;
ent1.RegionID = regionID;
ent1.CountryID = countryID;
ent1.UnitCurrentStock = 0;
ent1.UnitCurrentStock -= transactionQty;
FCCINVStoreUnitItem.GetFacadeCreate().Add(ent1, DatabaseOperationType.Add, TransactionRequired.No);
}
#endregion
#region Total Item
String fe2 = SqlExpressionBuilder.PrepareFilterExpression(INVCurrentStockEntity.FLD_NAME_ItemID, itemID.ToString(), SQLMatchType.Equal);
IList <INVCurrentStockEntity> lst2 = FCCINVCurrentStock.GetFacadeCreate().GetIL(null, null, String.Empty, fe2, DatabaseOperationType.LoadWithFilterExpression);
if (lst2 != null && lst2.Count > 0)
{
INVCurrentStockEntity ent2 = lst2[0];
ent2.UnitCurrentStock -= transactionQty;
String fe_up2 = SqlExpressionBuilder.PrepareFilterExpression(INVCurrentStockEntity.FLD_NAME_CurrentStockID, ent2.CurrentStockID.ToString(), SQLMatchType.Equal);
FCCINVCurrentStock.GetFacadeCreate().Update(ent2, fe_up2, DatabaseOperationType.Update, TransactionRequired.No);
}
else
{
INVCurrentStockEntity ent2 = new INVCurrentStockEntity();
ent2.ItemID = itemID;
ent2.BrandID = brandID;
ent2.RegionID = regionID;
ent2.CountryID = countryID;
ent2.UnitCurrentStock = 0;
ent2.UnitCurrentStock -= transactionQty;
FCCINVCurrentStock.GetFacadeCreate().Add(ent2, DatabaseOperationType.Add, TransactionRequired.No);
}
#endregion
result = true;
}
catch (Exception ex)
{
}
return(result);
}
private void BuildINVStoreIssueNoteItemMapEntity(Int64 sinID, Int64 projectID)
{
try
{
String fe_itemMap = SqlExpressionBuilder.PrepareFilterExpression(PRMMaterialReceiveItemMapEntity.FLD_NAME_MaterialReceiveID, ddlMaterialReceiveID.SelectedValue.ToString(), SQLMatchType.Equal);
IList <PRMMaterialReceiveItemMapEntity> lst = FCCPRMMaterialReceiveItemMap.GetFacadeCreate().GetIL(null, null, String.Empty, fe_itemMap, DatabaseOperationType.LoadWithFilterExpression);
if (lst != null && lst.Count > 0)
{
foreach (PRMMaterialReceiveItemMapEntity ent in lst)
{
INVStoreIssueNoteItemMapEntity iNVStoreIssueNoteItemMapEntity = new INVStoreIssueNoteItemMapEntity();
REQRequisitionItemEntity rEQRequisitionItemEntity = FCCREQRequisitionItem.GetFacadeCreate().GetByID(ent.RequisitionItemID);
if (rEQRequisitionItemEntity != null && rEQRequisitionItemEntity.ItemID > 0)
{
iNVStoreIssueNoteItemMapEntity.StoreIssueNoteID = sinID;
iNVStoreIssueNoteItemMapEntity.ItemID = rEQRequisitionItemEntity.ItemID;
iNVStoreIssueNoteItemMapEntity.FolioNo = String.Empty;
iNVStoreIssueNoteItemMapEntity.RequestQty = ent.ReceiveQty;
iNVStoreIssueNoteItemMapEntity.IssueQty = ent.ReceiveQty;
}
String fe_transaction1 = SqlExpressionBuilder.PrepareFilterExpression(INVTransactionEntity.FLD_NAME_ItemID, rEQRequisitionItemEntity.ItemID.ToString(), SQLMatchType.Equal);
String fe_transaction2 = SqlExpressionBuilder.PrepareFilterExpression(INVTransactionEntity.FLD_NAME_MRRNumber, ddlMaterialReceiveID.Text.ToString(), SQLMatchType.Equal);
String fe_transaction = SqlExpressionBuilder.PrepareFilterExpression(fe_transaction1, SQLJoinType.AND, fe_transaction2);
IList <INVTransactionEntity> lstINVTransactionEntity = FCCINVTransaction.GetFacadeCreate().GetIL(null, null, String.Empty, fe_transaction, DatabaseOperationType.LoadWithFilterExpression);
if (lstINVTransactionEntity != null && lstINVTransactionEntity.Count > 0)
{
iNVStoreIssueNoteItemMapEntity.BatchNo = lstINVTransactionEntity[0].BatchNumber;
}
// iNVStoreIssueNoteItemMapEntity.BatchNo = txtBatchNo.Text.Trim();
String fe_store1 = SqlExpressionBuilder.PrepareFilterExpression(INVStoreEntity.FLD_NAME_ProjectID, projectID.ToString(), SQLMatchType.Equal);
String fe_store2 = SqlExpressionBuilder.PrepareFilterExpression(INVStoreEntity.FLD_NAME_IsDefault, "1", SQLMatchType.Equal);
String fe_store = SqlExpressionBuilder.PrepareFilterExpression(fe_store1, SQLJoinType.AND, fe_store2);
IList <INVStoreEntity> lstINVStoreEntity = FCCINVStore.GetFacadeCreate().GetIL(null, null, String.Empty, fe_store, DatabaseOperationType.LoadWithFilterExpression);
if (lstINVStoreEntity != null && lstINVStoreEntity.Count > 0)
{
iNVStoreIssueNoteItemMapEntity.IssuedFromStoreID = lstINVStoreEntity[0].StoreID;
String fe_storeUnit1 = SqlExpressionBuilder.PrepareFilterExpression(INVStoreUnitEntity.FLD_NAME_StoreID, lstINVStoreEntity[0].StoreID.ToString(), SQLMatchType.Equal);
String fe_storeUnit2 = SqlExpressionBuilder.PrepareFilterExpression(INVStoreUnitEntity.FLD_NAME_IsDefault, "1", SQLMatchType.Equal);
String fe_storeUnit = SqlExpressionBuilder.PrepareFilterExpression(fe_storeUnit1, SQLJoinType.AND, fe_storeUnit2);
IList <INVStoreUnitEntity> lstINVStoreUnitEntity = FCCINVStoreUnit.GetFacadeCreate().GetIL(null, null, String.Empty, fe_storeUnit, DatabaseOperationType.LoadWithFilterExpression);
if (lstINVStoreUnitEntity != null && lstINVStoreUnitEntity.Count > 0)
{
iNVStoreIssueNoteItemMapEntity.IssuedFromStoreUnitID = lstINVStoreUnitEntity[0].StoreUnitID;
}
}
iNVStoreIssueNoteItemMapEntity.ReceivedDate = System.DateTime.Now;
iNVStoreIssueNoteItemMapEntity.ReceivedByEmployeeID = 168;
iNVStoreIssueNoteItemMapEntity.ReturnQty = null;
iNVStoreIssueNoteItemMapEntity.ReturnDate = null;
iNVStoreIssueNoteItemMapEntity.ReturnToStoreID = null;
iNVStoreIssueNoteItemMapEntity.ReturnToStoreUnitID = null;
iNVStoreIssueNoteItemMapEntity.ReturnedByEmployeeID = null;
iNVStoreIssueNoteItemMapEntity.ActualUse = null;
iNVStoreIssueNoteItemMapEntity.Amount = ent.WOItemTotalRate / ent.ReceiveQty;
iNVStoreIssueNoteItemMapEntity.PurposeOfWorks = "Adjustment Entry";
INVStoreEntity storeEntity = INVManager.GetDefaultStore(projectID);
INVStoreUnitEntity storeUnitEntity = INVManager.GetDefaultStoreUnit(storeEntity.StoreID);
iNVStoreIssueNoteItemMapEntity.IssuedFromStoreID = storeEntity.StoreID;
iNVStoreIssueNoteItemMapEntity.IssuedFromStoreID = storeUnitEntity.StoreUnitID;
FCCINVStoreIssueNoteItemMap.GetFacadeCreate().Add(iNVStoreIssueNoteItemMapEntity, DatabaseOperationType.Add, TransactionRequired.No);
#region Inventory
String batchNumber = String.Empty;
Decimal transactionQty = 0;
Boolean invResult = false;
invResult = INVManager.RemoveItemsFromStoreUnit(rEQRequisitionItemEntity.ItemID, rEQRequisitionItemEntity.BrandID, rEQRequisitionItemEntity.RegionID, rEQRequisitionItemEntity.CountryID, lstINVTransactionEntity[0].BatchNumber, Int64.Parse(transactionQty.ToString()), MiscUtil.GetLocalIP(), MiscUtil.GetCurrentEmployeeByMemberID(CurrentMember), 0, String.Empty, String.Empty, String.Empty, "", projectID, storeEntity.StoreID, storeUnitEntity.StoreUnitID);
#endregion
}
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, "Some Error Occured " + ex.Message, true);
}
}
