public IList <MDItemThumbRuleEntity> GetPagedData(Int32 startRowIndex, Int32 pageSize, String sortExpression)
{
IList <MDItemThumbRuleEntity> mDItemThumbRuleEntityList = new List <MDItemThumbRuleEntity>();
try
{
if (pageSize == -1)
{
pageSize = 1000000000;
}
if (String.IsNullOrEmpty(sortExpression))
{
sortExpression = MDItemThumbRuleEntity.FLD_NAME_MDItemThumbRuleID + " " + SQLConstants.SORT_ORDER_DESCENDING;
}
startRowIndex = Convert.ToInt32(startRowIndex / pageSize) + 1;
mDItemThumbRuleEntityList = FCCMDItemThumbRule.GetFacadeCreate().GetIL(startRowIndex, pageSize, sortExpression, null, DatabaseOperationType.LoadPagedWithSortExpression);
if (mDItemThumbRuleEntityList != null && mDItemThumbRuleEntityList.Count > 0)
{
totalRowCount = mDItemThumbRuleEntityList[0].TotalRowCount;
}
}
catch (Exception ex)
{
}
return(mDItemThumbRuleEntityList ?? new List <MDItemThumbRuleEntity>());
}
private void SaveMDItemThumbRuleEntity()
{
if (IsValid)
{
try
{
MDItemThumbRuleEntity mDItemThumbRuleEntity = BuildMDItemThumbRuleEntity();
Int64 result = -1;
if (mDItemThumbRuleEntity.IsNew)
{
result = FCCMDItemThumbRule.GetFacadeCreate().Add(mDItemThumbRuleEntity, DatabaseOperationType.Add, TransactionRequired.No);
}
else
{
String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(MDItemThumbRuleEntity.FLD_NAME_MDItemThumbRuleID, mDItemThumbRuleEntity.MDItemThumbRuleID.ToString(), SQLMatchType.Equal);
result = FCCMDItemThumbRule.GetFacadeCreate().Update(mDItemThumbRuleEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No);
}
if (result > 0)
{
_MDItemThumbRuleID = 0;
_MDItemThumbRuleEntity = new MDItemThumbRuleEntity();
PrepareInitialView();
BindMDItemThumbRuleList();
if (mDItemThumbRuleEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Item Thumb Rule Information has been added successfully.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Item Thumb Rule Information has been updated successfully.", false);
}
}
else
{
if (mDItemThumbRuleEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Failed to add Item Thumb Rule Information.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to update Item Thumb Rule Information.", false);
}
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
protected void lvMDItemThumbRule_ItemCommand(object sender, ListViewCommandEventArgs e)
{
Int64 MDItemThumbRuleID;
Int64.TryParse(e.CommandArgument.ToString(), out MDItemThumbRuleID);
if (MDItemThumbRuleID > 0)
{
if (string.Equals(e.CommandName, "EditItem"))
{
_MDItemThumbRuleID = MDItemThumbRuleID;
PrepareEditView();
cpeEditor.Collapsed = false;
cpeEditor.ClientState = "false";
}
else if (string.Equals(e.CommandName, "DeleteItem"))
{
try
{
Int64 result = -1;
String fe = SqlExpressionBuilder.PrepareFilterExpression(MDItemThumbRuleEntity.FLD_NAME_MDItemThumbRuleID, MDItemThumbRuleID.ToString(), SQLMatchType.Equal);
MDItemThumbRuleEntity mDItemThumbRuleEntity = new MDItemThumbRuleEntity();
result = FCCMDItemThumbRule.GetFacadeCreate().Delete(mDItemThumbRuleEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No);
if (result == 0)
{
_MDItemThumbRuleID = 0;
_MDItemThumbRuleEntity = new MDItemThumbRuleEntity();
PrepareInitialView();
BindMDItemThumbRuleList();
MiscUtil.ShowMessage(lblMessage, "Item Thumb Rule has been successfully deleted.", true);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to delete Item Thumb Rule.", true);
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
}
public IList <MDItemThumbRuleEntity> GetData()
{
IList <MDItemThumbRuleEntity> mDItemThumbRuleEntityList = new List <MDItemThumbRuleEntity>();
try
{
mDItemThumbRuleEntityList = FCCMDItemThumbRule.GetFacadeCreate().GetIL(null, null, null, null, DatabaseOperationType.Load);
if (mDItemThumbRuleEntityList != null && mDItemThumbRuleEntityList.Count > 0)
{
totalRowCount = mDItemThumbRuleEntityList[0].TotalRowCount;
}
}
catch (Exception ex)
{
}
return(mDItemThumbRuleEntityList ?? new List <MDItemThumbRuleEntity>());
}
private void DeleteItem()
{
Int64 ItemID;
Int64.TryParse(treeItem.SelectedValue, out ItemID);
if (ItemID > 0)
{
try
{
Int64 result = -1;
String fe = SqlExpressionBuilder.PrepareFilterExpression(MDItemEntity.FLD_NAME_ItemID, ItemID.ToString(), SQLMatchType.Equal);
MDItemEntity mDItemEntity = new MDItemEntity();
#region Item Brand Map
String fe1 = SqlExpressionBuilder.PrepareFilterExpression(PRMItemBrandMapEntity.FLD_NAME_ItemID, ItemID.ToString(), SQLMatchType.Equal);
PRMItemBrandMapEntity prmItemBrandMap = new PRMItemBrandMapEntity();
FCCPRMItemBrandMap.GetFacadeCreate().Delete(prmItemBrandMap, fe, DatabaseOperationType.Delete, TransactionRequired.No);
#endregion
#region Item Default
String fe2 = SqlExpressionBuilder.PrepareFilterExpression(MDItemDefaultEntity.FLD_NAME_ItemID, ItemID.ToString(), SQLMatchType.Equal);
MDItemDefaultEntity mDItemDefaultEntity = new MDItemDefaultEntity();
FCCMDItemDefault.GetFacadeCreate().Delete(mDItemDefaultEntity, fe2, DatabaseOperationType.Delete, TransactionRequired.No);
#endregion
#region Item Thumb Rule
String fe3 = SqlExpressionBuilder.PrepareFilterExpression(MDItemThumbRuleEntity.FLD_NAME_ItemID, ItemID.ToString(), SQLMatchType.Equal);
MDItemThumbRuleEntity mDItemThumbRuleEntity = new MDItemThumbRuleEntity();
result = FCCMDItemThumbRule.GetFacadeCreate().Delete(mDItemThumbRuleEntity, fe3, DatabaseOperationType.Delete, TransactionRequired.No);
#endregion
result = FCCMDItem.GetFacadeCreate().Delete(mDItemEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No);
if (result == 0)
{
_ItemID = 0;
_MDItemEntity = new MDItemEntity();
// clearing cache
FCCMDItem.GetFacadeCreate().RemoveCache();
PrepareInitialView();
LoadTreeView();
MiscUtil.ShowMessage(lblMessage, "Item has been successfully deleted.", true);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to delete Item.", true);
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
private void SavePreBOQDetailInfo()
{
try
{
#region Getting the checked items from tree
IList <PRMPreBOQDetailEntity> checkedItemsFromTree = new List <PRMPreBOQDetailEntity>();
foreach (TreeNode tn in treeItem.CheckedNodes)
{
PRMPreBOQDetailEntity ent = new PRMPreBOQDetailEntity();
ent.ItemID = Int64.Parse(tn.Value.ToString());
checkedItemsFromTree.Add(ent);
}
#endregion
Int64 preBOQID = 0;
if (isNewEntry == true)
{
preBOQID = FCCPRMPreBOQ.GetFacadeCreate().Add(BuildPRMPreBOQEntity(), DatabaseOperationType.Add, TransactionRequired.No);
}
else
{
preBOQID = currentPreBOQ.PreBOQID;
String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMPreBOQDetailEntity.FLD_NAME_PreBOQID, preBOQID.ToString(), SQLMatchType.Equal);
// FCCPRMPreBOQDetail.GetFacadeCreate().Delete(new PRMPreBOQDetailEntity(), fe, DatabaseOperationType.Delete, TransactionRequired.No);
}
#region Adding OLD
//IList<PRMPreBOQDetailEntity> addListOfNotPopulatedItems = currentlyCheckedItems.Except(populatedItems, new CustomerComparer()).ToList();
//StringBuilder xmlStr = new StringBuilder();
//String subXmlStr = String.Empty;
//xmlStr.Append("<m>");
//foreach (PRMPreBOQDetailEntity ent in addListOfNotPopulatedItems)
//{
// subXmlStr = subXmlStr + "<i><a>" + preBOQID + "</a><b>" + ent.ItemID + "</b></i>";
//}
//foreach (PRMPreBOQDetailEntity ent in checkedItemsFromTree)
//{
// subXmlStr = subXmlStr + "<i><a>" + preBOQID + "</a><b>" + ent.ItemID + "</b></i>";
//}
//xmlStr.Append(subXmlStr.ToString());
//xmlStr.Append("</m>");
//FCCBulkInsertXML.GetFacadeCreate().GetIL(xmlStr.ToString(), CommonConstants.PreBOQDetailTableInfo);
#endregion OLD
#region Adding New
IList <PRMPreBOQDetailEntity> addListOfNotPopulatedItems = currentlyCheckedItems.Except(populatedItems, new CustomerComparer()).ToList();
IList <PRMPreBOQDetailEntity> completeAddList = new List <PRMPreBOQDetailEntity>();
completeAddList = addListOfNotPopulatedItems;
foreach (PRMPreBOQDetailEntity ent in checkedItemsFromTree)
{
completeAddList.Add(ent);
}
IList <PRMPreBOQDetailEntity> finalAddList = completeAddList.Except(mappedItemsFromDB, new CustomerComparer()).ToList();
IList <PRMPreBOQDetailEntity> finalDeleteList = mappedItemsFromDB.Except(completeAddList, new CustomerComparer()).ToList();
if (finalAddList != null && finalAddList.Count > 0)
{
StringBuilder xmlStr = new StringBuilder();
String subXmlStr = String.Empty;
xmlStr.Append("<m>");
foreach (PRMPreBOQDetailEntity ent in finalAddList)
{
#region SET Item Rate and Qty OLD
#region Get and Assign Item Price
////Collect Item Actual Price with Default Brand, Vendor, Region, Country ID.
//Decimal ActualPrice=0;
//Int64 BrandID=MasterDataConstants.ItemDefaults.DEFAULT_BRAD;
//Int64 SupplierID=MasterDataConstants.ItemDefaults.DEFAULT_SUPPLIER;
//Int64 RegionID=MasterDataConstants.ItemDefaults.DEFAULT_REGION;
//Int64 CountryID= MasterDataConstants.ItemDefaults.DEFAULT_COUNTRY;
//String fe = SqlExpressionBuilder.PrepareFilterExpression(MDItemDefaultEntity.FLD_NAME_ItemID, ent.ItemID.ToString(), SQLMatchType.Equal);
//IList<MDItemDefaultEntity> itemDefaultList = FCCMDItemDefault.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression);
//if (itemDefaultList != null && itemDefaultList.Count > 0)
//{
// Int64.TryParse(itemDefaultList[0].BrandID.ToString(),out BrandID);
// Int64.TryParse(itemDefaultList[0].SupplierID.ToString(), out SupplierID);
// Int64.TryParse(itemDefaultList[0].RegionID.ToString(), out RegionID);
// Int64.TryParse(itemDefaultList[0].CountryID.ToString(), out CountryID);
//}
//var supplierItemMap = (from s in supplierItemMapList
// where s.ItemID == ent.ItemID
// && s.BrandID == BrandID
// && s.SupplierID == SupplierID
// && s.OriginRegionID == RegionID
// && s.OriginCountryID == CountryID
// select s).ToList();
//if (supplierItemMap != null && supplierItemMap.Count > 0)
//{
// Decimal.TryParse(supplierItemMap[0].Price.ToString(), out ActualPrice);
//}
#endregion
#region Thumb Rules
////Collect Total Qty From Thumb Rules
//Decimal totalQty = 0;
//String feThumbRule = SqlExpressionBuilder.PrepareFilterExpression(MDItemThumbRuleEntity.FLD_NAME_ItemID, ent.ItemID.ToString(), SQLMatchType.Equal);
//IList<MDItemThumbRuleEntity> itemThumbRuleList = FCCMDItemThumbRule.GetFacadeCreate().GetIL(null, null, String.Empty, feThumbRule, DatabaseOperationType.LoadWithFilterExpression);
//if (itemThumbRuleList != null && itemThumbRuleList.Count > 0)
//{
// totalQty += itemThumbRuleList[0].FloorQuantity * itemThumbRuleList[0].FloorRuleVariable * this.OverviewProject.LandAreaSft.Value * this.OverviewProject.NoOfStoried.Value;
// totalQty += itemThumbRuleList[0].BasementQuantity * itemThumbRuleList[0].BasementRuleVariable * this.OverviewProject.LandAreaSft.Value * this.OverviewProject.NoOfBasement.Value;
// totalQty += itemThumbRuleList[0].OverallQuantity * itemThumbRuleList[0].OverallRuleVariable * this.OverviewProject.LandAreaSft.Value;
//}
#endregion
#endregion
#region SET Item Rate and Qty
//GET Item Actual Price From Pre-BOQ or Set Zero
Decimal actualPrice = 0;
Decimal totalQty = 0;
Boolean importPriceFlag = false, importQtyFlag = false;
foreach (ListItem chbxItem in chbxImportInfoList.Items)
{
if (chbxItem.Selected == true && chbxItem.Text == CommonConstants.IMPORT_RATE_INFO)
{
importPriceFlag = true;
}
if (chbxItem.Selected == true && chbxItem.Text == CommonConstants.IMPORT_QTY_INFO)
{
importQtyFlag = true;
}
}
Int64 BrandID = MasterDataConstants.ItemDefaults.DEFAULT_BRAD;
Int64 SupplierID = MasterDataConstants.ItemDefaults.DEFAULT_SUPPLIER;
Int64 RegionID = MasterDataConstants.ItemDefaults.DEFAULT_REGION;
Int64 CountryID = MasterDataConstants.ItemDefaults.DEFAULT_COUNTRY;
IList <PRMPreBOQDetailEntity> _pRMPreBOQDeatilEntity = (from s in mappedItemsFromDB
where s.ItemID == ent.ItemID
select s).ToList();
if (importPriceFlag)
{
if (_pRMPreBOQDeatilEntity != null && _pRMPreBOQDeatilEntity.Count > 0 && _pRMPreBOQDeatilEntity[0].Rate > 0)
{
Int64.TryParse(_pRMPreBOQDeatilEntity[0].BrandID.ToString(), out BrandID);
Int64.TryParse(_pRMPreBOQDeatilEntity[0].SupplierID.ToString(), out SupplierID);
Int64.TryParse(_pRMPreBOQDeatilEntity[0].RegionID.ToString(), out RegionID);
Int64.TryParse(_pRMPreBOQDeatilEntity[0].CountryID.ToString(), out CountryID);
Decimal.TryParse(_pRMPreBOQDeatilEntity[0].Rate.ToString(), out actualPrice);
}
else
{
#region SET Rate From Price Database
String fe = SqlExpressionBuilder.PrepareFilterExpression(MDItemDefaultEntity.FLD_NAME_ItemID, ent.ItemID.ToString(), SQLMatchType.Equal);
IList <MDItemDefaultEntity> itemDefaultList = FCCMDItemDefault.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression);
if (itemDefaultList != null && itemDefaultList.Count > 0)
{
Int64.TryParse(itemDefaultList[0].BrandID.ToString(), out BrandID);
Int64.TryParse(itemDefaultList[0].SupplierID.ToString(), out SupplierID);
Int64.TryParse(itemDefaultList[0].RegionID.ToString(), out RegionID);
Int64.TryParse(itemDefaultList[0].CountryID.ToString(), out CountryID);
}
var supplierItemMap = (from s in supplierItemMapList
where s.ItemID == ent.ItemID &&
s.BrandID == BrandID &&
s.SupplierID == SupplierID &&
s.OriginRegionID == RegionID &&
s.OriginCountryID == CountryID
select s).ToList();
if (supplierItemMap != null && supplierItemMap.Count > 0)
{
Decimal.TryParse(supplierItemMap[0].Price.ToString(), out actualPrice);
}
#endregion
}
}
if (importQtyFlag)
{
if (_pRMPreBOQDeatilEntity != null && _pRMPreBOQDeatilEntity.Count > 0 && _pRMPreBOQDeatilEntity[0].TotalQty > 0)
{
Decimal.TryParse(_pRMPreBOQDeatilEntity[0].TotalQty.ToString(), out totalQty);
}
else
{
#region GET Qty From ThumbRule
String feThumbRule = SqlExpressionBuilder.PrepareFilterExpression(MDItemThumbRuleEntity.FLD_NAME_ItemID, ent.ItemID.ToString(), SQLMatchType.Equal);
IList <MDItemThumbRuleEntity> itemThumbRuleList = FCCMDItemThumbRule.GetFacadeCreate().GetIL(null, null, String.Empty, feThumbRule, DatabaseOperationType.LoadWithFilterExpression);
if (itemThumbRuleList != null && itemThumbRuleList.Count > 0)
{
totalQty += itemThumbRuleList[0].FloorQuantity * itemThumbRuleList[0].FloorRuleVariable * this.OverviewProject.LandAreaSft.Value * this.OverviewProject.NoOfStoried.Value;
totalQty += itemThumbRuleList[0].BasementQuantity * itemThumbRuleList[0].BasementRuleVariable * this.OverviewProject.LandAreaSft.Value * this.OverviewProject.NoOfBasement.Value;
totalQty += itemThumbRuleList[0].OverallQuantity * itemThumbRuleList[0].OverallRuleVariable * this.OverviewProject.LandAreaSft.Value;
}
#endregion
}
}
#endregion
subXmlStr = subXmlStr + "<i><a>" + preBOQID + "</a><b>" + ent.ItemID + "</b><c>" + actualPrice + "</c><d>" + totalQty + "</d><e>" + String.Empty + "</e><f>" + MiscUtil.ParseToDateTime(DateTime.Now.ToStringDefault()) + "</f><g>" + BrandID + "</g><j>" + SupplierID + "</j><k>" + RegionID + "</k><l>" + CountryID + "</l></i>";
}
xmlStr.Append(subXmlStr.ToString());
xmlStr.Append("</m>");
FCCBulkInsertXML.GetFacadeCreate().GetIL(xmlStr.ToString(), CommonConstants.PreBOQDetailTableInfo);
}
#endregion New
#region DeleteFromDB New
if (finalDeleteList != null && finalDeleteList.Count > 0)
{
foreach (PRMPreBOQDetailEntity ent in finalDeleteList)
{
String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMPreBOQDetailEntity.FLD_NAME_PreBOQDetailID, ent.PreBOQDetailID.ToString(), SQLMatchType.Equal);
FCCPRMPreBOQDetail.GetFacadeCreate().Delete(new PRMPreBOQDetailEntity(), fe, DatabaseOperationType.Delete, TransactionRequired.No);
}
}
#endregion DeleteFromDB New
#region Backup
//else
//{
// IList<PRMPreBOQDetailEntity> temp_currentlyCheckedItems = currentlyCheckedItems.Except(populatedItems, new CustomerComparer()).ToList();
// IList<PRMPreBOQDetailEntity> temp_mappedItemsFromDB = mappedItemsFromDB.Except(populatedItems, new CustomerComparer()).ToList();
// IList<PRMPreBOQDetailEntity> al = temp_currentlyCheckedItems.Except(temp_mappedItemsFromDB, new CustomerComparer()).ToList();
// IList<PRMPreBOQDetailEntity> dl = temp_mappedItemsFromDB.Except(temp_currentlyCheckedItems, new CustomerComparer()).ToList();
// IList<PRMPreBOQDetailEntity> new_al = checkedItemsFromTree.Except(populatedCheckedItems, new CustomerComparer()).ToList();
// IList<PRMPreBOQDetailEntity> new_dl = populatedCheckedItems.Except(checkedItemsFromTree, new CustomerComparer()).ToList();
// #region Deleting
// foreach (PRMPreBOQDetailEntity ent in new_dl)
// {
// String fe1 = SqlExpressionBuilder.PrepareFilterExpression(PRMPreBOQDetailEntity.FLD_NAME_PreBOQID, preBOQID.ToString(), SQLMatchType.Equal);
// String fe2 = SqlExpressionBuilder.PrepareFilterExpression(PRMPreBOQDetailEntity.FLD_NAME_ItemID, ent.ItemID.ToString(), SQLMatchType.Equal);
// String fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2);
// FCCPRMPreBOQDetail.GetFacadeCreate().Delete(ent, fe, DatabaseOperationType.Delete, TransactionRequired.No);
// }
// foreach (PRMPreBOQDetailEntity ent in dl)
// {
// String fe1 = SqlExpressionBuilder.PrepareFilterExpression(PRMPreBOQDetailEntity.FLD_NAME_PreBOQID, preBOQID.ToString(), SQLMatchType.Equal);
// String fe2 = SqlExpressionBuilder.PrepareFilterExpression(PRMPreBOQDetailEntity.FLD_NAME_ItemID, ent.ItemID.ToString(), SQLMatchType.Equal);
// String fe = SqlExpressionBuilder.PrepareFilterExpression(fe1, SQLJoinType.AND, fe2);
// FCCPRMPreBOQDetail.GetFacadeCreate().Delete(ent, fe, DatabaseOperationType.Delete, TransactionRequired.No);
// }
// #endregion
// #region Adding
// StringBuilder xmlStr = new StringBuilder();
// String subXmlStr = String.Empty;
// xmlStr.Append("<m>");
// foreach (PRMPreBOQDetailEntity ent in new_al)
// {
// subXmlStr = subXmlStr + "<i><a>" + preBOQID + "</a><b>" + ent.ItemID + "</b></i>";
// }
// foreach (PRMPreBOQDetailEntity ent in al)
// {
// subXmlStr = subXmlStr + "<i><a>" + preBOQID + "</a><b>" + ent.ItemID + "</b></i>";
// }
// xmlStr.Append(subXmlStr.ToString());
// xmlStr.Append("</m>");
// FCCBulkInsertXML.GetFacadeCreate().GetIL(xmlStr.ToString(), CommonConstants.PreBOQDetailTableInfo);
// #endregion
//}
#endregion
treeItem.ReBuildTree();
PrepareFormView();
MiscUtil.ShowMessage(lblMessage, "BOQ Setup Updated Successfully.", false);
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, "An Error Occoured.", true);
}
}