private Int64 UpdateTran(CMMeasurementBookEntity cMMeasurementBookEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.CMMeasurementBook_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, "@MeasurementBookID", DbType.Int64, cMMeasurementBookEntity.MeasurementBookID); db.AddInParameter(cmd, "@ProjectID", DbType.Int64, cMMeasurementBookEntity.ProjectID); db.AddInParameter(cmd, "@ProjectCode", DbType.String, cMMeasurementBookEntity.ProjectCode); db.AddInParameter(cmd, "@VendorCategoryID", DbType.Int64, cMMeasurementBookEntity.VendorCategoryID); db.AddInParameter(cmd, "@ReferenceID", DbType.Int64, cMMeasurementBookEntity.ReferenceID); db.AddInParameter(cmd, "@BillID", DbType.Int64, cMMeasurementBookEntity.BillID); db.AddInParameter(cmd, "@WorkOrderID", DbType.Int64, cMMeasurementBookEntity.WorkOrderID); db.AddInParameter(cmd, "@ItemID", DbType.Int64, cMMeasurementBookEntity.ItemID); db.AddInParameter(cmd, "@CreateDate", DbType.DateTime, cMMeasurementBookEntity.CreateDate); db.AddInParameter(cmd, "@ProjectFloorID", DbType.Int64, cMMeasurementBookEntity.ProjectFloorID); db.AddInParameter(cmd, "@ProjectFloorUnitID", DbType.Int64, cMMeasurementBookEntity.ProjectFloorUnitID); 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); }
Int64 ICMMeasurementBookDataAccess.Add(CMMeasurementBookEntity cMMeasurementBookEntity, DatabaseOperationType option, TransactionRequired reqTran) { try { long retValues = -99; switch (reqTran) { case TransactionRequired.No: { retValues = Add(cMMeasurementBookEntity, option); break; } case TransactionRequired.Yes: { retValues = AddTran(cMMeasurementBookEntity, option); break; } default: { retValues = -99; break; } } return(retValues); } catch (Exception ex) { throw ex; } }
private void PrepareEditView() { CMMeasurementBookEntity cMMeasurementBookEntity = CurrentCMMeasurementBookEntity; if (!cMMeasurementBookEntity.IsNew) { if (ddlProjectID.Items.Count > 0 && cMMeasurementBookEntity.ProjectID != null) { ddlProjectID.SelectedValue = cMMeasurementBookEntity.ProjectID.ToString(); } txtProjectCode.Text = cMMeasurementBookEntity.ProjectCode.ToString(); if (ddlVendorCategoryID.Items.Count > 0 && cMMeasurementBookEntity.VendorCategoryID != null) { ddlVendorCategoryID.SelectedValue = cMMeasurementBookEntity.VendorCategoryID.ToString(); } BuildVendorByVendorCategory(); if (ddlSupplierID.Items.Count > 0 && cMMeasurementBookEntity.ReferenceID != null) { ddlSupplierID.SelectedValue = cMMeasurementBookEntity.ReferenceID.ToString(); } BuildWorkOrderBySupplierID(); if (ddlBillID.Items.Count > 0 && cMMeasurementBookEntity.BillID != null) { ddlBillID.SelectedValue = cMMeasurementBookEntity.BillID.ToString(); } else { ddlBillID.SelectedValue = "0"; } if (ddlWorkOrderID.Items.Count > 0 && cMMeasurementBookEntity.WorkOrderID != null) { ddlWorkOrderID.SelectedValue = cMMeasurementBookEntity.WorkOrderID.ToString(); } else { ddlWorkOrderID.SelectedValue = MasterDataConstants.ItemDefaults.DEFAULT_WORKORDER.ToString(); BuildWorkOrderItem(); } if (ddlItemID.Items.Count > 0 && cMMeasurementBookEntity.ItemID != null) { ddlItemID.SelectedValue = cMMeasurementBookEntity.ItemID.ToString(); } btnSubmit.Text = "Update"; btnAddNew.Visible = true; } }
private void SaveCMMeasurementBookEntity() { if (IsValid) { try { CMMeasurementBookEntity cMMeasurementBookEntity = BuildCMMeasurementBookEntity(); Int64 result = -1; if (cMMeasurementBookEntity.IsNew) { result = FCCCMMeasurementBook.GetFacadeCreate().Add(cMMeasurementBookEntity, DatabaseOperationType.Add, TransactionRequired.No); } else { String filterExpression = SqlExpressionBuilder.PrepareFilterExpression(CMMeasurementBookEntity.FLD_NAME_MeasurementBookID, cMMeasurementBookEntity.MeasurementBookID.ToString(), SQLMatchType.Equal); result = FCCCMMeasurementBook.GetFacadeCreate().Update(cMMeasurementBookEntity, filterExpression, DatabaseOperationType.Update, TransactionRequired.No); } if (result > 0) { _MeasurementBookID = 0; _CMMeasurementBookEntity = new CMMeasurementBookEntity(); PrepareInitialView(); BindCMMeasurementBookList(); if (cMMeasurementBookEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "C MMeasurement Book Information has been added successfully.", false); } else { MiscUtil.ShowMessage(lblMessage, "C MMeasurement Book Information has been updated successfully.", false); } } else { if (cMMeasurementBookEntity.IsNew) { MiscUtil.ShowMessage(lblMessage, "Failed to add Measurement Book Information.", false); } else { MiscUtil.ShowMessage(lblMessage, "Failed to update Measurement Book Information.", false); } } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } }
protected void lvCMMeasurementBook_ItemCommand(object sender, ListViewCommandEventArgs e) { Int64 MeasurementBookID; Int64.TryParse(e.CommandArgument.ToString(), out MeasurementBookID); if (MeasurementBookID > 0) { if (string.Equals(e.CommandName, "EditItem")) { _MeasurementBookID = MeasurementBookID; PrepareEditView(); cpeEditor.Collapsed = false; cpeEditor.ClientState = "false"; } else if (string.Equals(e.CommandName, "DeleteItem")) { try { Int64 result = -1; String fe = SqlExpressionBuilder.PrepareFilterExpression(CMMeasurementBookEntity.FLD_NAME_MeasurementBookID, MeasurementBookID.ToString(), SQLMatchType.Equal); CMMeasurementBookEntity cMMeasurementBookEntity = new CMMeasurementBookEntity(); result = FCCCMMeasurementBook.GetFacadeCreate().Delete(cMMeasurementBookEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No); if (result == 0) { _MeasurementBookID = 0; _CMMeasurementBookEntity = new CMMeasurementBookEntity(); PrepareInitialView(); BindCMMeasurementBookList(); MiscUtil.ShowMessage(lblMessage, "C MMeasurement Book has been successfully deleted.", true); } else { MiscUtil.ShowMessage(lblMessage, "Failed to delete C MMeasurement Book.", true); } } catch (Exception ex) { MiscUtil.ShowMessage(lblMessage, ex.Message, true); } } } }
private Int64 DeleteTran(CMMeasurementBookEntity cMMeasurementBookEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.CMMeasurementBook_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 Update(CMMeasurementBookEntity cMMeasurementBookEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.CMMeasurementBook_SET"; using (DbCommand cmd = Database.GetStoredProcCommand(SP)) { AddOptionParameter(cmd, option); AddOutputParameter(cmd); AddFilterExpressionParameter(cmd, filterExpression); Database.AddInParameter(cmd, "@MeasurementBookID", DbType.Int64, cMMeasurementBookEntity.MeasurementBookID); Database.AddInParameter(cmd, "@ProjectID", DbType.Int64, cMMeasurementBookEntity.ProjectID); Database.AddInParameter(cmd, "@ProjectCode", DbType.String, cMMeasurementBookEntity.ProjectCode); Database.AddInParameter(cmd, "@VendorCategoryID", DbType.Int64, cMMeasurementBookEntity.VendorCategoryID); Database.AddInParameter(cmd, "@ReferenceID", DbType.Int64, cMMeasurementBookEntity.ReferenceID); Database.AddInParameter(cmd, "@BillID", DbType.Int64, cMMeasurementBookEntity.BillID); Database.AddInParameter(cmd, "@WorkOrderID", DbType.Int64, cMMeasurementBookEntity.WorkOrderID); Database.AddInParameter(cmd, "@ItemID", DbType.Int64, cMMeasurementBookEntity.ItemID); Database.AddInParameter(cmd, "@CreateDate", DbType.DateTime, cMMeasurementBookEntity.CreateDate); Database.AddInParameter(cmd, "@ProjectFloorID", DbType.Int64, cMMeasurementBookEntity.ProjectFloorID); Database.AddInParameter(cmd, "@ProjectFloorUnitID", DbType.Int64, cMMeasurementBookEntity.ProjectFloorUnitID); using (IDataReader reader = Database.ExecuteReader(cmd)) { returnCode = GetReturnCodeFromParameter(cmd); switch (returnCode) { case SqlConstants.DB_STATUS_CODE_DATAALREADYEXIST: { throw new ArgumentException("CMMeasurementBookEntity already exists. Please specify another CMMeasurementBookEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("CMMeasurementBookEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("CMMeasurementBookEntity already exists. Please specify another CMMeasurementBookEntity."); } } } } return(returnCode); }
private void PrepareEditView() { CMMeasurementBookEntity cMMeasurementBookEntity = CurrentCMMeasurementBookEntity; if (!cMMeasurementBookEntity.IsNew) { if (ddlProjectID.Items.Count > 0 && cMMeasurementBookEntity.ProjectID != null) { ddlProjectID.SelectedValue = cMMeasurementBookEntity.ProjectID.ToString(); } txtProjectCode.Text = cMMeasurementBookEntity.ProjectCode.ToString(); if (ddlSupplierID.Items.Count > 0 && cMMeasurementBookEntity.ReferenceID != null) { ddlSupplierID.SelectedValue = cMMeasurementBookEntity.ReferenceID.ToString(); } if (ddlBillID.Items.Count > 0 && cMMeasurementBookEntity.BillID != null) { ddlBillID.SelectedValue = cMMeasurementBookEntity.BillID.ToString(); } else { ddlBillID.SelectedValue = "0"; } if (ddlWorkOrderID.Items.Count > 0 && cMMeasurementBookEntity.WorkOrderID != null) { ddlWorkOrderID.SelectedValue = cMMeasurementBookEntity.WorkOrderID.ToString(); } else { ddlWorkOrderID.SelectedValue = "0"; } if (ddlItemID.Items.Count > 0 && cMMeasurementBookEntity.ItemID != null) { ddlItemID.SelectedValue = cMMeasurementBookEntity.ItemID.ToString(); } btnSubmit.Text = "Update"; btnAddNew.Visible = true; } }
private void UpdateMeasurementBookFloorInfo() { String fe_MeasurementBook = SqlExpressionBuilder.PrepareFilterExpression(CMMeasurementBookEntity.FLD_NAME_MeasurementBookID, CurrentCMMeasurementBook_DetailedEntity.MeasurementBookID.ToString(), SQLMatchType.Equal); CMMeasurementBookEntity cMMeasurementBookEntity = FCCCMMeasurementBook.GetFacadeCreate().GetByID(CurrentCMMeasurementBook_DetailedEntity.MeasurementBookID); if (cMMeasurementBookEntity != null && cMMeasurementBookEntity.MeasurementBookID > 0) { if (ddlProjectFloorID.SelectedValue != "0" && ddlProjectFloorID.Items.Count > 0) { cMMeasurementBookEntity.ProjectFloorID = Int64.Parse(ddlProjectFloorID.SelectedValue); } else { cMMeasurementBookEntity.ProjectFloorID = null; } FCCCMMeasurementBook.GetFacadeCreate().Update(cMMeasurementBookEntity, fe_MeasurementBook, DatabaseOperationType.Update, TransactionRequired.No); } }
private Int64 Delete(CMMeasurementBookEntity cMMeasurementBookEntity, String filterExpression, DatabaseOperationType option) { long returnCode = -99; const string SP = "dbo.CMMeasurementBook_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("CMMeasurementBookEntity already exists. Please specify another CMMeasurementBookEntity."); } case SqlConstants.DB_STATUS_CODE_DATAUPDATEDFROMOTHERSESSION: { throw new ArgumentException("CMMeasurementBookEntity data already updated from different session."); } case SqlConstants.DB_STATUS_CODE_FAIL_OPERATION: { throw new ArgumentException("CMMeasurementBookEntity already exists. Please specify another CMMeasurementBookEntity."); } } } } return(returnCode); }
protected void btnAddNew_Click(object sender, EventArgs e) { _MeasurementBookID = 0; _CMMeasurementBookEntity = new CMMeasurementBookEntity(); PrepareInitialView(); }
private CMMeasurementBookEntity BuildCMMeasurementBookEntity() { CMMeasurementBookEntity cMMeasurementBookEntity = CurrentCMMeasurementBookEntity; if (ddlProjectID.Items.Count > 0) { if (ddlProjectID.SelectedValue == "0") { } else { cMMeasurementBookEntity.ProjectID = Int64.Parse(ddlProjectID.SelectedValue); } } cMMeasurementBookEntity.ProjectCode = txtProjectCode.Text.Trim(); if (ddlSupplierID.Items.Count > 0) { if (ddlSupplierID.SelectedValue == "0") { } else { cMMeasurementBookEntity.ReferenceID = Int64.Parse(ddlSupplierID.SelectedValue); } } if (ddlBillID.Items.Count > 0) { if (ddlBillID.SelectedValue == "0") { cMMeasurementBookEntity.BillID = null; } else { cMMeasurementBookEntity.BillID = Int64.Parse(ddlBillID.SelectedValue); } } if (ddlWorkOrderID.Items.Count > 0) { if (ddlWorkOrderID.SelectedValue == "0") { cMMeasurementBookEntity.WorkOrderID = null; } else { cMMeasurementBookEntity.WorkOrderID = Int64.Parse(ddlWorkOrderID.SelectedValue); } } if (ddlItemID.Items.Count > 0) { if (ddlItemID.SelectedValue == "0") { } else { cMMeasurementBookEntity.ItemID = Int64.Parse(ddlItemID.SelectedValue); } } cMMeasurementBookEntity.CreateDate = MiscUtil.ParseToDateTime(System.DateTime.Now.ToStringDefault()); return(cMMeasurementBookEntity); }
Int64 ICMMeasurementBookFacade.Delete(CMMeasurementBookEntity cMMeasurementBookEntity, String filterExpression, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateCMMeasurementBookDataAccess().Delete(cMMeasurementBookEntity, filterExpression, option, reqTran)); }
Int64 ICMMeasurementBookFacade.Add(CMMeasurementBookEntity cMMeasurementBookEntity, DatabaseOperationType option, TransactionRequired reqTran) { return(DataAccessFactory.CreateCMMeasurementBookDataAccess().Add(cMMeasurementBookEntity, option, reqTran)); }