public static int UpdateTenantContract(mTenantContract pTenantContract) { int isSucess = 0; using (SqlConnection con = new SqlConnection(Global.connString)) { con.Open(); using (SqlCommand command = new SqlCommand("UPDATE tblTenantContract SET [TenantID] = @TenantID, [LandLordID] = @LandLordID, [UnitID] = @UnitID, [TenantDeposit] = @TenantDeposit, " + " [TenantMonthlyRent] = @TenantMonthlyRent, [ContractStartDate] = @ContractStartDate, [ContractEndDate] = @ContractEndDate, [AgreementDocoument] = @AgreementDocoument," + " [ContractStatusID] = @ContractStatusID WHERE TenantContractID = @TenantContractID ", con)) { command.Parameters.AddWithValue("@TenantContractID", pTenantContract.TenantContractID); command.Parameters.AddWithValue("@TenantID", pTenantContract.TenantID); command.Parameters.AddWithValue("@LandLordID", pTenantContract.LandLordID); command.Parameters.AddWithValue("@UnitID", pTenantContract.UnitID); command.Parameters.AddWithValue("@TenantDeposit", pTenantContract.TenantDeposit); command.Parameters.AddWithValue("@TenantMonthlyRent", pTenantContract.TenantMonthlyRent); command.Parameters.AddWithValue("@ContractStartDate", pTenantContract.ContractStartDate); command.Parameters.AddWithValue("@ContractEndDate", pTenantContract.ContractEndDate); command.Parameters.AddWithValue("@AgreementDocoument", pTenantContract.AgreementDocoument); command.Parameters.AddWithValue("@ContractStatusID", pTenantContract.ContractStatusID); isSucess = command.ExecuteNonQuery(); } } return(isSucess); }
public static int AddNewContract(mTenantContract pTenantContract) { int isSucess = 0; using (SqlConnection con = new SqlConnection(Global.connString)) { con.Open(); using (SqlCommand command = new SqlCommand("INSERT INTO tblTenantContract (TenantID , LandLordID , UnitID , TenantDeposit , TenantMonthlyRent, ContractStartDate, ContractEndDate, AgreementDocoument, ContractStatusID) " + " VALUES (@TenantID, @LandLordID, @UnitID , @TenantDeposit, @TenantMonthlyRent, @ContractStartDate, @ContractEndDate, @AgreementDocoument, @ContractStatusID) select CAST(scope_identity() AS int) ", con)) { command.Parameters.AddWithValue("@TenantID", pTenantContract.TenantID); command.Parameters.AddWithValue("@LandLordID", pTenantContract.LandLordID); command.Parameters.AddWithValue("@UnitID", pTenantContract.UnitID); command.Parameters.AddWithValue("@TenantDeposit", pTenantContract.TenantDeposit); command.Parameters.AddWithValue("@TenantMonthlyRent", pTenantContract.TenantMonthlyRent); command.Parameters.AddWithValue("@ContractStartDate", pTenantContract.ContractStartDate); command.Parameters.AddWithValue("@ContractEndDate", pTenantContract.ContractEndDate); command.Parameters.AddWithValue("@AgreementDocoument", pTenantContract.AgreementDocoument); command.Parameters.AddWithValue("@ContractStatusID", pTenantContract.ContractStatusID); isSucess = Convert.ToInt32(command.ExecuteScalar()); } } return(isSucess); }