public DataSet GetMonthfromNTodate(ref PropertyRentCard Entity_PC, out string StrError) { StrError = string.Empty; DataSet DS = new DataSet(); try { SqlParameter pAction = new SqlParameter(PropertyRentCard._Action, SqlDbType.BigInt); SqlParameter pFromDate = new SqlParameter(PropertyRentCard._FromDate, SqlDbType.DateTime); SqlParameter pToDate = new SqlParameter(PropertyRentCard._ToDate, SqlDbType.DateTime); pAction.Value = 16; pFromDate.Value = Entity_PC.FromDate; pToDate.Value = Entity_PC.ToDate; SqlParameter[] ParamArray = new SqlParameter[] { pAction, pFromDate, pToDate }; Open(CONNECTION_STRING); DS = SQLHelper.GetDataSet(_Connection, _Transaction, CommandType.StoredProcedure, "SP_PropertyRentalCard", ParamArray); } catch (Exception ex) { StrError = ex.Message; } finally { Close(); } return(DS); }
public int InsertProjectMonth(ref PropertyRentCard Entity_PC, out string StrError) { int iInsert = 0; StrError = string.Empty; try { SqlParameter pAction = new SqlParameter(PropertyRentCard._Action, SqlDbType.BigInt); SqlParameter pPropertyId = new SqlParameter(PropertyRentCard._PropertyId, SqlDbType.BigInt); SqlParameter pPartyId = new SqlParameter(PropertyRentCard._PartyId, SqlDbType.BigInt); SqlParameter pFortheMonthYear = new SqlParameter(PropertyRentCard._FortheMonthYear, SqlDbType.NVarChar); SqlParameter pReceiptVoucherId = new SqlParameter(PropertyRentCard._ReceiptVoucherId, SqlDbType.BigInt); SqlParameter pIsGenerated = new SqlParameter(PropertyRentCard._IsGenerated, SqlDbType.Bit); SqlParameter pRentalAmount = new SqlParameter(PropertyRentCard._RentalAmount, SqlDbType.Decimal); SqlParameter pPropertyRentCardId = new SqlParameter(PropertyRentCard._PropertyRentCardId, SqlDbType.BigInt); SqlParameter pProRentDtlsId = new SqlParameter(PropertyRentCard._ProRentDtlsId, SqlDbType.BigInt); SqlParameter pRemaingAmount = new SqlParameter(PropertyRentCard._RemaingAmount, SqlDbType.Decimal); pAction.Value = 17; pPropertyId.Value = Entity_PC.PropertyId; pPartyId.Value = Entity_PC.PartyId; pFortheMonthYear.Value = Entity_PC.FortheMonthYear; pReceiptVoucherId.Value = Entity_PC.ReceiptVoucherId; pIsGenerated.Value = Entity_PC.IsGenerated; pRentalAmount.Value = Entity_PC.RentalAmount; pPropertyRentCardId.Value = Entity_PC.PropertyRentCardId; pProRentDtlsId.Value = Entity_PC.ProRentDtlsId; pRemaingAmount.Value = Entity_PC.RemaingAmount; SqlParameter[] param = new SqlParameter[] { pAction, pPropertyId, pPartyId, pFortheMonthYear, pReceiptVoucherId, pIsGenerated, pRentalAmount, pPropertyRentCardId, pProRentDtlsId, pRemaingAmount }; Open(CONNECTION_STRING); BeginTransaction(); iInsert = SQLHelper.ExecuteScalar(_Connection, _Transaction, CommandType.StoredProcedure, PropertyRentCard.SP_PropertyRentalCard, param); if (iInsert > 0) { CommitTransaction(); } else { RollBackTransaction(); } } catch (Exception ex) { RollBackTransaction(); StrError = ex.Message; } finally { Close(); } return(iInsert); }
public int DeleteProjectRent(ref PropertyRentCard Entity_PC, out string strerror) { strerror = string.Empty; int insertrow = 0; try { SqlParameter pAction = new SqlParameter(PropertyRentCard._Action, SqlDbType.BigInt); pAction.Value = 8; SqlParameter pPropertyId = new SqlParameter(PropertyRentCard._PropertyRentCardId, SqlDbType.BigInt); pPropertyId.Value = Entity_PC.PropertyRentCardId; SqlParameter pCreatedby = new SqlParameter(PropertyRentCard._UserId, SqlDbType.BigInt); pCreatedby.Value = Entity_PC.UserId; SqlParameter pCreatedDate = new SqlParameter(PropertyRentCard._LoginDate, SqlDbType.DateTime); pCreatedDate.Value = Entity_PC.LoginDate; SqlParameter[] ParamArray = new SqlParameter[] { pAction, pPropertyId, pCreatedby, pCreatedDate }; Open(CONNECTION_STRING); BeginTransaction(); insertrow = SQLHelper.ExecuteNonQuery(_Connection, _Transaction, CommandType.StoredProcedure, PropertyRentCard.SP_PropertyRentalCard, ParamArray); if (insertrow > 0) { CommitTransaction(); } else { RollBackTransaction(); } } catch (Exception ex) { strerror = ex.Message; RollBackTransaction(); } finally { Close(); } return(insertrow); }
public int DeletePropertyMonth(ref PropertyRentCard Entity_PC, out string StrError) { StrError = string.Empty; int insertrow = 0; try { SqlParameter pAction = new SqlParameter(PropertyRentCard._Action, SqlDbType.BigInt); pAction.Value = 19; SqlParameter pProRentDtlsId = new SqlParameter(PropertyRentCard._ProRentDtlsId, SqlDbType.BigInt); pProRentDtlsId.Value = Entity_PC.ProRentDtlsId; SqlParameter[] ParamArray = new SqlParameter[] { pAction, pProRentDtlsId }; Open(CONNECTION_STRING); BeginTransaction(); insertrow = SQLHelper.ExecuteNonQuery(_Connection, _Transaction, CommandType.StoredProcedure, PropertyRentCard.SP_PropertyRentalCard, ParamArray); if (insertrow > 0) { CommitTransaction(); } else { RollBackTransaction(); } } catch (Exception ex) { StrError = ex.Message; RollBackTransaction(); } finally { Close(); } return(insertrow); }
public int InsertPCDetail(ref PropertyRentCard Entity_PC, out string StrError) { int iInsert = 0; StrError = string.Empty; try { SqlParameter pAction = new SqlParameter(PropertyRentCard._Action, SqlDbType.BigInt); SqlParameter pPropertyRentCardId = new SqlParameter(PropertyRentCard._PropertyRentCardId, SqlDbType.BigInt); SqlParameter pFromDate = new SqlParameter(PropertyRentCard._FromDate, SqlDbType.DateTime); SqlParameter pToDate = new SqlParameter(PropertyRentCard._ToDate, SqlDbType.DateTime); SqlParameter pCompanyId = new SqlParameter(PropertyRentCard._CompanyId, SqlDbType.BigInt); SqlParameter pRentalAmt = new SqlParameter(PropertyRentCard._RentalAmt, SqlDbType.Decimal); SqlParameter pPropertyTaxAmt = new SqlParameter(PropertyRentCard._PropertyTaxAmt, SqlDbType.Decimal); SqlParameter pSocietyMaintenaceAmt = new SqlParameter(PropertyRentCard._SocietyMaintenaceAmt, SqlDbType.Decimal); SqlParameter pDepositAmt = new SqlParameter(PropertyRentCard._DepositAmt, SqlDbType.Decimal); SqlParameter pCollectedDate = new SqlParameter(PropertyRentCard._CollectedDate, SqlDbType.DateTime); SqlParameter pRemark = new SqlParameter(PropertyRentCard._Remark, SqlDbType.NVarChar); SqlParameter pFlagCheck = new SqlParameter(PropertyRentCard._FlagCheck, SqlDbType.Bit); SqlParameter pStatus = new SqlParameter(PropertyRentCard._Status, SqlDbType.NVarChar); SqlParameter pFlagReceiptType = new SqlParameter(PropertyRentCard._FlagReceiptType, SqlDbType.Bit); SqlParameter pGSTPerDetails = new SqlParameter(PropertyRentCard._GSTPerDetails, SqlDbType.Decimal); SqlParameter pGSTAmt = new SqlParameter(PropertyRentCard._GSTAmt, SqlDbType.Decimal); SqlParameter pAmount = new SqlParameter(PropertyRentCard._Amount, SqlDbType.Decimal); SqlParameter pTaxTemplateID = new SqlParameter(PropertyRentCard._TaxTemplateID, SqlDbType.BigInt); pAction.Value = 4; pPropertyRentCardId.Value = Entity_PC.PropertyRentCardId; pFromDate.Value = Entity_PC.FromDate; pToDate.Value = Entity_PC.ToDate; pCompanyId.Value = Entity_PC.CompanyId; pRentalAmt.Value = Entity_PC.RentalAmt; pPropertyTaxAmt.Value = Entity_PC.PropertyTaxAmt; pSocietyMaintenaceAmt.Value = Entity_PC.SocietyMaintenaceAmt; pDepositAmt.Value = Entity_PC.DepositAmt; pCollectedDate.Value = Entity_PC.CollectedDate; pRemark.Value = Entity_PC.Remark; pFlagCheck.Value = Entity_PC.FlagCheck; pStatus.Value = Entity_PC.Status; pGSTPerDetails.Value = Entity_PC.GSTPerDetails; pGSTAmt.Value = Entity_PC.GSTAmt; pAmount.Value = Entity_PC.Amount; pFlagReceiptType.Value = Entity_PC.FlagReceiptType; pTaxTemplateID.Value = Entity_PC.TaxTemplateID; SqlParameter[] param = new SqlParameter[] { pAction, pPropertyRentCardId, pFromDate, pToDate, pCompanyId, pRentalAmt, pPropertyTaxAmt, pSocietyMaintenaceAmt, pDepositAmt, pCollectedDate, pRemark, pFlagCheck, pStatus, pGSTPerDetails, pGSTAmt, pAmount, pFlagReceiptType, pTaxTemplateID }; Open(CONNECTION_STRING); BeginTransaction(); iInsert = SQLHelper.ExecuteScalar(_Connection, _Transaction, CommandType.StoredProcedure, PropertyRentCard.SP_PropertyRentalCard, param); if (iInsert > 0) { CommitTransaction(); } else { RollBackTransaction(); } } catch (Exception ex) { RollBackTransaction(); StrError = ex.Message; } finally { Close(); } return(iInsert); }
public int InsertPC(ref PropertyRentCard Entity_PC, out string StrError) { int iInsert = 0; StrError = string.Empty; try { SqlParameter pAction = new SqlParameter(PropertyRentCard._Action, SqlDbType.BigInt); SqlParameter pPCNo = new SqlParameter(PropertyRentCard._PCNo, SqlDbType.NVarChar); //SqlParameter pPropertyName = new SqlParameter(PropertyRentCard._PropertyName, SqlDbType.NVarChar); SqlParameter pPropertyId = new SqlParameter(PropertyRentCard._PropertyId, SqlDbType.BigInt); SqlParameter pPartyId = new SqlParameter(PropertyRentCard._PartyId, SqlDbType.BigInt); SqlParameter pFlatTypeId = new SqlParameter(PropertyRentCard._FlatTypeId, SqlDbType.BigInt); SqlParameter pPropertyAddress = new SqlParameter(PropertyRentCard._PropertyAddress, SqlDbType.NVarChar); SqlParameter pUnitNo = new SqlParameter(PropertyRentCard._UnitNo, SqlDbType.NVarChar); SqlParameter pUnitArea = new SqlParameter(PropertyRentCard._UnitArea, SqlDbType.Decimal); SqlParameter pSqFt = new SqlParameter(PropertyRentCard._SqFt, SqlDbType.Decimal); SqlParameter pRent = new SqlParameter(PropertyRentCard._Rent, SqlDbType.Decimal); SqlParameter pCreatedBy = new SqlParameter(PropertyRentCard._UserId, SqlDbType.BigInt); SqlParameter pCreatedDate = new SqlParameter(PropertyRentCard._LoginDate, SqlDbType.DateTime); pAction.Value = 3; pPCNo.Value = Entity_PC.PCNo; pPropertyId.Value = Entity_PC.PropertyId; pPartyId.Value = Entity_PC.PartyId; pFlatTypeId.Value = Entity_PC.FlatTypeId; pPropertyAddress.Value = Entity_PC.PropertyAddress; pUnitNo.Value = Entity_PC.UnitNo; pUnitArea.Value = Entity_PC.UnitArea; pSqFt.Value = Entity_PC.SqFt; pRent.Value = Entity_PC.Rent; pCreatedBy.Value = Entity_PC.UserId; pCreatedDate.Value = Entity_PC.LoginDate; SqlParameter[] param = new SqlParameter[] { pAction, pPCNo, pPropertyId, pPartyId, pFlatTypeId, pPropertyAddress, pUnitNo, pUnitArea, pSqFt, pRent, pCreatedBy, pCreatedDate }; Open(CONNECTION_STRING); BeginTransaction(); iInsert = SQLHelper.ExecuteScalar(_Connection, _Transaction, CommandType.StoredProcedure, PropertyRentCard.SP_PropertyRentalCard, param); if (iInsert > 0) { CommitTransaction(); } else { RollBackTransaction(); } } catch (Exception ex) { RollBackTransaction(); StrError = ex.Message; } finally { Close(); } return(iInsert); }
public int UpdatetPropertyRentCard(ref PropertyRentCard Entity_PC, out string strerror) { strerror = string.Empty; int insertrow = 0; try { SqlParameter pAction = new SqlParameter(PropertyRentCard._Action, SqlDbType.BigInt); SqlParameter pPropertyId = new SqlParameter(PropertyRentCard._PropertyId, SqlDbType.BigInt); SqlParameter pPropertyRentCardId = new SqlParameter(PropertyRentCard._PropertyRentCardId, SqlDbType.BigInt); SqlParameter pPartyId = new SqlParameter(PropertyRentCard._PartyId, SqlDbType.BigInt); SqlParameter pPCNo = new SqlParameter(PropertyRentCard._PCNo, SqlDbType.NVarChar); SqlParameter pPropertyName = new SqlParameter(PropertyRentCard._PropertyName, SqlDbType.NVarChar); SqlParameter pFlatTypeId = new SqlParameter(PropertyRentCard._FlatTypeId, SqlDbType.BigInt); SqlParameter pPropertyAddress = new SqlParameter(PropertyRentCard._PropertyAddress, SqlDbType.NVarChar); SqlParameter pUnitNo = new SqlParameter(PropertyRentCard._UnitNo, SqlDbType.NVarChar); SqlParameter pUnitArea = new SqlParameter(PropertyRentCard._UnitArea, SqlDbType.Decimal); SqlParameter pSqFt = new SqlParameter(PropertyRentCard._SqFt, SqlDbType.Decimal); SqlParameter pRent = new SqlParameter(PropertyRentCard._Rent, SqlDbType.Decimal); SqlParameter pCreatedby = new SqlParameter(PropertyRentCard._UserId, SqlDbType.BigInt); SqlParameter pCreatedDate = new SqlParameter(PropertyRentCard._LoginDate, SqlDbType.DateTime); pAction.Value = 7; pPCNo.Value = Entity_PC.PCNo; pPropertyId.Value = Entity_PC.PropertyId; pPartyId.Value = Entity_PC.PartyId; pPropertyRentCardId.Value = Entity_PC.PropertyRentCardId; pPropertyName.Value = Entity_PC.PropertyName; pFlatTypeId.Value = Entity_PC.FlatTypeId; pPropertyAddress.Value = Entity_PC.PropertyAddress; pUnitNo.Value = Entity_PC.UnitNo; pUnitArea.Value = Entity_PC.UnitArea; pSqFt.Value = Entity_PC.SqFt; pRent.Value = Entity_PC.Rent; pCreatedby.Value = Entity_PC.UserId; pCreatedDate.Value = Entity_PC.LoginDate; SqlParameter[] ParamArray = new SqlParameter[] { pAction, pPCNo, pPropertyId, pPartyId, pPropertyRentCardId, pPropertyName, pFlatTypeId, pPropertyAddress, pUnitNo, pUnitArea, pSqFt, pRent, pCreatedby, pCreatedDate }; Open(CONNECTION_STRING); BeginTransaction(); insertrow = SQLHelper.ExecuteNonQuery(_Connection, _Transaction, CommandType.StoredProcedure, PropertyRentCard.SP_PropertyRentalCard, ParamArray); if (insertrow > 0) { CommitTransaction(); } else { RollBackTransaction(); } } catch (Exception ex) { strerror = ex.Message; RollBackTransaction(); } finally { Close(); } return(insertrow); }