public int UpdatetPropertyMaintenance(ref PropertyMaintenance Entity_PM, out string StrError) { StrError = string.Empty; int insertrow = 0; try { SqlParameter pAction = new SqlParameter(PropertyMaintenance._Action, SqlDbType.BigInt); SqlParameter pPropertyMaintenaceId = new SqlParameter(PropertyMaintenance._PropertyMaintenaceId, SqlDbType.BigInt); SqlParameter pPMNo = new SqlParameter(PropertyMaintenance._PMNo, SqlDbType.NVarChar); SqlParameter pPMDate = new SqlParameter(PropertyMaintenance._PMDate, SqlDbType.DateTime); SqlParameter pPropertyId = new SqlParameter(PropertyMaintenance._PropertyId, SqlDbType.BigInt); SqlParameter pPartyId = new SqlParameter(PropertyMaintenance._PartyId, SqlDbType.BigInt); SqlParameter pComplitFlag = new SqlParameter(PropertyMaintenance._ComplitFlag, SqlDbType.NVarChar); SqlParameter pMaintenaceType = new SqlParameter(PropertyMaintenance._MaintenaceType, SqlDbType.NVarChar); SqlParameter pCreatedby = new SqlParameter(PropertyMaintenance._UserId, SqlDbType.BigInt); SqlParameter pCreatedDate = new SqlParameter(PropertyMaintenance._LoginDate, SqlDbType.DateTime); pAction.Value = 5; pPMNo.Value = Entity_PM.PMNo; pPropertyMaintenaceId.Value = Entity_PM.PropertyMaintenaceId; pPMDate.Value = Entity_PM.PMDate; pPropertyId.Value = Entity_PM.PropertyId; pPartyId.Value = Entity_PM.PartyId; pComplitFlag.Value = Entity_PM.ComplitFlag; pMaintenaceType.Value = Entity_PM.MaintenaceType; pCreatedby.Value = Entity_PM.UserId; pCreatedDate.Value = Entity_PM.LoginDate; SqlParameter[] ParamArray = new SqlParameter[] { pAction, pPMNo, pPropertyMaintenaceId, pPMDate, pPropertyId, pPartyId, pComplitFlag, pMaintenaceType, pCreatedby, pCreatedDate }; Open(CONNECTION_STRING); BeginTransaction(); insertrow = SQLHelper.ExecuteNonQuery(_Connection, _Transaction, CommandType.StoredProcedure, PropertyMaintenance.SP_PropertyMaintenance, ParamArray); if (insertrow > 0) { CommitTransaction(); } else { RollBackTransaction(); } } catch (Exception ex) { StrError = ex.Message; RollBackTransaction(); } finally { Close(); } return(insertrow); }
public int InsertPM(ref PropertyMaintenance Entity_PM, out string StrError) { int iInsert = 0; StrError = string.Empty; try { SqlParameter pAction = new SqlParameter(PropertyMaintenance._Action, SqlDbType.BigInt); SqlParameter pPMNo = new SqlParameter(PropertyMaintenance._PMNo, SqlDbType.NVarChar); SqlParameter pPMDate = new SqlParameter(PropertyMaintenance._PMDate, SqlDbType.DateTime); SqlParameter pPropertyId = new SqlParameter(PropertyMaintenance._PropertyId, SqlDbType.BigInt); SqlParameter pPartyId = new SqlParameter(PropertyMaintenance._PartyId, SqlDbType.BigInt); SqlParameter pComplitFlag = new SqlParameter(PropertyMaintenance._ComplitFlag, SqlDbType.NVarChar); SqlParameter pMaintenaceType = new SqlParameter(PropertyMaintenance._MaintenaceType, SqlDbType.NVarChar); SqlParameter pCreatedBy = new SqlParameter(PropertyMaintenance._UserId, SqlDbType.BigInt); SqlParameter pCreatedDate = new SqlParameter(PropertyMaintenance._LoginDate, SqlDbType.DateTime); pAction.Value = 3; pPMNo.Value = Entity_PM.PMNo; pPMDate.Value = Entity_PM.PMDate; pPropertyId.Value = Entity_PM.PropertyId; pPartyId.Value = Entity_PM.PartyId; pComplitFlag.Value = Entity_PM.ComplitFlag; pMaintenaceType.Value = Entity_PM.MaintenaceType; pCreatedBy.Value = Entity_PM.UserId; pCreatedDate.Value = Entity_PM.LoginDate; SqlParameter[] param = new SqlParameter[] { pAction, pPMNo, pPMDate, pPropertyId, pPartyId, pComplitFlag, pMaintenaceType, pCreatedBy, pCreatedDate }; Open(CONNECTION_STRING); BeginTransaction(); iInsert = SQLHelper.ExecuteScalar(_Connection, _Transaction, CommandType.StoredProcedure, "SP_PropertyMaintenance", param); if (iInsert > 0) { CommitTransaction(); } else { RollBackTransaction(); } } catch (Exception ex) { RollBackTransaction(); StrError = ex.Message; } finally { Close(); } return(iInsert); }
public int InsertPMDetail(ref PropertyMaintenance Entity_PM, out string StrError) { int iInsert = 0; StrError = string.Empty; try { SqlParameter pAction = new SqlParameter(PropertyMaintenance._Action, SqlDbType.BigInt); SqlParameter pPropertyMaintenaceId = new SqlParameter(PropertyMaintenance._PropertyMaintenaceId, SqlDbType.BigInt); SqlParameter pFlagCheck = new SqlParameter(PropertyMaintenance._FlagCheck, SqlDbType.Bit); SqlParameter pUnitNo = new SqlParameter(PropertyMaintenance._UnitNo, SqlDbType.BigInt); SqlParameter pExpenseHdId = new SqlParameter(PropertyMaintenance._ExpenseHdId, SqlDbType.BigInt); SqlParameter pAmount = new SqlParameter(PropertyMaintenance._Amount, SqlDbType.Decimal); pAction.Value = 10; pPropertyMaintenaceId.Value = Entity_PM.PropertyMaintenaceId; pFlagCheck.Value = Entity_PM.FlagCheck; pUnitNo.Value = Entity_PM.UnitNo; pExpenseHdId.Value = Entity_PM.ExpenseHdId; pAmount.Value = Entity_PM.Amount; SqlParameter[] param = new SqlParameter[] { pAction, pPropertyMaintenaceId, pFlagCheck, pUnitNo, pExpenseHdId, pAmount }; Open(CONNECTION_STRING); BeginTransaction(); iInsert = SQLHelper.ExecuteNonQuery(_Connection, _Transaction, CommandType.StoredProcedure, PropertyMaintenance.SP_PropertyMaintenance, param); if (iInsert > 0) { CommitTransaction(); } else { RollBackTransaction(); } } catch (Exception ex) { RollBackTransaction(); StrError = ex.Message; } finally { Close(); } return(iInsert); }