protected void lvPRMMaterialReceiveItemMap_ItemCommand(object sender, ListViewCommandEventArgs e)
{
Int64 MaterialReceiveItemMapID;
Int64.TryParse(e.CommandArgument.ToString(), out MaterialReceiveItemMapID);
if (MaterialReceiveItemMapID > 0)
{
if (string.Equals(e.CommandName, "EditItem"))
{
//_MaterialReceiveItemMapID = MaterialReceiveItemMapID;
}
else if (string.Equals(e.CommandName, "DeleteItem"))
{
try
{
Int64 result = -1;
String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMMaterialReceiveItemMapEntity.FLD_NAME_MaterialReceiveItemMapID, MaterialReceiveItemMapID.ToString(), SQLMatchType.Equal);
PRMMaterialReceiveItemMapEntity pRMMaterialReceiveItemMapEntity = new PRMMaterialReceiveItemMapEntity();
result = FCCPRMMaterialReceiveItemMap.GetFacadeCreate().Delete(pRMMaterialReceiveItemMapEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No);
if (result == 0)
{
//_MaterialReceiveItemMapID = 0;
//_PRMMaterialReceiveItemMapEntity = new PRMMaterialReceiveItemMapEntity();
//PrepareInitialView();
//BindPRMMaterialReceiveItemMapList();
MiscUtil.ShowMessage(lblMessage, "Material Receive Item Map has been successfully deleted.", true);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to delete Material Receive Item Map.", true);
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
}
protected void lvPRMMaterialReceiveItemMap_ItemCommand(object sender, ListViewCommandEventArgs e)
{
Int64 MaterialReceiveItemMapID;
Int64.TryParse(e.CommandArgument.ToString(), out MaterialReceiveItemMapID);
if (e.CommandName == "FloorWiseRateAndQty")
{
CurrentWorkOrderItemIDPopup = MaterialReceiveItemMapID;
Label lblItemLV = (Label)e.Item.FindControl("lblItemLV");
Label lblRequisitionIDLV = (Label)e.Item.FindControl("lblRequisitionIDLV");
Label lblRequisitionItemIDLV = (Label)e.Item.FindControl("lblRequisitionItemIDLV");
Label lblWorkOrderItemMapIDLV = (Label)e.Item.FindControl("lblWorkOrderItemMapIDLV");
Label lblProjectIDLV = (Label)e.Item.FindControl("lblProjectIDLV");
Label lblWorkOrderIDLV = (Label)e.Item.FindControl("lblWorkOrderIDLV");
Int64 itemID;
Int64.TryParse(lblItemLV.Text.Trim(), out itemID);
String fe_floor = SqlExpressionBuilder.PrepareFilterExpression(BDProjectFloorEntity.FLD_NAME_ProjectID, lblProjectIDLV.Text.ToString(), SQLMatchType.Equal);
IList <BDProjectFloorEntity> lstBDProjectFloor = FCCBDProjectFloor.GetFacadeCreate().GetIL(null, null, String.Empty, fe_floor, DatabaseOperationType.LoadWithFilterExpression);
if (lstBDProjectFloor != null && lstBDProjectFloor.Count > 0)
{
String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMPreBOQEntity.FLD_NAME_ProjectID, lblProjectIDLV.Text.ToString(), SQLMatchType.Equal);
IList <PRMPreBOQEntity> preBOQList = FCCPRMPreBOQ.GetFacadeCreate().GetIL(null, null, String.Empty, fe, DatabaseOperationType.LoadWithFilterExpression);
if (preBOQList != null && preBOQList.Count > 0)
{
Int64 preBOQID = preBOQList[0].PreBOQID;
switch (preBOQList[0].IsLocked)
{
case true:
#region GET Item From BOQ
String fe_boq = SqlExpressionBuilder.PrepareFilterExpression(PRMBOQEntity.FLD_NAME_PreBOQID, preBOQID.ToString(), SQLMatchType.Equal);
IList <PRMBOQEntity> lstPRMBOQ = FCCPRMBOQ.GetFacadeCreate().GetIL(null, null, String.Empty, fe_boq, DatabaseOperationType.LoadWithFilterExpression);
if (lstPRMBOQ != null && lstPRMBOQ.Count > 0)
{
String fe_BOQDetail1 = SqlExpressionBuilder.PrepareFilterExpression(PRMBOQDetailEntity.FLD_NAME_BOQID, lstPRMBOQ[0].BOQID.ToString(), SQLMatchType.Equal);
String fe_BOQDetail2 = SqlExpressionBuilder.PrepareFilterExpression(PRMBOQDetailEntity.FLD_NAME_ItemID, itemID.ToString(), SQLMatchType.Equal);
String fe_BOQDetail = SqlExpressionBuilder.PrepareFilterExpression(fe_BOQDetail1, SQLJoinType.AND, fe_BOQDetail2);
IList <PRMBOQDetailEntity> lstPRMBOQDetail = FCCPRMBOQDetail.GetFacadeCreate().GetIL(null, null, String.Empty, fe_BOQDetail, DatabaseOperationType.LoadWithFilterExpression);
if (lstPRMBOQDetail != null && lstPRMBOQDetail.Count > 0)
{
String fe_floorDetail = SqlExpressionBuilder.PrepareFilterExpression("PRMBOQFloorDetail." + PRMBOQFloorDetailEntity.FLD_NAME_BOQDetailID, lstPRMBOQDetail[0].BOQDetailID.ToString(), SQLMatchType.Equal);
IList <PRMBOQFloorDetail_DetailedEntity> lstPRMPreBOQFloorDetail = FCCPRMBOQFloorDetail_Detailed.GetFacadeCreate().GetIL(100000, 1, String.Empty, fe_floorDetail);
lvREQRequisitionItemFloorDetail.DataSource = lstPRMPreBOQFloorDetail;
lvREQRequisitionItemFloorDetail.DataBind();
}
}
#endregion
break;
case false:
#region Get Item From Pre-BOQ
String fe_preBOQDetail1 = SqlExpressionBuilder.PrepareFilterExpression(PRMPreBOQDetailEntity.FLD_NAME_PreBOQID, preBOQID.ToString(), SQLMatchType.Equal);
String fe_preBOQDetail2 = SqlExpressionBuilder.PrepareFilterExpression(PRMPreBOQDetailEntity.FLD_NAME_ItemID, itemID.ToString(), SQLMatchType.Equal);
String fe_preBOQDetail = SqlExpressionBuilder.PrepareFilterExpression(fe_preBOQDetail1, SQLJoinType.AND, fe_preBOQDetail2);
IList <PRMPreBOQDetailEntity> lstPRMPreBOQDetail = FCCPRMPreBOQDetail.GetFacadeCreate().GetIL(null, null, String.Empty, fe_preBOQDetail, DatabaseOperationType.LoadWithFilterExpression);
if (lstPRMPreBOQDetail != null && lstPRMPreBOQDetail.Count > 0)
{
String fe_floorDetail = SqlExpressionBuilder.PrepareFilterExpression("PRMPreBOQFloorDetail." + PRMPreBOQFloorDetailEntity.FLD_NAME_PreBOQDetailID, lstPRMPreBOQDetail[0].PreBOQDetailID.ToString(), SQLMatchType.Equal);
IList <PRMPreBOQFloorDetail_DetailedEntity> lstPRMPreBOQFloorDetail = FCCPRMPreBOQFloorDetail_Detailed.GetFacadeCreate().GetIL(10000, 1, String.Empty, fe_floorDetail);
lvREQRequisitionItemFloorDetail.DataSource = lstPRMPreBOQFloorDetail;
lvREQRequisitionItemFloorDetail.DataBind();
}
#endregion
break;
default:
break;
}
}
}
Label lblItemNameLV = (Label)e.Item.FindControl("lblItemNameLV");
//BindREQRequisitionFloorDetailList();
//lblFloorWiseItemName.Text = lblItemNameLV.Text.ToString();
this.ModalPopupExtender2.Show();
if (lvREQRequisitionItemFloorDetail.DataSource != null)
{
btnFloorPopupSave.Enabled = true;
}
else
{
btnFloorPopupSave.Enabled = false;
}
if (CurrentPRMWorkOrderEntity.WorkOrderStatusID != MasterDataConstants.WorkOrderStatus.APPROVED)
{
lblLockMessage.Visible = false;
}
else if (CurrentPRMWorkOrderEntity.WorkOrderStatusID == MasterDataConstants.WorkOrderStatus.APPROVED)
{
btnFloorPopupSave.Enabled = false;
lblLockMessage.Visible = true;
}
}
if (MaterialReceiveItemMapID > 0)
{
if (string.Equals(e.CommandName, "EditItem"))
{
_MaterialReceiveItemMapID = MaterialReceiveItemMapID;
}
else if (string.Equals(e.CommandName, "DeleteItem"))
{
try
{
Int64 result = -1;
String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMMaterialReceiveItemMapEntity.FLD_NAME_MaterialReceiveItemMapID, MaterialReceiveItemMapID.ToString(), SQLMatchType.Equal);
PRMMaterialReceiveItemMapEntity pRMMaterialReceiveItemMapEntity = new PRMMaterialReceiveItemMapEntity();
result = FCCPRMMaterialReceiveItemMap.GetFacadeCreate().Delete(pRMMaterialReceiveItemMapEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No);
if (result == 0)
{
_MaterialReceiveItemMapID = 0;
_PRMMaterialReceiveItemMapEntity = new PRMMaterialReceiveItemMapEntity();
PrepareInitialView();
BindPRMMaterialReceiveItemMapList();
MiscUtil.ShowMessage(lblMessage, "Material Receive Item Map has been successfully deleted.", true);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to delete Material Receive Item Map.", true);
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
}
