Int64 IBDProjectLiftDataAccess.Add(BDProjectLiftEntity bDProjectLiftEntity, DatabaseOperationType option, TransactionRequired reqTran)
{
try
{
long retValues = -99;
switch (reqTran)
{
case TransactionRequired.No:
{
retValues = Add(bDProjectLiftEntity, option);
break;
}
case TransactionRequired.Yes:
{
retValues = AddTran(bDProjectLiftEntity, option);
break;
}
default:
{
retValues = -99;
break;
}
}
return(retValues);
}
catch (Exception ex)
{
throw ex;
}
}
Int64 IBDProjectLiftDataAccess.Delete(BDProjectLiftEntity bDProjectLiftEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran)
{
try
{
long retValues = -99;
switch (reqTran)
{
case TransactionRequired.No:
{
retValues = Delete(bDProjectLiftEntity, filterExpression, option);
break;
}
case TransactionRequired.Yes:
{
retValues = DeleteTran(bDProjectLiftEntity, filterExpression, option);
break;
}
default:
{
retValues = -99;
break;
}
}
return(retValues);
}
catch (Exception ex)
{
throw ex;
}
}
private void SaveBDProjectLiftEntity()
{
if (IsValid)
{
try
{
BDProjectLiftEntity bDProjectLiftEntity = BuildBDProjectLiftEntity();
Int64 result = -1;
if (bDProjectLiftEntity.IsNew)
{
result = FCCBDProjectLift.GetFacadeCreate().Add(bDProjectLiftEntity, DatabaseOperationType.Add, TransactionRequired.No);
}
else
{
String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(BDProjectLiftEntity.FLD_NAME_ProjectLiftID, bDProjectLiftEntity.ProjectLiftID.ToString(), SQLMatchType.Equal);
result = FCCBDProjectLift.GetFacadeCreate().Update(bDProjectLiftEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No);
}
if (result > 0)
{
_ProjectLiftID = 0;
_BDProjectLiftEntity = new BDProjectLiftEntity();
PrepareInitialView();
PrepareEditView();
BindBDProjectLiftList();
if (bDProjectLiftEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Project Lift Information has been added successfully.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Project Lift Information has been updated successfully.", false);
}
}
else
{
if (bDProjectLiftEntity.IsNew)
{
MiscUtil.ShowMessage(lblMessage, "Failed to add Project Lift Information.", false);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to update Project Lift Information.", false);
}
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
private Int64 Update(BDProjectLiftEntity bDProjectLiftEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.BDProjectLift_SET";
using (DbCommand cmd = Database.GetStoredProcCommand(SP))
{
AddOptionParameter(cmd, option);
AddOutputParameter(cmd);
AddFilterExpressionParameter(cmd, filterExpression);
Database.AddInParameter(cmd, "@ProjectLiftID", DbType.Int64, bDProjectLiftEntity.ProjectLiftID);
Database.AddInParameter(cmd, "@ProjectID", DbType.Int64, bDProjectLiftEntity.ProjectID);
Database.AddInParameter(cmd, "@NumberOfLift", DbType.Decimal, bDProjectLiftEntity.NumberOfLift);
Database.AddInParameter(cmd, "@LiftBrandID", DbType.Int64, bDProjectLiftEntity.LiftBrandID);
Database.AddInParameter(cmd, "@LiftBrandSupplierID", DbType.Int64, bDProjectLiftEntity.LiftBrandSupplierID);
Database.AddInParameter(cmd, "@NumberOfPassengerLift", DbType.Decimal, bDProjectLiftEntity.NumberOfPassengerLift);
Database.AddInParameter(cmd, "@PassengerLiftBrandID", DbType.Int64, bDProjectLiftEntity.PassengerLiftBrandID);
Database.AddInParameter(cmd, "@PassengerLiftBrandSupplierID", DbType.Int64, bDProjectLiftEntity.PassengerLiftBrandSupplierID);
Database.AddInParameter(cmd, "@CapacityOfPassengerLift", DbType.Decimal, bDProjectLiftEntity.CapacityOfPassengerLift);
Database.AddInParameter(cmd, "@NumberOfServiceLift", DbType.Decimal, bDProjectLiftEntity.NumberOfServiceLift);
Database.AddInParameter(cmd, "@ServiceLiftBrandID", DbType.Int64, bDProjectLiftEntity.ServiceLiftBrandID);
Database.AddInParameter(cmd, "@ServiceLiftBrandSupplierID", DbType.Int64, bDProjectLiftEntity.ServiceLiftBrandSupplierID);
Database.AddInParameter(cmd, "@CapacityOfServiceLift", DbType.Decimal, bDProjectLiftEntity.CapacityOfServiceLift);
Database.AddInParameter(cmd, "@NumberOfFireFighterLift", DbType.Decimal, bDProjectLiftEntity.NumberOfFireFighterLift);
Database.AddInParameter(cmd, "@BrandID", DbType.Int64, bDProjectLiftEntity.BrandID);
Database.AddInParameter(cmd, "@BrandSupplierID", DbType.Int64, bDProjectLiftEntity.BrandSupplierID);
using (IDataReader reader = Database.ExecuteReader(cmd))
{
returnCode = GetReturnCodeFromParameter(cmd);
switch (returnCode)
{
case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST:
{
throw new ArgumentException("BDProjectLiftEntity already exists. Please specify another BDProjectLiftEntity.");
}
case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION:
{
throw new ArgumentException("BDProjectLiftEntity data already updated from different session.");
}
case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION:
{
throw new ArgumentException("BDProjectLiftEntity already exists. Please specify another BDProjectLiftEntity.");
}
}
}
}
return(returnCode);
}
private Int64 DeleteTran(BDProjectLiftEntity bDProjectLiftEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.BDProjectLift_SET";
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand cmd = db.GetStoredProcCommand(SP))
{
AddOptionParameter(cmd, option);
AddOutputParameter(cmd, db);
AddFilterExpressionParameter(cmd, filterExpression, db);
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 Int64 Delete(BDProjectLiftEntity bDProjectLiftEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.BDProjectLift_SET";
using (DbCommand cmd = Database.GetStoredProcCommand(SP))
{
AddOptionParameter(cmd, option);
AddOutputParameter(cmd);
AddFilterExpressionParameter(cmd, filterExpression);
using (IDataReader reader = Database.ExecuteReader(cmd))
{
returnCode = GetReturnCodeFromParameter(cmd);
switch (returnCode)
{
case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST:
{
throw new ArgumentException("BDProjectLiftEntity already exists. Please specify another BDProjectLiftEntity.");
}
case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION:
{
throw new ArgumentException("BDProjectLiftEntity data already updated from different session.");
}
case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION:
{
throw new ArgumentException("BDProjectLiftEntity already exists. Please specify another BDProjectLiftEntity.");
}
}
}
}
return(returnCode);
}
private Int64 UpdateTran(BDProjectLiftEntity bDProjectLiftEntity, String filterExpression, DatabaseOperationType option)
{
long returnCode = -99;
const string SP = "dbo.BDProjectLift_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, "@ProjectLiftID", DbType.Int64, bDProjectLiftEntity.ProjectLiftID);
db.AddInParameter(cmd, "@ProjectID", DbType.Int64, bDProjectLiftEntity.ProjectID);
db.AddInParameter(cmd, "@NumberOfLift", DbType.Decimal, bDProjectLiftEntity.NumberOfLift);
db.AddInParameter(cmd, "@LiftBrandID", DbType.Int64, bDProjectLiftEntity.LiftBrandID);
db.AddInParameter(cmd, "@LiftBrandSupplierID", DbType.Int64, bDProjectLiftEntity.LiftBrandSupplierID);
db.AddInParameter(cmd, "@NumberOfPassengerLift", DbType.Decimal, bDProjectLiftEntity.NumberOfPassengerLift);
db.AddInParameter(cmd, "@PassengerLiftBrandID", DbType.Int64, bDProjectLiftEntity.PassengerLiftBrandID);
db.AddInParameter(cmd, "@PassengerLiftBrandSupplierID", DbType.Int64, bDProjectLiftEntity.PassengerLiftBrandSupplierID);
db.AddInParameter(cmd, "@CapacityOfPassengerLift", DbType.Decimal, bDProjectLiftEntity.CapacityOfPassengerLift);
db.AddInParameter(cmd, "@NumberOfServiceLift", DbType.Decimal, bDProjectLiftEntity.NumberOfServiceLift);
db.AddInParameter(cmd, "@ServiceLiftBrandID", DbType.Decimal, bDProjectLiftEntity.ServiceLiftBrandID);
db.AddInParameter(cmd, "@ServiceLiftBrandSupplierID", DbType.Decimal, bDProjectLiftEntity.ServiceLiftBrandSupplierID);
db.AddInParameter(cmd, "@CapacityOfServiceLift", DbType.Decimal, bDProjectLiftEntity.CapacityOfServiceLift);
db.AddInParameter(cmd, "@NumberOfFireFighterLift", DbType.Decimal, bDProjectLiftEntity.NumberOfFireFighterLift);
db.AddInParameter(cmd, "@BrandID", DbType.Int64, bDProjectLiftEntity.BrandID);
db.AddInParameter(cmd, "@BrandSupplierID", DbType.Int64, bDProjectLiftEntity.BrandSupplierID);
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 BDProjectLiftEntity BuildBDProjectLiftEntity()
{
BDProjectLiftEntity bDProjectLiftEntity = CurrentBDProjectLiftEntity;
bDProjectLiftEntity.ProjectID = OverviewProjectID;
if (!txtNumberOfLift.Text.Trim().IsNullOrEmpty())
{
bDProjectLiftEntity.NumberOfLift = Decimal.Parse(txtNumberOfLift.Text.Trim());
}
if (!txtNumberOfPassengerLift.Text.Trim().IsNullOrEmpty())
{
bDProjectLiftEntity.NumberOfPassengerLift = Decimal.Parse(txtNumberOfPassengerLift.Text.Trim());
}
if (!txtCapacityOfPassengerLift.Text.Trim().IsNullOrEmpty())
{
bDProjectLiftEntity.CapacityOfPassengerLift = Decimal.Parse(txtCapacityOfPassengerLift.Text.Trim());
}
else
{
bDProjectLiftEntity.CapacityOfPassengerLift = null;
}
if (!txtNumberOfServiceLift.Text.Trim().IsNullOrEmpty())
{
bDProjectLiftEntity.NumberOfServiceLift = Decimal.Parse(txtNumberOfServiceLift.Text.Trim());
}
else
{
bDProjectLiftEntity.NumberOfServiceLift = null;
}
if (!txtCapacityOfServiceLift.Text.Trim().IsNullOrEmpty())
{
bDProjectLiftEntity.CapacityOfServiceLift = Decimal.Parse(txtCapacityOfServiceLift.Text.Trim());
}
else
{
bDProjectLiftEntity.CapacityOfServiceLift = null;
}
if (!txtNumberOfFireFighterLift.Text.Trim().IsNullOrEmpty())
{
bDProjectLiftEntity.NumberOfFireFighterLift = Decimal.Parse(txtNumberOfFireFighterLift.Text.Trim());
}
else
{
bDProjectLiftEntity.NumberOfFireFighterLift = null;
}
if (ddlLifBrandID.Items.Count > 0)
{
if (ddlLifBrandID.SelectedValue == "0")
{
}
else
{
bDProjectLiftEntity.LiftBrandID = Int64.Parse(ddlLifBrandID.SelectedValue);
}
}
if (ddlLiftBrandSupplierID.Items.Count > 0)
{
if (ddlLiftBrandSupplierID.SelectedValue == "0")
{
}
else
{
bDProjectLiftEntity.LiftBrandSupplierID = Int64.Parse(ddlLiftBrandSupplierID.SelectedValue);
}
}
if (ddlPassengerLiftBrandID.Items.Count > 0)
{
if (ddlPassengerLiftBrandID.SelectedValue == "0")
{
}
else
{
bDProjectLiftEntity.PassengerLiftBrandID = Int64.Parse(ddlPassengerLiftBrandID.SelectedValue);
}
}
if (ddlPassengerLiftBrandSupplierID.Items.Count > 0)
{
if (ddlPassengerLiftBrandSupplierID.SelectedValue == "0")
{
}
else
{
bDProjectLiftEntity.PassengerLiftBrandSupplierID = Int64.Parse(ddlPassengerLiftBrandSupplierID.SelectedValue);
}
}
if (ddlServiceLiftBrandID.Items.Count > 0)
{
if (ddlServiceLiftBrandID.SelectedValue == "0")
{
}
else
{
bDProjectLiftEntity.ServiceLiftBrandID = Int64.Parse(ddlServiceLiftBrandID.SelectedValue);
}
}
if (ddlServiceLiftBrandSupplierID.Items.Count > 0)
{
if (ddlServiceLiftBrandSupplierID.SelectedValue == "0")
{
}
else
{
bDProjectLiftEntity.ServiceLiftBrandSupplierID = Int64.Parse(ddlServiceLiftBrandSupplierID.SelectedValue);
}
}
if (ddlBrandID.Items.Count > 0)
{
if (ddlBrandID.SelectedValue == "0")
{
}
else
{
bDProjectLiftEntity.BrandID = Int64.Parse(ddlBrandID.SelectedValue);
}
}
if (ddlBrandSupplierID.Items.Count > 0)
{
if (ddlBrandSupplierID.SelectedValue == "0")
{
}
else
{
bDProjectLiftEntity.BrandSupplierID = Int64.Parse(ddlBrandSupplierID.SelectedValue);
}
}
return(bDProjectLiftEntity);
}
private void PrepareEditView()
{
BDProjectLiftEntity bDProjectLiftEntity = CurrentBDProjectLiftEntity;
if (!bDProjectLiftEntity.IsNew)
{
txtNumberOfLift.Text = bDProjectLiftEntity.NumberOfLift.ToString();
txtNumberOfPassengerLift.Text = bDProjectLiftEntity.NumberOfPassengerLift.ToString();
txtCapacityOfPassengerLift.Text = bDProjectLiftEntity.CapacityOfPassengerLift.ToString();
txtNumberOfServiceLift.Text = bDProjectLiftEntity.NumberOfServiceLift.ToString();
txtCapacityOfServiceLift.Text = bDProjectLiftEntity.CapacityOfServiceLift.ToString();
txtNumberOfFireFighterLift.Text = bDProjectLiftEntity.NumberOfFireFighterLift.ToString();
if (ddlLifBrandID.Items.Count > 0 && bDProjectLiftEntity.LiftBrandID != null)
{
ddlLifBrandID.SelectedValue = bDProjectLiftEntity.LiftBrandID.ToString();
}
BuildLiftBrandSupplierByBrand();
if (ddlLiftBrandSupplierID.Items.Count > 0 && bDProjectLiftEntity.LiftBrandSupplierID != null)
{
ddlLiftBrandSupplierID.SelectedValue = bDProjectLiftEntity.LiftBrandSupplierID.ToString();
}
if (ddlPassengerLiftBrandID.Items.Count > 0 && bDProjectLiftEntity.PassengerLiftBrandID != null)
{
ddlPassengerLiftBrandID.SelectedValue = bDProjectLiftEntity.PassengerLiftBrandID.ToString();
}
BuildPassengerLiftBrandSupplierByBrand();
if (ddlPassengerLiftBrandSupplierID.Items.Count > 0 && bDProjectLiftEntity.PassengerLiftBrandSupplierID != null)
{
ddlPassengerLiftBrandSupplierID.SelectedValue = bDProjectLiftEntity.PassengerLiftBrandSupplierID.ToString();
}
if (ddlServiceLiftBrandID.Items.Count > 0 && bDProjectLiftEntity.ServiceLiftBrandID != null)
{
ddlServiceLiftBrandID.SelectedValue = bDProjectLiftEntity.ServiceLiftBrandID.ToString();
}
BuildServiceLiftBrandSupplierByBrand();
if (ddlServiceLiftBrandSupplierID.Items.Count > 0 && bDProjectLiftEntity.ServiceLiftBrandSupplierID != null)
{
ddlServiceLiftBrandSupplierID.SelectedValue = bDProjectLiftEntity.ServiceLiftBrandSupplierID.ToString();
}
if (ddlBrandID.Items.Count > 0 && bDProjectLiftEntity.BrandID != null)
{
ddlBrandID.SelectedValue = bDProjectLiftEntity.BrandID.ToString();
}
BuildBrandSupplierByBrand();
if (ddlBrandSupplierID.Items.Count > 0 && bDProjectLiftEntity.BrandSupplierID != null)
{
ddlBrandSupplierID.SelectedValue = bDProjectLiftEntity.BrandSupplierID.ToString();
}
btnSubmit.Text = "Update";
}
}
Int64 IBDProjectLiftFacade.Delete(BDProjectLiftEntity bDProjectLiftEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran)
{
return(DataAccessFactory.CreateBDProjectLiftDataAccess().Delete(bDProjectLiftEntity, filterExpression, option, reqTran));
}
Int64 IBDProjectLiftFacade.Add(BDProjectLiftEntity bDProjectLiftEntity, DatabaseOperationType option, TransactionRequired reqTran)
{
return(DataAccessFactory.CreateBDProjectLiftDataAccess().Add(bDProjectLiftEntity, option, reqTran));
}
