Int64 IPRMBOQFloorDetailDataAccess.Add(PRMBOQFloorDetailEntity pRMBOQFloorDetailEntity, DatabaseOperationType option, TransactionRequired reqTran)
{
try
{
long retValues = -99;
switch (reqTran)
{
case TransactionRequired.No:
{
retValues = Add(pRMBOQFloorDetailEntity, option);
break;
}
case TransactionRequired.Yes:
{
retValues = AddTran(pRMBOQFloorDetailEntity, option);
break;
}
default:
{
retValues = -99;
break;
}
}
return(retValues);
}
catch (Exception ex)
{
throw ex;
}
}
private void PrepareEditView()
{
PRMBOQFloorDetailEntity pRMBOQFloorDetailEntity = CurrentPRMBOQFloorDetailEntity;
if (!pRMBOQFloorDetailEntity.IsNew)
{
if (ddlBOQDetailID.Items.Count > 0 && pRMBOQFloorDetailEntity.BOQDetailID != null)
{
ddlBOQDetailID.SelectedValue = pRMBOQFloorDetailEntity.BOQDetailID.ToString();
}
if (ddlProjectFloorID.Items.Count > 0 && pRMBOQFloorDetailEntity.ProjectFloorID != null)
{
ddlProjectFloorID.SelectedValue = pRMBOQFloorDetailEntity.ProjectFloorID.ToString();
}
txtQty.Text = pRMBOQFloorDetailEntity.Qty.ToString();
txtRemarks.Text = pRMBOQFloorDetailEntity.Remarks.ToString();
txtEntryDate.Text = pRMBOQFloorDetailEntity.EntryDate.ToStringDefault();
btnSubmit.Text = "Update";
btnAddNew.Visible = true;
}
}
private Int64 UpdateTran(PRMBOQFloorDetailEntity pRMBOQFloorDetailEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.PRMBOQFloorDetail_SET";
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand cmd = db.GetStoredProcCommand(SP))
{
AddOptionParameter(cmd, option, db);
AddOutputParameter(cmd, db);
AddFilterExpressionParameter(cmd, filterExpression, db);
db.AddInParameter(cmd, "@BOQFloorDetailID", DbType.Int64, pRMBOQFloorDetailEntity.BOQFloorDetailID);
db.AddInParameter(cmd, "@BOQDetailID", DbType.Int64, pRMBOQFloorDetailEntity.BOQDetailID);
db.AddInParameter(cmd, "@ProjectFloorID", DbType.Int64, pRMBOQFloorDetailEntity.ProjectFloorID);
db.AddInParameter(cmd, "@Qty", DbType.Decimal, pRMBOQFloorDetailEntity.Qty);
db.AddInParameter(cmd, "@Rate", DbType.Decimal, pRMBOQFloorDetailEntity.Rate);
db.AddInParameter(cmd, "@Remarks", DbType.String, pRMBOQFloorDetailEntity.Remarks);
db.AddInParameter(cmd, "@EntryDate", DbType.DateTime, pRMBOQFloorDetailEntity.EntryDate);
DbConnection connection = db.CreateConnection();
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
using (IDataReader reader = db.ExecuteReader(cmd, transaction))
{
returnCode = GetReturnCodeFromParameter(cmd);
}
if (returnCode > 0)
{
transaction.Commit();
}
else
{
throw new ArgumentException("Error Code." + returnCode.ToString());
}
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
finally
{
transaction.Dispose();
connection.Close();
connection = null;
}
}
return(returnCode);
}
private void SavePRMBOQFloorDetailEntity()
{
if (IsValid)
{
try
{
PRMBOQFloorDetailEntity pRMBOQFloorDetailEntity = BuildPRMBOQFloorDetailEntity();
Int64 result = -1;
if (pRMBOQFloorDetailEntity.IsNew)
{
result = FCCPRMBOQFloorDetail.GetFacadeCreate().Add(pRMBOQFloorDetailEntity, DatabaseOperationType.Add, TransactionRequired.No);
}
else
{
String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(PRMBOQFloorDetailEntity.FLD_NAME_BOQFloorDetailID, pRMBOQFloorDetailEntity.BOQFloorDetailID.ToString(), SQLMatchType.Equal);
result = FCCPRMBOQFloorDetail.GetFacadeCreate().Update(pRMBOQFloorDetailEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No);
}
if (result > 0)
{
_BOQFloorDetailID = 0;
_PRMBOQFloorDetailEntity = new PRMBOQFloorDetailEntity();
PrepareInitialView();
BindPRMBOQFloorDetailList();
if (pRMBOQFloorDetailEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Project Cost Floor Detail Information has been added successfully.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Project Cost Floor Detail Information has been updated successfully.", false);
}
}
else
{
if (pRMBOQFloorDetailEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Failed to add Project Cost Floor Detail Information.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to update Project Cost Floor Detail Information.", false);
}
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
protected void lvPRMBOQFloorDetail_ItemCommand(object sender, ListViewCommandEventArgs e)
{
Int64 BOQFloorDetailID;
Int64.TryParse(e.CommandArgument.ToString(), out BOQFloorDetailID);
if (BOQFloorDetailID > 0)
{
if (string.Equals(e.CommandName, "EditItem"))
{
_BOQFloorDetailID = BOQFloorDetailID;
PrepareEditView();
cpeEditor.Collapsed = false;
cpeEditor.ClientState = "false";
}
else if (string.Equals(e.CommandName, "DeleteItem"))
{
try
{
Int64 result = -1;
String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMBOQFloorDetailEntity.FLD_NAME_BOQFloorDetailID, BOQFloorDetailID.ToString(), SQLMatchType.Equal);
PRMBOQFloorDetailEntity pRMBOQFloorDetailEntity = new PRMBOQFloorDetailEntity();
result = FCCPRMBOQFloorDetail.GetFacadeCreate().Delete(pRMBOQFloorDetailEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No);
if (result == 0)
{
_BOQFloorDetailID = 0;
_PRMBOQFloorDetailEntity = new PRMBOQFloorDetailEntity();
PrepareInitialView();
BindPRMBOQFloorDetailList();
MiscUtil.ShowMessage(lblMessage, "Project Cost Floor Detail has been successfully deleted.", true);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to delete Project Cost Floor Detail.", true);
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
}
private Int64 Update(PRMBOQFloorDetailEntity pRMBOQFloorDetailEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.PRMBOQFloorDetail_SET";
using (DbCommand cmd = Database.GetStoredProcCommand(SP))
{
AddOptionParameter(cmd, option);
AddOutputParameter(cmd);
AddFilterExpressionParameter(cmd, filterExpression);
Database.AddInParameter(cmd, "@BOQFloorDetailID", DbType.Int64, pRMBOQFloorDetailEntity.BOQFloorDetailID);
Database.AddInParameter(cmd, "@BOQDetailID", DbType.Int64, pRMBOQFloorDetailEntity.BOQDetailID);
Database.AddInParameter(cmd, "@ProjectFloorID", DbType.Int64, pRMBOQFloorDetailEntity.ProjectFloorID);
Database.AddInParameter(cmd, "@Qty", DbType.Decimal, pRMBOQFloorDetailEntity.Qty);
Database.AddInParameter(cmd, "@Rate", DbType.Decimal, pRMBOQFloorDetailEntity.Rate);
Database.AddInParameter(cmd, "@Remarks", DbType.String, pRMBOQFloorDetailEntity.Remarks);
Database.AddInParameter(cmd, "@EntryDate", DbType.DateTime, pRMBOQFloorDetailEntity.EntryDate);
using (IDataReader reader = Database.ExecuteReader(cmd))
{
returnCode = GetReturnCodeFromParameter(cmd);
switch (returnCode)
{
case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST:
{
throw new ArgumentException("PRMBOQFloorDetailEntity already exists. Please specify another PRMBOQFloorDetailEntity.");
}
case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION:
{
throw new ArgumentException("PRMBOQFloorDetailEntity data already updated from different session.");
}
case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION:
{
throw new ArgumentException("PRMBOQFloorDetailEntity already exists. Please specify another PRMBOQFloorDetailEntity.");
}
}
}
}
return(returnCode);
}
private PRMBOQFloorDetailEntity BuildPRMBOQFloorDetailEntity()
{
PRMBOQFloorDetailEntity pRMBOQFloorDetailEntity = CurrentPRMBOQFloorDetailEntity;
if (ddlBOQDetailID.Items.Count > 0)
{
if (ddlBOQDetailID.SelectedValue == "0")
{
}
else
{
pRMBOQFloorDetailEntity.BOQDetailID = Int64.Parse(ddlBOQDetailID.SelectedValue);
}
}
if (ddlProjectFloorID.Items.Count > 0)
{
if (ddlProjectFloorID.SelectedValue == "0")
{
}
else
{
pRMBOQFloorDetailEntity.ProjectFloorID = Int64.Parse(ddlProjectFloorID.SelectedValue);
}
}
if (!txtQty.Text.Trim().IsNullOrEmpty())
{
pRMBOQFloorDetailEntity.Qty = Decimal.Parse(txtQty.Text.Trim());
}
else
{
pRMBOQFloorDetailEntity.Qty = null;
}
pRMBOQFloorDetailEntity.Remarks = txtRemarks.Text.Trim();
if (txtEntryDate.Text.Trim().IsNotNullOrEmpty())
{
pRMBOQFloorDetailEntity.EntryDate = MiscUtil.ParseToDateTime(txtEntryDate.Text);
}
return(pRMBOQFloorDetailEntity);
}
protected void lvPRMBOQDetail_ItemCommand(object sender, ListViewCommandEventArgs e)
{
#region Modify Qty
if (e.CommandName == "ModifyQty")
{
Int64 ItemID;
Int64.TryParse(e.CommandArgument.ToString(), out ItemID);
Label lblBOQDetailLV = (Label)e.Item.FindControl("lblBOQDetailIDLV");
TextBox txtRateLV = (TextBox)e.Item.FindControl("txtRateLV");
Int64 BOQDetailID = Int64.Parse(lblBOQDetailLV.Text);
_CurrentBOQDetailIDPopup = BOQDetailID;
if (ItemID > 0)
{
_CurrentItemID = ItemID;
this.lblItemName.Text = ((Label)e.Item.FindControl("lblItemNameLV")).Text;
PRMBOQDetailEntity bOQDetailEntity = FCCPRMBOQDetail.GetFacadeCreate().GetByID(BOQDetailID);
if (bOQDetailEntity != null && bOQDetailEntity.BOQDetailID > 0)
{
String fe3 = SqlExpressionBuilder.PrepareFilterExpression(BDProjectFloorEntity.FLD_NAME_ProjectID, this.OverviewProjectID.ToString(), SQLMatchType.Equal);
IList <BDProjectFloorEntity> bDProjectFloorList = FCCBDProjectFloor.GetFacadeCreate().GetIL(null, null, String.Empty, fe3, DatabaseOperationType.LoadWithFilterExpression);
if (bDProjectFloorList != null && bDProjectFloorList.Count > 0)
{
foreach (BDProjectFloorEntity bdProjectfloorent in bDProjectFloorList)
{
String fe4 = String.Empty;
String feFloorDetail1 = SqlExpressionBuilder.PrepareFilterExpression(PRMBOQFloorDetailEntity.FLD_NAME_ProjectFloorID, bdProjectfloorent.ProjectFloorID.ToString(), SQLMatchType.Equal);
String feFloorDetail2 = SqlExpressionBuilder.PrepareFilterExpression(PRMBOQFloorDetailEntity.FLD_NAME_BOQDetailID, BOQDetailID.ToString(), SQLMatchType.Equal);
fe4 = SqlExpressionBuilder.PrepareFilterExpression(feFloorDetail1, SQLJoinType.AND, feFloorDetail2);
IList <PRMBOQFloorDetailEntity> list = FCCPRMBOQFloorDetail.GetFacadeCreate().GetIL(null, null, String.Empty, fe4, DatabaseOperationType.LoadWithFilterExpression);
if (list == null || list.Count <= 0)
{
PRMBOQFloorDetailEntity ent = new PRMBOQFloorDetailEntity();
ent.BOQDetailID = Int64.Parse(BOQDetailID.ToString());
ent.ProjectFloorID = Int64.Parse(bdProjectfloorent.ProjectFloorID.ToString());
Decimal dividedQty;
Decimal RateLV;
Decimal.TryParse(txtRateLV.Text, out RateLV);
Decimal.TryParse((bOQDetailEntity.TotalQty / (this.OverviewProject.NoOfBasement + this.OverviewProject.NoOfStoried)).ToString(), out dividedQty);
switch (bdProjectfloorent.FloorCategoryID)
{
case MasterDataConstants.FloorCategory.BASEMENT:
dividedQty = dividedQty / 4; //Assumuation
break;
case MasterDataConstants.FloorCategory.FLOOR:
dividedQty = dividedQty * 1; //Assumuation
break;
case MasterDataConstants.FloorCategory.PENTHOUSE:
dividedQty = dividedQty * 2; //Assumuation
break;
case MasterDataConstants.FloorCategory.HEAD_ROOM:
dividedQty = dividedQty * 3; //Assumuation
break;
default:
dividedQty = 0;
break;
}
ent.Rate = RateLV;
ent.Qty = dividedQty;
ent.Remarks = String.Empty;
ent.EntryDate = System.DateTime.Now;
FCCPRMBOQFloorDetail.GetFacadeCreate().Add(ent, DatabaseOperationType.Add, TransactionRequired.No);
}
}
BindPRMBOQFloorDetailList();
this.Panel1_ModalPopupExtender.Show();
}
else
{
MiscUtil.ShowMessage(lblMessage, "No Floor Available.", true);
}
}
}
}
#endregion
#region Modify Price Info
if (e.CommandName == "ModifyPrice")
{
Int64 ItemID;
Int64.TryParse(e.CommandArgument.ToString(), out ItemID);
if (ItemID > 0)
{
MiscUtil.PopulateMDBrandByItemID(ddlBrandID, false, Int64.Parse(ItemID.ToString()));
this.lblItemNameModifyPriceLV.Text = ((Label)e.Item.FindControl("lblItemNameLV")).Text;
if (ddlBrandID != null && ddlBrandID.Items.Count > 0)
{
this.ddlBrandID.SelectedValue = ((Label)e.Item.FindControl("lblBrandID")).Text;
}
BuildSupplierByBrand();
if (ddlSupplierID != null && ddlSupplierID.Items.Count > 0)
{
this.ddlSupplierID.SelectedValue = ((Label)e.Item.FindControl("lblSupplierID")).Text;
}
_CurrentItemID = ItemID;
if (ddlOriginRegionID != null && ddlOriginRegionID.Items.Count > 0)
{
this.ddlOriginRegionID.SelectedValue = ((Label)e.Item.FindControl("lblRegionID")).Text;
}
BuildCountryDropdownByRegion();
if (ddlOriginCountryID != null && ddlOriginCountryID.Items.Count > 0)
{
this.ddlOriginCountryID.SelectedValue = ((Label)e.Item.FindControl("lblCountryID")).Text;
}
GetCurrentPrice();
}
this.Panel2_ModalPopupExtender.Show();
}
if (e.CommandName == "AdditionalQty")
{
Int64 boqDetailID;
Int64.TryParse(e.CommandArgument.ToString(), out boqDetailID);
if (boqDetailID > 0)
{
_CurrentBOQDetailIDPopup = boqDetailID;
this.ModalPopupExtender1.Show();
}
}
#endregion
}
private void UpdateBOQFloorDetail()
{
try
{
IList <ListViewDataItem> listPRMFloorDetail = lvPRMBOQFloorDetail.Items;
if (listPRMFloorDetail != null && listPRMFloorDetail.Count > 0)
{
Decimal Totalqty = 0, totalRate = 0, avgRate, avgTotalQty, count = 0;
foreach (ListViewDataItem lvdi in listPRMFloorDetail)
{
Int64 floorDetailID;
Decimal newQty, floorRate;
TextBox txtTotalQtyLV = (TextBox)lvdi.FindControl("txtQtyLV");
TextBox txtRateLV = (TextBox)lvdi.FindControl("txtRateLV");
TextBox txtRemarksLV = (TextBox)lvdi.FindControl("txtRemarksLV");
Label floorDetailIDLV = (Label)lvdi.FindControl("lblBOQFloorDetailIDLV");
Decimal.TryParse(txtTotalQtyLV.Text.Trim(), out newQty);
Decimal.TryParse(txtRateLV.Text.Trim(), out floorRate);
Int64.TryParse(floorDetailIDLV.Text.Trim(), out floorDetailID);
PRMBOQFloorDetailEntity pRMBOQFloorDetailEntity = FCCPRMBOQFloorDetail.GetFacadeCreate().GetByID(floorDetailID);
pRMBOQFloorDetailEntity.Qty = newQty;
pRMBOQFloorDetailEntity.Rate = floorRate;
pRMBOQFloorDetailEntity.Remarks = txtRemarksLV.Text;
pRMBOQFloorDetailEntity.EntryDate = System.DateTime.Now;
String fe = SqlExpressionBuilder.PrepareFilterExpression(PRMBOQFloorDetailEntity.FLD_NAME_BOQFloorDetailID, floorDetailID.ToString(), SQLMatchType.Equal);
FCCPRMBOQFloorDetail.GetFacadeCreate().Update(pRMBOQFloorDetailEntity, fe, DatabaseOperationType.Update, TransactionRequired.No);
Totalqty += newQty;
totalRate += floorRate;
count++;
}
avgRate = totalRate / count;
avgTotalQty = Totalqty / count;
#region Update Project Cost Qty
String fe_BOQDetail = SqlExpressionBuilder.PrepareFilterExpression(PRMBOQDetailEntity.FLD_NAME_BOQDetailID, _CurrentBOQDetailIDPopup.ToString(), SQLMatchType.Equal);
PRMBOQDetailEntity prmBOQDetailEntity = FCCPRMBOQDetail.GetFacadeCreate().GetByID(_CurrentBOQDetailIDPopup);
prmBOQDetailEntity.TotalQty = Totalqty;
FCCPRMBOQDetail.GetFacadeCreate().Update(prmBOQDetailEntity, fe_BOQDetail, DatabaseOperationType.Update, TransactionRequired.No);
IList <ListViewDataItem> listPRMBOQDetail = lvPRMBOQDetail.Items;
if (listPRMBOQDetail != null && listPRMBOQDetail.Count > 0)
{
Int32 tempDataItemIndex = 0;
foreach (ListViewDataItem lvdi in listPRMBOQDetail)
{
DataKey currentDataKey = lvPRMBOQDetail.DataKeys[tempDataItemIndex++];
Int64 intBOQDetailID = (Int64)currentDataKey["BOQDetailID"];
if (_CurrentBOQDetailIDPopup == intBOQDetailID)
{
TextBox txtRateLV = (TextBox)lvdi.FindControl("txtRateLV");
TextBox txtTotalQtyLV = (TextBox)lvdi.FindControl("txtTotalQtyLV");
txtTotalQtyLV.Text = Totalqty.ToString();
txtRateLV.Text = avgRate.ToString();
break;
}
}
}
BindList();
#endregion
MiscUtil.ShowMessage(lblMessage, "Project Cost Information has been saved successfully.", false);
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, "Failed to Save Project Cost Information.", true);
}
}
Int64 IPRMBOQFloorDetailFacade.Delete(PRMBOQFloorDetailEntity pRMBOQFloorDetailEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran)
{
return(DataAccessFactory.CreatePRMBOQFloorDetailDataAccess().Delete(pRMBOQFloorDetailEntity, filterExpression, option, reqTran));
}
Int64 IPRMBOQFloorDetailFacade.Add(PRMBOQFloorDetailEntity pRMBOQFloorDetailEntity, DatabaseOperationType option, TransactionRequired reqTran)
{
return(DataAccessFactory.CreatePRMBOQFloorDetailDataAccess().Add(pRMBOQFloorDetailEntity, option, reqTran));
}
protected void btnAddNew_Click(object sender, EventArgs e)
{
_BOQFloorDetailID = 0;
_PRMBOQFloorDetailEntity = new PRMBOQFloorDetailEntity();
PrepareInitialView();
}
